Blog

Azure Data Studio Schema Compare

Do you need a tool for comparing database schemas? Azure Data Studio can be your answer. Let’s walk through using Azure Data Studio’s Schema Compare extension. Installing SQL Server Schema Compare Extension First, let’s open up Azure Data Studio. We’ll select the extensions button on the left: And we’ll search for schema compare: The only … Continue reading Azure Data Studio Schema Compare

SQL Server 2022 Released

It was last December when the first CTP for SQL Server 2022 was made available. Last week, on November 16, SQL Server 2022 was officially released. Gather ‘Round I felt like putting together a small roundup of blogs/links around the newest SQL Server release and came up with the links below. Some links are older, … Continue reading SQL Server 2022 Released

What Are All of These Acronyms?

It doesn’t take much to get confused when someone is rattling off multiple acronyms that you’re unfamiliar with. This is especially true when you’re just starting out in a profession or hobby as others might assume you know certain lingo or jargon. With that in mind, I wanted to take a look at some of … Continue reading What Are All of These Acronyms?

The Ins and Outs of OUTPUT

Are you familiar with the OUTPUT clause in SQL Server? It can be used with commands like INSERT, UPDATE, DELETE, and MERGE. It can also be used with setting variables in stored procedures. Using the tried and true StackOverflow2013, we’ll narrow it down today to focus on how INSERT/DELETE are typically used for logging table … Continue reading The Ins and Outs of OUTPUT

Notepad++ Macro and SQL Scripts

I recently saw a comment about building SQL scripts with Excel. While I haven’t gone that route before, the comment did remind me of a quick and dirty way of generating SQL statements with Notepad++ and macros. It can be helpful when you have the right set of data and repetitive steps to take. Let’s … Continue reading Notepad++ Macro and SQL Scripts

Recognizing the Resource Database

Can you name each of the system databases in SQL Server? You might be able to name master, msdb, model, and tempdb. What about the fifth system database? Don’t feel bad if you’re drawing a blank. The fifth system database is the Resource database. Even if you’ve never heard of the Resource database, chances are … Continue reading Recognizing the Resource Database

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.