Design least privilege for SQL Server application logins with roles, schema permissions, and stored procedures, then test real workflows.
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
Using Synonyms to Simplify Cross-Database Queries
Using synonyms can hide a cross-database object name from callers, but permissions, dependency checks, and deployment still need care.
SQL SERVER – SQL Slammer (Computer Worm)
Is there any virus associated with SQL Server? A DBA’s question led me to SQL Slammer, the computer worm that slowed down Internet traffic in January 2003.
SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005
How do you transfer the logins and passwords between instances of SQL Server 2005 after a hardware upgrade? I summarize Microsoft KB 918992 and its script.
Auditing Who Has sysadmin
Audit who has sysadmin in SQL Server, including direct members and Windows groups, then investigate nested access and forgotten logins.
SQL SERVER – Fix : Error 15281 SQL Server blocked access to STATEMENT OpenRowset/OpenDatasource of
Error 15281: SQL Server blocked OpenRowset/OpenDatasource because Ad Hoc Distributed Queries is off. Turn it on in Surface Area Configuration or with sp_configure.