SQL Server Administration

Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed

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 have restarted your machine. For more information, you can visit…

Getting the Paths for All Database Files in a SQL Server Instance

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 [?]; SELECT CAST(DB_NAME() AS VARCHAR(50)) AS DBName, CAST(physical_name AS VARCHAR(150)) as…

SQLArtBits: Free Online SQL Services

Three years ago, back in 2013, I founded the “SQLArtBits” community initiative. Under the SQLArtBits initiative we develop simple yet powerful data tools for the Microsoft Windows Operating System. The majority of our tools mainly interact with SQL Server, thus providing a richer user experience and enabling the user to…

Why You Need to Secure Your SQL Server Instances

Database Management Systems (DBMSs) store data. They sure have added functionality and a huge set of significant features but again, in the end of the day, they store data. Your data. This makes your DBMSs one of the most valuable assets in your Organization and that’s why you need to…

SQL Server 2008 R2 Service Pack Installation Fails – Element not found. (Exception from HRESULT: 0x80070490)

In case you are trying to install a SQL Server 2008 R2 service pack in a clustered SQL Server environment and the installation fails reporting something similar to the below: Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the…