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)
May
June 2006
Jul
S
M
T
W
T
F
S
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
1
2
3
4
5
6
7
8
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
T-SQL
(RSS)
Monday, September 12, 2005 10:27 PM
Getting to know SQL 2005 Service Broker
Looks likes I've got to do a presentation on Service Broker for the SQL 2005 launch - so I've been doing some home work on the subject. The best primer I've found is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp?frame=true this
posted by
Mat_Stephen
|
0 Comments
Filed Under:
Performance
,
SQL Server 2005
,
Webcasts
,
T-SQL
,
Architects Corner
,
Service Broker
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
,
High Availability and Disaster Recovery
,
Performance
,
SQL Server 2005
,
T-SQL
Wednesday, August 31, 2005 10:34 AM
SQL 2005 - UPSERT: In nature but not by name; but at last!
SQL Server has long been criticised for not having an UPSERT command, well now in SQL 2005 we have some good news, we have two new TSQL set operators that give us the complex insert/update logic that constitute an UPSERT. These are INTERSECT and
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Performance
,
SQL Server 2005
,
Performance Top Tips
,
T-SQL
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 2005
,
SQL Server 2000
,
T-SQL
Thursday, June 23, 2005 5:40 PM
Cool new OVER Clause (Transact-SQL) in SQL Server 2005
Cool new OVER Clause (Transact-SQL) in SQL Server 2005 to circumvent the not so efficient correlated subquery. Imagine a table: create table grades( StudentID int not null,StudentName varchar(10) not null,Subject varchar(10) not null,Score
posted by
Mat_Stephen
|
1 Comments
Filed Under:
Performance
,
SQL Server 2005
,
T-SQL