andyfenna

Linux to Windows Authentication

As you are all very well aware Linux to Windows for access to SQL Server can be a slippery slope to doom. So I have decided to create an...

2021-03-03 (first published: 2021-02-25)

4,594 reads

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...

Comments posted to this topic are about the item Script-Drop Orphan users from SQL...

Every expert knows you can't make perfect software that never crashes or has bugs....

I wanted to share with you tools from my personal toolbox. If your code...

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?