For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorks GO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1 ALTER DATABASE AdventureWorks ADD FILEGROUP...

Have you ever been asked to do OLAP on a PDA – Pocket PC. If you have this http://www.euroman.co.uk/pcktindex.html has to be the best answer. I’ve seen it demoed and it rocks – its so cool; bringing scalable OLAP server power to your PDA in a way you...

At last, here is a feature comparison between Microsoft SQL Server 2000 Reporting Services vs Business Objects Crystal Reports / Crystal Enterprise that I can actually point you to. We ' ve had our own internal one for quite sometime, but for what I believe...

Sorry I'm a little late in alerting you to this SQL Server 2005 Educational Webcast Series on TechNet, which runs from March 21-May 18. This 10 part series will provide IT Professionals with a broad overview of the benefits of SQL Server 2005 to whet...

Following on from a presentation 'First Look at SQL Server Integeration Services' to some MVPs here at TVP Reading, I am responding to the a question I was asked, 'how does SQL Server's fuzzy logic work'. I was meant to explain how the confidence and...

Are you ready to experience SQL Server 2005? Announcing the launch of the SQL Server 2005 Virtual Hands on labs. In these labs, you will get to experience many of the new features in SQL Server 2005 including CLR integration, XML support and deep business...

There are three technical tracks at the 2 day roadshow this year. The second day is a ‘SQL Server 2005’ day with a number of sessions covering SQL 2k5 from three angles: ITPro (DBA), Developer and Security. On the ITPro track there will be Analysis...

From the blog hits I received the last time I posted some info on free report packs available for SQL Server Reporting Services, I'm sure many of you will be pleased to find we've just posted two more for IIS and Great Plains. Objective: The Report...

I am pleased to be able to point you to the last word in SQL Server 2000 Backup and Restore methods. At last all the answers in one place! SQL Server 2000 Backup and Restore Published: March 1, 2005 Author: Pankaj Agarwal Published: February...

It's a great pleasure to announce the first Microsoft Collaboration Brief on an official SAP site, written by Microsoft’s own Hermann Däubler. Loading data from SAP BW into Microsoft Analysis Services using Open Hub Service . (You can cacnel any...

Thanks to all of you who tuned in to this webcast last week. Sorry this post is a little late, no sooner had I finished the webcast than the sore throat I had turned into a full blown cold and layed me out for the next couple of days. The archive...

I shall be presenting this first webcast myself and hosting the other two – hope you can join in. 23 March, 10am: TechNet Webcast: Business Intelligence on the Microsoft Platform This webcast is will provide IT Professionals with a complete technical...

I’m grateful to Andy Steer of Contemporary, one of our Gold BI Partners here in the UK , for pointing me to this useful free utility from.sqldbatips.com Overview: Reporting Services Scripter is a .NET Windows Forms application that enables scripting of...

Following Deepak's question, asked in his comment on my previous UDM post , I quizzed our internal Yukon alias and received the following useful info regarding using SQL against a UDM; thanks to Akshai Mirchandani. AS2005 supports a limited set...

There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005. Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’...

All ye! All ye! The pricing, the editions and the features available in the editions of SQL 2005 have all been decided, announced and published. Naturally I meet scepticism that suggests SQL Server 2005 has slipped and slipped again, and that perhaps...

Okay so these tools aren ' t totally free but I didn ' t really have anywhere else to categorise them. Anyway I ' m sure I ' ve seen advertisements that boast "you can get a ‘free’ toy with every packet of some breakfast cereal". Well these tools are...

Well I’ve been blogging for a 11 weeks or so and looking at my stats I can see the posts that attract the most attention are those that either advertise a freebie or offer a performance tip. So, blatantly pandering to my ratings, here’s another freebie...

At first glance, particularly if you’re a jaundiced techie like me, you may think the Balanced Scorecard is a concept wholly worthy of its acronym, BS. You might find a description of its function couched in those seemingly worthless terms like vision...

Just incase you missed this freebie: Report Packs SQL Server 2000 Report Pack for Microsoft CRM Download this set of six predefined CRM-based reports and a sample database that let you easily visualize and author managed reports to support key sales...

Actually, I reckon it must be Sun’s first Windows - SQL Server benchmark ever, unless you know otherwise? It’s great to see Sun embracing the new Opeteron chip from AMD and coming up with a great 32 bit SAP SD 2 tier 2 proc benchmark http://www50.sap...

When performing batch jobs where you wish to run processes in parallel it is important to understand how the scheduler works. You can get a description of what the scheduler does by looking under the title ‘ SQL Server Task Scheduling’ in Books...

Its a question that comes up more and more as people realise they can take advantage of SQL Server's lower TCO. "Does Microsoft have any tools for converting PSQL to TSQL". No, but the link below will take you to a company that has tools to do this and...

Max degree of parallelism is an advanced configuration option in SQL Server about which many question have been asked and much written. In this blog entry I hope to offer some insight and certainty as to what this option does and how it should be used...

Following the trend I've created my first Blogcast - Creating a simple SQL Server Reporting Services report using the Report Wizard. It lasts about 6 minutes. It takes you through the simple steps required to create a simple report, making a little tweak...