How to Enable Transparent Data Encryption for Databases in Your Availability Group
Transparent data encryption is the built-in method for at-rest data encryption in SQL Server. Taking steps towards security has always been important, but it is becoming even more important every…
How to Provision a Low-Cost SQL 2022 Testing Lab
This month we will be covering some features in SQL 2022. Specifically, I will create a new SQL 2022 Development instance and connect it to Azure Arc. Azure Arc is…
7 Common 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…
18 Misconceptions: Your Database is [NOT] Secure!
Welcome to Myths and Misconceptions Month, or “Mythconceptions Month,” as we have lovingly referred to it in our internal discussions preparing this month’s content. We will have posts about the…
Ask Us Anything Webinar (March 2023)
This month’s webinar is an opportunity to ask us anything related to SQL Server. Our team will hold a panel-style webinar to answer your questions (click here to submit a…
10 Free SQL Server Resources We Love
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…
SQLwatch.io as a Free Monitoring Tool for Your SQL Servers: A Jr. DBA Review
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….
5 common SQL Server Problems to Troubleshoot with sp_WhoIsActive
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…
SQL Server Maintenance With Ola Hallengren’s Maintenance Solution.
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…
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….
2 thoughts on “SQL Server Blog”