T-SQL Tuesday #36 – Community
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
724 reads
A Discussion of SQL Server-Related Topics
Does a Clustered Index really physically store the rows in key order?
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...
2012-10-21
8,005 reads
Dealing with orphaned users
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,697 reads
Dealing with negative session ids
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,183 reads
What’s been happening in Wayne’s World
Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...
2012-07-18
742 reads
I’m speaking at the PASS Summit 2012
The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...
2012-06-25
678 reads
Interview questions
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
11,934 reads
ORM Tools
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,467 reads
SQL Server 2012 Performance Test: Gap Detection
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...
2012-04-19
3,276 reads
T-SQL Tuesday #029 – Useful Feature of SQL Server 2012
This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...
2012-04-10
1,602 reads
Blogs
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025
I’m excited to announce that on June 17 – 18, 2025, I’ll be running...
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
By Tim Radney
I have recently had the privilege of working with multiple clients who have been...
Forums
Third party backup softwares
Hi Team, Can you someone suggest a few good third part backup tools, with...
2022 SSIS PackageFormatVersion?
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
Meta AI by Facebook: A New Contender in the AI Battle
Comments posted to this topic are about the item Meta AI by Facebook: A...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers