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)
Feb
March 2005
Apr
S
M
T
W
T
F
S
27
28
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
31
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
March 2005 - Posts
Wednesday, March 30, 2005 3:28 PM
The Final Word in Microsoft SQL Server 2000 Backup, Restore and recovery
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, 2005
posted by
Mat_Stephen
|
0 Comments
Filed Under:
High Availability and Disaster Recovery
Wednesday, March 30, 2005 4:16 AM
First Microsoft-SAP Collaboration Brief from Microsoft on loading data from SAP BW into SQL Server Anlaysis Srevices
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
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SAP
Wednesday, March 30, 2005 3:21 AM
Questions arising from TechNet Webcast: Business Intelligence on the Microsoft Platform 23rd March.
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
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
Webcasts
Tuesday, March 22, 2005 10:54 AM
Forthcoming UK Microsoft SQL Server Business Intelligence Webcasts.
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
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Business Intelligence
,
Webcasts
Monday, March 21, 2005 6:58 PM
Microsoft SQL Server - Reporting Services Scripter - a free tool from sqldbatips.com
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
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Free SQL Server Tools, Utilities and Addins
,
Reporting Services
Monday, March 21, 2005 9:48 PM
Using SQL against the Unified Dimension Model in Microsoft SQL Server 2005 Analysis Services
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
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
Analysis Services 2005
Thursday, March 10, 2005 12:40 PM
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 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
posted by
Mat_Stephen
|
5 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
Analysis Services 2005
Wednesday, March 09, 2005 12:57 PM
Microsoft SQL Server 2005 - The Pricing, The Editions, and the Edition's Features
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
posted by
Mat_Stephen
|
2 Comments
Filed Under:
SQL Server 2005
,
SAP
Tuesday, March 01, 2005 5:59 PM
Microsoft SQL Server Resource Kit tools - 'Free' with MSDN and TechNet
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
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Free SQL Server Tools, Utilities and Addins