Presentations in Action
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation...
2011-06-27
646 reads
Blog Posts
Replacing Cursors with Set-Based SQL Queries – Part 1
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a previous post I discussed...
2011-06-27
7,993 reads
SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. ...
2011-06-27
3,191 reads
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait...
2011-06-27
1,062 reads
Where Do You Go for Authoritative SQL Server Best Practices?
Reprinted from my editorial in Database Weekly.
In early 2000, I started a new DBA job with a large organization, as...
2011-06-27
937 reads
Why Two Devices
I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and...
2011-06-27
925 reads
LulzSec: Why You Should Care
Updating Resume is NOT Lulz
Wow, it’s been a crazy last couple of months with LulzSec running around doing what they...
2011-06-26
1,523 reads
ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
985 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
691 reads
Configuration Manager for Sqldiag
SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor...
2011-06-24
1,121 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