Group By Conference is Back April 11th!
I have joined forces with Blyther Morrow & Daniel Hutmacher to keep the GroupBy Virtual Conference going. We’re aiming to host the conference at least twice this year, and...
2019-04-02
110 reads
Blog Posts
Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012
Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket...
2019-04-02 (first published: 2013-09-18)
5,536 reads
SQL Server 2005 Diagnostic Information Queries (May 2012)
Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are...
2019-04-02 (first published: 2012-05-04)
2,363 reads
SQL Server 2008 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2019-04-02 (first published: 2012-06-11)
3,067 reads
SQL Server 2012 Diagnostic Information Queries (December 2011)
Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to...
2019-04-02 (first published: 2011-12-19)
3,641 reads
SQL Server 2019 Suspend/Resume TDE
Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in...
2019-04-02
160 reads
SQL Server Database Mirroring Tips and Tricks, Part 1
Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...
2019-04-02 (first published: 2012-03-12)
6,566 reads
SQL Server Diagnostic Information Queries for April 2014
I made some small improvements to a few of the queries this month. I plan to add several more SQL...
2019-04-02 (first published: 2014-04-18)
4,342 reads
SQL Server Diagnostic Information Queries for August 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2019-04-02 (first published: 2013-08-09)
3,604 reads
Testing with Temporary Stored Procedures
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
4 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers