When traveling outside the US, especially to a country with a State Department travel warning, you should consider leaving your smart phone and laptop at home and instead carry a...

Stealing a cell phone is petty theft, but impersonating a law enforcement officer is a felony. It could potentially be considered kidnapping, if they hold the person against their will...

There really is no reason to have surrogate keys for dates; not in a fully normalized and not in a star-schema database. A Date datatype consumes only 3 bytes, and...

Assuming the code is left as is, an index here or there could take the overall process down from 10 hours to 1 hour. The short answer is that you...

A DBA doesn't necessarily need to be a local admin on the Windows server, and depending on their daily responsibilities, a DBA doesn't need to be a member of the...

That's a scarry piece of T-SQL code. I'm guessing it's auto generated by an ORM tool or something. First, let's use a code formatting tool to untangle it. To produce...

sql-lover (8/14/2014)

---

-- Another UPDATE ---

After testing on my Dev box I finally deployed the trace flag on two of our live servers. So far so good. And crossing fingers, it...

sgmunson (8/13/2014)

---

Indeed, 9 million rows is an awful lot of data. Also, even assuming the report still has to exist, your execution plan is suggesting an index creation...

I'm not saying that the Microsoft development stack should be used for building the Air Force's mission critical systems (ie: deployed in the field in Iraq). A strong an compelling...

Using the MS SQL Server, MS Office, and MS VisualStudio stack, you can build practically any IT solution, and it integrates well. Often times the tools will integrate, but the...

jay-h (8/11/2014)

---

Eric M Russell (8/11/2014)

---

jay-h (8/11/2014)

---

If the news stories about badUSB are correct even...

jay-h (8/11/2014)

---

If the news stories about badUSB are correct even devices like keyboards or...

Gary Varga (8/11/2014)

---

Eric M Russell (8/11/2014)

---

Microsoft, after taking some hits for their "insecure by default" configurations and applications, tightened things up greatly. It caused project time lines to be extended...

Microsoft, after taking some hits for their "insecure by default" configurations and applications, tightened things up greatly. It caused project time lines to be extended and delayed shipping on some...

This thread make me think of something else from the past. Using the little known STATS_STREAM option of the CREATE STATISICS statement, you can re-create production statistics in another database...