I think someone slipped up and let a marketing type look at a spec document for someone's network. They saw this cloud-shaped thing and decided it was marketable.

Here's the...

One of my favorite stories about job hunting was years ago during the bubble (dot-com not housing). I saw a job posting for what looked like a bunch of...

I'm a little surprised no one has mentioned Common Table Expressions (CTE). They work a bit like temp tables but lack the management issues (dropping, concurrency, etc). Unfortunately...

There are some 3rd party add-ons to SSIS that I've used in the past that will let you pull information about the files on the remote FTP server. Once...

I find these type of questions really silly to say the least. Most of us will never run into these types of problems, and all this really proves is that...

I once had a phone interview for a DBA position. It was supposed to be a one on one phone interview. When I answered the phone there were...

If it can be asynchronous I'd go with a batch-style process (SSIS or some other tool) to avoid poking holes in database security.

That's just my take on it.

That's the one! Awesome. Thanks a ton.

Nope. It was free. And wasn't a company I recognized. Thanks for the suggestion.

This may be a case where it's worth asking the developer why they need the information their asking for or what they plan to do with it. There are...

I was running into a similar issue and really banging my head against the desk...literally.

I noticed at least one person with the same issue I had. Case sensitivity. ...

Good to know the answer even with a solution in place. Thanks so much.

I figured out what I needed to do to feel safe about this. Disable the schedule rather than the job itself. Simple.

This might not be the most popular answer: a calendar table is terribly convenient to have around. I made one using the following structure:

CREATE TABLE [dbo].[Calendar](

[dt] [datetime] NOT...

Done a fair bit of CLR.

1) TiffPageCount: We have a java-based tiff viewer to display scanned images in our main web site. For multi-page tiff files it...