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.
SQL SERVER – Connecting Specific Database on Starting SSMS
In today’s blog post we are going to learn how to connect specific database directly when we start SQL Server Management Studio. Honestly, this is a very simple process, but I have seen quite a few DBA still unaware of this feature. I have seen DBAs directly connecting to master…
Read MoreSQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)
Question: How to Delete a Single Table From SQL Server Backup File (.bak)?
SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)
In the last puzzle, user had to write the shortest code to produce 0. I have received around 700 valid answers and while reading through the answers, I had a blast. I personally learned quite a lot from just administrating the quiz. Since that puzzle, I have received quite a few emails requesting to come up with next puzzle.
SQL SERVER – The SaveToSQLServer Method has Encountered OLE DB Error Code 0x80040E4D
My relationship with existing clients, I provide quick help to them on simple issues. Let us learn the error related to SaveToSQLServer.
How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142
Question: How to Enforce Password Policy of Windows to SQL Server?
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.