tonyrogerson@torver.net

 office: 01582 346 161

Tony Rogerson, SQL Server MVP
SQL Server Specialist

Tony has over 20 years industrial experience gained through his work within the IT industry. He is a highly respected and leading figure in the UK SQL Server Community recognised through his work as founder and chairman of the highly successful UK SQL Server User Group and for participation as an Expert at Microsoft events (Ask The Experts and presentation) and finally as part of his contribution as a SQL Server MVP for which he has been awarded yearly since 1998.

Tony is trusted amongst his broad client base from enterprise to university research fellow, a selection of his clients include Redburn Partners, Renault F1, Quartix, Cardinus, Photobox, XMA and Bank of America.

He provides support, development, stand-in DBA resource, migration assistance, troubleshooting, business intelligence and training, basically anything SQL Server centric, he can work remotely using extensive resources at his office and hosting facility or on-site.

Recent Entries on Tony's Blog

Common Table Expressions (CTE's) - How it works; How Recursion Works; Using with Adjacency List
Using the OUTPUT clause on INSERT when loading data using OPENROWSET and BULK operator
UK MS Premier Customer? - Premier Field Engineering are hosting an Operations Day for SQL 2008
MSTSC - No more /Console
London Event 13-16 May: Insight from Kimball University: Microsoft Data Warehouse in Depth
Rude easter egg in SQL 2005 - Uniqueidentifier gives the F0FF
Send Table or View as embedded HTML in an email – stored procedure
Taking stock on the success of SQLBlogCasts.com
Database taste challenge - SQL Server 2005 v Oracle 11g.
Rampant Frogs Run Riot in Tony's pond
sp_send_dbmail in a transaction with @query causes unresolvable deadlock
SQLBits - My Session - Making the Leap into Advanced T-SQL
SQLBits II - Some thoughts from last Sat
Rafal Lukawiecki - Data Mining and Business Intelligence - London, 3rd April - all day event
The Windows 2008, VS 2008 and SQL 2008 UK launch 27th Feb London
UK SQL Server User Group - Meeting Dates for London and Reading (TVP)
Podcasts - some useful and insightful stuff going on at NxtGenUG
UDF's in Derived Tables - they really are executed multiple times, well in 2000!
UK User Group Meetings Started Again - London, 21st February and then alternating 3rd Thursday (Reading / London)
Using a UDF in a CHECK constraint to check validity of History Windows (Start - End Date Windows)

Recent Articles from Tony

Upgrading to SQL Server 2005 - Video presentation
The new features of SQL Server 2005 are well worth the upgrade effort, but how do you upgrade your e....
FOR XML basics, CLR basics, Web Service - presented at PASS Europe - 2006-02-23T13:00:00
These are the examples including slides for the event I presented at on 23 Feb 2006; I go through ba....
SQL Server 2005 - Optimistic Concurrency
Supporting slides for webcast on optimistic concurrency, look at row versioning, ALLOW_SNAPSHOT_ISOL....
SQL Server 2005 Optimistic Concurrency - Examples
Examples of how to use READ_COMMITTED_SNAPSHOT, ALLOW_SNAPSHOT_ISOLATION and a talk about row versio....
Simply Fed! Develop a simple data feed from a third party database
This article shows a simple approach to creating an effective platform for providing reporting and a....
Fragmentation - NTFS Volumes and SQL Server (PPT)
RAID (PPT)
Cursors