Subscribe for notifications
I'm trying to share information as much as possible. I run weekly webinars, speak in various conferences and try to blog for new things. If you'd like to know what I'm doing you can easily subscribe for my notifications. Notifications are just as said: Notifications. I'm not selling anything or spamming you. Only info you want with option to unsubscribe always.
You can subscribe for notifications at: https://www.qumio.com/Subscribe/
Free SQL Server tools
I've done few useful tools for SQL Server that help me doing my work everyday. These tools are free to use for everyone but because of the nature of the "free lunch" I don't provide any guarantee nor take any responsibility of the side effects when using tools.
That said I'll still add that these tools are now downloaded more than 1000 times and I've never heard from anyone that they've had any issues with them.
sp_DBCCInfo
When was DBCC CheckDB last succesfully ran? Is your database's data purity checked when you run CheckDB? Is your database updated from previous versions? sp_DBCCinfo answers these questions when you ran this. My normal procedure is to schedule this to be ran once a month and report the result to DBA team. It's a report that gives you confidence that there is no hidden corruption problems in your database. For detailed information please read my blog post about the tool.
Qumio_SQLio_util
PowerShell script that runs a set of batches with SQLio and puts the results to database. You can easily make reports of your Disk Storage performance with different SQL Server related workloads after you've uploaded the results to database. For detailed information please read my blog post about the tool.