Had some spare time today so I used it to finally get around to a small project I had in mind. The intention is just to do it […]
SQL 2016- Activity monitor – Active Expensive Queries
Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. […]
SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered
So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the […]
Fill Factor and Page split demonstrated
Recently on one of the popular SQL Forums I read a post by a DBA who seemed experienced but still had a poor understanding of fill factor and […]
Some new screens you will likely encounter when installing MS SQL 2016
Here a screenshot by screenshot tour on installing SQL 2016, please keep in mind that this is a CTP (preview) so the screens may differ from RTM – […]
Did you know you can launch a trail version of SQL 2016 Azure VM?
But you will be charged for it because it launches the VM under your Azure account and will be billed as per usage. However you can register for […]
The tempdb – why shrinking doesn’t always work
Recently I was working on performance issues for a client and one of the topics we were looking at was tempdb. There was some confusion about when tempdb […]
Performance comparison between Plain text, Hashing and Cell level encryption
In this blog post I am doing a quick comparison on the performance implications of using Cell level encryption vs Hashing vs storing the data as plain text […]
OStress.exe – use it if you aren’t already
I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. […]
MS SQL Server and Tic Toc and why I changed my mind that it’s a good idea
I am not sure MS has got it right with the release cycle for SQL server. While this debate has happened before (I was then excited that there […]