In this series of posts covering the new features in SQL Server 2016, I'm moving on to looking at the Query Store. This tool provides a way to track query execution plan performance over time to help assist troubleshooting efforts. Figuring out why the database has suddenly started running slowly can be at times difficult to diagnose quickly. The query store is an extra tool … [Read more...] about SQL Server 2016 New Features – Query Store
In my previous post, I listed a number of the SQL Server 2016 new features. Let's look at the first one in that list - Always Encrypted. With Always Encrypted the key to unlocking the encryption resides with the application. The encyption key is never passed to SQL Server. God like administrators cannot view the data on the server in its unencrypted form. This provides a … [Read more...] about SQL Server 2016 New Features – Always Encrypted
SQL Server 2016 will be made available to purchase by the public on 1st June 2016 and if we compare this schedule with Microsoft's plans of a major release every 2 years, this one comes 26 months after SQL Server 2014 which arrived on 1st April 2014. So will the list of new features in SQL Server 2016 persuade businesses to upgrade? This list is by no means complete and … [Read more...] about SQL Server 2016 – What Are The New Features?
If you're looking at performance and trying to understand I/O on a per database level in SQL Server, sadly there is not a report in Management Studio that you can run from those available. It will need some T-SQL to pull out this information from an existing DMV - sys.dm_io_virtual_file_stats. The information returned by the DMV is data which has been recorded since the … [Read more...] about How to Find I/O Usage Per Database in SQL Server
SQL Server Developer Edition - whether you are wanting to learn the product at home to advance your career or you need a copy for your enterprise to test and develop on, it's historically been a good investment for relatively little cost. Personally for home use, I have always downloaded the evaluation versions of SQL Server that expire after 6 months. That's kind of … [Read more...] about How to Get SQL Server Developer Edition for Free