Recently I tried to start a thing every Friday where database folks get together and chat over coffee or some other beverage. The intention was to share knowledge […]
administration / Database / MSSQL / TSQL
Auditing via the T-log
A client of mine recently wanted to find out who deleted all the records from a table being used in production. This is an issue that we have […]
Training Feedback 2015
As with the previous 2 years we have finished analyzing our feedback data from all the trainings conducted over Jan 15 – Dec 15. Another remarkable year with […]
administration / Database / MSSQL / TSQL
How to troubleshoot MS SQL Server
I am sure the title must have piqued the interest of most DBAs since this is what we do every day. It’s also one of the most common […]
SQL 2016 – Always encrypted
Here I try to summarize a lot of the information available on the MSDN website for the Always Encrypted feature being launched in SQL 2016. The primary concept […]
SQL 2016 – Setting up Always Encrypted
A quick Step by step guide on setting up always encrypted on the server as well as the client, and a quick approach on migrating existing tables to […]
SQL 2016 – In-Memory OLTP enhancements
A bit late in the day but I am still posting the changes to In-memory OLTP that are proposed for SQL 2016. Why? In-memory OLTP in SQL 2014 […]
SQL 2016 – Possible bug in temporal tables
I am not sure if this has been raised before, it seems like a very common scenario that I am sure most people will encounter but I wasn’t […]
administration / MSSQL / TSQL
SQL 2016 – Temporal Tables the way we are most likely to end up using it
In this post I am quickly going show how to convert the existing tables into temporal tables. This is a common requirement I expect we will all encounter […]
SQL Cuppa Sessions
If you have been following me on LinkedIn recently you must have seen this update. Looking forward to having some fun SQL conversations, especially on what people think […]