This article, discusses how you can resolve the error you might get in SQL Server: Operating System Error 170(Requested Resource is in use) The Root Cause for the Error Message It might happen at some point, under certain circumstances, to get the “Operating System Error 170” error message on your SQL Server environment. The above … Read more…
DBAs play a major role in the everyday operation of any organization that uses databases. However, the term “healthy database” is often misinterpreted. In the databases world, a healthy database is not just a database that is online and is not corrupted. A healthy database, and consequently an RDBMS instance, have also an “accepted” up-time … Read more…
If you are trying to install Microsoft Access Database Engine 2016 Redistributable, under certain circumstances you might get the error message: The program can’t start because VCRUNTIME140.dll is missing from your computer. Try reinstalling the program to fix this problem. As it can be figured out from the error message, VCRUNTIME140.dll refers to the Visual … Read more…
I have started SQLNetHub initially with the name “The SQL Server and .NET Blog” back in 2008 with a passion for SQL Server and the technical community. Today, 9 years later, after hundreds of articles, many webcasts, public speaking, and more, and with even more passion for SQL Server, Azure and related technologies, SQLNetHub is evolving … Read more…
What is the IDENTITY_CACHE Option in SQL Server? The IDENTITY_CACHE option, is a new database scoped configuration option in SQL Server 2017 and Azure SQL Database. This option is set to ON by default. The concept of identity caching in SQL Server is that the Database Engine stores in cache a series of values for … Read more…
SQL Server Management Studio (SSMS) for some time now, is not included in the SQL Server media. Instead, it is being provided as a standalone free program which can be downloaded from Microsoft’s website. The decoupling between SSMS and SQL Server Installation Media This is a good thing and I personally agree with this … Read more…
SQL Server 2017 (also known as SQL Server vNext) and the new Azure SQL Database are finally here and they are generally available! In subsequent articles we will analytically examine every new feature using many examples. SQL Server 2017 (and later) Now Also Supports Running on Linux and Docker Containers! In this post, we … Read more…
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 how to patch a standalone SQL Server instance. First Patch SQL Server on the TEST Environment First, always patch the … Read more…
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 follow the below procedure for resolving the issue. Procedure for Resolving the “There is no SQL Server Failover Cluster … Read more…
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, we are going to backup a SQL Server 2014 database, encrypt it, and then restore … Read more…
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 of the email: ———————————– Dear Artemakis, We are once again pleased to present you with … Read more…
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. Read the article below, in order to get useful suggestions on how you can overcome such issue. The Error Message The below, is the exact error message you … Read more…
This Article about Locking and Blocking in SQL Server is from my eBook “Tuning SQL Server (Second Edition)” 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 Engine of a … Read more…
Here’s a quick T-SQL tip on getting the paths for all database files in a SQL Server instance. The 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 … Read more…
In this article, we will be discussing about how you can resolve the error message: “Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine“. About the Setup Failure Error When you run the SQL Server 2005 setup on a Windows cluster (i.e. installing or uninstalling … Read more…