You mentioned the report should be accessible by multiple customers and should run within 15 seconds. Does each customer see the exact same report, or does each customer see a...

Often times in the aftermath of a corporate acquisition or downsizing, executive management will simply stop investing in specific divisions or teams, because they are not considered important to be...

david.wright-948385 (10/23/2015)

---

Eric M Russell (10/23/2015)

---

I've found a Date type is more useful for indicating active / inactive status. I want to know when, not just if, a row changed to...

If I had to go with an True | False type indicator, then I'd go with a positive indicator; a tinyint, not nullable, and constrained to the values 0 or...

Jayanth_Kurup (10/22/2015)

---

a virtual machine hosted on a cloud provider like Azure or AWS would help , all you need is a internet connection at that point, but you are at...

Does "100 miles of the border" include the entire east and west coastline?

Wayne West (10/22/2015)

---

It's standard procedure for most corporations that when their execs travel to China that they're issued a new phone before they go and that phone is destroyed when...

GoofyGuy (10/22/2015)

---

This is my favourite pet peeve which is the departmentalisation cancer that is the Service Management model of IT. Rules are made on one level, ignored by competing teams...

If you're traveling between countries that are not on good terms politically with each other, then it's a good idea not to bring along your laptop or smart phone, but...

Wayne West (10/21/2015)

---

Eric M Russell (10/21/2015)

---

If someone (or something), other than the official DBA, unexpectedly changes configuration settings on the database server, then you probably want to immediately close all...

Are you referring to the brute force dictionary query against sys logins table to get passwords? Yes, it works. There are...

One definition of a "bad manager" is one who locks themselves in their corner office from 8am - 5pm every day, or one who spends their day hovering over the...

timlenz (10/20/2015)

---

Mike Fal (github.com/MikeFal) did an excellent presentation to our SQL Users Group on configuring your servers using PowerShell. By having the configuration setup he was able to install a...

SQLCurious (10/20/2015)

---

Thanks, Eric. Unfortunately, that's not enough for me since it will only tell me that the object has been modified...that too the most recent one. I need to know...

The following will return all objects modified today.

select * from sys.objects where cast(modify_date as date) = cast(getdate() as date);