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)
Dec
January 2005
Feb
S
M
T
W
T
F
S
26
27
28
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
31
1
2
3
4
5
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
January 2005 - Posts
Monday, January 31, 2005 3:26 PM
SQL Server Lock Escalation – Friend of Foe?
Sometimes I hear the comment that someone can’t get their application to scale above 50 – 100 users; above a certain number of users there is a sudden ceiling in scalability. So often I have found this to be a problem with nothing more than SQL
posted by
Mat_Stephen
|
3 Comments
Filed Under:
Performance
Wednesday, January 26, 2005 9:31 PM
SP I promised during TechNet Gig on SQL Performance which will identify blocking spid at top of blocking chain : sp_blocker_pss80
Please follow the link below to the MS KB article containing the above SP. Note the 'fast' parameter to improve performance by reducing the amount of extra diagnostic info returned. http://support.microsoft.com/default.aspx?scid=kb;en-us;271509 Hope
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Performance
,
Performance Top Tips
Tuesday, January 25, 2005 12:01 AM
CREATE proc track_waitstats & CREATE proc get_waitstats - useful code for diagnosing SQL 2000 performance
For those attending my TechNet SQL 2000 performance tuning session at TVP Reading on Tuesday 25th Jan, here is the code for the track_waitstats and get_waitstats stored procedures I refer to during the presentation. CREATE proc track_waitstats
posted by
Mat_Stephen
|
3 Comments
Filed Under:
Performance
,
Performance Top Tips
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
Wednesday, January 05, 2005 12:46 PM
Catch the SQL Server 2005 Express, it’s the future and it’s free!
We’ve all been waiting a long time for SQL Server 20005 and not everyone has been able to get the betas to get an early look. Well now anyone can get their hands on the beta 2 of SQL Server 2005 Express edition. The Express edition, what’s
posted by
Mat_Stephen
|
6 Comments
Filed Under:
SQL Server 2005
,
Free SQL Server Tools, Utilities and Addins
Monday, January 03, 2005 10:28 PM
Hitchhicker’s Guide to SQL Server Reporting Services author to present at IT Forum Highlights - Birmingham UK 13th Jan 05
Hitchhiker’s Guide to SQL Server Reporting Services is an excellent book in the Hitchhiker’s series of excellent books. The book is co written by Peter Blackburn (UK MVP) and William Vaughn (massive reputation). I think it is excellent for
posted by
Mat_Stephen
|
(Comments Off)
Filed Under:
Business Intelligence
,
Reporting Services