DBA Myths: CHECKDB runs on startup.
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for ... Continue reading
2019-09-30 (first published: 2019-09-16)
581 reads
SQLStudies
DMV with SQL Server Service info (including the service accounts)
I recently found this DMV and couldn’t wait to share. sys.dm_server_services What’s so great about it? For each service for ... Continue reading
2019-09-23 (first published: 2019-09-12)
1,023 reads
My fantasy SQL feature(s)? T-SQL Tuesday #118
It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? ... Continue reading
2019-09-19 (first published: 2019-09-10)
524 reads
When were the statistics last updated and how many rows were sampled?
TL;DR; Final query is at the bottom. Every now and again (particularly when someone is having performance problems) I’ll get ... Continue reading
2019-09-04
198 reads
SQL Homework – September 2019 – Getting the data in
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-09-02
242 reads
Why is as important as How
I recently had someone tell me, and I’m paraphrasing a bit here: We know how to fix this now, so ... Continue reading
2019-08-28
158 reads
Setting Trigger Order
If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you ... Continue reading
2019-09-09 (first published: 2019-08-26)
533 reads
Why do DBAs dislike loops?
If you started out as a developer you were probably taught how important loops are. They are one of the ... Continue reading
2019-09-02 (first published: 2019-08-22)
1,223 reads
7th Anniversary
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
13 reads
Constructing a datetime from an integer date and an integer time.
Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date ... Continue reading
2019-08-27 (first published: 2019-08-15)
788 reads
Blogs
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Forums
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers