Welcome to TechNet Blogs Sign in | Join | Help

May 2005 - Posts

Tuesday, May 31, 2005 1:12 PM

SQL Server 2005 webcasts starting today and coming throughout June

You can register for all these webcasts from here http://www.microsoft.com/uk/technet/training/webcasts.mspx#EIA 31 May, 17.30: Real-Time BI with SQL Server 2005 Analysis ServicesThere is an increasing demand to make business intelligence (BI) 'real-time'.
posted by Mat_Stephen | 1 Comments
Filed Under: ,
Tuesday, May 31, 2005 12:42 PM

Keep up-to-date with knowledge base articles coming out of Microsoft

I am very grateful to Andy Steer of Contemporary Plc for this useful tip. To keep up-to-date with knowledge base articles coming out of Microsoft, check out this web page containing RSS feeds for all Microsoft products: http://support.microsoft.com/selectindex/?target=rs
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Thursday, May 26, 2005 2:30 PM

SQL Server Reporting Services: How to do an aggregate, SUM(Field), and display it as a % of the total for a Table or Matrix column

SQL Server Reporting Services: How to do an aggregate, SUM(Field), and display it as a % of the total for a Table or Matrix column To do this we have to take advantage of the fact that the SUM function, and indeed all aggregate functions, have an optional
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Monday, May 23, 2005 5:23 PM

Processing XML Showplans Using SQLCLR in SQL Server 2005 - Make Use of the New XML Showplans

SQL 2005 now provides Showplan (Query plan) output in XML - why? To make it easier for a dba/developer to write TSQL, or other code, that can determine the cost of a query and thus dynamically determine if the query should be prevented
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Monday, May 23, 2005 1:41 PM

Expanding the reach of the Maestro beta program

I'm happy to announce we've opened the Maestro beta program so customers and partners can self nominate themselves to the program and get early access to the bits.  This is to allow people, not involved with the TAP, to get hold of the beta to experiment
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Monday, May 23, 2005 12:07 AM

Transfering Data Oracle Data To And From SQL Server

This post is for two purposes: firstly to point to a comprehensive blog post covering the transfer of data between Oracle and SQL Server using SQL Server 2005 Integration Services - which answers a recuring question from customers and partners with insight,
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Thursday, May 19, 2005 11:38 AM

SQL Server 2000 vs SQL Server 2005 Performance

As SQL server 2005 gets closer more and more people are asking how much faster is it than SQL Server 2000. Thanks to Rog Garrison here's one of the first tests I've seen http://www.sqljunkies.com/Tutorial/077C7BEB-EB31-4A07-923D-BE309F59D0F8.scuk Thank
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Monday, May 16, 2005 4:11 PM

Blogcast: Solution Exporer inside SQL Server 2005 Management Studio

Following on from my previous two blogcasts looking at the SQL Server 2005 Management Studio (SMS), here’s another blogcast (5m55s) looking at the Solution Explorer in SMS.
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, May 16, 2005 1:58 PM

Top Tip: How to use the same dimension twice on one fact table with SQL Server 2000 Analysis Services

I’m grateful to Cristian Petculescu for this Top Tip: How to use the same dimension twice on one fact table with SQL Server 2000 Analysis Services.   To use the same dimension twice, against one fact table, you essentially use the same dimension
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, May 16, 2005 1:55 PM

Blogcast: Introducing the Object Explorer in the new SQL Server 2005 Management Studio

Following on from my last blogcast here’s a blogcast (8m57s) that introduces the Object Explorer in the new SQL Server 2005 Management Studio. 
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, May 16, 2005 11:58 AM

Blogcast: First Glimpse at SQL Server 2005 Management Studio

I’ve just done a short (4m47s) blogcast giving a first glimpse at the new SQL Server 2005 Management Studio
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Wednesday, May 11, 2005 10:45 PM

Webcast with Proclarity

If you were unable to connct to our webcast with Proclarity last month then please have another go, here is the corresponding missive from marketing: Last month you registered to attend the TechNet Webcast ‘Analysing and Presenting SQL Server Data with
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Wednesday, May 11, 2005 9:49 PM

Nice one Maestro - the next generation of the Business Scorecard Accelerator is now in beta 1

Thank heavens – Microsoft is going to charge for its next version of its business scorecard solution code named Maestro, beta 1 of which has just been announced.  Why is this charge a good thing?  Because if people have to pay for this product
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Monday, May 09, 2005 10:46 PM

Tell your boss you need to go to Tech Ed 2005 Europe (Amsterdam, 5-8 July, 4th for pre-conference seminars)

Here's an invitation from the TechEd crew, note the early bird offer!.  I'm really looking forward to it; Amsterdam - top venue!  Welcome to Tech·Ed 2005 Europe - Microsoft’s flagship European technical education conference for developers
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Friday, May 06, 2005 3:54 PM

SQL Server 2000 Service Pack 4 - baked and Ready to go

Improve the performance, serviceability, and enhance the security of your SQL Server 2000 installations with SQL Server 2000 Service Pack 4. SP4 will be released to the web and be available for customer download on Friday, May 6, 2005 at 9am PST. ·        
posted by Mat_Stephen | 1 Comments
Filed Under: ,
Wednesday, May 04, 2005 9:07 AM

Top Tip - Dynamic Database connections for SQL Server 2000 Reporting Services reports

A question that crops up from time to time with SQL Server 2000 Reporting Services is 'how do I dynamically change the data source used buy a report - from within a report?'   To do this is quite straight forward in SQL 2005 Reporting Services
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Wednesday, May 04, 2005 7:12 AM

Become an Industry Insider and get published on TechNet

Industry Insiders is the term given to a community activity that my team (Microsoft's IT Pro Evangelists in the UK) have recently started.  The idea is to help bring together technical experts in the ITPro Community by providing a high visibility
posted by Mat_Stephen | 1 Comments
Filed Under:
Tuesday, May 03, 2005 1:56 PM

Webcasts - Business Intelligence using SQL Server 2005

The marketing people here at Microsoft, have asked me to advertise a new series of BI webcasts using SQL Server 2005.  So, to oblige, here is their spiel: “Your business intelligence (BI) applications need to integrate seamlessly into your overall
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Tuesday, May 03, 2005 8:00 AM

Another Blog with an interesting fuzzy logic example using SQL Server Integration Services to process web server logs

For those of you interested in implementing fuzzy logic in SQL Server Integration Services Jamie Thomson's Blog has a very good blog post on the subject with an interesting real world example that overcomes a challenging performance problem. 
posted by Mat_Stephen | 0 Comments
Filed Under: ,