Data Ceili 2023 – Schedule and Registration
Today we have announced the schedule for Data Céilí 2023 and have opened registration! We have two days of great sessions for you, the 8th of June will have...
2023-04-03
44 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)
897 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)
255 reads
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,161 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)
199 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)
588 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)
624 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)
194 reads
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When I got off the plane from SQLBits I wasn't feeling great. To be honest, I...
2023-03-28
69 reads
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container applications. What are containers? Containers are a way to package software in a portable and...
2023-04-10 (first published: 2023-03-27)
261 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers