Happy New Year! I hope you’ve had a great week.
Is it just me or has it been super busy this week, both at work and in the SQL Community? Four day weeks are tough and I don’t know about you but I’m already thinking about booking a holiday :-) This week I was lucky enough to get my filthy hands on some FusionIO drives, and I’ve been putting them to work on some busy SSAS boxes.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Using Extended Events in SQL Server Denali CTP1 to Map out the TransactionLog SQL Trace Event EventSubClass Values – I was trolling the SQL Server MSDN forums earlier this week when an interesting question came up about how to monitor Transaction Log activity. It turns out SQL Server Profiler only provides the EventSubClass values and not the descriptions. Jonathan Kehayias blogged about how this information can be extrapolated using the power of Extended Events.
- TPC-E Benchmark Analysis by CPU Type – As a DBA I think it’s important to keep informed on the latest performance of CPU’s out there in the market. Glenn Berry highlights what’s hot right now for us all.
- Whats the problem with reporting ? – Sharing his thoughts on the matter, Simon Sabin. I have to say that I agree.
- Sharding With SQL Azure – Excellent post here from the SQL Azure Team Blog, showing us how we can leverage the power of the Cloud.
- Updated Blogger Rankings – Thom LaRock (@SQLRockstar) posts his prestigious Blogger rankings . If you’re new to the SQL community and your RSS Reader is looking a little empty, this is a great place to start to find a brilliant variety of SQL Server Bloggers to follow.
- Which Process ID is SQL Server running on? – Find out with Gethyn Ellis.
- Restore of Replicated Database fails – Another pearl of Replication Troubleshooting wisdom from the Microsoft SQL Server Replication Support Team. A lot of the time I have not seen these errors in the field myself, that’s why this posts are so great because now I know what to resolve the issue when I do.
- SQL Server Denali – Paging – A closer look at this new feature courtesy of Andrew Hogg.
- Hide SQL Server Instance on all versions – Here’s a nice tip courtesy of Pradeep Adiga.
- 2010 PASS Summit Interviews – Here’s a round-up of interviews of SQL Celebrities from the Pass Summit brought to you by MidnightDBA’s.
- SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos – The last batch of the SQL Server MCM Training videos have been available for all to enjoy.
- Most Popular SQL Server Events – Organised by Brad McGehee. I think that you will agree that the results make for some very interesting reading.
- All I Want is a Normal(ized) Life – More T-SQL wizardry from Brad Schulz.
- Tracking database recovery progress using information from DMV – Another tip courtesy of the Microsoft Customer Service and Support Team.
UK SQL Server Upcoming Events
There are a lot of new User Groups firing up (Southampton/Surrey) this year so be sure to keep your eyes peeled for events near you.
- SOUTHAMPTON – Wed Jan 19 – User group evening of Exploring SQL Server’s Architecture with Christian Bolton
- SURREY – Wed 19 Jan – Gavin Payne and chums cover contemporary technology topics for those using SQL Server in 2011.
- LEEDS – Wed 19 Jan – Chris Burns and the Resource Governor and Policy Based Management with Chris Testa-O’Neill
- MANCHESTER – Thu 20 Jan – User Group meeting with Tony Rogerson
- SQLBits 8 – 7th – 9th April – Europe’s biggest SQL Server event will be at he seaside this time around.
Provisional Dates for your Diary:
- MANCHESTER – Wed 2 Mar
- LEEDS – Thu 3 Mar
- LEEDS – Wed 11 May
- MANCHESTER – Thu 12 May
- MANCHESTER – Wed 15 Jun
- LEEDS – Thu 16 Jun
- LEEDS – Wed 20 Jul
- MANCHESTER – Thu 21 Jul
Misc Technology Posts
- Trouble In the House of Google
- US woman @theashes gives in to Twitter, flies to Sydney
- Thousands of stolen iTunes accounts for sale in China
- Global spam e-mail levels suddenly fall
That’s it for this week. What was your favourite post? If I’ve missed anything that you think deserves a mention then be sure to let me know! You can leave your comments below, send me an email and find me on Twitter(@JohnSansom).