Baseline-SQL-Server
Get Core SQLServer Health Metrics using Dynamic SQL
| October 11, 2022
Dynamic SQL To Collect Remote SQL Server Health
Read More
Category: Linked Server
Errors
Error/Fix: Cannot initialize the data source object of OLE DB provider “OraOLEDB.Oracle” for linked server. (.Net SqlClient Data Provider)
| February 20, 2020
Recently I was working on one user request to create a linked server for Oracle database in SQL Server 2014 instance. After installing the correct Oracle ODBC drivers,
Read More
[SQLDBATools] PowerShell Module
ScriptOut Linked Server with Actual Password
| October 25, 2019
Within my organization, we work in a controlled environment. That means, with each SQL Instance migration, we have strict rules to script out everything including System database user
Read More