SQL Server Articles

SQL Server articles and tips, and getting the most out of SQL CoPilot.

SQL Server Articles and Tips

SQL Server Best Practices - Scan Your Entire Estate in Minutes

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...

Read more...

SQL Server DMVs - Performance and Troubleshooting

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.

Read more...

Getting Started With SQL CoPilot

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.

Read more...

DBCC CHECKDB - Use and Abuse

DBCC CHECKDB - How to use it and what to do when it finds corruption.

Read more...

SQL Server I/O Performance

A list of everything I could think of that can affect SQL Server I/O performance.

Read more...

Optimize for Ad Hoc Workloads

Optimize for Ad Hoc Workloads is a configuration option that can free significant amounts of memory for some SQL Servers.

Read more...

DBCC CHECKDB WITH DATA_PURITY

What is meant by data purity? How to check it. How to fix it.

Read more...

What is the Default Trace?

All about the default trace. What is it? What events does it contain? How can you view it?

Read more...

Recent and Upcoming Releases

SQL CoPilot Update - v2.0.21

Now you can scan your estate for best practices...

Read more...

SQL CoPilot Update - v2.0.17

Real-time dashboard, job information and more...

Read more...

SQL CoPilot Update - v2.0.15

New features added - and a bug fix...

Read more...

Version 2 Released

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.

Read more...

Version 1.6 Released

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.

Read more...

Version 1.5.1 Released

Four more reports have been added to SQL CoPilot.

Read more...

Version 1.4.3 Released

Fixes a bug that causes an error message in the Database Files report on case sensitive instances.

Read more...

Version 1.4.2 Released

Fixes a formatting issue and missing PLE for case-sensitive collations.

Read more...

Version 1.4.1 Released

SQL CoPilot now works with minimal permissions. And a couple of bug fixes as well!

Read more...