SSMS will not let you type in Windows credentials. Here is how to connect using NT AUTHORITY\SYSTEM account with PsExec from Sysinternals.
Interview Question of the Week #057 – What is GO Statement in SQL SERVER?
Learn what the GO statement really does in SQL Server, why a variable vanishes after it, and the simple rules every script writer should know.
SQL SERVER – Install Error – The /UIMode setting cannot be used in conjunction with /Q or /QS
Installing SQL Server from a configuration file failed with: The /UIMode setting cannot be used in conjunction with /Q or /QS. Here is the quick fix.
SQL SERVER – SSIS – Get Started with the For Loop Container – Notes from the Field #113
In Notes from the Field #113, Tim Mitchell shows how to get started with the SSIS For Loop Container to control how many times your ETL logic runs.
SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts
A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.
Finding Where an Object Is Used Across a Database
Use dependency metadata, definition searches, and runtime evidence to find object usage while accounting for dynamic SQL and external callers.
SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More
Many SQL Server 2016 features reach Azure SQL Database first. Here is how I checked the IF EXISTS Function and other new features on SQL Azure databases.