Browse by Tags

SQL Server 2008 – iFTS Introduction

This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008. This is one of my favourite features which I’ve had to keep stum about for quite a while. Firstly an introduction to full text. Full text is the feature in SQL Server that allows you to search text content...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 02-19-2008
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 and...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 12-18-2007
SSAS 2005 - Visualize Attribute Relationships

Complicated attribute relationships are difficult to oversee in SSAS 2005. Microsoft solved this problem in SQL Server 2008 with a graphical view of the attribute relationships. Unfortunately, most of us still work with SSAS 2005 and have to wait a couple of months before using the benefits of SSAS 2008...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 11-16-2007
Should you wait for Katmai.

I read Steve Jones editorial in Database Weekly today and saw his statement. " I still recommend jumping from 2000 to 2008 if you haven't already upgraded" My personal view is that if you are looking to replace your systems then 2005 has some great features that you get out of the box and is now stable...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-12-2007
MCITP BI News; some news for MCTS BI and SQL Server 2008

Anticipated recources for the premier Microsoft Business Intelligence certification (MCITP BI) for SQL Server 2005 are fading from Microsoft. I recently was made aware from Amazon that a book I pre-ordered titled "MCITP Self-Paced Training Kit (Exam 70-446): Designing and Developing a Business Intelligence...

Posted to greenmtnsun (Weblog) by greenmtnsun on 10-17-2007
How to get the name of the day of date

Do you have a date and you want the day of the week but not the number but the name i.e. Monday, Tuesday etc. Well there are two functions that you can use with dates that can be used to extract a part of the date. One function returns the number and one returns text version. The functions are DATEPART...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-03-2007
Whats in a BOL link?

In using BOLyou will have noticed that the links in BOL contain some lovely guids. I often want to reference BOL in documents, forum posts etc but was concerned that the guids might change. So I asked Alan Brewer whether they change or not. He gave me a great response which I've got his permission to...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 08-16-2007
Coming Soon: SQL Server SoundBytes!

The U.K. SQL Server PFE team is preparing, starting from September 2007, a series of SQL Server SoundBytes aimed to deliver proactive content to our Premier customer via Livemeeting. Premier SoundByte sessions will be ideal for customers who need proactive information, for whom it may not be convenient...

Posted to The Premiers (Weblog) by ThePremiers on 06-22-2007

Page 1 of 1 (8 items)