Ars Technica

SQL Server 2005 TSQL syntax for getting dta out of an update or insert

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...
Ars Technica

SQL Server 05 - Symantec Backup Exec vs... RedGate vs. TSQL... thoughts?

We are getting a new SQL server to run a vendor application.<BR><BR>The other sys admins want to get Symantec Backup Exec version 10D's SQL Agent for the server.<BR><BR>I personally think it would be ...
Redmond Magazine

T-SQL Smarts -- Preventing Injection Attacks

Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack. As much as making your T-SQL work smarter for you, a la ...
MCPmag

Hacking SQL Server

SQL Injection is a fairly new method of hacking your database. Learn how it’s done—and how to protect yourself. MOST NETWORK ADMINISTRATORS charged with keeping the network infrastructure secure tend ...