Thursday, 9 December 2010
Confessions of the User Group (dis)Organiser
Tuesday, 7 December 2010
Friday, 19 November 2010
SQL Southampton - SQL Server User Group in Southampton 8th December [Updated 24/11/2010]
Sunday, 24 October 2010
How to start a regional group and be part of the UK SQL Server User Community
Friday, 8 October 2010
SQLBits 8 Venues...
Thursday, 7 October 2010
Are you trying to tell me something...
Whoop!! Whoop!! Site Down!!!
Grrrrr....
Wednesday, 6 October 2010
Finding Non-SARGable queries
Tuesday, 5 October 2010
Gadget Show Top 5 Budget Mobile Phones
How to setup a MSSQL Server Management Studio (SSMS) 2008 New Query Template
But it works for SQL 2008 r2 - apart from changing the paths slightly.
%Install Dir%:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\SQLFile.sql
I cant work out why is there nothing on MSDN about this cool feature?
Or why is not part of the SQL templates.
References:
http://sqlsoundings.blogspot.com/2010/03/using-ssms-templates-for-fun-and-profit.html
http://msdn.microsoft.com/en-us/library/ms174169.aspx
http://stackoverflow.com/questions/593047/mssql-server-management-studio-ssms-2005-new-query-template
Sunday, 15 August 2010
Microsoft Certified IT Professional: Database Administrator 2008
I’ve now passed both Microsoft certification exams for the MCITP: Database Administrator 2008 :
- Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
- Exam 70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance
As preparation for the 70-432 exam I got the following books:
- MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation And Maintenance Book/CD Package (PRO-Certification)
- The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance
- SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450)
I read all the MCTS Self-Paced Training Kit and actually enjoyed it (as much as you can enjoy reading a technical book – but it wasn’t as painful as Gallbladder surgery!) – I have to agree with some of the comments on Amazon that there are a few mistakes, but who hasn’t released code/documentation that didn’t need a few tweaks after it was released?
I have to make a special mention of SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450)- it’s the only book I found that covers the 70-450 exam!!! In the appendix, there is a mapping of chapters to exam objectives so you only need to read the appropriate chapters.
After leaving the test centre having passing 70-432 with 960, I thought this exam felt much easier than the 70-433 exam.
I was (quickly) convinced (by my wife – Hello!) that I should just try and take the next exam straight away. The odd thing about the Microsoft exams is you only need to get 700 – it doesn’t matter how well you do, you still get the qualification in this case ‘just enough is good enough’ .
So, just a few days after passing 70-432, I took 70-451 and passed with 929.
I was surprised by how easy the MCITP: Database Administrator 2008 was compared with the MCITP: Database Developer 2008. There were (in total) 84 questions for the Database Administrator and 128 for the Database Developer – a big difference.
It’s not the number of questions, although the more questions, the more sweating you do. It’s the breadth of the content. There was so much to learn and remember. I think Brent Ozar conveyed it really well in his blog post: MCM Prep Week: Microsoft Exams 70-433 and 70-451There is only the MCITP: Business Intelligence Developer 2008 to go, then I’ll have the whole set! :-)
Friday, 9 July 2010
MCITP: Database Developer 2008
I started in Feb/March working through two books;
MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development Book/DVD Package and The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit: Database Design
The books cover a huge range of subjects; the MS press book covered more areas and was in some ways better but was also tedious at times - often sending me off for a good nights' kip! The Prep Kit was written in (my opinion) a nicer style for the user, but didn't cover nearly enough of the exam.
I read the Prep-Kit book first, took a practice exam and scored very low! I bought the MS Press book and found this filled-in the gaps and reinforced what I learnt from the first book. I found the different writing styles very useful as it didnt feel like I was reading the same book twice.
I took 70-433 and scored 1000.
There is no official exam prep for the 70-451 exam, so I took it 2 weeks after passing the first exam. The exam was tough, very tough! I thought I'd failed. When I clicked 'finish' I closed my eyes as I really thought I would have to tell everyone at work I'd failed.
But to my amazement, I passed with 865! I spent the next 4 hours in shock. I had a hospital appointment later that day and my resting heart rate was over 100 bpm!
Now for a little rest before I start on the MCITP: Database Administrator 2008!
Thursday, 8 July 2010
Website updates...
There aren't any (huge) increases in functionality. I'll just fixed problems that annoy me. :-)
Fixes;
New menu - I did the old one in a rush so it didn't really work very well.
Updated blog feed - I sorted out the problems with the formatting.
Twitter account - I created a twitter account (Apparently social networking is the next big thing!)
Friday, 12 February 2010
SQLBits (episode) VI - Westminster Strikes Back...
Check out the SQLBits.com website for more details.
Wednesday, 13 January 2010
Format T-SQL as HTML and more...
I've just added some new features to the T-SQL Tidy website.
Special thanks to Jean-Claude Manoli for the HTML formatting code website:http://www.manoli.net/csharpformat/