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
PASS Update #58 (Elections)
Last year we had some problems with our annual election, enough problems that clearly we needed to do a deeper...
2011-06-27
675 reads
Look How Far You Have Come
A reader wrote to me over the weekend, seeking advice on behalf of their friend, who had been feeling deflated...
2011-06-27
860 reads
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
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
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
Five Lines of Code
An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
I caught...
2011-06-24
787 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