Along with my freelance work as an independent consultant, I do keep an eye on various forums and look at issue reported with solutions so that I can blog about them to help the community. One of the Facebook group where I am active is SQLBangalore and recently once of the member posted an issue. He was trying to create a login using SQL Server Management Studio and getting error for SELECT INTO statement as below.
SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days
Just the other day one of my customers asked me that they are facing a situation where they have specified in their backup script RETAINDAYS option but it is actually not deleting their older database backups.Â
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.Â
Data Starvation – Balance Your SQL Server – Part 1
With the new Intel Skylake CPUs coming out recently it seemed like a good time to discuss CPU resources and how to know if they’re running optimally. After all, there’s little sense in upgrading your server if your current one is already data starved. Let us learn about how to balance your SQL Server facing data starvation.Â
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
I just love my On Demand offering because it gives me more pleasure of assisting clients who are in urgent need of an SQL expert. Most of the time I am called for help when clients are not able to start SQL Service due to some reason. Today we will see how to fix an error which is about unable to start SQL Server.
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to Create Primary Key Without ANY Index?
SQL Authority News – SQL Server 2012 Service Pack 4 Released
It has been a while since I stopped writing about Service Packs announcements, I believe those who needs to always keep track of this and do not need to know via a separate blog post. With that said, I personally do not believe in any such kind of restrictions at all. I believe we should do what we believe will help others. For the same reason, we are reading a blog post about SQL Server 2012 Service Pack 4 Released.Â
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.