SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

A great and related reference to what we will discuss in this blog post is this one: https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although …

Advertisement

PowerShell: Resolve partial computer names, CNAME’s & IP Addresses to concrete Host name / IP

One can refer to a host by several means. Where I am at, we generously use CNAME's to point to host to insulate the applications from having to change when then hostname changes. For example, if the hostname for Dev SQL Server is ddxumapDEV, then we might have a cname entry that says "Dev-SQL". All …