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
High Availability and Disaster Recovery
(RSS)
Tuesday, September 06, 2005 6:11 PM
SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers
For a long time now Oracle enthusiasts have bashed SQL Server for not having Optimistic Concurrency Controls. They would demonstrate a SQL Server reader blocking a writer and possibly a writer blocking a reader. Thus, having appeared to demonstrate
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
T-SQL
,
High Availability and Disaster Recovery
,
Performance
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 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
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:
SQL Server 2005
,
High Availability and Disaster Recovery
Monday, May 23, 2005 5:23 PM
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 dba/developer to write TSQL, or other code, that can determine the cost of a query and thus dynamically determine if the query should be prevented
posted by
Mat_Stephen
|
0 Comments
Filed Under:
SQL Server 2005
,
High Availability and Disaster Recovery
,
Performance
Monday, April 18, 2005 4:49 PM
TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning
For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorksGO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1ALTER DATABASE AdventureWorks ADD FILEGROUP FG2GO
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Business Intelligence
,
SQL Server 2005
,
High Availability and Disaster Recovery
,
Performance
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
Tuesday, February 08, 2005 3:50 PM
Microsoft SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertainty
Max degree of parallelism is an advanced configuration option in SQL Server about which many question have been asked and much written. In this blog entry I hope to offer some insight and certainty as to what this option does and how it should be
posted by
Mat_Stephen
|
2 Comments
Filed Under:
High Availability and Disaster Recovery
,
Performance
,
Performance Top Tips
Tuesday, February 01, 2005 4:28 PM
I'm trying to find some detail on Patch management / deployment on a 4 SQL Server node cluster?
Stephen Daborn asked this question on my High Availability blog entry and I didn't get back before the post closed - sorry Stephen - been doing a lot of snow boarding recently. Anyway its a good question and it deserves an answer. The best thing to do
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Free SQL Server Tools, Utilities and Addins
,
High Availability and Disaster Recovery
Monday, January 10, 2005 1:50 PM
Oracle RAC, Grid, IBM, and Microsoft: A Corporate Altercation or Religious Divergence
People often ask me, “When Microsoft is going to get into the type of clustering as defined by Oracle’s RAC (Real Application Clusters)?” Generally, I find these are people who believe the technical concepts behind RAC are the way of the future,
posted by
Mat_Stephen
|
3 Comments
Filed Under:
Oracle
,
High Availability and Disaster Recovery
Friday, January 07, 2005 11:23 AM
SQL Server Health and History Tool (SQLH2)
This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5. Realising such downloads have sometimes
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Free SQL Server Tools, Utilities and Addins
,
High Availability and Disaster Recovery
,
Performance
,
Reporting Services
Monday, December 20, 2004 1:15 PM
TechNet Webcast: A Technical Overview of SQL 2005 High Availability Features (Part 2 of 2) - Level: 200
Friday, January 14, 2005 - 9:30 - 10:30 AM Pacific Time Matthew Hester, TechNet Presenter, Microsoft Corporation There are a number of barriers to availability, and only some of these are addressable by DBMS technology. This session looks at some of the
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Webcasts
,
High Availability and Disaster Recovery
Monday, December 20, 2004 1:14 PM
TechNet Webcast: A Technical Overview of SQL 2005 High Availability Features (Part 1 of 2) - Level: 200
Friday, January 07, 2005 - 9:30 - 10:30 AM Pacific Time Bryan Von Axelson, TechNet Presenter, Microsoft Corporation There are a number of barriers to availability, and only some of these are addressable by DBMS technology. This first part of a two-part
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Webcasts
,
High Availability and Disaster Recovery
Friday, December 17, 2004 8:26 PM
SQL Server Disaster Recovery (DR) and SANs, Remote Mirrors and Geo-Clusters
After some positive comments arising from my High Availability post I’ve decided to Blog on DR earlier than I had intended. I hadn’t intended to blog on DR for a while because it’s a difficult subject and I was hoping it might get easier if I left
posted by
Mat_Stephen
|
2 Comments
Filed Under:
High Availability and Disaster Recovery
Wednesday, December 15, 2004 8:12 AM
SQL Server High Availability – I have to talk about this so much I feel like a scratched record.
Rather than write endless amounts here I’m just going to describe some useful pointers that you can reference. The first reference is to failover clusters, I mention this one first as it dives head on into that word ‘Cluster’. This word is
posted by
Mat_Stephen
|
2 Comments
Filed Under:
High Availability and Disaster Recovery