Statistics Enhancements in SQL Server 2012
Today I want to talk about Statistics Enhancements in SQL Server 2012. As you already
know SQL Server uses Statistic Objects...
2012-02-29
4,383 reads
Blog Posts
Trello: An agile style kan-ban web app that really works
I am no different to many others where I am being asked to work on various projects concurrently and expected...
2012-02-29 (first published: 2012-02-27)
2,902 reads
What I Want For My Birthday
Dell has teased us with some images of their upcoming 12th Generation servers (that will support the Intel Sandy Bridge-EP...
2012-02-29
1,795 reads
Write a Variable To a File Using SSIS
Problem
I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error...
2012-02-29
6,035 reads
A Script A Day - Day 24 - Object Qualification
Today’s script is one I use as an example to explain that there is method behind my standards that some...
2012-02-28
1,514 reads
How’s Microsoft doing with community involvement? (updated)
Update: Jen Lussier has blogged a summary of the talks she had at the MVP summit last week. Take a...
2012-02-28
1,614 reads
Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong
Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can...
2012-02-28
4,110 reads
Presenting at SQL Saturday #110
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,409 reads
Removing Identical Duplicate Rows
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,240 reads
SQL Server 2008/2008 R2 Diagnostic Queries for March 2012
Since it is nearly March, I will go ahead and jump the gun by a few days and post an...
2012-02-28
1,854 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