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

Notes From A SQL 2017 Azure Install – Availability Group Nodes Across Multiple Azure Regions

Posted on June 26, 2018 by Eric Cobb

One of the really great things about Azure is the capability to easily create servers in other data centers, in other parts of the country or world (referred to as …

SQL Scripts: How To Find Missing Indexes

Posted on June 5, 2018 by Eric Cobb

One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it …

Speaking At Music City Data 2018

Posted on May 30, 2018 by Eric Cobb

Music City Data (part of the 3-day Music City Tech conference) is this Saturday, June 2nd, and I realized last night that I had completely forgotten to announce that I will …

SQL Scripts: How To Find Filtered Indexes

Posted on May 9, 2018 by Eric Cobb

Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …

Read Blog