This blog comes to you from the home office after three days of caring for my sick six-year-old son. Yay for stomach bugs… Have you ever needed to install SQL Server for a quick test of a feature, stand up a fresh instance for a team, or automation? Like anything with technology, there are multiple Read More …
Are you starting to experiment with Azure SQL Databases? Is your company interested in moving to the Cloud and asking you to investigate different options? This blog will show you three options to connect to an Azure SQL Database using the same tooling you would use for on-premises SQL Databases. I will demonstrate the three Read More …
As you sit and wonder about when the next Star Wars movie is going to come out, do you ever get the thought of “I wonder if all my SQL Servers are configured the same?” Occasionally, I get a thought like that run through my mind. Or I might see something on Twitter or Blog Read More …
Have you ever opened the SQL Server Error Log and wondered, “where are all the errors?” Digging through the Error Log to find what you need can be a pain. Sure, you could use several methods to parse through the Error Log to find what you are looking for, but sometimes you want to take Read More …
Is your SQL environment prepared for a disaster? There are big and small disasters and depending on your perspective big and small can mean different things. Preparing your environment for these special events by exporting SQL Server Configurations for DR purposes is essential. I am not going to talk about your backup/recovery, HA, RPO, or Read More …
Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to create a schema only database copy. Here are three approaches that are easy to understand and perform. One approach will use PowerShell and the dbatools module. Read More …
No, No, not those dumps: SQL Server Memory dumps!! Recently, I was on Slack and wondered into the #firstresponderkit channel. I am a big fan of all the First Responder Kit utilities by Brent Ozar ( b | t ). I don’t usually poke my head in this channel. This particular day I was browsing Read More …
Here we are, another Tuesday!! It is time for our Fourth and final installment in the Failing SQL Agent Jobs series. This week, we will cover how to store SQL Agent Job Failures to a database for tracking and review. First step: This step we will re-use some code from our first blog in this Read More …
It is Tuesday!! Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators for sending notifications when Job Failures occur. First step: You must already have Database Mail configured on your SQL Server in order to follow along with Read More …
Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed Agent Job information and send the report via e-mail to the interested team(s). Let’s get started putting the pieces together to build our report. First step: Read More …
