24 November 2009 12:57
tonyrogerson
This Thurs - London SQL UG, also Edinburgh SQL UG
We are also starting our LiveLock discussions, ever watched Argumental? Well, same principal - we have a specific topic, the first one will be "Every table must have a clustered index" and we have a group who argue for and group against, we summarise by pulling it back to a best practice advice to end the stalemate - should be fun!
If you don't want these email blasts then just reply to me with the word remove on the subject.
To register please visit http://sqlserverfaq.com?eid=193.Make sure you reserve your place sooner because this session will be popular.Come and socialise and learn from your peers; these physical meetings are great places to expand your network, get answers and find out how other people are using SQL Server and what is going on. This is the last meeting this year for London and for those who can we should do drinks after the meeting to continue the SQL chat in an even more informal environment.If you want to twitter please make sure you use the tag #uksqlug so it is shown on the site.Agenda
17:30 - 18:00 Meet & Greet
Meet up and socialise with your friends, meet new people, find out what other people are doing with SQL Server.
18:00 - 18:15 Round Table discussion and Nuggets
Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have - perhaps a work problem, general guidance etc..
18:15 - 18:30 LiveLock: Every table should have a Clustered IndexTwo sides of the audience, one will argue FOR the statement and one will argue AGAINST.18:30 - 18:45 Dave Ballantyne SQL Nugget from his blog posts...http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/09/08/bug-use-of-ranking-functions-result-in-an-inefficient-query-plan.aspxhttp://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/10/15/udf-overhead-a-simple-example.aspx
( with an offshoot to http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/11/24/the-observer-effect-in-action.aspx)
18:45 - 19:15 SQL Server Internals for the Beginner
Tony Rogerson, SQL Server MVPTony will cover SQL Server memory, Database Structure (how they are composed) including why the transaction log is so important and how to fix the amount of space it uses if it grows too big, we will also cover some best practice for instance maintanence plans and finally we will cover Index internals and fragmentation and what causes it.
This really will be from beginners in, but don't be put off - I will try and go as deep as people want and time permits.Its a good open session so if you want anything specific covering then let me know in advance.19:15 - 19:35 Break with Pizza
19:35 - 20:15 TBC
To be confirmed shortly20:15 - 21:00 Microsoft Business Intelligence Project Boosters
Siddharth Mehta
BIDS and SSMS are not always sufficient for any MS BI Project. Right from the documentation that might be required just for compliance to tools that are able to fill up the gaps that SSMS or BIDS leave behind, a lot of accessories are required for a project for a leveraged development and delivery.
MS BI Project Booster is a kind of kit that consists of a collection of tool & utilities (freewares) and douments and/or documenting methods, that is good to have installed or available in advance, that can help any MS BI Team to tackle issues or cater requirements in a speedier manner at various stages of a project development life cycle. It's a resource kit, and can be used at various stages of the project and by the use of the same, I believe that a project can have the benefit of an Agile BI Development from an implementation perspective.My Blog: http://siddhumehta.blogspot.com
About me: http://beyondrelational.com/blogs/siddharthmehta/about.aspx
Many thanks
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com
http://sqlblogcasts.com/blogs/tonyrogerson