Tag: sql server

Community

Locking down Microsoft SQL Server

Rewriting applications because of database security gaps is costly and time consuming. One of the easiest ways to avoid rewrites is to make security a priority during the initial database design and to enforce security at each tier. <br><br> We’ll discuss some of the techniques for providing a s

Community

Book Review: Transact-SQL Cookbook

by Ales Spetic & Jonathan Gennick – So you have mastered Transact-SQL, and you know how to SELECT, INSERT, UPDATE, and DELETE data. But, do you know how to create and use a pivot table, how to summarize classes of sets of data, how to find the complement of a set, how to calculate a matrix trace, ho