How to Tell When SQL Server Started?
As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...
2010-04-28
1,854 reads
Blog Posts
Social Networking and SQLSaturday
I think we do a pretty good job of delivering technical content, but not such a great job at getting...
2010-04-28
1,467 reads
SQL Server Connection Strings
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,580 reads
SQL University Post Coming Tomorrow
This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...
2010-04-28
1,447 reads
Undocumented Capabilities of Extended Event Objects
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,173 reads
A DMV a Day – Day 27
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,551 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,231 reads
In, Exists and join – a roundup
Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...
2010-04-27
1,349 reads
Latest Issue of The SQL Server Standard – Volume 7 Issue 3
Available for download by all PASS members (membership is free), this issue has Techies Talking to Non-Techies by Don Gabor....
2010-04-27
627 reads
One Trip Booked – TechEd 2010
Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to...
2010-04-27
781 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers