I do now 😉

I realize my...

Indeed. Simple is often the best way to transform things. I like this...

My advice would be to see if you have some combination of unique fields that define what the entity is. If that's Date + OtherValue1, use that. Typical advice is...

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