Newcastle SQL Server User Group (@sqlne)

Next Meeting

Thursday,

March

26

SQL NorthEast User Group meeting, Thursday 26th March with Erin Stellato (SQLSkills) and Peter Shaw

  • In-Person @ 100, Quayside Newcastle, Tyne and Wear, United Kingdom (map)
  • 17:30 - 21:00 (UTC) Dublin, Edinburgh, Lisbon, London
  • Language: English

NORTHEAST SQL SERVER USER GROUP


    **Register Here**

Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers. Remember to tell your friends and the people you work with; make sure you register as soon as you can.

5.30pm – 6:00pm Registration and networking 
6:00 – 6:15pm Round Table discussion and Nuggets - ALL 
6:15pm - 7:15pm -  Updating Statistics Affects Query Performance More Than You Think with Erin Stellato (SQLSkills)
7:15 - 7:40pm - Break 
7:40pm – 8:40pm - 

Why are DBA's so afraid of Entity Framework (and other ORMs for that matter) 

with Peter Shaw
8:40pm - 9:00pm - Feedback and Close

Finally: Drinks on the Quayside :)

Featured Presentation:

Updating Statistics Affects Query Performance More Than You Think

Erin Stellato, Principal Consultant SQLskills.com

Stop me if you've heard this one, "This query is slow, let's update statistics." But what does updating statistics *really* do to your query performance? And is it the right solution? While updating statistics may provide a short-term solution, it can bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you *do* update statistics, and you’ll see why that might not always be the right long-term solution. Erin will be joining us from the US via web conference.

About Erin:
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Why are DBA's so afraid of Entity Framework (and other ORMs for that matter)

Peter Shaw

In this session I'll look at just why so many DBA's have such a negative impression of the Entity Framework Object Relational Mapper that's at the heart of many microsoft application deployments these days. We'll examine some of the commonly touted reasons that DBA's give for hating it, and the reasons why many developers defend it, and along the way we'll see that both sides of the argument have some merit in what's been said. We'll finish the session off by showing that, it's really not as bad as most DBA's think, and when the developers take advantage of some of the deeper functionality available in the framework, there's actually a surprising amount of control to be had. Along the way I'll show a typical Code First Database Mapping Project in Visual Studio and explain just exactly how things can be tuned and how it all fits together in a way that can be understood by developers and DBA's alike.

About Peter:
None