-
In the post Import/Export to Excel , I showed how to export data to EXCEL The problem that most users find it is it would include column names in the file and file should exists already with headings This procedure would solve that problem create procedure...
-
Come and join us for this great evening of developer focused content. These meetings are great opportunities to meet other SQL Server professionals, get your burning issues solved. This event brings a new slot to our agenda - the open mike slot where...
-
It's an interesting time with being asked to performance test/benchmark a new server setup for a migration of sql server and data centre. Both current and new servers are SAN attached and it has been what is effectively the testing of the storage...
-
I would just like to congratulate both Christian http://sqlblogcasts.com/blogs/christian/ and James http://blogs.conchango.com/jamesrowlandjones/default.aspx for being awarded as Microsoft's MVPs. Both thoroughly deserve it, if only for helping me...
-
The next London SQL Usergroup meeting will be next Thursday. http://www.sqlserverfaq.com/events/136/UK-SQL-Server-User-Group-Evening-Meeting-Agenda-TBC.aspx You can register now on the new usergroup site. The plan is to have an open mic slot for anyone...
-
Apple's MobileMe service has been through some troubled times since its launch in July, but they seem to have finally fixed a nasty problem which corrupted the Outlook address book. Following the very first sync, Outlook contacts became unusable in...
-
I'm forever forgetting how to do this and am currently on a project where I get a ton of CSV files daily and need to load them. The trick with getting rid of the " is to know how to escape the " in a format file. The data looks like this...
-
First one in the series of SQL Server 2008 version, here it comes Cumulative Update package 1! What kind of fixtures are available in this CU1 package? Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed...
-
I was awarded SQL Server MVP status by Microsoft today in recognition of my community contributions. Hooray! If you don't know much about the Microsoft Most Valuable Professional progam here is an extract from the website: "Microsoft Most Valuable...
-
Just received my email... Dear Tony Rogerson, Congratulations! We are pleased to present you with the 2009 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise...
-
I was trying to send an email from an SSIS package when a package failed. However, the Send Mail Task failed everytime. There was no error message except the one in the sysdtslog90 table: An error occurred with the following error message: "Failure...
-
The first cumulative update for SQL 2008 has some fixes for the setup of SQL 2008. However there isn't a slipstreamed version of SQL 2008 with the Cumulative update. So you've got a bit of a chicken and egg situation. You need to install SQL 2008...
-
Are you the developing a multi user system or a large scale system? Do you know what concurrency is and how to improve it? If not then you should. Of the large scale systems I've worked on the biggest area of work is making the system scale. Its all...
-
In some cases we need to generate the data based on a starting date, to an end data (today-getdate()). This process is called data extrapolation based on limited information (starting date). Here I am trying to achieve the same without storing data in...
-
How to combine relational and multi-dimensional data into one query result set using OpenQuery...