Free - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Free (RSS)

SQL Server 2008 UK Usergroup London Launch event

SQL Server 2008 UK Usergroup London Launch event As part of the SQL Server Launch wave we are holding a usergroup meeting to celebrate the launch (not RTM). We're going to run this as an open session so you'll be able to ask us to cover the areas...
Posted by simonsabin | with no comments
Filed under: , , ,

SQL Server 2008 - CTP6 is now available

The next CTP of SQL Serve 2008 is now available for download. Whats different about this CTP from the others, apart from the new features which there are a lot, is there is a bug bash contest that is opening. Simply put the people that raise the most...

Office 2007 iFilters are now available

The ifilters needed to index office 2007 documents are now available for download from here http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en At the time of writing some of the related KB...

SQLBits 2008 In Birmingham on 1st March Call for speakers

Yes we're doing it again. SQLBits ( www.sqlbits.com ) will be back on the 1st March at The Lakeside Conference Centre in Birmingham. Its a bigger venue than TVP so we shouldbe able to let more people attend. Registrations aren't open yet but if you register...

SQLBits Registration is open

We have now opened the full registration for www.SQLBits.com You will need to register on the site and then select the 10 sessions ( http://www.sqlbits.com/information/PublicSessions.aspx ) you would most like to see. We will use this voting to help decide...
Posted by simonsabin | with no comments
Filed under: , ,

PDF 64 bit iFilter at last

If you use full text and wat to index pdf documents you might have found you run into problems on a 64 bit machine. This is because there is no 64 bit iFilter for pdfs. The iFiliter is the bit of code that interprets the code and spits out the information...
Posted by simonsabin | with no comments

SQLBits - Free SQL Server Conference October 2007

I have pleasure in announcing SQLBits Community Day .On the 6th October we will be taking over building 3 at Microsoft's Head offices in Reading. To hold a full day of SQL Server content with speakers from the UK. There will be 20 sessions over 3 tracks...

SSIS : Enhanced Error Component - Update

I have finally got round to looking into the error reports and found a few bugs in this component. I have uploaded a new install for this component including the fixes. The component now validates correctly that the correct inputs are attached to the...

SQL Server 2005 May 2007 BOL now available

Thanks to Gail Erickson of the SQL Server Documentation Team notifying me of the availability of May BOL. The May 2007 release of Books Online is available on MSDN and on the download site. This is a very targeted update to BOL and is limited to correcting...

Using SMO from TSQL

If you are desperate to get your hands on the code I used in the SMO in TSQL demo I did at the usergroup meeting you can download it now from codeplex. http://www.codeplex.com/SMOinTSQL There are 2 projects in there one an SSMS project and one a C# project...

Free 2GB SQL Server USB Keys

We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink) The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t...

Update to the taskpad custom report

Thank you to those people that informed me that my taskpad report was incorrectly reporting the backups times against the wrong type of backup. I have now fixed the report and have also included the backup types that are supported by SQL 2005. You can...

SQL Server Samples are now live on Codeplex

Microsoft are in the process of retiring GotDotNet and replacing it with CodePlex. CodePlex is a shared source website which allows you to upload projects and give access to other people to view/maintain. The great feature is that it is using Team Foundation...
Posted by simonsabin | with no comments

SSIS : How do I add rownumber/line number to a data flow

There are a number of options to achieve a row number /line number in a data flow. One of the easiest solutions is to use script component. This video shows you how to, http://sqlblogcasts.com/files/folders/ssis_tools/entry1591.aspx if (socialButtons...

Raw file reader has been updated

My raw file reader has now been updated, the following are the changes from the previous version Column headers can be included if more than one column is selected. Context menu to copy data from the grid Can read a package for raw files and will load...
More Posts Next page »