MySQL’s UUID() function returns a random 36 character value. Here is how to generate random number strings and passwords of any length from it.
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.
Interview Question of the Week #056 – How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server
An interview practical: fix a SQL Server installation failure when the rule Setup account privileges failed. Here is the answer.