SQL Server 2008 R2 Service Pack 2 Cumulative Update 10
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 10, which is build 10.50.4297. This Cumulative Update...
2013-12-17
1,424 reads
Blog Posts
SQL Server Diagnostic Information Queries for December 2013
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
924 reads
Transactions: Rolling back a nested transaction
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,523 reads
Collecting Historical Wait Statistics
As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...
2013-12-16 (first published: 2013-12-11)
2,506 reads
DBA JumpStart – A SQL Community Ebook for DBAs
If you could give a DBA just one piece of advice, what would it be?
I asked 20 successful and experienced...
2013-12-16 (first published: 2013-12-10)
3,319 reads
Forty Things You Didn’t Know About SQL Server
Last week I delivered a seminar at the Expert Days 2013 event by the name of 40 Things You Didn’t...
2013-12-16
589 reads
Last Weeks Top “Reading” Links #62
Monday afternoon and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout most days I tweet...
2013-12-16
1,384 reads
NFC Tags-Fun, And Maybe Useful at SQLSaturday
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
898 reads
Nine T-SQL best practices
SQL Server databases are the backbone of many enterprise applications, and good Transact-SQL (T-SQL) code is the best way to...
2013-12-16
958 reads
Scalzi’s Law of Cleverness, as applied to resumes
John Scalzi (blog, Twitter) – science fiction writer, Hugo award winner, philosopher, and blogger extraordinaire – has an adage that I wish...
2013-12-16
940 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers