I’m super excited that two of my sessions have been selected for SqlBits (http://sqlbits.com/) on the 29th –31st March, 2012. SqlBits is all lined up to be the largest SQL event in Europe this year!
If you go to only one SQL event this year, this is the one. Now if you go to two events you must of course come to our very own first ever Sql Saturday which is also the Irish Technical launch for SQL 2012. its on the 23rd march and is free http://www.sqlsaturday.com/105/eventhome.aspx
here are my two sessions.
Load Testing Analysis Services (Friday 30th March)
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
This session focuses on tools and methodology to load test Analysis Services in highly concurrent environments. Including how to locate resource bottlenecks and the appropriate configuration settings that can help improve performance.
Sample source code will be supplied to help you load test analysis services. We will be focused on the MOLAP engine, but techniques are equally applicable to the new tabular data model available in BISM.
SQL 2012 Always On-Deep Dive (Sat 31st March)
Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.
During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery.
This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.
This session scored really highly in the last SQL Bits so I hope to improve the scores this time.