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-03-31
38 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-03-31
76 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-03-31 (first published: 2023-03-28)
17 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)
53 reads
SQL Bits 2023 Recap
I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many...
2023-03-31 (first published: 2023-03-23)
127 reads
The AI T-SQL Tuesday–#160
It’s time for T-SQL Tuesday again, and this time there is an interesting invitation. Damien Jones reached out and wanted to host, so he gets to pick the topic...
2023-03-31 (first published: 2023-03-14)
187 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-03-31
89 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-03-31 (first published: 2023-03-28)
9 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-03-31 (first published: 2023-03-29)
32 reads
My personal experience using kubecost in Kubernetes environment
What is Kubernetes? Kubernetes which is also referred to as k8. k8 is an open-source container orchestration platform that automates deployment, scaling, and management of the containerized application. k8...
2023-03-29 (first published: 2023-03-19)
108 reads
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Remove the Dynamic code from my SQL sproc
I have a stored procedure that was created to run dynamically. Other than me...
Significance of Historical waits report in SQL server Performance dashboard
I have the following historical wait report for my SQL server. I have noticed...
Ask SSC