Monitoring blocking and deadlocking with Extended T-SQL Collector
Monitoring blocking and deadlocking hasn’t always been easy. Sometimes, the tools available in SQL Server are not as friendly as...
2014-12-12
1,863 reads
Reblog: December 5 to December 11
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-12-12
701 reads
Friday Followup For December 12, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-12-12
441 reads
SQL Bits – Europe’s largest SQL Conference
4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...
2014-12-12
1,408 reads
T-SQL Tricks – Trigger Your Memory
I was scanning Twitter the other day and saw a note from someone that they had written a query using...
2014-12-18 (first published: 2014-12-11)
7,884 reads
Exam Prep 70-463: SSIS Connection Managers
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-17 (first published: 2014-12-11)
8,070 reads
DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD
I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do...
2014-12-11
3,440 reads
Rebuilding and Reorganizing Clustered Columnstore Indexes
Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations...
2014-12-16 (first published: 2014-12-11)
6,829 reads
Converting Dates
I ran across a post recently where someone had dates stored as characters (never good), but also in this format:...
2014-12-10
864 reads
Sequence feature TIP #76
Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new...
2014-12-10
282 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers