2010 Recap
As a part of a recap on the year that was 2010, I should start with a recap of my goals. For that review I had to go back...
2010-12-28
4 reads
Blog Posts
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,202 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,200 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
760 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,921 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,179 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,469 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
50 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,530 reads
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,711 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers