Mat Stephen's Azure Data Services Blog
All things Azure Data Services (previously All things SQL Server). Complied by Matthew Stephen - Data Solutions Architect (Azure), Microsoft UK
SQL Server 2005 Integration Services - Top Reference Site
SQL Server 2005 Integration Services - Top Reference Site From the people that brought you...
Author: Mat_stephen_1 Date: 07/12/2005
Blogcast: SQL Server 2000 - Using the Index Tuning Wizard
Another blogcast from the States covering performance tuning in SQL Server 2000, this one covers...
Author: Mat_stephen_1 Date: 07/12/2005
UK SQL Server User group meeting 12TH July :: SQL Server 2005 The Home Stretch Euan Garden, Group Program
Tony Rogerson of the UK SQL User group has asked me to publicise the following User Group meeting...
Author: Mat_stephen_1 Date: 07/11/2005
TechEd Amsterdam: If you want to come and say hello, here's my schedule - and a cautionary note regarding Jay Walking here in Amsterdam
If you'd like to meet with me to discuss any issues arising from my blog posts, anything SQL, or...
Author: Mat_stephen_1 Date: 07/04/2005
Roger Sessions ObjectWatch: TechEd USA - his digest - insight from a true sage that can't be ignored
This issue’s feature article is “Tech-Ed 2005; The Elephant That Wasn’t There”. This article reports...
Author: Mat_stephen_1 Date: 06/30/2005
Office Business Scorecards Accelerator – the ultimate marriage of business and intellgence. Another free application from Microsoft
At first glance, particularly if you’re a jaundiced techie like me, you may think the Balanced...
Author: Mat_stephen_1 Date: 06/30/2005
Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!
There are very many, and from my own professional perspective, too many (I’ve got to try and learn...
Author: Mat_stephen_1 Date: 06/29/2005
The QFE for SQL Server 2000 Reporting Services Service Pack 2 is now available.
The QFE for SQL Server 2000 Reporting Services Service Pack 2 is now available. The QFE is a...
Author: Mat_stephen_1 Date: 06/28/2005
SQL Server Reporting Services: Custom colour in charts
A frequently asked question is, 'how does one customise the colours in a chart?' Below is a link to...
Author: Mat_stephen_1 Date: 06/28/2005
Business Intelligence (BI): The way it is, without the blah blah
I've just completed an article which gives my definition of BI, its written for people new to this...
Author: Mat_stephen_1 Date: 06/24/2005
Cool new OVER Clause (Transact-SQL) in SQL Server 2005
Cool new OVER Clause (Transact-SQL) in SQL Server 2005 to circumvent the not so efficient correlated...
Author: Mat_stephen_1 Date: 06/23/2005
Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05
Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet...
Author: Mat_stephen_1 Date: 06/22/2005
Querying and Reporting on Report Execution Log Data
Well I didn't realise, or maybe I just plain forgot, that these reports and the necessary support...
Author: Mat_stephen_1 Date: 06/22/2005
Follow up on Replication Columns question in my TechNet SQL 2005 presentation (14/6/05)
Question: How many columns does SQL Server 2005 allow in a published article (SQL Server 2000 was...
Author: Mat_stephen_1 Date: 06/22/2005
Follow up on Witnesses question from SQL Server™ 2005 High Availability TechNet evening 21/6/05
Database Mirroring: How many witness can you have in quorum? - One How many witnesses can you have...
Author: Mat_stephen_1 Date: 06/22/2005
Blogcast: SQL Server 2000 Performance Demo 1-3 Managing indexes
Here's a Blogcast, the third in a series of three from the US, looking at Performance tuning...
Author: Mat_stephen_1 Date: 06/20/2005
Blogcast: SQL Server 2000 Performance Demo 1-2 Analyzing an execution plan
Here's a Blogcast, second in a series of three from the US, looking at Performance tuning techniques...
Author: Mat_stephen_1 Date: 06/20/2005
Blog cast SQL Server 2000 Performance Demo 1-1 Searching and browsing objects
Here's a Blogcast, one of a series of three from the US, looking at Performance tuning techniques...
Author: Mat_stephen_1 Date: 06/20/2005
More follow up from my TechNet SQL 2005 presentation (14/6/05) - SMP boxes and database files
During my TechNet presentation on Tuesday evening (14/6/05 in Reading), I got a little side tracked...
Author: Mat_stephen_1 Date: 06/16/2005
Peer to peer demo code
Here's the code I used for the Peer to Peer replication demo I did during the SQL Server 2005...
Author: Mat_stephen_1 Date: 06/16/2005
Peer to Peer replication demo code from SQL Server 2005 TechNet evening on the 14th June at our Reading office
You can find all the code @ https://blogs.technet.com/mat_stephen/articles/406459.aspx
Author: Mat_stephen_1 Date: 06/16/2005
Steve Ballmer on Mendocino - video available
The Video from SAPPHIRE (Steve Ballmer on Mendocino) is now available on the website at...
Author: Mat_stephen_1 Date: 06/14/2005
London roadshow follow up: Selective execution of SQL Server Integration Service Tasks and Transforms
I had a question, at the London roadshow (8th June), which I wasn’t sure if I could answer reliably,...
Author: Mat_stephen_1 Date: 06/14/2005
Reporting Services: How to stop IE striping out leading spaces in report data values
Reporting Services: How to stop IE striping out leading spaces in report data values: My thanks to...
Author: Mat_stephen_1 Date: 06/14/2005
Blogcast: How to add a multicast transform to a SQL Server Integration Services package
Here is a 4min 8sec blogcast showing how to add a multicast transform to a SQL Server Integration...
Author: Mat_stephen_1 Date: 06/11/2005
SQL 2005 Express to get Report Server and Workgroup edition to get Report Builder
Good news! Due to popular demand we have added Report Server to the Express edition of SQL 2005 and...
Author: Mat_stephen_1 Date: 06/10/2005
BUG: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4
Alas SQL Server 2000 SP4 has introduced a bug that prevents all one's memory being used if you are...
Author: Mat_stephen_1 Date: 06/10/2005
Blogcast: How to create a simple SQL Server Integration Services package
Here is an 8min 13sec blogcast showing how to create a simple SQL Server Integration Services...
Author: Mat_stephen_1 Date: 06/10/2005
SQL Server 2005 launch date anounced!
This morning, at TechEd USA, Paul Flessner announced the release date for SQL Server 2005. This is...
Author: Mat_stephen_1 Date: 06/07/2005
Two SQL 2005 TechNet Evenings I'll be delivering in Reading, UK
For those of you in the area, I'll be presenting these two TechNet evenings in Reading UK - it would...
Author: Mat_stephen_1 Date: 06/07/2005
SQL Server TechCenter Launches
Well, how about this - looks good to me! Definitely one for your favourites. I'll say no more and...
Author: Mat_stephen_1 Date: 06/03/2005
SQL Server 2005 webcasts starting today and coming throughout June
You can register for all these webcasts from here...
Author: Mat_stephen_1 Date: 05/31/2005
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...
Author: Mat_stephen_1 Date: 05/31/2005
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...
Author: Mat_stephen_1 Date: 05/26/2005
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...
Author: Mat_stephen_1 Date: 05/23/2005
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...
Author: Mat_stephen_1 Date: 05/23/2005
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...
Author: Mat_stephen_1 Date: 05/22/2005
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...
Author: Mat_stephen_1 Date: 05/19/2005
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),...
Author: Mat_stephen_1 Date: 05/16/2005
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...
Author: Mat_stephen_1 Date: 05/16/2005
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...
Author: Mat_stephen_1 Date: 05/16/2005
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...
Author: Mat_stephen_1 Date: 05/16/2005
Webcast with Proclarity
If you were unable to connct to our webcast with Proclarity last month then please have another go,...
Author: Mat_stephen_1 Date: 05/11/2005
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...
Author: Mat_stephen_1 Date: 05/11/2005
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...
Author: Mat_stephen_1 Date: 05/09/2005
SQL Server 2000 Service Pack 4 - baked and Ready to go
Improve the performance, serviceability, and enhance the security of your SQL Server 2000...
Author: Mat_stephen_1 Date: 05/06/2005
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...
Author: Mat_stephen_1 Date: 05/04/2005
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...
Author: Mat_stephen_1 Date: 05/04/2005