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 …

Backing Up Databases With The dbatools PowerShell Module

Posted on November 20, 2019 by Eric Cobb

We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I’ve actually done as many as 40 in one day. Our …

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 …

Read Blog