Reading User Group Meeting – 20th Nov


For those which live or work close to Reading – there will be a UserGroup on the 20th Evening held in TVP – Microsoft Offices.


 


Agenda:


 


6pm – 6:30 Registration and networking + Tea/Coffee with biscuits.


 


Meet and greet.


 


6:30pm – 7 Round Table discussion – ALL


 


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, may be a problem at work.


 


7pm – 7:40 SQL Server 2008 – Data & Backup Compression


Beatrice Nicolini


Premier Field Engineer | SQL Server |Microsoft U.K.


Read my Blog.: http://blogs.technet.com/beatrice


 


With the 2008 release, SQL Server makes a major advance in scalability for data warehousing. With data and backup compression, SQL Server 2008 reduces the size of tables and indexes by storing fixed-length data types in variable length storage format and allows saving disk media space for your SQL backups. This session will guide you through the new data and backup features of SQL 2008, and will show which options are available for different data warehousing scenarios.


 


7:40pm – 7:55 BREAK: Sarnies


 


More time to network and ask questions…


 


7:55pm – 8.15pm Open Nuggest Session


The Audience – anyone


 


Bring your 5 minute hint/tip/demo and present it. This worked well at the London User Group.


Please let me know in advance via email to http://sqlserverfaq.com/events/138/tonyrogerson@torver.net.


It’s a great way of getting your name know and developing your career! There will be prizes for each person who presents.


 


8:15pm – 8.45pm Table Expressions and the Optimiser and some SQL 2008 optimisations for Optional Parameters


Tony Rogerson, SQL Server MVP


http://sqlblogcasts.com/blogs/tonyrogerson


 


We will look at the theory behind Table Expressions (Derived Tables, Views, Table Valued Functions and Common Table BLOCKED EXPRESSION, we will delve into some traps and suprise you at what the optimiser is doing under the covers. To finish off we will look at some SQL Server 2000 introduced optimiser improvements that certainly if you are using dynamic SQL because of optional parameters will mean you can move away from dynamic SQL back to simple straighforward SQL.


 


To register:


 


http://sqlserverfaq.com/events/138/UK-SQL-Server-User-Group-Evening-Meeting-Agenda-TBC.aspx 


 


Beatrice Nicolini –

Comments (1)