In this post we carry one from where we left off in the first part. Since we discussed what the L1 DBA (resident) should try and do when […]
administration / Database / MSSQL / TSQL
SQL Cuppa – A new skype handle and logo
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 […]