+1 for sp_Blitz.

This will give you things to look at. I've written some thoughts on the tool from our databases, though I'm not sure what the change are since I...

SQLCMD -L needs the browser service, which isn't running most of the time.

The most success I've had in finding instances is when we have SCOM or OpsMgr or something that...

There are a few reasons, but primarily this separates system objects from user objects. In case of corruption, or the need to restore a filegroup instead of the entire database,...

Disclosure, I work for Redgate.

This will search all databases on your instance if you like. You'll have to connect to...

Client licenses are not bound to a server. They are client license, to allow a client to access a SQL Server.

For a count, ask the Accounting department. They paid for...

Corrected to add batch separators.

Dalkeith (7/26/2016)

---

Everyone makes mistakes but I contend that there will be less mistakes if you have a more flexible and knowledgeable workforce. Whether thats sys admins / developers doing more...

BLOB_EATER (7/26/2016)

---

Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

Before enabling TDE I would...

Logging of users meaning what? What log items do you want?

David.Poole (7/25/2016)

---

I think the difficulty faced by database developers is in identifying what it is you are trying to test. You don't want to find yourself testing whether the...

That would be great. IF you can do...

Chris Harshman (7/25/2016)

---

Where I work, the developers do a lot of test driven development for their C# work, but a limiting factor for them doing more on the database side...

Kim Crosser (7/25/2016)

---

“Trying to improve software quality by increasing the amount of testing is like trying to lose weight by weighing yourself more often. What you eat before you step...

Eric M Russell (7/25/2016)

---

When I'm writing a new SQL query, I'll mockup 10x the amount of data currently in production for the subset of tables that are relevent to query,...

tabinsc (7/25/2016)

---

Since most of my SQL coding is set-based (1 query operation per procedure), unit testing seems pointless since there is only one unit. I do use SQLTest for...