Hugo Kornelis (7/29/2016)

---

Disclaimer: When I go to a SQL Saturday event, it is usually as a speaker, not as an attendee. I am aware that speakers have a different view...

TheFault (7/29/2016)

---

I travelled 88 miles for SQL Saturday #411 in Cambridge, just attending not speaking.

Also travelled 109 miles for SQLBits XIV in London, and 99 miles for SQLBits XV in...

GilaMonster (7/29/2016)

---

I'm going to be an outlyer, but most of these were paired with a second event in the same region (eg MVP Summit, SQLBits, etc), and I was speaking...

Japie Botma (7/29/2016)

---

We (3 of us) traveled 160 km twice. Two of our colleagues, from our remote site, traveled 300 km once. It is just too much, so we stopped...

RenoChris (7/27/2016)

---

I'd like to use search in this way but I'm so disappointed in how outlook search works (or doesn't) Also the fact that Ctrl-F means Forward instead of...

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