GitHub

migrate-sql-server-users-to-instance-transact-sql-tsql-tutorial.md

# Tutorial: Migrate Windows users and groups in a SQL Server instance to Azure SQL Managed Instance using T-SQL DDL syntax [!INCLUDE[appliesto-sqlmi](../includes ...
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 ...
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 ...
Ars Technica

TSQL: Creating a simple foreign key

I have a foreign key constraint that I created to reference the primary key of another table:<BR><BR><pre class="ip-ubbcode-code-pre">constraint geneassay_fk foreign ...
Ars Technica

TSQL using FOR XML - Need to get the xmlns:xsi section to appear after xmlns="blah"

I am using TSQL to extract data and drop it to XML. The problem is that the system consuming this XML file must have the xmlns="blah" portion appearing first, otherwise it fails. How the heck can I ...
MCPmag

Hacking SQL Server

SQL Injection is a fairly new method of hacking your database. Learn how it’s done—and how to protect yourself. MOST NETWORK ADMINISTRATORS charged with keeping the network infrastructure secure tend ...