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

No. How would you know what a duplicate is? This isn't a obvious as you might think.

Find all backup files for a db

delete old backup files (delete .baks older than the last 2)

copy backup files to new folder, based on criteria.

It's not my choice anymore. I could be, but I like to always be prepared.

Thanks. Maybe if they open a MS Research spot in CO. Or I go with Sales somehow. No chance I'm moving...

Sean Lange (3/2/2016)

---

I don't even...

And age of the classifier. At least the age they act 😛

Lots of companies are doing a much better job of this. New phone and new laptop in the last month. each time I've signed into Dropbox/Github/FB/others, I get a note...

Alan.B (3/1/2016)

---

Ed Wagner (3/1/2016)

---

Alan.B (3/1/2016)

---

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it seem so far away, lets try WEEK...

That's...

Articles published as released in the newsletter, appear on the front page, and live on, as Gail mentioned, in the Articles section.

Kyrilluk (3/2/2016)

---

Gary Varga (3/2/2016)

---

I have been seriously thinking about this over the last couple of days and believe that a Neural Network can be audited. Not directly, as both Kyrilluk...