Whether an IT department is Great or Lousy; it's determined by the aggregation of those of us in the department.

One great quote in there is "velocity is more important than perfection", which is a tenet that I have found to be very true over the years. It's not...

My (admittedly un-scientific) belief is that only a small percentage of organizations in private (or public) sector engage in what could be genuinely called "data science". Whatever predictive modeling they...

below86 (10/27/2015)

---

Eric M Russell (10/27/2015)

---

However, if a single column approach is more appropriate, then I still prefer not to use 1 or 0 but rather a character using a less...

I generally look to see what the most common condition is. That condition gets the zero value. The abnormal condition gets the 1 value. Then I just name the column...

I mentioned earlier that I prefer using two date columns to indicate active status like so:

ActiveDate date not null default (getdate()),

InactiveDate date not null default ('9999-12-31'),

check (InactiveDate >= ActiveDate),

However,...

When an industry...

Niko Neugebauer has written a great series of blog posts about Clustered ColumnStore internals.

Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)

http://www.nikoport.com/2014/07/29/clustered-columnstore-indexes-part-36-maintenance-solutions-for-columnstore/

xsevensinzx (10/26/2015)

---

Eric M Russell (10/26/2015)

---

..If you look through the jobs, many are development positions, but there are some good data ones. Data modeler, BI Analyst, Data Architect, Big Data Engineer,...

Eric M Russell (10/26/2015)

---

Besides searching across text of all database objects, another approach is to search the text of cached query plans. This will narrow the search to only those...

Besides searching across text of all database objects, another approach is to search the text of cached query plans. This will narrow the search to only those objects and statements...

Many organizations, even if they have good...

Dumb (or just inexperienced) programmers are hired to initially develop databases,...

The following operation will set database to RESTRICTED_USER mode, meaning that only SYSADMIN accounts can login. It also does a rollback and disconnect on any existing connections.

alter database <db_name> set...

I'd keep staging in a separate database, because that gives you the flexibility to set whatever recovery model, backup schedule, log truncation, and other database options are optimal for staging...