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.
YCSB Benchmark and Latest Evaluation With NuoDB
Database world is very big and it is very difficult to compare multiple database with each other. The reality is that every database organization talks about the unique features of their database in such fashion that each database is the best among the competition. When I go for a database consultation, my customers often ask, which is the best possible database out there in the industry which can handle big data efficiently. If you search on the internet, you will realize that there are tons of the database products out there. In this blog post we will discuss about how we can select the best possible database with the help of YCSB Benchmark.