Thanks to our Partners:

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 Click here to join Meeting
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

Wed, 17 Mar in 6 days
LONDON
Evening Meeting (124 registered)
SQL 2008 Data Warehousing Features (Vincent Rainardi); Index Views and Computed Columns (Neil Hambly); Business Intelligence in Office 2010 - Excel,PowerPivot,SharePoint (Duncan Sutcliffe); finishing with a Q & A on BI with the panel
Sat, 27 Mar in 16 days
MANCHESTER
Evening Meeting (3 registered)
Introduction to Business Intellence in the SQL Server Stack - ***Date to be confirmed*** - register your interest
Sat, 27 Mar in 16 days
MANCHESTER
Evening Meeting (5 registered)
Introduction to Database Maintenance and Development 101 - ***Date to be confirmed*** - register your interest
Wed, 21 Apr in 41 days
READING
Evening Meeting (18 registered)
Developer and DBA Focus
Fri, 7 May in 57 days
ONLINE
Webcast (2 registered)
Database Design Part 1 - Why is Normalisation important? What is Normalisation, a look at First Normal Form (1NF) and Boyce Codd (BCNF) Normal Form
Wed, 19 May in 69 days
LONDON
Evening Meeting (17 registered)
Developer and DBA focus
Wed, 23 Jun in 104 days
READING
Evening Meeting (4 registered)
Business Intelligence focus
Wed, 14 Jul in 125 days
LONDON
Evening Meeting (7 registered)
Generic session on SQL Server

Past Events RSS

25 Feb 2010
EDINBURGH
Evening Meeting (19 registered)
** Prize Draw **, An evening of performance troubleshooting with Iain Kick , Learning SQL Server with Alistair Board
25 Feb 2010
CARDIFF
Evening Meeting (16 registered)
**Change to Agenda** BI Fundamentals: Building an Enterprise ETL Framework in SSIS, Data Warehouse Design
20 Jan 2010
DUNDEE
Evening Meeting (7 registered)
Allan Mitchell - Intro to SQL Server Integration Services 2008; Tony Rogerson - Intro to SQL Server tools both flavours - DBA and Developer. Usual Nuggets, Usual SQL LiveLock; Q & A; Advice etc..
17 Dec 2009
MANCHESTER
Evening Meeting (9 registered)
Manchester SQL Server User group - Round the table talks, SQL Nuggets, Informal talk and out for a drink and a chance to win a Copy of Windows 7 and SQL Server 2008
10 Dec 2009
LEEDS
Evening Meeting (9 registered)
An evening of Service Broker and Powershell
26 Nov 2009
EDINBURGH
Evening Meeting (8 registered)
** Cancelled ** SQL Server Nuggets and a look into the Newsgroups
26 Nov 2009
LONDON
Evening Meeting (57 registered)
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
18 Nov 2009
LONDON
Evening Meeting
SQL Azure and what is new in SQL Server 2008 R2
11 Nov 2009
READING
Evening Meeting (36 registered)
High Availability (Partitioning, File Groups (use of, backup/restore)) and an Introduction to SQL Server architecture - Tony Rogerson; Virtualising SQL Server (why, design, how, issues, solutions, troubleshooting) - Justin Langford
29 Oct 2009
LONDON
Evening Meeting (42 registered)
Deploying SSRS reports using msbuild (Jamie Thomson); BI 2.0 (Andrew Sadler); Data Warehouse Development Workbench for SQL Server (Steve Hitchman)
28 Oct 2009
DUNDEE
Evening Meeting
SQL Injection Attacks and Tips on How to Prevent Them
15 Oct 2009
MANCHESTER
Evening Meeting (17 registered)
Reporting Services evening. Hosted by Chris Testa-O'Neill
14 Oct 2009
READING
Evening Meeting (33 registered)
Focus: Developer/DBA; Tony Rogerson on TSQL Hints and Tips (CTE Recursion,Case,Partitioning,Sub-Queries,Normalisation/DeNormalisation) and Colin Leversuch-Roberts "How are my servers Today?" - real time monitoring dashboards
8 Oct 2009
CARDIFF
Evening Meeting (18 registered)
South Wales User Group first meeting - Ensuring Business Continuity (Backups, Mirroring and Monitoring) - Tony Rogerson; SQL 2008 Integration Services - some of the things that make it better - Allan Mitchell.
8 Oct 2009
EDINBURGH
Evening Meeting (11 registered)
SQL Server Performance Analysis Tools and Powershell

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
Jennifer Stirrup Wed 6:49PM
Is anyone hiring at the moment? Looking for a London-based BI focused role
tonyrogerson Wed 12:46PM
@philcr I'd really like to see Surface with a 2008 R2 demo on it taking full advantage of the kit - that would be cool! #sqlfaq
tonyrogerson Sun 10:14AM
Time for a brew - am reading on the SQL Server Modelling stuff and "M" - don't see where it fits to be honest #sqlfaq
tonyrogerson Fri 8:13PM
@Plip Should have used DAS and disk replication - commodity simple kit always the best approach (usually) #sqlfaq
tonyrogerson Fri 4:52PM
Ashwani Roy and Chris Testa-O'Neill are doing a 30 minute Q&A panel at the 17th March UG even - cool #sqlfaq
tonyrogerson Fri 3:13PM
Posted a blog http://bit.ly/afepEy that describes what Granularity is #sqlfaq
tonyrogerson Fri 12:24PM
7th May 1pm - 1.45pm http://bit.ly/c4UmAP I'm going to do a webcast on Normalisation - vender neutral #sqlfaq
tonyrogerson Fri 12:02PM
Just helped a friend take her first steps in SQL Server #sqlfaq over LiveMeeting; dam "namespace error" on SSRS on the install though :(
tonyrogerson Fri 10:32AM
Thinking about my Denormalisation/RElational Theory talk for SQLBits #sqlfaq; so much to cover - so little time.
mladenprajdic Fri 10:22AM
@tonyrogerson i don't know how useful the #sqlfaq is but there is #sqlhelp that is used and has quite some traffic.
tonyrogerson Fri 10:17AM
Whats the point using DISTINCT (tuples will b unique-I get that), but still keyless - what have you achieved in "relational" terms? #sqlfaq
tonyrogerson Fri 10:09AM
In CJ Date's book SQL and Relational Theory he talks about having DISTINCT on every query - that would be interesting #sqlfaq #infooverload
tonyrogerson Fri 7:39AM
17th March Business Intelligence event is now full - we've over 100 registered now, there is a reserve list in operation #sqlfaq
deepfat Thu 1:26PM
#SQLFAQ London SQL Server BI evening 17th March in Victoria be there and be a cube http://bit.ly/cx1vu4
tonyrogerson Thu 1:09PM
Just emailed the UG, had 4 offers to present and more registrations - the 17th will be a good evening! #sqlfaq BI is popular these days
camurphy Thu 11:14AM
RT @tonyrogerson Agenda http://bit.ly/aJDVTc is now up for Business Intelligence evening in London on 17th March #sql #sqlfaq
plip Thu 11:09AM
.RT @tonyrogerson Agenda http://bit.ly/aJDVTc is now up for Business Intelligence evening in London on 17th March #sql #sqlfaq