I don’t know about most guys out there but I personally feel this was a great addition to SQL 2016. I use the datetime2 function quite a bit […]
SQL 2016 – Compress and Decompress – with a catch! Compress doesn’t always save space
While working at Thomson Reuters I was part of the Search and navigation team and we had a number of reports created around the data being analyzed from […]
administration / Azure / MSSQL
SQL 2016 – Basic Availability Groups
With database mirroring out of the picture a question on most SMEs mind was how can we get HA on our SQL machines now? Database mirroring was a […]
Creating a network graph in SQL Server
Over the holidays I have been looking to try out some new concepts in SQL Server and figured I should perform some analysis on all the emails I […]
Deploying changes to In-memory OLTP tables almost seamlessly
If you’re looking to implement the in memory OLTP tables in SQL Server 2014, one of the biggest drawbacks for the same is the fact that tables need […]
In Memory OLTP Decision Tree
A Very Simplified diagram explaining some key decision points and important aspect of using in memory OLTP in SQL 2014
Attaching a database mdf file when the ldf file is missing – with a catch!!
A few days back I got a call close to midnight where a client’s client was facing an issue. They had recently suffered a power failure and the […]
The Dunning – Kruger effect
If you don’t know what this means pay attention!! I recently posted a blog about the characteristics of a senior DBA. One of the points mentioned there was […]
Proof that tempdb mdf and ldf files are **NOT** dropped at the OS level when SQL Server is restarted
A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. https://www.youtube.com/watch?v=N4eB-uY5MYI […]
A ton of MS E-books to download
I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on […]