below86 (10/23/2015)

---

[IsntInactive] = Isnt Inactive = Is NOT Inactive = Is Active? - IMHO that has to be a joke, right? Talking about confusing.

It's probably just me but the...

I prefer to use [IsntInactive] where a code of 100 - 255 indicates various reasons for it's non inactivity, codes <= 99 indicate inactivity, and 0 means not specified.

😉

Rod at work (10/23/2015)

---

I very much prefer using IsActive, or simply put Active. I am adamant about this because at my previous job the guy who set up the database...

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