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 More
SQL 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?
SQL SERVER – How to Enable Backup Compression On by Default
In this blog post we will discuss how to Enable Backup Compression on by default.
SQL SERVER – Document Your Databases with Data Dictionary and Diagrams
A couple of months ago I told you about the new interesting tool I found for documenting existing database schemas – Dataedo. For those who don’t remember, this is a desktop tool that enables you to describe database schema elements and create ER diagrams for existing databases, and export to nicely formatted HTML and PDF documents.
SQL SERVER – What Are Ghost Records and How to Clean Them Up?
What are Ghost Records and How to Clean Them Up?
I loved this question when I received it last week in my SQL Server Performance Tuning Practical Workshop.
SQL Authority News – SQL Server 2017 and Automatic Tuning
Earlier today in Ignite conference, Microsoft announced general availability of SQL Server 2017 on Oct 2. This is fantastic news. Lots of people are waiting for the latest version of SQL Server for a while. The matter of fact, many of my customers are using an earlier version of SQL Server are waiting to upgrade as soon as SQL Server 2017 is available to download. In this blog post I will talk about the feature I have been eagerly waiting to try out –Â Automatic Tuning.Â