Tony Rogerson's ramblings on SQL Server

Hopping mad frog wants to learn SQL Server

tonyrogerson — Fri, 26 Jun 2009 10:32:00 GMT

I always like working at home with my patio door open, we had a really heavy rain shower and I got a visitor. Anyway, this video is one of the instances of me chasing him/her out of my office. So much for prepping for my LiveMeeting this afternoon :)...(read more)

Determining Backup or Restore Percent Complete in SQL Server 2008 and SQL Server 2005

tonyrogerson — Fri, 19 Jun 2009 11:59:00 GMT

If you want to see how far along your restore or backup is then you can do this... select percent_complete from sys . dm_exec_requests where session_id = 53 This is in addition to the STATS = n option on the BACKUP/RESTORE commands....(read more)

Licence "experts" - SQL 2008 Standard Clustering and the Active/Passive requirements

tonyrogerson — Fri, 19 Jun 2009 11:13:00 GMT

I'm migrating one of my clients from SQL Server 2000 to SQL Server 2008, they currently have an active/passive SQL Server 2000 cluster and we are going to keep the same architecture but on SQL Server 2008. The licence "expert" first states...(read more)

My new word: Automatonmattic

tonyrogerson — Tue, 16 Jun 2009 19:23:00 GMT

Pronounced: "Automaton-Mattick" Meaning: Used to descibe individuals using forums who persistently post canned answers without adjusting the said answers to take into account changes in the underlying topic or technology....(read more)

Tonight on LiveMeeting -> SQL 2008 R2 and Gemini; From Data Modelling to Information Architecture and Attribute Relationships, Aggregations and using MDX Studio to its best

tonyrogerson — Wed, 10 Jun 2009 12:03:00 GMT

We are broadcasting tonights UK SQL Server User Group meeting in Reading, for more information go to http://sqlserverfaq.com/events/168/SQL-2008-R2-and-Gemini-From-Data-Modelling-to-Information-Architecture-and-Attribute-Relationships-Aggregations-and...(read more)

Job in Bristol; MS SQL Server DBA OLAP developer - Permanent.

tonyrogerson — Wed, 10 Jun 2009 06:03:00 GMT

There is a job going in Bristol (see below), if you are interested and experienced enough for the role then please email me tonyrogerson@sqlserverfaq.com and I'll forward your details onto the agent - note; obviously - do so before the end of June...(read more)

UK SQL Server User Group - LiveMeeting tonight - Integrating Data Mining into your BI Solution

tonyrogerson — Thu, 04 Jun 2009 06:04:00 GMT

Don't forget tonight's online meeting presented by Allan Mitchell, SQL Server MVP. The LiveMeeting URL to join the meeting is: https://www.livemeeting.com/cc/mvp/join?id=JJRMN6&role=attend&pw=b%27q%2F-s8D8 ; please join at least 10 minutes...(read more)

Satya's good find - MS Press free ebook on "Introducing SQL Server 2008"

tonyrogerson — Wed, 03 Jun 2009 06:17:00 GMT

Good catch Satya! There is a new MS press ebook out on "Introducing SQL Server 2008", this is particularly apt as I'm doing a number of LiveMeetings targetted at introducing the product . http://sqlblogcasts.com/blogs/ssqanet/archive/2009...(read more)

UK SQL Server User Group - Weekly LiveMeetings sorted; Leeds Perf Troubleshooting tomorrow night + BI LiveMeeting Thursday

tonyrogerson — Tue, 02 Jun 2009 06:54:00 GMT

We have weekly LiveMeetings on every Thursday in June, plus a range of physical events, also don't forget tomorrow (Wed) is the Leeds user group meeting ( http://sqlserverfaq.com?eid=182 ) and they will be covering Performance Troubleshooting Techniques...(read more)

June 10th BI Event in Reading; SQL 2008 R2 & Gemini; Data Modelling to Info Architecture; Attribute Relationships, Aggregations & using MDX studio to its best

tonyrogerson — Sun, 31 May 2009 20:04:00 GMT

June 10th sees a cracking line up as the title above shows. For more information and to register: http://www.sqlserverfaq.com/events/168/SQL-2008-R2-and-Gemini-From-Data-Modelling-to-Information-Architecture-and-Attribute-Relationships-Aggregations-and...(read more)

LiveMeeting recording for my SQL Server Toolset intro (part 1) is now available

tonyrogerson — Thu, 28 May 2009 15:11:00 GMT

The first in my live meeting series was on SQL Server Basics - Part 1 : An introduction to the SQL Server toolset. The recording is available here: http://sqlserverfaq.com/livemeetings/sqlfaq_20090528_tonyrogerson_sqlserverbasics_tools.zip I pretty much...(read more)

SQL User Group - tonight is Edinburgh; tomorrow a Live Meeting on the SQL Server toolset

tonyrogerson — Wed, 27 May 2009 06:46:00 GMT

Don't forget tonight is the Edinburgh user group meeting ( http://sqlserverfaq.com?eid=174 , if you've already registered then see you there - Martin Bell is your host this evening. Tomorrow afternoon I'm doing a Live Meeting ( http://sqlserverfaq...(read more)

SQL User Group - ADO.NET + Windows 7 indepth tomorrow evening; Live Meetings starting soon, Edinburgh and Cambridge new event

tonyrogerson — Tue, 12 May 2009 13:13:00 GMT

Are you coming to Reading tomorrow - see you there! Tomorrow evening at Microsoft I've got Mike Taulty taking us through ADO.NET Data Services and James O'Neill and Viral Tarpara from Microsoft will do Windows 7 indepth. We've also got our...(read more)

This months event for the SQL User Group - Manchester this Thurs; Reading next Wednesday

tonyrogerson — Tue, 05 May 2009 18:07:00 GMT

Quick note on what's coming up this month in the user group physical meetings, if you want to come make sure you register asap so we know numbers. This Thurs: Manchester, Evening http://sqlserverfaq.com/events/172/Tony-Rogerson-23-years-of-hints-and...(read more)

Thurs 13th May - Reading; Understanding ADO.NET Data Services and Windows 7 features in-depth.

tonyrogerson — Tue, 05 May 2009 17:45:00 GMT

Come and join us for the evening of Wednesday the 13th May at TVP Reading where we have Mike Taulty from Microsoft presenting on "Understanding ADO.NET Data Services" and we have James O'Niell and Viral Tarpara both IT Pro Evangelists for...(read more)