Intelligent Cloud Conference

Date

May 29-30

Cinema in Field's

Arne Jacobsens Allé 12

Tickets

500 attendees

Speakers

50+ Speakers

Microsoft - event sponsor
Alexander Arvidsson

Session: SQL Server hates you(?) - what the DBAs never told the developers

Have you had performance tank despite the code working fine in another environment? Maybe heard that some SQL is bad but not why? If so, this is the session for you!
This session will start with a walkthrough of some of the basic settings in SQL Server and how they affect you as a developer. It follows with key tips on what settings to change, why some code will wreak havoc on your performance and how isolation levels matter (and why NOLOCK can be an exceptionally bad idea!) The session is led by a 20-year DBA veteran who decided to try to help developers understand performance issues by seeing things from his perspective.
If you want to explore how default settings kill your performance, investigate why harmless SQL might not be quite so harmless and gain insight into how isolation levels affect function and performance, then this session will provide you with the tools to think outside the box and incorporate database engine knowledge into your developer prowess!

Level: 200

Timeslot: Tuesday 19:40 - 20:30

Track: The Database Track

Speaker: