Microsoft announced GitHub Copilot in SQL Server Management Studio (SSMS). If you’re a DBA or a Data Engineer, you know the backlog is growing, the queries are getting more complex. In this article, I’m going to walk you through how I’ve integrated Copilot into my SSMS environment to write cleaner, faster code. Copilot In SSMS … Read more
In this article, I will take you on a deep dive into how to use SSMS like a professional. We will cover installation, navigation, and the expert workflows I use to manage complex database environments. How to Use SSMS SSMS is an integrated environment for managing any SQL infrastructure. It’s not the database itself (that’s … Read more
With the recent release of SSMS 22, Microsoft has fundamentally changed how we install, update, and interact with our SQL environments. In this comprehensive tutorial, I’ll walk you through everything you need to know about the latest version of SSMS. SSMS Latest Version What is New in SSMS 22? SSMS has moved to the Visual … Read more
In this article, I’m going to walk you through the professional methods I use to track down exactly who updated a table in SQL Server. We will move from the “quick ” checks to the robust, proactive ways. How To Find Who Updated The Table In SQL Server The Reality of SQL Server Tracking By … Read more
In this article, I will walk you through professional-grade methods for performing cross-table updates in SQL Server, from standard joins to advanced merge logic. SQL Server Update Table From Another Table Manual updates are out of the question for anything over a dozen rows. We need a way to tell SQL Server: “Look at Table … Read more
In SQL Server, you can use the Insert into select statement to insert data into a table from the SELECT Query. This is useful when copying data from one table to another. Let’s learn more about insert statements in SQL Server Management Studio. The syntax for Insert into Select Statement Below is the syntax for … Read more
One challenge consistently pops up: How do you generate INSERT statements from an existing SQL Server table without losing your mind?. Today, I’m going to share my professional blueprint for automating this process. Generate Insert Statements From Table SQL Server Generating these statements serves three primary purposes: Method 1: The “SSMS Script Data” Wizard (The … Read more
Knowing exactly which SSMS Version you are running is the first step toward a stable environment. In this guide, I will show you how to check your SSMS version using multiple professional methods. How To Check SSMS Version Method 1: The “Help > About” Menu (The Golden Standard) This is the most direct and authoritative … Read more
In this SQL Server tutorial, You will learn about SQL Server split string into rows. As a database developer or data engineer, sometimes, you need to split a string into rows while processing data. You will understand two methods to split a string into rows; in the first method, you will use the STRING_SPLIT() function, … Read more
In this article, I’m going to show you the authoritative ways to get row counts in SQL Server—ranging from the slow-but-accurate to the lightning-fast methods. SQL Get Number Of Rows In Table Method 1: The Standard COUNT(*) (Best for Small Tables) Let’s start with the basics. If you are working with a configuration table or … Read more