Partager via


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

<Previous Next>