Viewing 15 posts - 1 through 15 (of 20 total)
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...
June 14, 2017 at 5:54 am
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....
June 2, 2017 at 5:52 am
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...
March 9, 2016 at 6:00 am
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...
December 22, 2015 at 5:59 am
Steve Jones - SSC Editor (2/27/2015)
Gary Varga (2/27/2015)
thottle (2/27/2015)
...One of the restrictions Steve did not mention is that Express, under license, cannot be used for an outward facing web site...
I...
February 27, 2015 at 10:49 am
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...
February 27, 2015 at 7:31 am
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...
February 27, 2015 at 7:14 am
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!
November 13, 2014 at 10:48 am
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...
November 11, 2014 at 6:11 am
Are you absolutely sure that something other than WidgetA and WidgetB have data for the last 7 days?
Yes. If it doesn't, dataset 2 tossed up a blank report, which...
November 10, 2014 at 2:48 pm
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...
November 4, 2014 at 7:44 am
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...
November 3, 2014 at 6:42 am
I'd go as The Doctor of the BBC TV program Doctor Who, of course.
Hey, if you're the Ninth Doctor, all you need is a leather jacket.
And a bad American accent....
October 31, 2014 at 11:34 am
I'd go as The Doctor of the BBC TV program Doctor Who, of course.
Hey, if you're the Ninth Doctor, all you need is a leather jacket.
And a bad American accent....
October 31, 2014 at 11:21 am
I'm not sure how to dress up as a 5 hour query rollback.
Or a corrupt database.
Or missing backups.
Or users with owner privileges.
Or a cursor.
Just stay up all night before,...
October 31, 2014 at 7:27 am
Viewing 15 posts - 1 through 15 (of 20 total)