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)
Apr
May 2006
Jun
S
M
T
W
T
F
S
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
7
8
9
10
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
Post Event Follow Up
(RSS)
Friday, August 12, 2005 2:36 PM
Follow up on XPs and SQLiMail question from SQL Server™ 2005 Management and Admin TechNet evening 28/7/05
Sorry for the delay in getting these answers posted but my trip to the US and some hols have got in the way. I was asked if SQL Express could handle Extended Stored Procedures unlike msde. The answer is msde can handle XPs and so can SQL Express.
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
,
Post Event Follow Up
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
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:
SQL Server 2005
,
High Availability and Disaster Recovery
,
Performance
,
Post Event Follow Up
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:
SQL Server 2005
,
High Availability and Disaster Recovery
,
Post Event Follow Up
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:
SQL Server 2000
,
SQL Server 2005
,
Performance
,
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 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