AFAIK, yes. You could use some sort of middle tier app server with connection pooling, which might get you more, but the low levels are low as they are stacked...

Someone is having fun with AI tech

I tend to update SSMS fairly soon after the new version is announced. Same for the Red Gate add-ins.

For Visual Studio, I tend to wait quite a while because...

I'm glad you're optimistic. FWIW, have you submitted these to...

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...