Visual Studio Magazine

Elevate SQL Development with VS Code

As SQL development increasingly becomes part of full-stack workflows, developers are looking for ways to simplify their tooling without compromising capability. While SQL Server Management Studio ...
CSOonline

SQL Slammer 16 years later: Four modern-day scenarios that could be worse

If you were in IT in 2003, you remember what you were doing when Slammer went off like all civilians do when a president is shot. It was a Saturday…early Saturday. The SQL Slammer worm had been ...
TechRepublic

Determine when to use stored procedures vs. SQL in the code

Determine when to use stored procedures vs. SQL in the code Your email has been sent Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one ...
InfoWorld

How to use GPT as a natural language to SQL query engine

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...
Visual Studio Magazine

Visual Studio Code SQL Server Tool Gets IntelliCode, Object Explorer

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...