SQL Server articles and tips, and getting the most out of SQL CoPilot.
Here's a list of 50 SQL Server best practices and a way to scan your entire estate in minutes, with the results going to a spreadsheet...
Which SQL Server DMVs are used by SQL CoPilot, and examples of how you can use them to get data about your servers and for troubleshooting performance issues.
SQL CoPilot is designed to be very easy and intuitive to use, without the need for help files or detailed documentation. This article is a quick guide to getting started.
DBCC CHECKDB - How to use it and what to do when it finds corruption.
A list of everything I could think of that can affect SQL Server I/O performance.
Optimize for Ad Hoc Workloads is a configuration option that can free significant amounts of memory for some SQL Servers.
What is meant by data purity? How to check it. How to fix it.
Version 2 of SQL CoPilot has just been released. This is a complete rewrite as a standalone application, and no longer has any dependency on Management Studio.
You can now view summaries of execution plans, allowing expensive statements, table and index scans, missing indexes and warnings to be quickly identified. And it's been fully tested for use with SQL Server 2014.
Fixes a bug that causes an error message in the Database Files report on case sensitive instances.
Fixes a formatting issue and missing PLE for case-sensitive collations.