This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have de...
One should be very careful while working with system objects in SQL Server. Below is one of the situation where some permissions were given on system objects which was causing SQL startup failure. I h...
Once, while doing a load testing with my client, I was shown below error while taking log backups on secondary replica. Msg 35295, Level 16, State 1, Line 1 Log backup for database “MyAppDB” on a sec...
It is perfectly valid for a DBA (or their manager) to assign KPIs to the servers and databases they administer. KPIs are unique for every shop, and for every role. The post appeared first on https://...
Often people confused with Big Data, Data Science and Data Analytics. Are they same or different.This link will give you an idea about what are they, what skills you need and what are the salary level...
There are many wait types in SQL Server and not all of them are documented. Long ago I wrote blog on PREEMPTIVE and Non-PREEMPTIVE waits. SQL SERVER – PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 1...
In this blog post we are going to learn about Installation Error – The Specified Driver is Invalid. SYMPTOMS SQL Server installation failed with errors in setup logs. Summary.txt shows below Troubles...
Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has now been renamed to the Docker Community Edition. So what does this me...
When database development is done using the graphical (GUI) tools in the SQL Server Management Studio (SSMS) or via simple scripts, they often fail to specify a name to each individual constraint. Thi...
Today’s blog is originated from a blog interaction. After hardening a server, my friend was not able to start SQL Browser service. When we try to start from services, we get below standard error, whic...
Question: Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? Answer: You might have heard this advice many times but never got a complete answer to “Why”? Most of the bl...
This is one of the common question which is asked via emails to me. “How to apply the patch in AlwaysOn Availability Group configuration?” OR “What are the steps we should do and things to take care w...
