Ever had your SHRINK operation “stuck” and didn’t know why, or how to solve it? It’s more common than you think. Check out this post for more info, tricks and tips.Continue reading “Troubleshooting Long-Running SHRINK Operations”
How well can you monitor Azure SQL Databases and Azure Managed Instances without any 3rd party tools? Is Azure SQL Analytics really good enough for the job? Can it be a decent competitor to powerhouses such as SentryOne, Red-Gate, Apex, Solarwinds and others? Can you use it as a cheap alternative in the cloud? Will I ever stop asking questions and get to the point already? Yes, of course I will! Just keep reading.Continue reading “Is Azure SQL Analytics all you need for SQL Server Monitoring?”
We all know the error log used by SQL Server to audit failed logins by default. But is it good enough? For many scenarios, it isn’t. It’s actually missing a lot of important information. But, worry not, for there are better solutions!Continue reading “Finding the Details Missing from the SQL Server Failed Logins Audit”
Linked Servers are an easy way to allow direct access between different SQL Servers. But, by using this feature, you may have created a wide-open backdoor into your servers! Read on for more details… Continue reading Are you using Linked Servers? They may be in serious danger!
Today’s script has something very interesting to do with Heap tables. Specifically, how to turn then into something that’s not a heap. Continue reading for more info…Continue reading “How to Un-Heap Your Heaps?”
Watch now! In this session, the second of a 2-part series, we will cover the rich tools, features, and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle, and how to solve common problems and edge cases.
This webinar was delivered as part of the PASS Global Hebrew Virtual Chapter, and as such is presented in Hebrew. Continue reading CI and CD with SSDT Part 2: Methodology & Features for DB DevOps (PASS Global Hebrew)
Watch now! In this session, the first of a 2-part series, we will learn what is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.
This webinar was delivered as part of the PASS Global Hebrew Virtual Chapter, and as such is presented in Hebrew. Continue reading CI and CD with SSDT Part 1: Development Lifecycle Basics for DBAs (PASS Global Hebrew)