I have had similar doubts about AI over past years... I don't see much that is that useful outside of some search result summaries.

However, over the recent month AI has...

Agreed. When we start reaching a limit, we should reconsider the approach. I can only assume someone needing that many parameters is trying to process a lot of data in...

• This reply was modified 7 months, 1 week ago by SQLGrinder.

Agreed. When we reach these limits, we need to rethink the approach. I can only assume someone needing that many parameters is trying to process a lot of data. If...

• This reply was modified 7 months, 1 week ago by SQLGrinder.

We suck as "we" could have prevented this...

Historically, IT never install the latest patches as soon as they came out and wait for a time period or another release or...

dmbaker, I agree. I know the purpose of the semicolon and I always put it in front of the WITH on purpose.

I frequently cut and paste and reuse code, so...

Speaking of modeling good behavior... Shouldn't we be pointing the finger at Microsoft for choosing the word WITH to start a CTE.

• This reply was modified 3 years, 7 months ago by SQLGrinder.
• This reply was modified 3 years, 7 months ago by SQLGrinder.

After each SQL install I run a script to change numerous setting and setup the environment before and data touches the instance. With model database I set initial size,...

All this confusion over asking what type of DBA we are?

I agree that the term DBA should no longer be used like a generic catch-all title like the term...

When I run the script I keep getting

Get-Content A positional parameter cannot be found that accepts argument 'C:\ServerList.txt'

We recently had the requirement to audit some of our sensitive servers. I looked at SQL Server Audit and another draw back is that is only runs on Enterprise....