Tag Archive: SQLBits

  • SQLBits 2024: Learning about people at a technical event

    SQLBits 2024 Learning about people at a technical event

    It has been a hot minute since I attended a SQLBits conference. It’s a techie event! I’m not technical. Project Managers must surely be classed as ‘persona non-grata’. Last year the team went, and I took a holiday. All those people in one place and guess which one of us came back with Covid? Typical. So, this year, trying to reduce my chances of a fourth bout, and with more ‘non-technical’ sessions available at the conference, it…

    » Read more
  • Behind the Scenes: My Perspective as a Speaker at SQLBits

    Behind the Scenes My Perspective as a Speaker at SQLBits

    SQLBits, the renowned conference for data professionals, brought together a diverse range of speakers this year, including four from Purple Frog Systems: myself, Lewis, Hollie, and Alex. Each of us tackled a variety of sessions, contributing our unique perspectives to the event. I spoke on two topics, both in the non-technical category about blogging and why it’s important to be creative in technical roles. First-time speaker nerves……

    » Read more
  • Introducing our SQLBits 2024 sessions…

    SQLBits 2024, the world’s largest data platform conference, is just around the corner held in Farnborough, London at the end of March, and the anticipation is building as the Purple Frog Team gears up to deliver a lineup of insightful and innovative sessions. Last month, the team received confirmation on their submitted sessions, and the offerings are nothing short of intriguing. Whether you’ll be joining in person at Farnborough or…

    » Read more
  • Why you should start presenting at conferences

    Have you presented a session at a user group or a conference? No? then read on to find out why you need to change that. Many of the readers of this blog will be active members of the SQL Server community, reading/writing blogs themselves, going to conferences or user groups, partitipating in webinars, etc. We’re fortunate in the UK to have the most active SQL Server community in the World. Yes there are physically more user groups and…

    » Read more
  • SQLBits X Video available

    SQLBits X Video Now available The video of my talk at SQLBits X is now available on the SQLBits website here. The talk was focused on presenting the results of my MSc Business Intelligence dissertation, comparing the performance of different methods of using SSIS to load data warehouse dimensions, specifically type 2 SCDs. The talk also covers a comparison of the performance between traditional hard disks and solid state storage systems such as…

    » Read more
  • SQL Relay Agenda Announced

    SQL Relay: Free, Full Day SQL Server Events If you’ve not heard the news yet, then where have you been hiding?! With SQLBits X such a phenomenal success, but already a distant memory, we’re all looking for the next SQL Server community event to learn, network and enjoy. The 2012 SQL Relay, following on from the great inaugural events last year, have now been announced and registration is open. Where are they? Monday 21st May –…

    » Read more
  • Automating T-SQL Merge to load Dimensions (SCD)

    This is the 3rd post in the Frog-Blog series on the awesomeness of T-SQL Merge. Post 1: Introduction to T-SQL merge basics Post 2: Using T-SQL merge to load data warehouse dimensions In this post we’ll be looking at how we can automate the creation of the merge statement to reduce development time and improve reliability and flexibility of the ETL process. I discussed this in the 2nd half of a talk I gave at the UK technical launch of SQL…

    » Read more
  • SQLBits X talk – Loading Data Warehouse Dimensions

    I’m thrilled to have been asked to present another session at SQLBits X, especially so as it’s set to be the biggest and best Bits yet. It’s the official UK launch of SQL Server 2012, and as such there’s an impressive collection of Microsoft folk attending and presenting, alongside the MVPs and internationally renowned speakers that we now come to expect at SQL Bits. The Saturday is now sold out, but (as of writing this)…

    » Read more
  • PowerPivot Vs QlikView 101 – SQLBits Video

    PowerPivot Vs QlikView 101 – SQLBits Video The video is now available from my PowerPivot and QlikView talk at SQLBits 9 in Liverpool in September 2011. You can download or watch the video here. In this 1 hour session I create interactive dashboards from scratch in both PowerPivot and QlikView, showing how to set up the data model, overcome common pitfalls and build the dashboards. I create almost identical dashboards in both systems and…

    » Read more
  • SQLBits 9 Session – PowerPivot and QlikView 101

    Thank you to the SQLBits committee, speakers, helpers and attendees, for making SQLBits 9 one of the best yet. What a great example SQLBits is of the power of the SQL Server community coming together to help each other, and enjoy a few beers in the process! I was delighted to have my “PowerPivot & QlikView 101” session chosen by the committee, which I presented on Saturday afternoon. Thank you to all those who attended, great to…

    » Read more