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)
Jun
July 2005
Aug
S
M
T
W
T
F
S
26
27
28
29
30
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
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
July 2005 - Posts
Friday, July 29, 2005 4:33 PM
New Microsoft SQL Server 2005 Upgrade Advisor - CTP June Refresh
Last night at the TechNet evening in Reading I was asked if we are planning an upgrade event. I couldn't say last night, but now I'm glad to say yes we are. In the week starting 5th Decemer we are planning a SQL focus day - during which we
posted by
Mat_Stephen
|
2 Comments
Filed Under:
SQL Server 2005
,
Post Event Follow Up
Friday, July 29, 2005 3:15 PM
Get Ready for SQL Server 2005 with Free Microsoft E-Learning Courses.
More and more people are asking me about SQL 2005 training courses and certification. I believe the exams will be ready in Q1 next year. In the meantme, how about access to the training courses absolutely free until 1st November @ https://www.microsoftelearning.com/sqlserver2005
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Business Intelligence
,
SQL Server 2000
,
Free SQL Server Tools, Utilities and Addins
Thursday, July 28, 2005 4:57 PM
SQL Server Marketing present 'Escape from Yesterworld'
The US marketing people for the Visual Studio and SQL Server product teams are pleased to announce the “Escape from Yesterworld” site has launched. In their own words: "Through the fun and interesting links below, people can learn about
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
Friday, July 22, 2005 2:15 PM
Blogcast: Using SQL 2000 Profiler
Here's another blogcast in the SQL 2000 performance blogcast series out of the States - this time 'Using SQL 2000 Profiler'. This one's a bit long at 11mins 8secs. http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_3.asx
posted by
Mat_Stephen
|
1 Comments
Filed Under:
SQL Server 2000
,
Blogcasts
,
Performance
Thursday, July 21, 2005 2:38 PM
Serialising an ADOMD.net CellSet object
I'm grateful to T.K. Anand for this useful code snippet which is useful if you're writing a web services client that consumes OLAP data. The following Adomd.net code can be used for saving and loading cellsets… Save:
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2000
,
SQL Server 2005
,
Analysis Services 2005
Wednesday, July 20, 2005 2:26 PM
SQL Server 2000 Analysis Services Cube Security
If you were given an opportunity to create a “cubed” solution for 50,000 different users, would you create one cube with 50,000 roles? Would you create 50,000 cubes – one for each customer? What would you do? This is what Mosha Pasumansky
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2000
,
SQL Server Security
Tuesday, July 19, 2005 9:50 AM
Are you still using @@IDENTITY?
Are you still using @@IDENTITY? It seems many people are. If you are, are you aware that it might not always return what you expect? No? then read on. @@IDENTITY will return the last IDENTITY column value inserted across any scope
posted by
Mat_Stephen
|
3 Comments
Filed Under:
SQL Server 2000
,
SQL Server 2005
,
T-SQL
Monday, July 18, 2005 11:16 AM
How Do You Deploy SQL Server Reporting Services?
A colleague of mine in the States, Rob Caron, is very keen to learn how our customers are deploying Reporting Services; specifically with respect to IIS. When we launched Reporting Services (RS) it was all too easy to say it was a ‘free’ addition to
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2000
,
SQL Server 2005
,
Architects Corner
,
Reporting Services
Friday, July 15, 2005 1:02 PM
SQL Server 2005 JDBC Driver Beta 1 Now Available
Not many people know we have a SQL JDBC driver at all, well now we've got a beta version for SQL Server 2005. It works for a wide variety of OSs including: HP-UX, IBM AIX, Linux, Solaris, Windows 2000, Windows Server 2003, or Windows XP. Apparently
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2000
,
SQL Server 2005
,
Architects Corner
,
Free SQL Server Tools, Utilities and Addins
Thursday, July 14, 2005 9:35 PM
Reporting Services: Two New (Free) Report Packs Released for Sharepoint and Axapta
Good news for the chap I met on the 'Ask the Experts' desk at TechEd, who was contemplating jumping through all sorts of hurdles to create reports form Sharepoint data. I couldn't really get my head round the (Sharepoint) problems he foresaw, but
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2000
,
SQL Server 2005
,
Free SQL Server Tools, Utilities and Addins
,
Reporting Services
Tuesday, July 12, 2005 4:51 PM
SQL Server 2005 Integration Services - Top Reference Site
SQL Server 2005 Integration Services - Top Reference Site From the people that brought you www.SQLDTS.com we now have www.SQLIS.com . This is a top website for examples, information, news and links to MSDN, MSDNTV and blogs etc covering Integration
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
SQL Server Integration Services
Tuesday, July 12, 2005 10:48 AM
Blogcast: SQL Server 2000 - Using the Index Tuning Wizard
Another blogcast from the States covering performance tuning in SQL Server 2000, this one covers using index tuning wizard. 6 mins 47 secs http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_2.asx
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2000
,
Blogcasts
,
Performance
Monday, July 11, 2005 2:12 PM
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 12TH July :: SQL Server 2005 The Home Stretch Euan Garden, Group ProgramManager, Microsoft, Redmond. Session 1 (6.15pm - 7.30pm)Come and see/learn about
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
Monday, July 04, 2005 2:19 PM
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 just to say hello, I will be at the Ask the Experts Info desk, here at TechEd at 11:30 - 2pm. Tuesday. And I'll also be at
posted by
Mat_Stephen
|
6 Comments
Filed Under:
Business Intelligence
,
SQL Server 2000
,
SQL Server 2005