Viewing 15 posts - 1 through 15 (of 18 total)
I vote for having SSIS on its own server. This post[/url] outlines some reasons (be sure to read the comments, too), and although it's primarily targeted at SQL Agent,...
March 29, 2016 at 6:40 am
thomashohner (8/28/2014)
FROM #RESULTS r
INNER JOIN table1...
August 29, 2014 at 6:26 am
We have (or will have soon) 3 production servers and 1 dev server, with approximately 150 databases across them all. I am the de facto DBA, although we do...
October 26, 2012 at 5:30 am
Where I work, we are not able to RDP to any of the production servers, but we are able to connect via SSMS. If I have to do anything...
October 18, 2012 at 5:15 am
Well, I am the odd man out on this topic; I voluntarily wear a tie and sport coat to work every day. Now, I don't mind that other people...
September 25, 2012 at 5:12 am
I have started to implment a DBA (or "Admin") database within the last year. I am an accidental DBA, having started in application development, then moving to database development,...
August 2, 2012 at 6:32 am
Until recently, I was using AS. I switched to using =, exactly because of the readability. Of course, I am also rather..... particular when it comes to formatting...
February 3, 2012 at 6:10 am
Any idea on how well this scales, or its performance versus using a full join between the two tables with a WHERE clause where either side is NULL?
November 4, 2011 at 5:36 am
majorbloodnock (9/29/2011)
For the record, though, the drawers in my pedestal contain the following unexpected items:
Ink cartridges and blotting paper - I do have a fountain pen, but it's been years...
September 29, 2011 at 6:25 am
Steve Jones - SSC Editor (9/9/2011)
I would argue that US colleges don't teach an ultra liberalist point of view. They seek to teach a broad range of subjects. I'm not...
September 9, 2011 at 11:01 am
One of my big issues is that you cannot get the reports to work within earlier versions of SharePoint (technically, you can, but it's a major headache).
Beyond that, I agree...
September 6, 2011 at 8:45 am
I always try to park in a space and fashion that allows me a quick escape route if necessary. Right now, I take the spot that is right near...
September 1, 2011 at 5:46 am
If the database is accessed from a web application, I would handle all of the appropriate access through the application itself.
In other words, I would have a table of users,...
September 1, 2011 at 5:34 am
I have never stored the text of a procedure in a table.
I did once have a system that stored the names of procedures in a table, and would use it...
August 30, 2011 at 6:23 am
I have had a number of jobs that mentioned training as one of the benefits. The reality has always been quite the opposite; the IT training budget is one...
July 20, 2011 at 5:40 am
Viewing 15 posts - 1 through 15 (of 18 total)