2020 IDERA ACE
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 …
Nuggets Of SQL Server Knowledge
Eric regularly speaks at developer and database conferences throughout the country. See a list of upcoming and previous speaking engagements.
If you have attended one of Eric’s conference sessions and would like to download the files for a presentation, this is the place!
As a Developer turned DBA, Eric offers tips about database design, indexing, and other things he wishes he would have known as a developer.
Open source SQL Server projects, such as SQL Server Metrics Pack and SQL Server Permissions Manager, that are freely available for download.
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 …
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 …
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 …
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 …
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 …