Home - SQL Nuggets

Speaking

Eric regularly speaks at developer and database conferences throughout the country. See a list of upcoming and previous speaking engagements.

Presentations

If you have attended one of Eric’s conference sessions and would like to download the files for a presentation, this is the place!

Developer Tips

As a Developer turned DBA, Eric offers tips about database design, indexing, and other things he wishes he would have known as a developer.

Downloads

Open source SQL Server projects, such as SQL Server Metrics Pack and SQL Server Permissions Manager, that are freely available for download.

Latest Blog Posts

2020 IDERA ACE

Posted on October 30, 2019 by Eric Cobb

I am super excited to announce that I have been selected to participate in the 2020 IDERA ACE program! IDERA made the announcement last week, and I am honored to …

Recover Deleted Indexes With SQL Server Metrics Pack

Posted on October 22, 2019 by Eric Cobb

In my latest enhancement to SQL Server Metrics Pack , I added a new feature to the index metrics scripts that automatically generates a CREATE INDEX script and stores it …

SQL Server Metrics Pack Update – September 2019

Posted on September 20, 2019 by Eric Cobb

This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements …

SQL Scripts: Find Queries That Have Missing Index Requests

Posted on August 27, 2019 by Eric Cobb

In a previous article, I went over how SQL Server will recommend an index that it believes will help a query run faster, and I showed how to find missing …

Patching Multiple SQL Servers With Powershell and dbatools

Posted on July 18, 2019 by Eric Cobb

Patching SQL Server can sometimes be a time consuming process, especially when you have multiple servers that need to be patched. Remoting in to each box to run through the …

Read Blog