SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.

The containerized SQL Server can be managed through a number of other tools, including Visual Studio Code and SQL Server Management Studios for Windows. Red Hat and SUSE already have built-in ...

As promised in part one, I developed a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database (See Code Download for full source code and executable). The ...

They can produce .Net managed code that runs as SQL Server-stored procedures and create custom objects for ETL (extraction, transformation, and loading).

You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.