You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain.
Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an Always On availability group.
This is Part 4 of a series on Always On and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.
Level 1 of the stairway looks at exactly what the technologies "Always On", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.
In this new level of the stairway, we examine the storage knowledge you need for an Always On configuration.
By Steve Jones
One of the things that many DBAs struggle with is managing space across an...
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
Comments posted to this topic are about the item The Cloud Security Problem, which...
Thanks in Advance! I'm having trouble grouping all counts and sums on one line...
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers