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.
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.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’
After a patch, my SQL Server would not start because upgrade step ‘sqlagent100_msdb_upgrade.sql’ failed with error 537. Here is how I fixed it.
SQL SERVER – 2016 Error Reasons: Msg 10778, Level 16 Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported
Msg 10778 says foreign key relationships between memory optimized and non-memory optimized tables are not supported. Here is why.