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

Recency Frequency talk from last nights user group - the SQL to do the Recency/Frequency grouping on Adventureworks - examples of OVER and PARTITION BY, using CTE's, CROSS APPLY
SQLUG Events - London/Edinburgh/Cardiff/Reading - Masterclass, NoSQL, TSQL Gotcha's, Replication, BI, CEP
Event on SQL Server 2008 Disk IO and the new Complex Event Processing (StreamInsight) feature in R2 on 14th July, London
SQL Windowing screencast session for Cuppa Corner - rolling totals, data cleansing
London User Group Meetings this week (19th/20th May); 26th May-Agile Data Warehousing; 17th June-Kim Tripp/Paul Randal event; 22-24th June-3 Day Workshop Ramesh Meyyappan
Cuppa Corner talk "A trip to First Normal Form" available - Domains, Functional Dependencies, Repeating Groups and First Normal Form
This Wed, Reading - Service Broker, Indexing, Normalisation, Sets, RI and Locking, Surrogate Keys
Sets, Surrogates, Normalisation, Referential Integrity - the Theory with example Scaling considerations in SQL Server
Post SQL 2008 R2 Launch Thurs 15th London - UK SQL Server User Group is having a Social Event @ the Bull 6.30pm - 10pm.
Tuesday 6th Manchester SQL User Group - Chris Testa-O'Neil (Loading a datawarehouse using SSIS) and Tony Rogerson (Normalisation/Denormalisation, Locking and Indexing)
Edinburgh this Thurs (25th) - Rob Carrol talks about how to build a high performance, scalable reporting platform and the tuning techniques required
Relational Database pioneer Chris Date is giving a seminar 13th/14th May Edinburgh on "SQL and Relational Theory - How to Write Accurate SQL Code"
Database Design - Surrogate keys: Part 1 of many (Rules for Surrogate Keys, E. F. Codd and C J Date research and problems they solve)
What is Granularity?
2 Hours spent trying to get Visual Studio 2008 to Build my project off a server mapped drive in Windows 7
UK Tech-Days 2010 Registration is up there now - a day on SQL Server 2008 R2
UK SQL UG - Meetings in Cardiff, Edinburgh, Manchester, London - Online stuff; Social evenings starting - get involved!
How to create a One to One relationship in SQL Server using DRI, Triggers and Views
Dundee SQL User Group Meeting this Wed (20 Jan 10) - Tony Rogerson and Allan Mitchell
Removing blank line in SSMS (Management Studio) Find and Replace dialogue

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