SQL University Troubleshooting Week Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
724 reads
Blog Posts
SQL University Troubleshooting Week: Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
888 reads
SQL Joins and Subqueries
A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...
2011-05-22
1,116 reads
Find your Enabled SQL Server Network Protocols Using PowerShell
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
2,151 reads
Forum Fun: Running Calculation SQL
A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...
2011-05-21
676 reads
SQL Rally 2011 Recap
As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the...
2011-05-21
1,118 reads
Busy is as Busy Does
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
561 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,890 reads
MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you get the gist. I announced that I would...
2011-05-20
14 reads
MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you...
2011-05-20
717 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