GitHub

sql-server-linux-replication-tutorial-tsql.md

In this tutorial, configure SQL Server snapshot replication on Linux with two instances of SQL Server using Transact-SQL. The publisher and distributor will be the same instance, and the subscriber ...
Redmond Magazine

T-SQL Smarts: Executing Sp_executesql

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...
Redmond Magazine

T-SQL Smarts -- Preventing Injection Attacks

Working with dynamic SQL is all well and good, but avoid the risks that can lead to your code being susceptible to a SQL injection attack. As much as making your T-SQL work smarter for you, a la ...
Ars Technica

SQL Server 2005 TSQL syntax for getting dta out of an update or insert

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...
Ars Technica

Set a variable using tSQL to a value returned in a query

I used to know how to do this but have forgotten. How do I set a variable to an item returned by a query using TSQL (SQL Server). I have delcared my @variable and need to set it to an item returned by ...
GitHub

FY25_SQL_Server_Permissions_Process_Standards - Audit.sql

- LoginName: The name of the login associated with the 'sysadmin' role. - LoginType: The type of login (e.g., SQL authenticated, Windows authenticated). - ServerRole: Displays 'sysadmin' as this ...