The signature feature for OLTP workloads in SQL 2014 has been the In-Memory Database option also codenamed ‘Hekaton’. In this session we will take a deeper dive and demonstrate the benefits of Hekaton for even a VM in Azure.
The second pillar of SQL 2014 from an OLTP perspective has been enabling the Hybrid Cloud scenario. We will touch on some of the most important features in SQL 2014 as well as some newer scenarios being lit up by the Azure updates in this quarter.
This session should help you assess the value of SQL 2014 upgrade and its Azure integration from a DBA perspective.
Neeraj (LinkedIn ) is a Senior Technical Evangelist in the Commercial ISV, Technical Evangelism & Development (TED) division in Microsoft. He has been working on enabling ISVs to migrate to Azure platform for the past 4 years. Prior to this role, Neeraj was working for past 8 years in the SQL Server Performance team. During that time he worked on industry standard benchmarks like TPCC, TPCE as well as ISV benchmarks.
Writing T-SQL Code as an Art-Form
Have you considered what the T-SQL code you write communicates about you? Does it show the level of precision you intend? Does it demonstrate that you care if your code can be easily read and interpreted by those that must maintain it later? Sloppy code decreases ROI since valuable time is wasted every time the code has to be investigated over its lifecycle. When you see your own code six months, or a year later, do you feel good about it? Or do you hope no one is able to determine that you wrote it?
Arnie believes that writing Code is similar to writing theatrical dialogue. Set the state, he says, she says, they do something, something else happens. Reading easily maintainable code should be like reading a script. Straightforward, simple –even in the face of complexity, and predictable. Be ready to be challenged to up your game in how you write your T-SQL code. Like an artist, you should not hesitate to ‘sign’ your code. Arnie will provide suggestions and tips, as well as tools that you can use to help create solid, easy to maintain, and ‘readable’ T-SQL code that increases the ROI of the code base.
Arnie [LinkedIn] is a Data Architect, Consultant and Trainer specializing in developer/development issues related to SQL Server. Clients include Fortune 100 enterprises, large scale NGOs, as well as domestic and foreign governments. In addition to facilitating the Oregon SQL –developers user group, he is a SQL Server MVP, a senior moderator for the Microsoft MSDN SQL Server Forums, member of the Microsoft TechNet Wiki Community Council, and co-founder of Portland Code Camp.
Featured Sponsor: Red Gate
- Visit our
- for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.