SQL Saturday 215 Deck and Demos Live
Hello Dear Reader! I'm up in Jacksonville for SQL Saturday 215. Today I'm presenting SQL Internals, Backups, and Recovery Models! OH...
2013-04-27
711 reads
Blog Posts
A Rickety Stairway to SQL Server Data Mining, Part 11: Model Comparison and Validation
by Steve Bolton
Throughout this series of amateur self-tutorials on SQL Server Data Mining (SSDM) I’ve typically included some kind...
2013-04-26
2,690 reads
Choosing the Right Processor for your SQL Server Workload
Last year, we planned to move our data warehouse from a 2 socket server to a 4 socket server that was left in the data centre from an abandoned...
2013-04-26
17 reads
Does TDE really work on MDF files?
Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:
-- create a...
2013-04-26 (first published: 2013-04-22)
3,443 reads
Gulf Coast SQL Server Users Group Wrapup
Today has been quite the day! This afternoon I presented for the SQL PASS Performance Virtual Chapter and tonight I...
2013-04-26
553 reads
Reblog: April 19 to April 25
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-26
1,036 reads
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
862 reads
Adding Data to Filestream with T-SQL
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...
2013-04-25
1,380 reads
Consultants – Why pay more?
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...
2013-04-25
1,422 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
529 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