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

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
Tonights London UG meeting - starts at 5.30pm; 6 sessions of content from 15 mins - 45 mins
Taking advantage of Table Variables NOT being transactional - application logging files within a transaction and keeping what's happened
This Thurs - London SQL UG, also Edinburgh SQL UG
SQL 2008 SP1 CU5 is now out and fixes the OPTION(RECOMPILE) Parameter Embedding Optimisation problem - properly!
SQL Server Virtualisation - Licencing, Management, Performance and Support
London UG this Thurs (29th Oct) on BI - Deploying SSRS Reports using MSBuild, WhereScape and BI 2.0 - I'm searching give me a minute.
SQL Server 2005 Support - Performance Dashboard using Management Studio Custom Reports - the download
Detecting changed rows in a trigger using HashBytes and without EVENTDATA and OR's
Database Mirroring - a very good KB artile (things to consider when setting up database mirroring)
Another row concatenation example
Deck and scripts from Cardiff 8th Oct 2009 - Business Continuity Discussion
User Group: Cardiff and Edinburgh this Thurs (2009-10-08)
Dundee University are doing a MSc in Business Intelligence covering Relational, Dimensional database design, ETL, MDX, Designing BI systems...
SQL Server MVP again - I've received the 2009 Microsoft MVP Award for SQL Server.
References + Deck + SQL Samples from my System Management presentation on 20090929 @ MS Data Management Conference in London
My Systems Management session (20090929 in London) - Management Data Warehouse (Data Collector), Powershell, SQLCmd, Event Notifications and Extended Events, Policy Based Management
Operations Manager on Windows 2008 Active Directory Machine - Discovery Failed

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