Wait for an Agent job to finish by polling its current sysjobactivity row, enforcing a timeout, and checking sysjobhistory outcome.
SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD
Good DBAs automate the boring work. Here is a simple script to run Backup and Restore of a database from the command prompt with SQLCMD.
SQLAuthority News – Delhi Women Safety – 2400th Blog Post – A Milestone
My 2400th blog post is not a boast. After the sad event in Delhi, I write as a father and husband about women safety and why it matters to every Indian.
Generate Random Values in SQL Server: SQL in Sixty Seconds #042
To generate random values in SQL Server, pick the function by the job: RAND for one value, CHECKSUM(NEWID()) for a value on every row, CRYPT_GEN_RANDOM for tokens. The tests here count 100,000 draws and show where the common formulas go wrong.
SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name
Error 1505 says the CREATE UNIQUE INDEX statement terminated because a duplicate key was found. The word key confuses many developers, so I explain it simply.
SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors
New developers often hit Error 8111 when they try a PRIMARY KEY constraint on nullable column, followed by Error 1750. Here is why it happens and how to fix it.
Warning Before SQL Login Passwords Expire With DaysUntilExpiration
A Friday-night login failure is avoidable. One small query warns you weeks ahead, if somebody owns the warning.