Welcome to TechNet Blogs
Sign in
|
Join
|
Help
Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
This Blog
About
Email
Syndication
RSS 2.0
Atom 1.0
Search
Go
Archives
January 2006 (4)
November 2005 (4)
October 2005 (3)
September 2005 (9)
August 2005 (13)
July 2005 (14)
June 2005 (24)
May 2005 (19)
April 2005 (18)
March 2005 (9)
February 2005 (18)
January 2005 (7)
December 2004 (18)
News
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified on Microsoft.com
Navigation
Home
Photos
Post Categories
Analysis Services 2005 (9)
Architects Corner (6)
Blogcasts (14)
Business Intelligence (72)
Code samples (1)
Free SQL Server Tools, Utilities and Addins (26)
High Availability (1)
High Availability and Disaster Recovery (15)
Oracle (5)
Performance (32)
Performance Top Tips (7)
Post Event Follow Up (8)
Replication (3)
Reporting Services (35)
SAP (12)
Service Broker (1)
SQL 64 bit (4)
SQL Server 2000 (41)
SQL Server 2005 (86)
SQL Server Integration Services (13)
SQL Server Security (4)
T-SQL (5)
Webcasts (18)
May
June 2005
Jul
S
M
T
W
T
F
S
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
Microsoft Evangelists UK
John Howard
Eileen Brown
Steve Lamb
SQL Server sites of interest
SQL Server's home page
SQL Server on Technet
SQL Server Security Center
SQL Server on MSDN
SQL Server 2005
SQL server 2005 | data mining
SQL Server Developer Center - SQL Server 2005 Webcasts
Webcasts and chats for SQL Server
Get the Facts on Database Security
Reporting Services TechNet Site
sql-server-performance.com
SQL Server Integration Services - Community
SQL Server Integration Services - Microsoft Corp.
Analysis Services - Microsoft Corp.
Useful SQL 2005 Docs
Troubleshooting Performance Problems in SQL Server 2005
SQL Server 2005 comparison: features by edition
Useful Integration Services Docs
Project REAL—Business Intelligence in Practice
Managing and Deploying SQL Server Integration Services
Conchango Describes How SQL Server 2005 Integration Services Compares with Informatica
Useful SQL 2000 Docs
Microsoft SQL Server 2000 Analysis Services Performance Guide
Microsoft SQL Server 2000 RDBMS Performance Tuning Guide for Data Warehousing
SQL Server 2000 Operations Guide
Microsoft SQL Server 2000 High Availability Series
SQL Server 2000 Backup and Restore
Analysis Services 2000 Whitepapers
SQL Server Blogroll
Bob Beauchemin's Blog - Top trainer and Author
Mosha Pasumansky, Microsoft OLAP Server Development
Technorati Profile
Donald Farmer - Microsoft SQL Server Integration Services Group Program Manager
Euan Garden - SQL Server Group Program Manager
UK Bloggers
Jamie Thomson for Integration Services
Chris Webb's BI Blog - Extreme MDX
Personal sites of interest
LifeLikeFriends
June 2005 - Posts
Thursday, June 30, 2005 10:55 PM
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 on Microsoft’s major Tech-Ed 2005 conference in Orlando earlier this month. This was the conference at which Microsoft laid out its strategy
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
,
Architects Corner
Tuesday, June 28, 2005 10:22 PM
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 generally distributed release that can be obtained from http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en.
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Reporting Services
,
SQL Server 2000
Tuesday, June 28, 2005 1:40 PM
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 a blog post from Brian Welcker, which is actually a post on how to overcome the encumberence of the chart legend when it takes up too much space
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
Reporting Services
,
SQL Server 2005
,
SQL Server 2000
Friday, June 24, 2005 4:40 PM
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 area and who are still trying to get their heads round it. BI is traditionally swamped in marketing and analyst 'blah blah', which only serves
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
Thursday, June 23, 2005 5:40 PM
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 subquery. Imagine a table: create table grades( StudentID int not null,StudentName varchar(10) not null,Subject varchar(10) not null,Score
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Performance
,
SQL Server 2005
,
T-SQL
Wednesday, June 22, 2005 9:31 PM
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 evening 21/6/05 Question; how does a snapshot database perform compared to the original database when it comes to querying – can it make use of
posted by
Mat_Stephen
|
0 Comments
Filed Under:
High Availability and Disaster Recovery
,
Performance
,
SQL Server 2005
,
Post Event Follow Up
Wednesday, June 22, 2005 5:28 PM
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 infrastrucuture come with Reporting Services under the extras folder on the CD - all useful stuff for report heads. Longest Running ReportsMost Executed
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
Reporting Services
,
Free SQL Server Tools, Utilities and Addins
,
SQL Server 2005
,
SQL Server 2000
Wednesday, June 22, 2005 4:55 PM
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 linited to 254)? Answer: The column limit for transactional replication, I'm informed, is now in excess of 1000.
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
,
Post Event Follow Up
,
Replication
Wednesday, June 22, 2005 2:29 PM
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 on one box? - Many
posted by
Mat_Stephen
|
0 Comments
Filed Under:
High Availability and Disaster Recovery
,
SQL Server 2005
,
Post Event Follow Up
Monday, June 20, 2005 5:47 PM
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 techniques with SQL 2000 'Managing indexes' http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-3.asx
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Performance
,
Blogcasts
,
SQL Server 2000
Monday, June 20, 2005 5:44 PM
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 with SQL 2000 'Analyzing an execution plan' http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-2.asx
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Performance
,
Blogcasts
,
SQL Server 2000
Monday, June 20, 2005 5:40 PM
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 with SQL 2000 http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-1.asx
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Performance
,
Blogcasts
,
SQL Server 2000
Thursday, June 16, 2005 11:13 PM
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 and, while talking about partitioning in SQL 2005, found myself drawing my audiences’ attention to the fact that only one thread can access a database
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Performance
,
SQL Server 2005
,
SQL Server 2000
,
Post Event Follow Up
Thursday, June 16, 2005 4:47 PM
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 @ http://blogs.technet.com/mat_stephen/articles/406459.aspx
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
,
Post Event Follow Up
Tuesday, June 14, 2005 11:53 PM
Steve Ballmer on Mendocino - video available
The Video from SAPPHIRE (Steve Ballmer on Mendocino) is now available on the website at http://www.microsoft-sap.com/alliance.aspx Mendocino is described at www.sap.com/mendocino, and www.microsoft.com/office/sap. I think mendocino is very significant
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SAP
Tuesday, June 14, 2005 3:42 PM
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, so I promised to blog the answer. The question: “Can I run selected (with mouse) tasks and transforms from inside the SQL Server Integration Services
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
SQL Server Integration Services
,
Post Event Follow Up
Tuesday, June 14, 2005 10:21 AM
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 Russell Christopher and Mike Schetterer who recently discussed the problem that IE will strip out leading spaces from data in a report. The solution:
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Business Intelligence
,
Reporting Services
,
SQL Server 2005
,
SQL Server 2000
Saturday, June 11, 2005 5:52 PM
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 Services package (the package created in the previous blogcast). A multicast transform can create two or more replica data flows from one original
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
Blogcasts
,
SQL Server Integration Services
Friday, June 10, 2005 3:57 PM
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 added Report Builder to the Workgroup edition - there are some caviats though so check the small print at the bottom of this feature guide. http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
Reporting Services
,
SQL Server 2005
Friday, June 10, 2005 1:10 PM
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 using AWE - please see the following article. http://support.microsoft.com/default.aspx?scid=kb;en-us;899761 Microsoft will post a fix for
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2000
Friday, June 10, 2005 11:15 AM
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 package. The package aggregates 2 million records from a raw data file and passes the resulting 64 aggregated rows into a table in tempdb.
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
Blogcasts
,
SQL Server Integration Services
Tuesday, June 07, 2005 2:40 PM
SQL Server 2005 launch date anounced!
This morning, at TechEd USA, Paul Flessner announced the release date for SQL Server 2005. This is an excerpt from his notes from TechEd: "It is official — the countdown to launch has begun! During my Tech•Ed keynote this morning,
posted by
Mat_Stephen
|
7 Comments
Filed Under:
SQL Server 2005
Tuesday, June 07, 2005 12:15 PM
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 be good to see you there! 14 th June Session Abstract: Microsoft SQL Server 2005 is the next version of the successful SQL Server product family. This
posted by
Mat_Stephen
|
0 Comments
Filed Under:
High Availability and Disaster Recovery
,
SQL Server 2005
Friday, June 03, 2005 1:15 PM
SQL Server TechCenter Launches
Well, how about this - looks good to me! Definitely one for your favourites. I'll say no more and just paste in the general announcememt for customers. SQL Server TechCenter Launches The new SQL Server TechCenter is live
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
,
SQL Server 2000