Sorry I missed it. I loved the event in 2021. Was in Boston last weekend and heading to NY today, so no time to come over and remain married.

You haven't explained how you use the other keys. What you need to do is help develop an algorithm.  Explain for 1234 how you derive this? Or for 9786, how...

I...

I think the cloud will keep you in editorials until you decide to stop.

What I've learned is that the tech debt a company carries can block a lift and...

I disagree, not the least of which because of the state of software licensing.

Azure SQL is just SQL Server, a few more things, a few less, but it's really the same. I could move SQL Server Central there easily, as we don't use...

I'm sure. You're wrong, but I still love you, Jeff.

...

There's a series of five articles about SQLFacts right here on SQLServerCentral (1, 2, 3, 4, 5)! The toolkit has grown a lot...

Ha, hardly, lots of complaints about this, but with regulation all...

One of the folders on my machine is called "DevTools" with the following contents. Some that I've highlighted in bold are ones that I use often and/or I think...

Perhaps something in the restore statement, but glad it's working and thanks for the followup.

If this is a one off, then instead of the studentid in the SELECT, then put the scalar value instead.

As Drew noted, however, make your question easier for people to...

Not sure, but with data, often it's something small I've missed.

Rather than this join, what I'd pick is a row or two that I  am struggling with and limit my...

Lol, I book flights constantly, so a different perspective. Often I want a 4 day or 7 day trip, so moving one date should move the other. That's a handy...

I don't think IQP is the end-all, and in many cases, poorly written procedures that are "catch-all" still can perform really poorly. The IQP stuff tries to reduce the edge...