I'm confused. Service accounts are Windows accounts only. If you're speaking of logins in SQL Server, then follow the advice above with regards to password policy

Will? Isn't it?

It has before. After the 70s, quite a drought.

But they will come...

This is a Windows level setting, and usually there is a limit. I think it's 3, but it might depend on your particular OS version and AD settings.

I might set...

+1

It is a regular battle. One reason that RG moved to outsource the sending. I used to do this, and it was a day a week to work through spam...

Absolutely true as a hypothesis.

Not very true in reality. Most...

Yankees for me, and Rockies since I live in Denver.

Too busy with kid stuff this year. Middle kid graduates HS and the younger one is busier with volleyball. Add in...

All of those are valid statements in my SQL 2012 and SQL 2014 instances. Didn't try 2016, but I'm sure it's the same.

You have different control of tempdb. I believe...

Have to say I'm less excited this year. Between not playing (time, shoulder), and the Rockies not looking good, I'm a little down.

🙁

I hope to be

tempdev is the logical name in the file. The physical name is tempdb.mdf

TomThomson (3/3/2016)

---

Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single...

Best practice, be efficient. I know it sounds bad, but use a tool. This is a problem that doesn't lend itself to using your own time and effort to build...

+1 for Grant's note. You will see data growth, which sometimes is unexpected. New indexes can account for this, loads, ETL, etc.

Extended Events will help, but it can be a...

Certainly some of thsoe can be done with T-SQL, but they fit better, and I'd argue most file operations are better handled in PoSh. Better error handling and easier to...