Jeff Iannucci

Jeff loves to help others save time. Whether improving query performance or reducing downtime for maintenance tasks or migrations, he’s not only passionate about discovering ways to save our most valuable resource, but also about sharing what he’s learned. Starting as an accidental DBA in 1998, Jeff has worked extensively with SQL Server database design, administration, and T-SQL development. He appreciates any opportunity to share his knowledge with the community, and has been presenting at user groups and writing blog posts since 2018. He was chosen as an IDERA ACE for 2020, and in 2021 became an author for Pluralsight. When not resolving database issues, he enjoys watching Indycar racing, attending Arizona Diamondbacks and Phoenix Suns games, and cooking Italian food for his wife and four children.

SQL Server Tool Update: sp_CheckSecurity version 1.1

by
free sql server dba tool sp_CheckSecurity

Since releasing our initial version of sp_CheckSecurity, we have received quite a bit of feedback. Thank you for all the emails, blog comments, and issues noted in GitHub, that have all been helpful in directing us towards making this SQL Server tool more useful. Today we are announcing the release of version 1.1, available for download … Read more

Introducing sp_CheckSecurity

by
free sql server dba tool sp_CheckSecurity

Are your SQL Servers secure? With new threats to your data emerging daily, it’s a difficult question to answer. And what is even included in the word “secure”? Sure, maybe you’re confident you have security against hacking (or maybe not?), but what about internal security? Are you protected against oops moments? Are there elevated permissions … Read more

Make SQL Server Database Restores Easy With sp_DatabaseRestore

by
easy sql server database restores

If you’ve read the Straight Path blog for any period of time, you’ve probably noticed more than a few posts about database backups. You may have also noticed we’re big fans of the Ola Hallengren Maintenance Solution for backups, which creates stored procedures and jobs to handle your regular backups. These scripts and jobs are … Read more

7 Common SQL Server Transaction Log Myths

by
sql server transaction log myths

SQL Server is a complicated piece of software, so it’s understandable that some of us have some misconceptions about what the transaction log is and what it does. This post is designed to not just tell you about these myths, but also to show you a few ways how to prove (or rather disprove) some … Read more

10 Free SQL Server Resources We Love

by
free sql server resources

Featured image photo by Susan Holt Simpson on Unsplash Everybody loves freebies, and the SQL Server community is full of them. Free scripts, stored procedures, blog posts, books, and helpful advice from some of the smartest minds are all available to you right now. So whether you’re just starting your career as a Database Administrator … Read more

5 common Problems to Troubleshoot with sp_WhoIsActive in SQL Server

by

If there were a Mount Rushmore of SQL Server community tools, Adam Machanic would have to be one of the four faces. You may not know his name, but you more than likely know the free troubleshooting tool he created over a decade ago: sp_WhoIsActive. Fix your performance problems, fix your blocking, fix a bunch. … Read more

6 Common Mistakes Made With SQL Server Backups

by
6 Common Mistakes Made With SQL Server Backups

People are always saying things about the importance of data, like how it is the lifeblood of a business. It sounds cliché, but there’s a lot of truth to that. You and I can’t survive without any blood, and there’s a good chance your business wouldn’t exist for long if they suddenly lost all their … Read more