[Coping] Hidden Wounds
Through high school and college, I carried deep wounds due to what was going on at home. Only a handful of people outside of my family knew what what...
2021-01-29 (first published: 2021-01-20)
428 reads
Logical crossroads in Azure Data Factory (IF and Filter operations)
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn...
2021-01-26 (first published: 2021-01-19)
234 reads
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know...
2021-01-19
13 reads
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know...
2021-03-25 (first published: 2021-01-19)
588 reads
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know...
2021-01-27 (first published: 2021-01-19)
1,197 reads
Synapse Analytics and .NET for Apache Spark Example 3 - CTE()
The next example is how to do a CTE (Common Table Expression). When creating the CTE I will also rename one of the columns from “dataType” to “x”.
T-SQL WITH...
2021-01-19
17 reads
Synapse Analytics and .NET for Apache Spark Example 3 - CTE()
The next example is how to do a CTE (Common Table Expression). When creating the CTE I will also rename one of the columns from “dataType” to “x”.
T-SQL WITH...
2021-01-19
81 reads
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
559 reads
Daily Coping 19 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-19
37 reads
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)
Welcome to a new year, and a new look at what I’ve learned in my time as a beginner and junior DBA. So, I’ve been in this DBA gig...
2021-01-28 (first published: 2021-01-19)
672 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers