Belfast SQL Server User Group

Welcome to the Belfast Chapter

Next Meeting

Thursday,

February

26

When good SQL Design Goes Bad & Optimising Reporting Services Performance

  • In-Person @ Adelaide Exchange Belfast, Antrim, United Kingdom (map)
  • 18:00 - 21:00 (UTC+00:00) Dublin, Edinburgh, Lisbon, London
  • Language: English

The presentation will cover the following. 


6:15 - 6:30: Registration & Intro
6:30 - 7:30: When good SQL Design goes bad.
7:30 - 7:45: Break and Refreshments
7:45 - 8:45: Optimising Reporting Services Performance

Sign up http://www.eventbrite.co.uk/e/belfast-sql-server-usergroup-tickets-15403541407

Featured Presentation:

When good SQL Design goes bad.

Bob Duffy, Database Architect Prodata

Take what you’ve learned about SQL Server and turn it upside down. In this humorous session I’ll be contesting many of the so called “best practices” in SQL Server and demonstrating counter arguments. Come along to see how so called “pillars” of design are starting to break down. · When you should NOT use stored procedures · When we don’t need indexes · When Clustered Tables are bad · When Identity Columns should not be Primary Keys · When we don’t care about fragmentation · When good naming convention’s go bad · Why Partitioning often makes your queries slower. · When it makes sense to make all your parameters nvarchar (max) Health Warning: Do not try these concepts on your production system

About Bob:
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified. Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.

Optimising Reporting Services Performance

Bob Duffy, Database Architect Prodata

This sessions is a quick look at how to improve reporting services performance by looking at how to monitor report performance and spot key design issues Sections Covered are: - Reporting Services Architecture and Internals - Logging and Monitoring Reports - Parameterisation - The dreaded multi select parameter - Connections - Datasets - Tablix and Pivoting Data - Drill Down and Navigation - Top Issues

About Bob:
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified. Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo.jpg

Broadtree Solutions

Ormo Baths

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids