T-SQL: CASE Statement
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,735 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
66 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be...
2010-12-28
1,484 reads
Wrapping Up 2010
Goal Setting
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to...
2010-12-28
909 reads
RTFM365, Week 3
Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my...
2010-12-28
773 reads
Can You Dig It? – StmtCursor and StmtReceive Elements
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
2010-12-28
1,221 reads
SSAS Understanding Multiple Security Roles
In a previous article I showed how you can create dynamic security in SSAS.This is a great way to make...
2010-12-28
3,205 reads
SSMS Tools Pack (free), supports SQL Sever Denali CTP1
Free tools are very welcome to the community, while some of the creators of these kind of the tools are...
2010-12-28
1,543 reads
Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-28
1,208 reads
SQL Server Workload Types and Hardware Selection
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2010-12-28
2,944 reads
Blogs
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....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
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