SQL Server Management Studio 18.9.2

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

C#, Excel, and SQL Server

Using Excel to work with SQL Server data sets is often more convenient than having to write a complete solution using C#. A variety of solutions exist to work with Excel from your C# code and Microsoft.Office.Interop.Excel is just one of them. EPPlus is also a popular solution for working with Excel. EPPlus is free… Read More