Tip of the Week No.1 – SQL Server Always Encrypted

Check our Tip of the Week, about the SQL Server Always Encrypted feature!   Tip of the Week #1 With Always Encrypted in SQL Server 2016 and later, you can protect sensitive data, by encrypting sensitive data on the application side, without revealing the encryption keys to the Database Engine. To this end, through a … Read more…

New Blog Post Series: Tip of the Week!

Hi friends around the globe! We are pleased to announce a brand new blog post series titled “Tip of the Week“. Via this series, every Monday, we will be sharing with you, useful short tips on a variety of topics such as: SQL Server Administration and Development, Azure SQL Database, Programming, Data Access and more! … Read more…

Quick Tip: SQL Server Support for TLS 1.2

This short post discusses SQL Server Support for TLS 1.2. It is a recommended security best practice, to upgrade to Transport Layer Security (TLS) protocol 1.2 as several known vulnerabilities have been reported against SSL and earlier versions of TLS. Many of us who work with SQL Server, we needed – or will need at a … Read more…

New Blog Post Category: Quick Tips

Hey folks all around the world! I hope you are having a great time! I do, and I’m super excited to announce today that I’m launching a new post category on the SQLNetHub Blog. The name of this category is “Quick Tips“. I really enjoy writing long and comprehensive articles which explore all those amazing … Read more…

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

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…

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed…

In this article, we will be discussing about the following error message in SQL Server and how to easily resolve it: Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed…   About this Error Message If you ever encounter issues when trying to create, add, or edit steps for a … Read more…