Tony Rogerson's ramblings on SQL Server

Hopping mad frog wants to learn SQL Server

2009-06-26T10:32:00Z

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 :) http://www.youtube.com/watch?v=vrq_0woVynE Tony....(read more)

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

2009-06-19T11:59:00Z

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

2009-06-19T11:13:00Z

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 that SQL Server 2008 Standard edition doesn't have clustering - so, that got corrected with a link onto the MS website; now I'm told you need two licences for a SQL Server 2008 active/passive cluster - wrong again and here are the bits from...(read more)

My new word: Automatonmattic

2009-06-16T19:23:00Z

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

2009-06-10T12:03:00Z

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-using-MDX-Studio-to-its-best.aspx . The agenda... 6.15pm – 7:00pm Andrew Fryer, Microsoft SQL Server 2008 R2 and Gemini SQL Server 2008 R2 will be the release with Gemini in it. Gemini is about trying to marry self service BI for end users with proper...(read more)

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

2009-06-10T06:03:00Z

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 2009 as google will index this and the job position may filled quickly. UK folks only! Job Title - MS SQL DBA OLAP developer Position - Permanent Location - Bristol XXX is a leading distributor of digital media with clients throughout the world. We...(read more)

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

2009-06-04T06:04:00Z

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 before the meeting so you have time to download the LiveMeeting control. We are recording the LiveMeeting and it will be available next week. 4 Jun 2009 Integrating Data Mining into your BI Solution LIVE MEETING @ 7.30pm - 8pm Allan Mitchell, SQL...(read more)

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

2009-06-03T06:17:00Z

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/06/03/free-microsoft-press-ebook-offer-introducing-sql-server-2008.aspx...(read more)

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

2009-06-02T06:54:00Z

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 end-to-end as well as replaying Profiler files, if you've already registered then see you there - Martin Bell is your host for the evening. Thursday evening (7.30pm) Allan Mitchell SQL Server MVP is doing a Live Meeting ( http://sqlserverfaq...(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

2009-05-31T20:04:00Z

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-using-MDX-Studio-to-its-best.aspx Join us for another UK SQL Server User Group meeting. 5.30pm – 6:00 Registration and networking + Tea/Coffee with biscuits. Meet and greet. 6:00pm – 6:15pm Round Table discussion and Nuggets - ALL Take stock and get...(read more)

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

2009-05-28T15:11:00Z

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 covered the following: >> Common tools you need to use in deploying, using and managing SQL Server (Configuration Tools, Management Studio, Profiler and Perfmon) >> Simple querying SQL Server Installation Center Configuration Manager Manage...(read more)

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

2009-05-27T06:46:00Z

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.com?eid=175 ) on the product tools at an introduction level - ideal for anyone who needs to manage SQL Server but its not their main job (forward this on if you know someone like that). Three new bloggers are active on http://sqlblogcasts.com...(read more)

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

2009-05-12T13:13:00Z

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 weekly Thursday Live Meetings starting on the 28th May, even if the topics aren't immediately applicable come and join us anyway for the networking sessions - meet your peers perhaps get the gossip or get a question answered in our round table session...(read more)

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

2009-05-05T18:07:00Z

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-tips-on-SQL-and-using-it-and-Chris-TestaONeill-Monitoring-and-Controlling-Resources-in-SQL-Server.aspx We have control! Monitoring and Controlling Resources in SQL Server - Chris Testa-O'Neill Hints and Tips from 23 years of SQL - Tony Rogerson...(read more)

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

2009-05-05T17:45:00Z

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 Microsoft taking us through the features in the soon to be released windows 7 in-depth. http://sqlserverfaq.com/events/167/Sessions-on-Understanding-ADONET-Data-Services-Windows-7-features-indepth-and-the-usual-SQL-Nuggets-and-Networking.aspx These...(read more)