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)
181 reads
Blog Posts
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and it can have a range of negative impacts on SQL Server performance and stability, potentially...
2023-04-17 (first published: 2023-03-31)
1,089 reads
Tales From The Field Weekly Wrap Up for the Week of 04-10-2023, Taylor Swift, & The Disney 10 Miler
Hello Dear Reader! Last week was a really busy week with an even busier weekend. We will get to the show recap's in a moment but first let's dive...
2023-04-17
13 reads
Truncating very large transaction log in full recovery mode
While I always configure transaction log backups for every database in non-simple recovery model, and to compliment it I also have monitoring in place if transaction log doesn't get...
2023-04-17 (first published: 2023-03-31)
859 reads
Autonomous Driving Around London
There’s a video of Bill Gates taking a drive in an autonomous car around London. I’ve been to London dozens of times, ridden and cabs and Ubers, and even...
2023-04-14 (first published: 2023-03-31)
239 reads
Typing with Your Tongue Part 2: Voice Access
A few months ago, I wrote a post on how I use voice technology to continue working with my ALS condition. Since that post was written, Microsoft released a...
2023-04-14 (first published: 2023-03-28)
171 reads
Flyway Desktop PoC–Adding a Shadow and Baseline Script
In the last post, I created a baseline marker for Flyway in each database. This set the version in the dev and QA databases to v1. However, I also...
2023-04-12
34 reads
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management Studio to authenticate using Azure Active Directory to a SQL database in Azure? I had...
2023-04-12 (first published: 2023-03-28)
596 reads
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow us to spot when someone may be up to no good. We can look at...
2023-04-12 (first published: 2023-03-29)
551 reads
Reasons Why SQL Servers Don’t Get Configured to Industry Best Practices
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers...
2023-04-11
12 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers