Redmond

Exploiting SQL Server 2008 Through Code

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

Access + SQL is the optimal low-code solution

With low-code gaining attention, what is the "structure that can strengthen field culture without destroying it"? The optimal ...
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 ...
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 ...

Create a dependency map with graphify before touching legacy code

When you are asked to modify legacy code, what is the first thing you do?Looking at the file list in an IDE, searching for ...
TechRepublic

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

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. I once was pulled into a discussion about the ...