Building proof of concepts is harder than it looks. John Sterrett shows how DBAs and developers can build them faster and get more out of Windows Azure.
SQL SERVER – Common Sense Data Security – Notes from the Field #055
Kevin Hazzard explains common sense data security for sensitive user information, with humor and real world examples you will recognize.
SQL SERVER – Validation Rules: Code or Database? – Notes from the Field #054
Should validation rules live in the .NET app layer or in the database? G. Andrew Duthie looks at this common argument between developers and DBAs.
SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053
Stuart Ainsworth shows a cool trick: using Bitwise And (&) instead of a junction table to get more performance with fewer code changes.
SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052
Kathi Kellenberger explains Table Valued Constructors, a relatively unknown topic, in the 52nd episode of my Notes from the Field series.
Why Use Biml to Build SSIS Packages Faster
Why use Biml when SSIS already has a designer? This guest post by Reeves Smith shows how one XML file and a single variable can generate many near-identical SSIS packages, and when the extra effort pays off.
SQL SERVER – Do You Know Your Data’s Classification? – Notes from the Field #050
Tim Radney asks if you know your data’s classification, and explains why data professionals must know what data they hold and how sensitive it is.