Visual Studio Magazine

10 More New T-SQL Functions

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...
dbta

Code for Performance from the Start

All SQL data manipulation operations—that is, Select, Insert, Update, and Delete statements—are performed at a set level. One retrieval statement can return multiple rows; one modification statement ...
BizTech

What Is SQL Injection and How Do You Prevent It?

Autumn is an associate editorial director and a contributor to BizTech Magazine. She covers trends and tech in retail, energy & utilities, financial services and nonprofit sectors. But what are SQL ...
dbta

It’s Always a Good Time for New Features

Change Data Capture for Azure SQL Databases in Public Preview For decades, users of SQL Server have requested a feature to capture historical change information and tracking for SQL Data Manipulation ...