Visual Studio Magazine

Write .NET Code in SQL Server

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...
techtarget

Six sample databases for SQL Server and how to find them

It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database used to be installed as part of the SQL Server installation process. Fast forward to ...
Network World

Chapter 3: Examples of SQL Server Implementations

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

[Database Series 06] Understand Bind Variables! Basic Techniques to Prevent SQL Injection and Improve Performance

The content of this article might be a bit difficult for those with no programming experience.This is because, in my ...
Visual Studio Magazine

SQL Formatter Previews in Microsoft's MSSQL VS Code Tool

MSSQL v1.45 adds a built-in T-SQL formatter in public preview. Azure SQL Database Provisioning is now generally available. Shortcuts Configuration also moves to general availability. Microsoft has ...