Patching SQL Server is an ongoing process. Service packs and cumulative updates are being regularly released in order to apply possible bug fixes as well as provide additional functionality. This article, suggests a procedure for patching a standalone SQL Server…
There is no SQL Server Failover Cluster Available to Join
If you are trying to add a new node to an existing SQL Server failover cluster and you are getting the error message “There is no SQL Server failover cluster available to join“, then you can perform the below checks:…
Encrypting a SQL Server Database Backup
Encrypting a SQL Server database backup is necessary in many cases, especially when the database has sensitive data. SQL Server provides an easy way to encrypt database backups. Let’s further examine this functionality with a step-by-step example. In this example,…
I’m a Microsoft Data Platform MVP for the 9th Year!
Today is a very special day. I have just received a special email from Microsoft HQ, an email saying that I was awarded with the prestigious Microsoft Most Valuable Professional (MVP) award on Data Platform (SQL Server). Here’s a part…
Locking and Blocking in SQL Server
This article is from my book: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More The majority of modern relational database management systems (RDBMSs) make use of lock-based concurrency. Lock-based concurrency is the approach based on which the Database…
Getting the Paths for All Database Files in a SQL Server Instance
Here’s a quick T-SQL tip. You can get the list of paths for all database files (both data and log files) using the undocumented SQL Server stored procedure sp_MSforeachdb. You can use the below T-SQL statement: exec sp_MSforeachdb @command1=”USE [?];…
Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine.
When you run the SQL Server 2005 setup on a Windows cluster (i.e. installing or uninstalling SQL Server), you might get an error message: Setup failed to start on the remote machine. Check the Task scheduler event log on the…
The TempDB System Database in SQL Server
This article is from my book: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More The tempdb system database in SQL Server is one of the databases that are shipped with every SQL Server installation and…
The Importance of Database Indexes
This article is from my book: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More | Buy Imagine that you have a large book and you are looking for a specific piece of information. If the book…
Sneak Peek of SQLArtBits DBA Security Advisor v2.0
On April 5 2017, SQLArtBits releases DBA Security Advisor v2.0. This article gives a sneak peek of the upcoming new release of DBA Security Advisor v2.0. DBA Security Advisor is a powerful tool developed by SQLArtBits that allows Database Administrators (DBAs) to…
New Article Series: Beginner’s Corner
We are all beginners. We are not experts or gurus. There is no such thing. This is just an illusion. In the end of the day, we are all beginners who constantly learn and evolve. The majority of articles I…
Executing T-SQL Statements Against All Databases
There are many cases where a DBA needs to perform a task against all databases in a SQL Server instance. In order to avoid the process of just changing a part of the statement or switching to the target database…
A connection was successfully established with the server, but then an error occurred during the login process.
When you try to connect to a SQL Server database from a client application, under certain circumstances, you might get the below error message: A connection was successfully established with the server, but then an error occurred during the login…
Getting Started with SQL Server In-Memory OLTP – Part 2
In the previous article of this blog series, I introduced In-Memory OLTP and explained how it is possible to create an In-Memory OLTP – enabled database as well as memory-optimized tables (durable and non-durable). Today we are going to talk…