Recently someone posted a question on one of the popular groups on Linkedin about one of the most fundamental structures in RDBMS the PK. It was followed by […]
administration / MSSQL / TSQL
administration / Database / MSSQL / TSQL
Very large table performance – basic data capture
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 […]
Session State request to session state server
Problem Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server […]
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, […]
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 […]
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 […]