{"id":728,"date":"2007-10-13T21:39:03","date_gmt":"2007-10-13T20:39:03","guid":{"rendered":"http:\/\/www.craigmurphy.com\/blog\/?p=728"},"modified":"2007-10-29T01:46:13","modified_gmt":"2007-10-29T00:46:13","slug":"sqlbits-post-event","status":"publish","type":"post","link":"http:\/\/www.craigmurphy.com\/blog\/?p=728","title":{"rendered":"SQLBits – post-event"},"content":{"rendered":"


\nSQLBits, the sponsors: Microsoft<\/a> | Idera<\/a>
\nQuest Software<\/a> | Solid Quality Learning<\/a> | redgate<\/a><\/p>\n

I attended the first DDD-style SQL conference held in Reading last Saturday: SQLBits<\/a><\/strong>. It was an excellent event, well organised and very slick. Some really nice touches too, like coaches from Reading railway station to the venue at Microsoft’s Thames Valley Park campus (it was held on a Saturday, so the free bus wasn’t running). And there was a super bowling event laid on as part of the after-event entertainment!<\/p>\n

I was given the job of room monitor, which isn’t an onerous job, but one that is very much required. Speakers often need somebody to remind them that they have to wrap up, sometimes they need a 15 min, 10 min or 5 min warning as their session reaches its conclusion. Anyway, I was able to sit in on some interesting sessions, those noted below. I did jump between sessions in the other slots – I was also podcasting too, so didn’t sit in on other sessions in the entirety. Here’s the first podcast: 029 – SQLBits – Richard Fennell on SQL Server Unit Testing<\/a><\/p>\n

I was amused when Sutha said words to the effect “everybody hates writing documentation, right?” I couldn’t resist replying with “speak for yourself!” – it got a good laugh in the room. Of course, everybody really does <\/em>hate writing documentation!<\/p>\n

Handling early arriving facts 200 BI
\nSutha Thiru<\/a>
\nHow do we handle early arriving facts? If you are an experienced DW developer you would have come across this many times, if you are a novice you are certain to face this challenge in the near future. Each organisation makes decision to handle this scenario as suited to them. I have handled this scenario in one of these 3 categories. 1. Ignore early arriving facts all together? Is that the right way to do it? 2. During load process populate the dimension table with the Natural Key and default values and map surrogate key to the incoming fact record. 3. During fact load map default surrogate key and load those records into the \u201cRejected\u201d table. I would be conducting a demo for point 2 and 3. In depth analysis on what happens to the records in the Rejected table and what do I propose to resolve these records? What is Business Intelligence Service Centre (BISC) and their involvement is going to mission critical for the success of your BI project? <\/p><\/blockquote>\n

Getting Started with SQL Server Reporting Services 200 BI
\nTim Leung <\/a>
\nSQL Server Reporting Services provides a powerful mechanism for generating reports. This session provides an introduction to the many features and capabilities of Reporting services. Topics covered will include installation, managing reports and security. The session will also show you how to author reports using the Business Intelligence studio. Highlights include using Stored Procedures as data sources, passing parameters into reports and running conditional logic inside reports. Tips and tricks are included throughout the session to help you on your way. <\/p><\/blockquote>\n

Daves Top 10 SQL Keywords 200 DBA
\nDave McMahon <\/a>
\n\u2018Top of the Pops\u2019 might be dead, but Dave will give you his own countdown of his 10 most useful\/favorite SQL keywords. No secrets to giveaway here, suffice to say that you will know some of them (but maybe not used this way) and some may be unfamiliar to you. The whole \u2018Countdown\u2019 will be demoed and Dave will explain why they make his top 10. This is a session for people who use SQL regularly as Developers, know the standard DML but maybe never had the chance to peek around the corner to see what else was there! Both SQL 2000 and SQL 2005 syntax will feature, so this is stuff you can take away and use today …\n<\/p><\/blockquote>\n

Catch the end of Dave’s “Top of the Tops” styled session over here<\/a>.<\/p>\n

Related Podcasts<\/strong>035 – SQLBits – Simon Harriyott – On SQLBits and Dave McMahon in a wig\u2026<\/a>
\n034 – SQLBits – Liam Westley, Matt Barrett discuss SQLBits and Dave McMahon <\/a>
\n033 – SQLBits – Colin Mackay on SQLBits and events in Reading <\/a>
\n032 – SQLBits – Martin Cairney on Securing SQL Server <\/a>
\n031 – SQLBits – John Van Hoof <\/a>
\n030 – SQLBits – Attendees Jane Dallaway and Jim Shilling tell us what they think <\/a>
\n029 – SQLBits – Richard Fennell on SQL Server Unit Testing<\/a><\/p>\n


\nDave McMahon, podcasting<\/p>\n


\nRecursive photography?<\/p>\n


\nDave’s pre-session nerves are showing now<\/p>\n


\nThank you Solid Quality Mentoring for the sustenance<\/p>\n


\nHey, Rich, look, it’s an XBOX 360<\/a> – you should’ve come along and tried to win it! One lucky person won this, meaning that Quest Software went home with less than they arrived with.<\/p>\n


\nFernando (blog<\/a> and blog<\/a>) and Helen on the Solid Quality Mentoring stand<\/p>\n


\nThe boys from Idera had “iPods” as prizes!<\/p>\n


\nAnother full session<\/p>\n


\nSuper Simon Sabin struts his stuff (here’s Idera’s Super Simon<\/a>)<\/p>\n


\nUh oh. Quiche. Developers. The two don’t work. For real: look here<\/a>, here<\/a> and here<\/a>.<\/p>\n


\nDave tells us who he is to a packed room<\/p>\n


\nMartin Cairney: can bowl.<\/p>\n


\nI so nearly won with 140. Liam<\/a> came back from 127 to win with 142.<\/p>\n

Technorati Tags: SQLBits<\/a>, Quiche<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

SQLBits, the sponsors: Microsoft | Idera Quest Software | Solid Quality Learning | redgate I attended the first DDD-style SQL conference held in Reading last Saturday: SQLBits. It was an excellent event, well organised and very slick. Some really nice touches too, like coaches from Reading railway station to the venue at Microsoft’s Thames Valley … Continue reading SQLBits – post-event<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,16,36],"tags":[],"class_list":["post-728","post","type-post","status-publish","format-standard","hentry","category-community","category-developer-events","category-sqlbits-102007"],"_links":{"self":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=728"}],"version-history":[{"count":0,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/728\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=728"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}