New Job -> Week 5 -> Create Index Maintenance Scripts
This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL...
2023-04-18 (first published: 2023-04-17)
183 reads
SQLKitty
New Job -> Week 4 -> Set Up Auditing
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure...
2023-04-19 (first published: 2023-04-06)
375 reads
New Job -> Week 3 -> Creating Alerts
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
186 reads
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life....
2023-04-10 (first published: 2023-03-24)
556 reads
New Job -> Week 1 -> What Tools Do You Need?
I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when I...
2023-04-05 (first published: 2023-03-17)
429 reads
Creativity in Technology
I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...
2023-03-24 (first published: 2023-03-15)
184 reads
Documentation vs Automation
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
453 reads
Help! My tempdb is full and I can’t access SQL Server!
I got a call saying the database server is inaccessible because tempdb is full. I get online and try to connect because I want to see the error for...
2023-01-18 (first published: 2023-01-06)
1,099 reads
Long time, no posts
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
32 reads
Adding AD group perms to SQL Server
Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg...
2022-10-27
23 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