Organiser

Tony Rogerson, SQL Server MVP

my blog |  hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Thu Nov 26, 2009 in LONDON

SQL Server internals and best practice for Absolute Beginners (Tony Rogerson); Nuggest from Dave Ballantyne on Ranking, UDF's; MS Business Intelligence Project Boosters (Siddharth Mehta) - an Introduction to the Power of Policies (Martin Cairney), BakBone product demonstration and the first LiveLock Discussion

LiveMeeting Attendee URL This event is not available via LiveMeeting
Time Starts (UK time) at 18:00 , Finishes 21:00
Cost Free
Organiser UK SQL Server User Group
Address Microsoft London, Cardinal Place, 100 Victoria Street, London, SW1E 5JL
Directions to Event
Tags Internals for Beginners; Indexing; Database Structure; File Groups

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:00 - 17:30 Meet & Greet

Meet up and socialise with your friends, meet new people, find out what other people are doing with SQL Server.

17:30 - 17:45 Round Table Discussion - Q & A from and to the audience


Bring your SQL problems and hopefully somebody within the room will be able to fix or advise you. There is always a wealth of experienced people at the user group meetings.

17:45 - 18:00 LiveLock: Every table should have a Clustered Index


Two sides of the audience, one will argue FOR the statement and one will argue AGAINST.


18:00 - 18:15 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.aspx

http://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:15 - 19:00 Introduction to the Power of Policies
Martin Cairney Right Join Consultants Ltd

A demonstration of the power of Central management Servers and Policy Based Management and how it can easily be used to validate your earlier versions of SQL Server.   We'll cover the different ways to evaluate a policy against single instances or groups of instances and the integration with Management Studio.  We'll also identify how this can be extended into an automated process.


19:00 - 19:20 Break with Pizza

19:20 - 19:50 BakBone Product Demonstration

BakBone’s integrated framework of solutions embraces the concepts of data protection, data availability and data retention into a model that is flexible, cost-effective, and easy to integrate. This unique approach creates a comprehensive suite of heterogeneous data protection technologies that are seamlessly managed from a single centralised console.

19:50 - 20:35 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

20:35 - 21:00 SQL Server Internals for the Beginner
Tony Rogerson, SQL Server MVP

Tony 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.

Coming Events RSS

Thu, 5 Aug in 7 days
MANCHESTER
Evening Meeting (18 registered)
Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008 Reporting Services R2 with Chris Testa-O'Neill
Wed, 18 Aug in 20 days
MAIDSTONE
Evening Meeting
Kent User Group - Complex Event Processing (Allan Mitchell), Replication (Neil Hambly)
Wed, 15 Sep in 48 days
LEEDS
Evening Meeting (9 registered)
Using XML data in SQL Server with Anthony Brown, and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
Thu, 16 Sep in 49 days
MANCHESTER
Evening Meeting (7 registered)
User group evening with Tony Rogerson, Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown
Thu, 23 Sep in 56 days
CARDIFF
Evening Meeting (6 registered)
Chris Testa O'Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products **Keep Checking back for further updates**
Thu, 30 Sep in 63 days
YORK
Multi Day Seminar
SQLBits 7: The Seven Wonders of SQL - September 30th to October 2nd
Thu, 7 Oct in 70 days
EDINBURGH
Evening Meeting (4 registered)
SQL Server User Group
Wed, 27 Oct in 90 days
LEEDS
Evening Meeting (3 registered)
User group evening with Allan Mitchell and SQL Server and Virtualisation with Mike Kiersey
Thu, 28 Oct in 91 days
MANCHESTER
Evening Meeting (7 registered)
SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008
Wed, 8 Dec in 132 days
LEEDS
Evening Meeting (3 registered)
User group evening with Tony Rogerson and Neil Hambly explores indexed views and computed columns
Thu, 9 Dec in 133 days
MANCHESTER
Evening Meeting (6 registered)
User group evening - Agenda to be confirmed
Wed, 19 Jan in 174 days
LEEDS
Evening Meeting (3 registered)
User group evening with Chris Burns and the Resource Govenor and Policy Based Management with Chris Testa-O'Neill

Past Events RSS

20 Jul 2010
LEEDS
Evening Meeting
AGI Northern Group meeting: Using geospatial data in the Microsoft world.
14 Jul 2010
LONDON
Evening Meeting (92 registered)
SQL Server and Disk IO (File Groups/Files, SSD's, Fusion-IO, In-RAM DB's, Fragmentation) - Tony Rogerson; Physical Join Operators in SQL Server - Ami Levin; Complex Event Processing - Allan Mitchell
28 Jun 2010
EDINBURGH
Evening Meeting (14 registered)
Replication (Components, Adminstration, Performance and Troubleshooting) - Neil Hambly and SQL Server Upgrades (Notes and Best practice from the field) - Satya Jayanty
24 Jun 2010
CARDIFF
Evening Meeting (16 registered)
Alex Whittles on data warehouse design case studies and an introduction to PowerPivot with Adam Morton
23 Jun 2010
READING
Evening Meeting (31 registered)
Introduction to NoSQL (Not Only SQL) - Gavin Payne; T-SQL Gotcha's and how to avoid them - Ashwani Roy; Introduction to Recency Frequency - Tony Rogerson; Reporting Services - Tim Leung
17 Jun 2010
LONDON
Full Day Seminar
SQL Server Master Class with Kimberly Tripp and Paul Randal
27 May 2010
ONLINE
Online
Q & A Session with the UK SQL Server Product Team
20 May 2010
LONDON
Evening Meeting (30 registered)
Business Intelligence: Implementing common business calcs using DAX in PowerPivot (Chris Webb); Case Study on how to deal with Metrics on high data volumes
19 May 2010
LONDON
Evening Meeting (38 registered)
Service Broker (Intro, Terminology, Design Considerations); Monitoring and Controlling Resources in SQL Server (Resource Governor, Data Collector); BakBone NetVault: FASTRecover provides byte-level continuous data protection
7 May 2010
ONLINE
Webcast (14 registered)
"Cuppa" Corner: Database Design What is and Why is Normalisation important? Domains, Functional Dependencies, Repeating Groups, First Normal Form.
21 Apr 2010
READING
Evening Meeting (40 registered)
Service Broker (Intro + Guidance), Indexing (Selection, Usage, Fragmentation etc...), Normalisation, Surrogate Keys - Locking considerations
15 Apr 2010
LONDON
Evening Meeting (11 registered)
Social for SQL and SQL Server professionals - SQL quiz, meet your peers, ask the group Q & A
6 Apr 2010
MANCHESTER
Evening Meeting (8 registered)
Loading a datawarehouse using SQL Server Integration Services (SSIS) Chris Testa-O'Neill, Database Design: Normalisation/Denormalisation and using Surrogate Keys Tony Rogerson; Group discussion on topics brought by the audience.
30 Mar 2010
MANCHESTER
Evening Meeting (9 registered)
Introduction to Database Maintenance and Development 101.
25 Mar 2010
EDINBURGH
Evening Meeting (12 registered)
SQL Server 2008 Reporting Services Scalability and Performance

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
tonyrogerson Wed 1:32PM
Do most developers talk Oddle Poddle? #sqlfaq
glhotz Tue 9:46AM
RT @tonyrogerson: "Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory
tonyrogerson Mon 2:36PM
"Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory
gavinpayneuk Mon 8:09AM
Trying #oracle as a #sqlserver user for the first time, why and how in Part 1 of my new blog series http://bit.ly/a8KVbL #sqlfaq
tonyrogerson Mon 5:31AM
Celko advocating 100's of params http://bit.ly/aYvo2K when passing a "set" of values rather than CSV or TVP - he just doesn't get it #sqlfaq
tonyrogerson Fri 9:51AM
26th-28th July - Live Video of KDD-2010 Conference (data mining) Keynotes http://bit.ly/9PIA9C #sqlfaq