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…
Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed
If you are trying to install SQL Server 2016 on Windows Server 2012 R2, under certain circumstances, you might get the below error message: Rule “KB2919355 Installation” failed. KB2919355 Check Failed. If you have installed KB2919355, please make sure you…
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…
Getting Started with SQL Server In-Memory OLTP – Part 1
In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory OLTP (codenamed “Hekaton”) is a powerful engine which is fully integrated into SQL Server’s Database…
Frequent Password Expiration: Time to Revise it?
Until recently, enabling the password expiration option in SQL Server was included in many security best practices. However, recent studies, revised this recommendation and support that it should not be further included in SQL Server’s security best practices. However, if…
Selected Tweets of Year 2016!
Another year has passed…as always, full of everything! Events, blog posts, articles on well-known online SQL Server journals, software tools, and of course direct communication with you, my fellow SQL Server community members, via all available online and offline channels!…