Browse by Tags

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 articles aren't available. If you use full text...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 18 2007
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 for the search service (full text) to use to...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jul 18 2007
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 of BI, Dev and DBA, plus some of the first...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 17 2007
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 technical inaccuracies in a handful of topics...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jun 4 2007
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. Both can be opened using the TFS in codeplex...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 8 2007
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-shirts, books and USB keys. If you want to learn...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 29 2007
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 downlaod the new version of the taskpad custom report...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Mar 28 2007
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 Server. This means that any one using Visual...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 22 2007
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 - var height=90;var width=720;

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Mar 5 2007
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 each one of them Will remember the last 10 packages...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 17 2007

Page 1 of 2 (14 items) 1 2 Next >