There is no compelling reason to avoid cursors and dynamic sql when you're doing something like coding an administrative script that is occasionally used to iterate across databases or servers....

You might as well disable the login until the application is fixed.

A lot of application developers only work with transient persistence layers, something like session state for an embedded application or the shopping cart for an eCommerce website. In that case,...

I'll bet Google knows exactly where Steve is, right this minute. They know where he was exactly one year ago, and they probably have an algorithm that can predict where...

Perhaps start with the AdventureWorks sample database, and then extend it by modeling additional tables for Payroll or Invoicing.

Some people may (even subconsciously) be using their work life as an escape from home life.

... The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is...

Thanks for finding what tables contain the catalog permissions. Based on this I'll code up a script to generate GRANT_PERMISSION statements from SSISDB. There should have been a way to...

First, is the workload on the new server the same as what was typical on the old? Also, list and compare the server level settings between the new and old...

When I think of a "lookup table", it's usually not something that models a complete entity, but rather just ID and Description.