Stronger Security Via Always Encrypted in SQL Server 2016

October 3, 2017 by Leave a Comment

STRONGER SECURITY VIA ALWAYS ENCRYPTED IN SQL SERVER 2016 Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data within a table. Second, TDE encrypts only data at rest, in files. Data in memory or in-flight between the application and server are unencrypted. Enter Always Encrypted. READ … [Read more...]

Filed Under: Architecture, Compliance, DBA, DBTA, Security, SQL Server Tagged With: ,

Is Microsoft SQL Server Supported By …?

March 19, 2013 by 1 Comment

One of the types of question you get after speaking at a conference about virtualization, like I did at the 2012 PASS Summit with my buddy David Klee (Twitter | Blog), might go down like this: "Is SQL Server version X supported on hypervisor platform Q?" or something even more specific like "Is SQL Server 2012 supported on VMWare vSphere ESX 4.1 Update 2? Or do I have to upgrade to ESX 5.0?". Now, when I'm asked a question like this, I usually drool and act like an ape, hoping the the questioner will flee in terror.  If they insist on hanging around to hear a real answer, I now refer them to … [Read more...]

Filed Under: Administration, Compliance, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag Tagged With: , , ,

Microsoft Document Watch for Operational Excellence

August 8, 2011 by 1 Comment

Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence.  I read everything I could on the topic.  I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins.  (Perhaps that list of favorites might, in and of itself, make a good blog post).  Fast-forward a decade and I'm still mightily interested in operational excellence for IT organizations.  It's just that so much good material is available for free on the … [Read more...]

Filed Under: Administration, Architecture, Compliance, Cool Technologies, Hardware, On-Line Resources, Security, SQL Server, SQLMag, SQLServerPedia Syndication, Strategies, TCD blog post, Tips & Tricks, Virtualization Tagged With: , , , , , , , , , , ,