11 November 2008 18:57
tonyrogerson
Reading User Group Meeting - 10th Nov: SQL 2008 Data & Backup Compression / Open Mic / Table Expressions and SQL 2008 Optimiser Improvements around Optional Parameters
Below is the agenda for next weeks Thursday user group meeting at Microsoft offices @ TVP (Reading). These are great opportunities for meeting other SQL professionals and expanding your knowledge of the product and how to use it.
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 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
Filed under: SQL Server, SQL Server User Group, SQL Server FAQ