70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
655 reads
Blog Posts
Building Flat File Connectors Dynamically For SSIS
Building Connectors Is Crap in SSIS – Updated What else can I say. I finally broke when I had to build a flat file connector with 258 columns that...
2013-07-24
17 reads
DBCC CHECKDB … Terminated Abnormally Due to Error State 6
I recently encountered a DBCC CHECKDB failure with a fairly non-specific failure message. The error message said it terminated abnormally...
2013-07-24
7,237 reads
I’m going to my first SQL Saturday!
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
665 reads
Moving The Bottleneck
Most of you probably get that there will always be a bottleneck in a system. You implement a fix in...
2013-07-24
581 reads
Shortcut to reference examples, syntax, and definitions straight from SSMS
I’ve never really used the F1 key for help files with most applications. I was surprised at the usefulness in...
2013-07-24
874 reads
SQL Community Speakers – Why We Do It
I started this post over a year ago and have just now come back around to finish it. Over the...
2013-07-24
658 reads
SQL Saturday Sacramento This Weekend
SQL Saturday #222 in Sacramento, CA, is coming fast! This Saturday, July 27, I will be presenting a little pre-show...
2013-07-24
672 reads
SQL Server : Understanding Bulk Change Map (BCM) Page and Bulk Logged Recovery Model
In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the...
2013-07-24
3,776 reads
SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups
In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this post, we will try to understand the Differential Change...
2013-07-24
1,821 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers