How do I tell what compression level my tables/indexes are?
It’s been a while since I worked with compression and the other day I needed to check which of my ... Continue reading
2020-11-27 (first published: 2020-11-17)
524 reads
Reflections on PASS Virtual Summit 2020
PASS Summit 2020 has wrapped up (or is in the process of wrapping up), and as with years past, I’m getting this written while the experience is still fresh...
2020-11-17
18 reads
The Secret to Saving on Cloud Costs
Have you ever cringed when you received your monthly cloud bill? Does it feel like you’re overpaying for your cloud services, but don’t know how to reduce your monthly...
2020-11-27 (first published: 2020-11-16)
434 reads
The Learning Curve for DevOps
If you’re attempting to implement automation in and around your deployments, you’re going to find there is quite a steep learning curve for DevOps and DevOps-style implementations. Since adopting...
2020-11-25 (first published: 2020-11-16)
281 reads
Daily Coping 16 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-16
34 reads
SQLpassion Black Friday Deal 2020
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-11-16
24 reads
SQLpassion Black Friday Deal 2020
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-11-24 (first published: 2020-11-16)
211 reads
What the future of PASS needs – and how I can help
At the recent PASS Virtual Summit I and the other candidates took part in a Ask Me Anything (AMA) session – where the community posed us questions. It was...
2020-11-24 (first published: 2020-11-16)
222 reads
PASS Summit 2020 – My experience
This was the first year in 16 years for me that there has been a fall season without the PASS Summit to go to. Every year, during the fall,...
2020-11-25 (first published: 2020-11-15)
281 reads
Notes on the 2020 PASS Virtual Summit – Part 6
Mostly Friday notes here. This morning I was the moderator for Continuous Integration with Local Agents and Azure DevOps by Steve Jones. The way the Summit worked this year...
2020-11-14
43 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers