Along with the release of SQL server 2016 CTP 3 now comes the preview of a brand new feature for on premise databases – the Query Store. This feature enables performance monitoring and troubleshooting through a log of executed queries. This blogpost will cover the aspects of this new feature including: Introduction How to activate it Configuration options What information is found in the Query Store How to use the feature What’s in it for me
With the release of SQL Server 2016 CTP 3.0 also comes the ability to test the Many-to-Many functionality within the SSAS Tabular. This blogpost will cover the aspects of the many-to-many feature from SQL Server 2016 – including: Prerequisites The old way The new way This post is based on data from the AdventureWorksDW2012 database.
With the release of SQL Server 2016 also comes a great new feature to get a live view of the current execution plan for an active query. This blogpost will cover the aspects of this new feature including: Introduction How to activate How to use and read the output Downsides – if any
You know this everybody – you need to install a whole new SQL Server on the customers Windows Server. And the customer doesn’t have the time or money to wait for you to click around the GUI and sit around and watch the progress-bar move every second. So why not do this in a fully automatic way and in the same time save both effort and expensive time doing so?
Statistically it happens some time for all of us with a website – and today was my ‘lucky day’. Got a mail from my hosting-company telling me that my WordPress blog has gotten hacked and was disabled untill I changed all access-codes and made a full-re-install of the binaries. Luckily I’ve got backups of everything – so nothing was lost. Everything is a-ok now – and I hope it does not happen again.