The Perfect is the Enemy of the Good (Again)
I wrote an editorial for SSC back on January 19th about the perfect being the enemy of the good. It’s...
2010-02-17
510 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,337 reads
The Power Grid (No, Not THAT Power)
Yesterday I had the Adversity Index, today it’s the Power Grid from MediaIte. It attempts to score the power of...
2010-02-17
751 reads
MVP Summit Impressions From Day 1
Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side...
2010-02-17
643 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-17
782 reads
2010 MVP Summit Held This Week
If you can’t tell what is happening in the above photo, you won’t be alone. Today, at the opening keynote...
2010-02-17
608 reads
SQL Saturday returns to Redmond, WA
SQL Saturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons.
I have submitted 2 proposals for presentations,...
2010-02-17
751 reads
SSIS 2008 Script Component variable gotcha..
In a previous post I showed you how to access variables from within an SSIS script component. More specifically I...
2010-02-16
4,572 reads
The T-SQL Hammer
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
2010-02-16
3,479 reads
SQL Server - Checkpoint
What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages out to...
2010-02-16
6,856 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers