Aaron Bertrand (@AaronBertrand) explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
Aaron Bertrand (@AaronBertrand) talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
Another post, another set of slides and demo scripts. I have been out on the road for the last two weeks with SQL Relay 2015 here in the UK, travelling through Nottingham, Reading, London, Bristol, Cardiff, and Birmingham. Along the way I met a bunch of great speakers and had a lot of interesting conversations.
Prior to SQL Server 2016, 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
Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.
Tim Radney (@tradney) walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.