Project number 3 at Principality
Purple Frog Systems welcome the opportunity to undertake a third project for Principality Building Society. At Purple Frog Systems we pride ourselves on building long term relationships with our clients, and Principality are no exception. Having designed and built a business intelligence infrastructure with a focus on finance, treasury and FSA regulatory requirements, we'll now be concentrating on internal analytics and sales tracking.
Principality are a great client to work with; the diversity of their business combined with their willingness to adopt the latest available technology results in interesting, challenging and rewarding projects, we're sure this new project will be no different.
New Purple Frog website goes live
Today marks the launch of the new and improved Purple Frog Systems website. We've upgraded both the website and blog backend systems to provide more content flexibility and to allow for further growth and bandwidth capacity. We hope you like the new look.
Our services section is not only intended to explain what we do as a company, but also as a business intelligence reference guide. If you're learning about business intelligence and want to know what it is and how it all works, please have a look. if there's anything that you think needs enhancing or new content adding then please let us know. We're always looking to expand it further, and now the new website platform will provide a greater ability to do it.
The Frog-Blog is a way of feeding back into the SQL Server Business Intelligence community. All of us at Purple Frog Systems have benefited greatly over the years from people putting the time and effort into blogs and user groups, and feel that they are a vital part of the community, which we’re proud to be a part of. If you have a topic or problem that you'd like us to address on the blog, feel free to get in touch using the contact us page.
Midlands SQL Server User Group
Purple Frog, in association with www.SQLServerFAQ.com, have launched the Midlands SQL Server User Group.
The SQL Server user group community is growing at a pace, with new user groups being set up across the UK. It provides an ideal way for database professionals to keep up to date with the latest tools and techniques, as well as network with peers over pizza and a beer or three. It's suitable for all, from those that are just SQL-curious through to the seasoned DBA and Business Intelligence guru.
The user group network has a vast array of expert members to draw speakers from, and can always be relied upon to educate, inform and of course enter tain.
Alex Whittles, lead consultant at Purple Frog, has presented numerous Business Intelligence sessions at user groups before, and identified the lack of any user group activity in the Midlands. Being based in Telford, Purple Frog is ideally located to head up the creation of the new group which will be based in Birmingham.
We're planning to put on one DBA focused session and one BI session, so there should be something for everyone.
It'll be free to attend, and we'll put on some food as well.
SQL Bits 8 Registration Open
SQL Bits 8 will be held in Brighton from Thursday 7th April to Saturday 9th April 2011, and will be in The Brighton Grand Hotel.
- Day 1 - 7th April - Pre-Conference Training Day - Choose from one of eight Full day seminars by SQL Server experts on a wide range of aspects of SQL Server.
- Day 2 - 8th April - 20-25 sessions throughout the day spread over 5 rooms covering all aspects of SQL Server
- Day 3 - 9th April - 20-25 sessions delivered by the UK SQL Server community and this day is FREE
Whether you're a SQL Server guru, or just SQL-Curious, there are sessions for all levels, interests and abilities. The Purple Frog team will be there, focusing on the Business Intelligence track. Our lead consultant, Alex Whittles, may even be presenting a Purple Frog session! He needs your votes so head to the SQL Bits website now and vote for him! Hope to see you there.
Purple Frog Seminar at SQLBits
Purple Frog have been asked to deliver a seminar at Europe's largest SQL Server conference, SQLBits.
Alex Whittles will be presenting a demonstration using SQL Server Reporting Services (SSRS) to create automated dynamic documentation of SQL Server Analysis Services (SSAS) cubes. Using SQL Server 2008 R2, this will utilise Dynamic Management Views (DMV) and spatial data to automate items such as the Kimball BUS Matrix and star schema diagrams.
The 8th SQLBits conference will be held in Brighton at The Brighton Grand Hotel between Thursday 7th April and Saturday 9th April 2011.
SQLBits has grown to be the leading SQL Server conference in Europe, and is a highly recommended resource for all members of the Microsoft SQL community, whether you're a pro or beginner, DBA or Business Intelligence focused.
Places are running out fast, so book your place at www.SQLBits.com
SQLBits Session Summary
This weekend saw the eighth SQLBits conference take place in Brighton. Alex Whittles from Purple Frog presented two technical sessions at the conference, one on using DMVs and spatial data to visualise star schemas and the BUS matrix to automate OLAP cube documentation, and one for a bit of fun, drawing pictures using SQL Server spatial queries.
The sessions were recorded so should be available to watch in the near future, in the meantime here's a quick two minute summary of each session.
OLAP Cube documentation using DMVs and spatial data
Drawing pictures with SQL Server spatial data
New contract with Investment Bank
Purple Frog Systems are proud to announce that we've won a new contract with one of the World's leading investment banks.
Purple Frog will be designing the architecture and data model for a new data warehouse providing real time analysis and reporting capability across OTC derivatives.
We're delighted to have been awarded this contract, and look forward to working with such a prestigious client.
Purple Frog Booked for Talks
The Purple Frog team have a busy few months ahead in the SQL Server Community, presenting talks at a number of SQL Server groups around the country including Southampton, London, Bristol and Exeter.
We've also got another event coming up in Birmingham, which Purple Frog runs and sponsors.
The SQLBits team have also announced the next SQLBits conference, being held in Liverpool between 29th September and 1st October 2011. If you're involved with SQL Server in any way, OLTP transactional programming, DBA or Data Warehousing, it's the must attend event. Our lead consultant, Alex, has submitted a couple of talks which we hope will get selected!
You can find out more details of all of our upcoming talks on our SQL Server Community Events page
Selected to speak at SQLBits 9
We are absolutely thrilled that we've been asked to speak at the next SQLBits conference, in Liverpool on 1st October 2011.
Alex Whittles will be presenting an introduction to PowerPivot and QlikView, showing how to get started with these in-memory analytical tools, how they differ and what their pros and cons are.
This will be Alex's second SQLBits conference that he's presented at.
SQLBits is the largest, and generally believed to be the best, SQL Server conference in Europe. It's only beaten in size by PASS in the US, and welcomes the best speakers from around the World. It's a three day conference that's held every 6 months, covering all aspects of SQL Server from Dev to DBA and Business Intelligence. Sessions run from level 100 for the novice to level 400 for the experienced professional; you can choose your own track to cover any level of any topic that suits you.
It's not just a place to learn new skills, it's also a fantastic forum to network with like minded people, share a beer and generally bring some fun to the database world - if you've not been before then we highly recommend it.
Places are booking up fast, so register for your SQLBits place here.
Purple Frog is delighted to adopt the words 'Purple' and 'Frog' at AdoptAWord.com.
At Purple Frog our goal is to help companies and organisations understand their data and information. We often take the essential basics of comminication for granted in our quest for ever more advanced IT systems. 'I CAN' provide children with communication difficulties advice and support to help them overcome these difficulties.
This Christmas, why not adopt a word of your own, and help I CAN help a kid in the process?
Martin is now a Microsoft Certified Master
The MCM certification is one of the most demanding of all certifications, and requires an exceptionally high level of knowledge and ability in the subject area. With exams as well as a grueling hands-on lab assessment, it ensures the candidate has a mix of both a deep theoretical knowledge as well as the practical ability to implement it.
Martin is only the 7th person in the UK to achieve this certification, and only the 4th who doesn't work for Microsoft.
We are obviously very proud of this achievement, and congratulate Martin on this very impressive award, as well as his hard work to achieve it.
You can find out more about the Microsoft Certified Master program here.