cheers. If that answered what you need, please mark it (or other posts) as answers for future readers.

You can query DMVs for fragmentation. Do this before and after.

Note that unless this is a read only database, you need some free space for maintenance.

https://msdn.microsoft.com/en-us/library/ms188917.aspx

Are you sa or db_owner? These are separate things. If you are sa/sysadmin, you have rights. If you are the db_owner, then you can see properties.

Netflix started with relatively little bandwidth from their end. They can compete, or Steve's Video Service can compete, because few people use it. A 5Mbps home connection works. As the...

Not in the middle. I've done it at the beginning to avoid exports if disk space was low.

Use a PoSh script to check disk space, then fail the step if...

Does the pattern [ADR*XYZ*] always hold?

If so, when you put this in a table, you can always use PATINDEX/CHARINDEX to find the beginning and offset to the beginning of your...

I'm for neutrality in terms of not prioritizing traffic based on source. However, I don't think that this means Google or Netflix can't pay for higher connection speeds to send...

Jeff Moden (5/11/2015)

---

In that case, I recommend major CYA efforts on the part of the DBAs because that's where the blame will end up if audits fail, audit data is...

I think for the DBAs/developers, who perform the ETL stuff, we do need to think about knowing JSON, XQuery, and more to help us transform data into formats that we...

Agree with the first half. There is work to be done. However, for many, many people, I think...

Sean Redmond (5/12/2015)

---

At all of the presentations that I have been to, it has been presented to the world as a finished product. There is also an element that...

Sean Redmond (5/11/2015)

---

Hi Steve,

How often do we get a version that can promise a 10x improvement to a system? I see In-Memory-OLTP as the biggest change, or, at least,...

Ed Wagner (5/11/2015)

---

They're also releasing SPs more frequently. The rapid-fire release strategy comes with a serious cost - customer confidence. If I have to be genuinely fearful every...

It's not the fix, it's additional testing. Hopefully, also nothing else added.

A month, however does seem long. I'd have liked...

PhilipC (5/8/2015)

---

They don't believe in it, and more or less don't even want to discuss it anymore. In the past they've said virtual simply won't stand up to a physical...