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?
T-SQL Tuesday #156 – Production-Grade Code
What quality makes code production-grade? That’s the question posed by Tom Zika in this month’s edition of T-SQL Tuesday. I don’t believe there’s a “right” answer to this question but I do know there are plenty of opinions. Check out the full invitation post by clicking the T-SQL Tuesday logo and read on below for … Continue reading T-SQL Tuesday #156 – Production-Grade Code
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
The Rivalry Between SELECT INTO and INSERT INTO
Data can be inserted into one temp table from another a couple of ways. There is the INSERT INTO option and the SELECT INTO option. Are you devoted to one option over the other? Maybe you’re used to one and never experimented with the other. Let’s test each and compare performance to find out which … Continue reading The Rivalry Between SELECT INTO and INSERT INTO
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
Updating with Nested REPLACE Functions
Have you ever ran into a situation where you needed to replace both ends of a string? Maybe it was tags in a set of XML values or phrases at the beginning and end. I came across that situation recently and was able to show if two statements were needed or if REPLACE could be … Continue reading Updating with Nested REPLACE Functions
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
Pagination Options in SQL Server
If you’ve ever been combing through Google search results or a list of items on Amazon, you’ve seen paging in action. These sites don’t show you millions of results at once. Instead, they may grab the first 20 results for a page, then the next 20 results when you go to the next page, and … Continue reading Pagination Options in SQL Server
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Chad Callihan 