7 Common SQL Server Transaction Log Myths

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

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

SQLwatch.io as a Free Monitoring Tool for Your SQL Servers: A Jr. DBA Review

SQLwatch review - free monitoring tool - review by jr DBA

I have been working for Straight Path for a while, and I have grown comfortable with the monitoring tools we use and what we look for on a daily basis. I thought I would branch during our second “Community Tools Month” and try out SQLWatch since it is a free community tool designed to help … Read more

5 common Problems to Troubleshoot with sp_WhoIsActive in SQL Server

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

SQL Server Maintenance With Ola Hallengren’s Maintenance Solution.

Ola maintenance for sql server databases

Perspective from a Junior DBA. Welcome to our month of community tool blog posts! We will discuss some of our favorite and most used tools and how we use them in the coming weeks. Our first post is on Ola Hallengren’s SQL Server maintenance solution. For some, this will be old news; this will be … Read more