I suspect SQL Server 2016 runs better than 2005.

It's always an "it depends" discussion. Some things run for years, and there's no reason to change. Some things do need to...

Ah, I realized I had an extension added. I'll update the article with this.

Likely you added the sp_whoisactive extension

Good Stuff.  There were a couple of the queries that didn't run against my Synapse instance.  "can't convert to int".  I had to cast some of the columns to...

Hi Steve, very useful posts around ADS, however, when I fire my ADS for a 2k16 SQL, in the monitoring part I have no "Server Reports" nor tempdb as...

These things made a big difference in my career before SQL Server Central. Answering questions elsewhere, doing a talk at a UG, they helped me stand out as well. You...

Yep, and don't spend a lot of time building them. Propose something, vote on it, and enforce it. If you find the need...

Honestly I find few people building ER diagrams, much less doing extensive modeling. Some customers still use ErWin, which is really the standard. I loved ER/Studio a long time ago,...

All good advice that I learned and try to remember today. I might give this list to younger people.

When IT departments start tightening their belt - the guy whose primary job is to pick arguments over tabs and naming conventions, the guy whose brightest idea is to...

Tabs vs. Spaces and Singular vs. Plural, ...commas before or after?

Really?  You're debating and voting on this?  Holding meetings and discussions?  Wasting everyone's time with this crap?

I think the...

Interesting. I think AI works better, in general, with more generic things, or with some code prompting, which is easier in C# than SQL.

I'm doing some testing with SQL Prompt...

Agreed, David.

Heh... let's look at the first paragraph in the article...

...

Heh... wanna learn something new and exciting??? Then actually learn what you can do in SQL.

And watch out for people...

Thanks, need to read this.

We use Cassandra extensively in one of our software products. Its "active-active" clustering, and being able to perform a write on any node, is the primary reason why we...