How to use Minion Enterprise for the first time, part 2
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
Articles
How to use Minion Enterprise for the first time
This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.
PowerShell for fun (and profit?)
Let’s have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
In Beta: Health Check for Minion Enterprise!
At the PASS Summit we were thrilled to announce a new feature: Health Check for Minion Enterprise! Minion Enterprise already gathers a ton of information about your servers and SQL Server instances into a central repository, which is perfect for alerting, reporting and configuration. Now, we’re adding standard audits and internal health checks, so you …
New book: Voices from the Data Platform (Kindle)
Before I even tell you about this book, go get the Kindle version for $10! for free, before the sale ends! (The sale has eneded.) Let Her Finish: Voices from the Data Platform The writing of this book was a collaborative effort taken up by 7 very talented IT professionals. – From the Amazon.com book description …
New book: Voices from the Data Platform (Kindle) Read More »
Which is the performance killer: SELECT INTO or INSERT INTO?
There are many ways to kill performance in a script or stored procedure. However, not many think about the possibility that adding columns to a temporary table can kill performance. Here, I’m going to show you how a simple design decision – using INSERT vs ALTER TABLE – can have a huge impact on your procedure …
Which is the performance killer: SELECT INTO or INSERT INTO? Read More »
Protect yourself from Ransomware with Minion Enterprise
Ransomware is becoming a huge problem in the corporate world as more and more companies fall prey to this heinous act of terrorism. One of the biggest disasters that could befall you as a company – or even specifically as a DBA – is to come in one day and discover your shop has been …
Protect yourself from Ransomware with Minion Enterprise Read More »
I’m the new DBA, and I’m locking down development servers
As the new DBA, I’m here to fix things for you. I’m going to take care of the things that keep causing fires and outages and slowdowns….and I’m locking down your dev environment. Here’s why.
We just upgraded the Minion Maintenance suite!
Welcome to the next version of Minion Maintenance! Now you have a single installer for all three modules, plus new features and fixes for the entire backup and maintenance suite!
Get table properties in Azure SQL Database
Even in Azure SQL Database, you need to know certain things about your tables that can be hard to find. We’ll show you how to get that data.