Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.

PASS SQLRally 2011 www.sqlpass.org Twitter Facebook

Development (DEV)

The following sessions were chosen to be presented at PASS SQLRally Nordic 2012.
Scroll down to see them all: 

Selected Sessions

Title:

SQL Server 2012 Security for Developers

Speaker:

Andreas Wolter

Abstract:

A system is only as secure as its weakest link. SQL Server 2012 continues to be on the top of the most secure database systems – so the tools and techniques are there, to make sure your Database Application opens no gaps. In this session you will see lots of techniques and best practices which should be in every developer’s toolbox to tighten your databases' security. Among them: how to correctly use schemas to enforce and at the same time simplify security; ownership-chaining as well as its pitfalls; how to securely handle dynamic SQL to protect from SQL Injection; code signing and the new features that SQL Server 2012 provides for Developers: Contained Databases and User-Defined Audit. Security is simple, if it is considered in the design-phase – and your Admin will be grateful, too.

Level 300

Title:

Designing Hybrid Systems for the Enterprise

Speaker:

Buck Woody

Abstract: Developing a system for a Distributed Computing (Cloud) configuration is not an "either/or" proposition - you should develop your systems in a component-oriented fashion so that each area can be created for an on-premises or cloud configuration. This also allows you to use many cloud providers, even at the same time. Buck Woody will show you how to create a hybrid system that best fits your needs.

Level 300

 


Title:

SQL Server 2012 Query Optimizer Deep Dive

Speaker:

Connor Cunningham

Abstract:

This talk will go through the internals of the query optimizer in SQL Server, covering how the Optimizer works, what kinds of internal structures it uses, and what sorts of things you can do to understand why the optimizer is picking the plan it picks.  This talks specifically covers some of the areas where customers have reported issues and the common resolutions we recommend.  An overview of the new ColumnStore index Batch processing mode, which makes data warehouse queries execute 10x+ faster, is also presented.  This talk is organized so that people of all skill levels can get something from it, meaning that it starts from the customer perspective and then goes deeper.  On various topics, Conor will go down into the core guts of the feature so that even the most skilled customer can learn something new about how things work down in the deepest sections of the code.  If you want to become better at query tuning, this is the talk to attend.

Level 400


Title:

The evils of user-defined functions

Speaker:

Hugo Kornelis

Abstract: User-defined functions in SQL Server are very much like custom methods and properties in .Net languages. At first sight, they seem to be the perfect tool to introduce code encapsulation and reuse in T-SQL. So why is this feature mostly avoided by all T-SQL gurus? The reason is performance. In this session, you will learn how user-defined functions feed the optimizer with misleading and insufficient information, how the optimizer fails to use even what little information it has, and how this can lead to shocking query performance. However, you will also see that there is a way to avoid the problems. With just a little extra effort, you can reap the benefits of SQL Server and still get good performance.

Level 300


Title:

Leonard Lobel

Speaker:

SQL Server Enterprise Data Management

Abstract: SQL Server is readily equipped with three powerful features to help you manage data in your enterprise. Join Lenni in this triple-header, demo-packed session covering Change Data Capture (CDC), Transparent Data Encryption (TDE), and SQL Server Audit. With CDC, you can record changes in your database, without requiring any programming or resorting to triggers. Enabling TDE automatically encrypts the entire database in the background, without increasing database size, and without requiring any code. And with SQL Server Audit, virtually any action taken by any user can be recorded for auditing in either the file system or the Windows event log.

Level 300


Title:

SQLCAT - Shared technical learnings for building a highly scalable
and available cloud application

Speaker:

Mark Souza, Mark Simms

Abstract: The SQLCAT team has successfully architected, designed and built over 50 SQL Server cloud projects. We want to share the learnings on how to design a SQL Server cloud application to scale to handle large , complex workloads. Building cloud applications are different than building on premise SQL Server applications. Agenda I) Share some of the existing successful cloud deployment feeds and speeds. II) The challenges we faced III) It is all about the architecture up front IV) Lessons Learned V) Summary Q&A.

Level 300


Title:

Indexing for performance - what the server tells you

Speaker:

Mikael Wedham

Abstract:

You run queries every day. SQL Server says: "Here are yor results". Some people are good with that, but the server actually tells you much more. In this session we're going to learn the language of statistics and de-mystify the signs that execution plans in SQL Server uses to tell you what it did and why. We are also going to try to interpret the subtle signs into actual facts, where the server tells you: "I need this index, please". This session will teach you the why and how of the results.

Level 200


Title:

Cloud-Ready Data Services

Speaker:

Scott Klein

Abstract:

Microsoft Windows Azure offers a number of data services that provide the ability to store relational data as well as structured and unstructured data. The key is to understand how to appropriately leverage these enterprise services to solve growing data challenges. We'll also discuss the approach for using the right service for the right problem to get the best performance out of each service.

Level 300


Title:

B(r)inging Maps to SQL Server

Speaker:

Simon Lidberg & Mikael Colliander

Abstract:

Maps and spatial information gets more and more interesting now in both BI solutions as well as in mobile apps. SQL Server has very advanced mapping capabilities with the spatial data types and in this session we well both look at how the spatial data types work as well as how you can build BI solutions and applications that can be used to display the information. We will also look at ways on how to geo code your data using SQL Server and mapping services on the internet.

Level 200


Title:

Practical uses of new T-SQL functionality in SQL Server 2012 &
Windows Azure SQL Database

Speaker:

Tobias Ternstrom

Abstract:

SQL Server 2012 adds a number of powerful new T-SQL features that let you solve common problems in better and more efficient ways. However, to get the most out of these features you need to know why and how to use them. This session will focus on practical uses of key new features, why they were added in the first place, and best practices that explain how to use them effectively.

Level 300

 
 

 


PRIMARY  SPONSOR


ENTERPRISE  SPONSOR
 

   
 
 
 
 
 
 
 

STANDARD