Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

When good SQL Design Goes Bad & Optimising Reporting Services Performance

SQL

Thursday, 26 February 2015 from 18:00 to 21:00 (GMT)

When good SQL Design Goes Bad & Optimising Reporting...

Ticket Information

Type End Quantity
Free Entry Ended Free  

Share When good SQL Design Goes Bad & Optimising Reporting Services Performance

Event Details

 

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.

Do you have questions about When good SQL Design Goes Bad & Optimising Reporting Services Performance? Contact SQL

When & Where


Adelaide Exchange
24- 26 Adelaide St
BT2 Belfast
United Kingdom

Thursday, 26 February 2015 from 18:00 to 21:00 (GMT)


  Add to my calendar

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.