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,616 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
4,101 reads
Blogs
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Forums
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...
Referencing a SQLCMD variable in a Post Deployment script using SqlPackage
Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...
Calling stored procedure to bulk import from SSIS causes access denied
Hi, I'm working on building a data validation engine, which is supposed to check...
Ask SSC