Disaster Recovery - Part 1 - Possibly Almost Everything But the Kit
Over the years I have been fortunate or unfortunate enough, depending on who you are to have experienced several disasters...
2013-07-26
1,050 reads
Blog Posts
Hardware 201: Selecting and Sizing Database Hardware
On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download...
2013-07-26
1,110 reads
Headed to Cocoa for SQLSaturday #231
I’m leaving mid-morning today to drive to Cocoa with my family for a beach weekend and SQLSaturday #231. I’ll be...
2013-07-26
704 reads
Page Split Mini-Series - Part II - Page Latch Contention
Last time, in Part
I of my page-split mini-series, we began speaking about page
splits, defining what they are, how they occur,...
2013-07-26
13,625 reads
Reblog: July 19 to July 25
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-07-26
910 reads
Rebuilding server level collation setting
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,829 reads
SQL Server Login Errors
Hello Dear Reader. Quick blog today. If you are working in the SQL Server world eventually you will try to...
2013-07-26
1,032 reads
The SQLAndy Rules for Storing Credit Card Numbers
I’ll try to write more about these over the next couple months, but I wanted to write down a quick...
2013-07-26
1,128 reads
Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love Extended Events
If you are looking for a presentation that brings together bacon, unicorns, and lightsabers, then you should have seen my...
2013-07-26
920 reads
70-457 Reviewer #07, Resolving Concurrency Problems in SQL Server 2012
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,847 reads
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers