Linked Server Tribulations In SQL Server
In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.
2014-08-05
5,492 reads
Thomas Knight
Database User Superfluousness In SQL Server
In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.
2014-02-04
3,986 reads
Blogs
[MSSQLTips] Visual Studio 2019 Configuration for the Production DBA
By gbargsley
Happy Tuesday everyone… Today I am honored to have my first article published on...
Daily Coping 22 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know...
Forums
SCOM/SCCM alert when Always On High Availability dashboard is green
Hello experts, Does anyone know why SCOM (or is it SCCM?) would send the...
Restart SQL server from CMD
We have a issue in SQL Server 2017 (RTM-CU21) with SSISDB when a server...
Replication issue
my table is getting replicated from server 1 to server 2. I got a...
Ask SSC