If you’re already running SQL Server Management Studio (SSMS) 18, a notice should appear advising that an upgrade to 18.9.2 is available. You can get the latest version from Download SQL Server Management Studio (SSMS) – SQL Server Management Studio (SSMS) | Microsoft Docs If you need the latest version of SQL Server Management Studio,… Read More
SQL Server – MSSQLTIPS
Writing date-based queries with SQL Server are common in our industry. Writing good queries is likely less common. As a subscriber to the MS SQL Tips new letter, I frequently encounter useful information and helpful tips. “Using a calendar table in SQL Server – Part 1” by Aaron Bertrand (2021-04-22) is particularly useful for creating… Read More
SQL Server – Dynamic Data Pivot
Creating a pivot table dynamically is not difficult as it may seem. Try it and you’ll see how relatively simple it can be. Read More
SQL Server Management Studio 18.8
Microsoft SQL Server Management Studio with Azure Data Studio was released on December 17, 2020. SQL Server is my RDBMS of choice for Enterprise level applications. Having the latest SSMS with Azure Data Studio offers the best of both worlds. Download SSMS-18.8