We're still trying to get everything up to sql server 2008 (not R2) and not currently planning to upgrade from that because the business is up for sale at present.

Most...

The IT skills shortage is just like the so called plumbers shortage we had 10 years ago. A government initiative pushed teenagers into training as plumbers at the colleges, but...

In the properties of his login in Security in Management Studio, user mapping tab, msdb database, I think he should have one of the db_ssis..... roles ticked, probably db_ssisadmin.

Being...

If the csv format is the same why create new tables? Having a staging table which is cleared at the start of the whole import and just adding another column...

Also answers such as "I'd get on the SQL Server central website and see what others who have faced similar problems recommend examining" show a readiness to learn new techniques...

We're another "never used it" shop - there's always been another way so we haven't needed clr.

Bankruptcy also makes other non-obvious things difficult such as getting house insurance, as some companies won't insure a property where a bankrupt lives even if the policy holder is not...

I used Itzik Ben-Gan's solution using TOP to delete in chunks and added a truncate to the script to run every 30 iterations when I had 50 million rows to...

They need to remember that many of their enterprise level customers such as government agencies, civil service, banks etc. will be bound by security restrictions that prevent them using cloud...

Our "desktop" is a Wyse terminal to a server somewhere across the site with VMWare hosting our Win7 development environments. I'm told it is "PC over IP".

It means we can...

A bit late but the best SQL memory of 2013 was doing Itzik Ben-Gan's Advanced T-SQL course which stretched my braincells more than any other course I've done. Loads of...

I'm in the UK and have 31.5 days leave (1.5 added in place of compulsory shutdowns) which was 26.5 until 5 years service complete. Plus Bank Holidays. Then we work...

A Nokia Windows phone (my favourite) that acts as a proper pc with USB ports, so that I can plug a proper camera and a USB stick/external drive into it...

Why not just follow these instructions with your normal installation media?

http://www.mssqltips.com/sqlservertip/1807/sql-server-2008-client-tools-installation/

Happy thanksgiving but if you want to get out of the work, go green and cut out the outside lights, thus reducing the ambient light in the rural setting, saving...