At my last job, on day 1, they wanted me to look at a stored procedure I would be working with daily. I needed to copy and paste a table...

In Visual Studio, I prefer working in the dark background, but not with SSIS or Management Studio. The latter may simply be that I've been too lazy to change it....

A user group I'm in uses it to communicate (and I need to be a little more present on it), and we use it at work. But we're all but...

Here's a thought: Don't link the stereo to the car's computer. I know Microsoft and Apple are keen on turning cars into a media center, but consider even in the...

Steve Jones - SSC Editor (2/27/2015)

Gary Varga (2/27/2015)

I...

Ron, all three of my projects at my last job had aspx front-ends. It connects the same as other versions of SQL server. I've not tried it on MVC yet...

I worked for a very small company that used SQL Express for its internal processing. One of the restrictions Steve did not mention is that Express, under license, cannot be...

Missed the obvious solution.

Changed...

WHERE f.shipDate BETWEEN (GetDate() - 7) AND GetDate()

AND b.prodNumber NOT IN (widgetA, widgetB)

to...

WHERE f.shipDate BETWEEN (GetDate() - 7) AND GetDate()

AND b.prodDescription NOT LIKE (%'widget'%)

Doh!

OK. I'll see if I can move the criteria up into the join (which is pretty ugly, but it works, and with a not-entirely-painful execution plan) and see if that...

Yes. If it doesn't, dataset 2 tossed up a blank report, which...

Born - If there were a HIPAA violation, it would not be a Microsoft problem. Microsoft offers tools that can and will do the job at a price. The issue...

One area where Express is used a lot is in medical billing. While licensing forces such companies to use it internally, in the event of a breach, you suddenly have...

Hey, if you're the Ninth Doctor, all you need is a leather jacket.

And a bad American accent....

Hey, if you're the Ninth Doctor, all you need is a leather jacket.

And a bad American accent....

Just stay up all night before,...