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 2 years, 8 months ago by  SQLGrinder.
• This reply was modified 2 years, 8 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....