“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
Using Decision trees Algorithm in Data mining
A small video on how to setup and use the decision tree algorithm in SSAS to perform data mining. This video should help most developers get started. https://www.youtube.com/watch?v=dtoEMqQGcKg
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 […]
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 – 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 […]