People want to make things faster. It’s in our nature as IT professionals. What are you tuning for? I’ve been asking that a lot later. I have to sit back and ask some very basic questions to try to see where people’s IT-related pain is at. What is your end goal? In my world, I…
Month: May 2020
The default filegroup, and why you should care.
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index & heaps) and another for the indexes (non-clustered indexes). Or maybe you want to separate your data tables from the system tables. There are any number of reasons why you might want to have multiple…
Automate SQL Server error log alerting with Minion Enterprise
Minion Enterprise (ME) is our tool for auditing, managing, and alerting on SQL Server instances and servers. With ME, you can automate custom SQL Server error log searches! One of the features is the error log search alert. The Error Log Search module allows you to set up specific error log search terms
Ten minute SQL Server backup and maintenance
We’re going to set up backup, DBCC CheckDB, and index maintenance for 5 servers in 10 minutes. Note that doing the same thing for 50 servers would take the same amount of time! Why do backups and CheckDB and index maintenance?
Clumio’s Rapid Recovery is amazing for SQL Server
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both cloud and on-premises environments where the storage endpoint is in the cloud instead of a storage platform in your own datacenter. I’ve been exploring their offerings,…