Every once in a while I see a post on the forums that is similar to the one below:- Hi Can anybody provide tips on how to improve […]
administration / Database / MSSQL / TSQL
What’s in a name? Mdf = pdf
“What’s in a name? That which we call a mdf file By any other name would work as well.” At a training recently I was asked this question, […]
administration / Database / MSSQL / TSQL
How to troubleshoot MS SQL Server – Part 2
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
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 […]
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 – 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 2016 – TempDB Optimizations are enabled by default Woot!!
Last year I had spent a decent amount of time writing about tempdb. With SQL 2016 a lot of those point are validated and enabled by default going […]
SQL 2016 – sys.dm_exec_query_stats upgraded version
This is one the most frequently used DMVs for DBA when troubleshooting performance issues and MS has been adding more columns to the DMV with every release. In […]