tonyrogerson@torver.net

 office: 01582 346 161

Tony Rogerson, SQL Server MVP
SQL Server Specialist

Resume of Tony Rogerson

Tony began his long IT career in July 86, completed an apprenticeship as a Production Systems Analyst in April 90, he has used many languages and products throughout that career the main ones being IDEF-0, Application System, PL/1, CICS, DB2, System W, Oracle, SQL Server, Visual Basic, Visual Basic .NET and C++.

He has worked in many industries including Finance, Retail, Web and Engineering and provided consultancy to hundreds of companies.

Tony currently works as a freelance SQL Server specialist providing consultancy, offsite project development and training/mentoring as well as proving a big presence within the UK SQL Server community through the user group he runs and his technical blog.

Tony knows most of the worlds SQL Server specialists and also has access to a very large pool of other product experts such as .NET.

Recent Entries on Tony's Blog

UK SQL Server (SQL Relay 2012) - 5 cities of full day content 21st May - 30th May - Overview and Deepdive - It's free too
Cost Comparison Hard Disk Drive to Solid State Drive on Price per Gigabyte - dispelling a myth!
The enterprise vendor con - connecting SSD's using SATA 2 (3Gbits) thus limiting there performance
Reporting Brick - Reducing the cost of performing Business Intelligence with Commodity Hardware
You do not need a separate SQL Server license for a Standby or Passive server - this Microsoft White Paper explains all
Cost justification for buying a 32GB superfast Alienware M18x with a price tag of around £5K ($10K)
First annual SQLRelay annouced for 3rd - 6th October, visit one of over 13 regional UK based SQL user groups
Discovery - when your IO Subsystem out performs processor Cores - how parallelisation really is our friend
Use GUID’s (uniqueidentifier) for keys when storing data on SSD’s (Part 3 - Initial Base line with IOMeter and First Test Group)
Use GUID’s (uniqueidentifier) for keys when storing data on SSD’s (Part 2 - Initial Database Schema)
Use GUID’s (uniqueidentifier) for keys when storing data on SSD’s (Part 1 - SSD Backgrounder)
VB.Net / VB6 Developer wanted for one of my clients - Weybridge
Impressions of my ASUS eee slate EP121 - Dual core 4GB, 64GB SSD
Deck from London UG 20110616 - Building a Reporting Brick capable of 1.2GBytes/sec and 80K IOs/sec for less than £2K
UK SQL Server User Group Events coming up May/June 2011
Considering Data Access Patterns when Determining Server Resource Requirements
SQL User Group Events coming - Cambridge, Leeds, Manchester and Edinburgh
NoSQL developer (and of course database professional) day - University of Dundee, Sat 20th Nov
Code from talk on Hierarchies at Edinburgh UG 2010-10-07
Slides and Code from SQLBits Recency Frequency talk by Tony Rogerson and Alison Coughtrie

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