sqlpasshistory

ID: 19

Back to Main list

PASS SQLRally 2012 Nordic

Session Date/Time (dd-MM-YYYY 24h)	Speaker	Category	Track	Title
02-10-2012 11:00	Tobias Ternstrom	Regular Session (60 minutes)	Development (DEV)	Practical Uses of New T-SQL Functionality in SQL Server 2012 & Windows Azure SQL Database
02-10-2012 11:00	Klaus Aschenbrenner	Regular Session (60 minutes)	Database Administration (DBA)	SQL Server 2012 Troubleshooting with Extended Events
02-10-2012 11:00	Alberto Ferrari	Regular Session (60 minutes)	Business Intelligence (BI)	Querying and Optimizing DAX
02-10-2012 13:00	Allan Hirt	Regular Session (60 minutes)	Database Administration (DBA)	Deploying SQL Server 2012 Failover Clustering Instances
02-10-2012 13:00	Niko Neugebauer	Regular Session (60 minutes)	Business Intelligence (BI)	ETL Frameworks with Dynamic SSIS Packages
02-10-2012 13:00	Mikael Wedham	Regular Session (60 minutes)	Development (DEV)	Indexing for Performance - What the Server Tells You
02-10-2012 14:15	Leonard Lobel	Regular Session (60 minutes)	Development (DEV)	SQL Server Enterprise Data Management
02-10-2012 14:15	Marco Russo	Regular Session (60 minutes)	Business Intelligence (BI)	xVelocity Under the Hood
02-10-2012 14:15	Joe Chang	Regular Session (60 minutes)	Database Administration (DBA)	Automating DMV Performance Collection, Analysis and Archival
02-10-2012 15:45	Silvano Coriani	Regular Session (60 minutes)	Database Administration (DBA)	SQLCAT - Learn how Windows Azure SQL Database can support very large scale customer deployments
02-10-2012 15:45	Thomas Kejser	Regular Session (60 minutes)	Business Intelligence (BI)	Big Data Customer Solution Architectures
02-10-2012 15:45	Mark Simms, Mark Souza	Regular Session (60 minutes)	Development (DEV)	Shared technical learnings for building a highly scalable and available cloud application
02-10-2012 17:00	Just Blindbaek	Regular Session (60 minutes)	Business Intelligence (BI)	Excel Services and Publishing Excel Sheets via SharePoint
02-10-2012 17:00	Simon Lidberg, Mikael Colliander	Regular Session (60 minutes)	Development (DEV)	B(r)inging Maps to SQL Server
02-10-2012 17:00	Neil Hambly	Regular Session (60 minutes)	Database Administration (DBA)	SQL Server 2012 Memory Management
03-10-2012 09:00	Buck Woody	Regular Session (60 minutes)	Development (DEV)	Designing Hybrid Systems for the Enterprise
03-10-2012 09:00	Ewan Fairweather	Regular Session (60 minutes)	Database Administration (DBA)	SQLCAT - SQL 2012 OLTP
03-10-2012 09:00	Adam Jorgensen	Regular Session (60 minutes)	Business Intelligence (BI)	Zero to Cube
03-10-2012 10:15	Andreas Wolter	Regular Session (60 minutes)	Development (DEV)	SQL Server 2012 Security for Developers
03-10-2012 10:15	Thomas Kejser	Regular Session (60 minutes)	Database Administration (DBA)	Optimising Column Stores with Statistical Analysis
03-10-2012 10:15	Chris Webb	Regular Session (60 minutes)	Business Intelligence (BI)	The Best Microsoft BI Tools You’ve Never Heard Of
03-10-2012 12:45	Conor Cunningham	Regular Session (60 minutes)	Development (DEV)	SQL Server 2012 Query Optimizer Deep Dive
03-10-2012 12:45	Stacia Varga	Regular Session (60 minutes)	Business Intelligence (BI)	Power View: A Peek Behind the Curtain
03-10-2012 12:45	Alexei Khalyako	Regular Session (60 minutes)	Database Administration (DBA)	SQLCAT - Data Movement Considerations for the Hybrid Solutions between Cloud and on-Premise
03-10-2012 14:00	Michael Frandsen	Regular Session (60 minutes)	Database Administration (DBA)	Windows Server 2012 Infrastructure for SQL Server
03-10-2012 14:00	Henk Van der Valk	Regular Session (60 minutes)	Business Intelligence (BI)	SQL Server Parallel Data Warehouse
03-10-2012 14:00	Hugo Kornelis	Regular Session (60 minutes)	Development (DEV)	The Evils of User-Defined Functions
03-10-2012 15:15	Steve Simon	Regular Session (60 minutes)	Business Intelligence (BI)	A Dive into Data Quality Services SQL Server 2012
03-10-2012 15:15	Scott Klein	Regular Session (60 minutes)	Development (DEV)	Cloud-Ready Data Services
03-10-2012 15:15	Victor Isakov	Regular Session (60 minutes)	Database Administration (DBA)	Upgrading Your High-Availability Solution to SQL Server 2012 AlwaysOn Availability Groups

SessionID: 3893

Practical Uses of New T-SQL Functionality in SQL Server 2012 & Windows Azure SQL Database

Back to calendar

Event Date: 02-10-2012 11:00 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Tobias Ternstrom

Title: Practical Uses of New T-SQL Functionality in SQL Server 2012 & Windows Azure SQL Database

Description:

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.

SessionID: 3647

SQL Server 2012 Troubleshooting with Extended Events

Back to calendar

Event Date: 02-10-2012 11:00 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Klaus Aschenbrenner

Title: SQL Server 2012 Troubleshooting with Extended Events

Description:

Extended Events is a new lightweight tracing infrastructure that Microsoft introduced first with SQL Server 2008. SQL Server 2012 provides you now also a very sophisticated UI for configuring event sessions based on Extended Events. In this session you will get a basic overview about Extended Events, what are they, how they are used inside SQL Server, and how you can use them to troubleshooting your SQL Server 2012 installation.

SessionID: 3522

Querying and Optimizing DAX

Back to calendar

Event Date: 02-10-2012 11:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Alberto Ferrari

Title: Querying and Optimizing DAX

Description:

In SQL 2012 DAX became a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless, as with any other language, you can write good DAX or bad DAX, depending on your understanding of the engine internals. In this session we are going to introduce DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations and a better understanding of query plans, which we will show, in order to give a complete understanding of how to get the best out of DAX.

SessionID: 3780

Deploying SQL Server 2012 Failover Clustering Instances

Back to calendar

Event Date: 02-10-2012 13:00 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Allan Hirt

Title: Deploying SQL Server 2012 Failover Clustering Instances

Description:

There are quite a few changes to failover clustering instances in SQL Server 2012, not the least of which is full multi-subnet support, the use of SMB shares, the ability to use a local tempdb, and more. Add to that mix the possibility of a new platform (Windows Server 2012), and there's a lot DBAs will need to know to update their skills to deploy clustered instances with the latest version of SQL Server. This session will cover the relevant tips, tricks, and gotchas including anything related to Windows Server 2012 if possible.

SessionID: 3792

ETL Frameworks with Dynamic SSIS Packages

Back to calendar

Event Date: 02-10-2012 13:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Niko Neugebauer

Title: ETL Frameworks with Dynamic SSIS Packages

Description:

In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and so many tables are affected by the changes of multiple applications and developers.

If you have just a couple of objects to take care off, then it is all fine and easy to handle, but if you are working with 100's or 1000's of tables, will you try to edit all your SSIS packages manually?

Join me to discover some ways to develop some simple ETL frameworks which can help handling some real world challenges, and learn how you can do some simple running without that much work. The only existing constant in the nature is the change, so we better be ready to face it.

SessionID: 3822

Indexing for Performance - What the Server Tells You

Back to calendar

Event Date: 02-10-2012 13:00 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Mikael Wedham

Title: Indexing for Performance - What the Server Tells You

Description:

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.

SessionID: 3894

SQL Server Enterprise Data Management

Back to calendar

Event Date: 02-10-2012 14:15 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Leonard Lobel

Title: SQL Server Enterprise Data Management

Description:

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.

SessionID: 3527

xVelocity Under the Hood

Back to calendar

Event Date: 02-10-2012 14:15 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Marco Russo

Title: xVelocity Under the Hood

Description:

You run a DAX query, you get the result amazingly fast. But how did this happen? How does the xVelocity in-memory engine works, under the hood, to run queries so fast? In this session we will analyze the internals of the xVelocity engine, understanding the roles of Formula Engine and Storage Engine, how they interact and how queries are executed, with a particular interest on filter context and how it propagates through relationships. This knowledge can be important to understand how to get the best from the xVelocity engine by using the proper data model and DAX expressions.

SessionID: 3666

Automating DMV Performance Collection, Analysis and Archival

Back to calendar

Event Date: 02-10-2012 14:15 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Joe Chang

Title: Automating DMV Performance Collection, Analysis and Archival

Description:

The SQL Server Dynamic Management Views and Functions are highly useful in providing quick access to available performance data without having to wait for a new trace. Collecting, analyzing and archiving DMV data through SQL scripts can be awkward and cumbersome. It is much more effective to do this in a proper programming language. Much of the tedious analysis work can be automated, but a quality assessment is still beyond the capability of hands-off tools.

Performance data can be collected at regular intervals and archived without much effort. When there is a significant performance degradation, the before and after execution plans are readily available. Performance problems are not difficult to resolve. But management may want an explanation, and are prone to issue edicts. So it is important that the correct information be presented.

SessionID: 3701

SQLCAT - Learn how Windows Azure SQL Database can support very large scale customer deployments

Back to calendar

Event Date: 02-10-2012 15:45 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Silvano Coriani

Title: SQLCAT - Learn how Windows Azure SQL Database can support very large scale customer deployments

Description:

In this session we’ll present some of the challenges the MS team (MCS, PFE, DPE, Windows Azure Incubation and SQL CAT) faced working with key customers to implement and launch successfully massive scaling web applications currently running on the Windows Azure as well as key lessons learned and best practices. These customer experiences cover Pottermore.com, Samsung Electronics and MYOB. Pottermore.com is built around the Harry Potter books where users can share and participate in the stories and showcase their own Potter-related creativity by uploading their thoughts and drawings to the site. Samsung Electronics system supports their Smart TV line across the globe with key services such as registration, firmware and apps upgrades, content delivery and remote management. MYOB is an ISV that provides accounting system for small companies across Australia and New Zealand planning to deploy and manage 100k+ SQL Databases. We’ll touch areas like design solution for web scale leveraging a custom sharding approach vs. federations and how to plan for capacity and size a deployment appropriately. We’ll talk also about how to help the application operation team in instrumenting the app and build a telemetry system to collect the right data on performance and other areas, using VSTS on Windows Azure or other test tools, and facilitate the interaction with MS Support organizations. Finally we’ll address some other challenges like upgrading from Oracle, moving a current .Net app to Windows Azure , moving effectively data across shards and between SQL Database and the on premises for backup and restore purposes plus planning for large number of connections.

SessionID: 3897

Big Data Customer Solution Architectures

Back to calendar

Event Date: 02-10-2012 15:45 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Thomas Kejser

Title: Big Data Customer Solution Architectures

Description:

Big Data solutions can be as simple as the acquisition and storage of large volumes of data, or as complex as a system that processes 135 Billion+ events/month. In today's SQLCAT Big Data session, we will be reviewing customer solution architectures such as those involving Big Data to BI, Distributed Querying, Near Real Time Processing, and Event Messaging. We will also be talking about the lessons learned from working with customers on Microsoft's Big Data Solutions.

SessionID: 3637

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

Back to calendar

Event Date: 02-10-2012 15:45 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Mark Simms, Mark Souza

Title: Shared technical learnings for building a highly scalable and available cloud application

Description:

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

SessionID: 3774

Excel Services and Publishing Excel Sheets via SharePoint

Back to calendar

Event Date: 02-10-2012 17:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Just Blindbaek

Title: Excel Services and Publishing Excel Sheets via SharePoint

Description:

Quick overview of publish options with focus on the “Items in the workbook” option which is especially handy when you will embed in SharePoint without it resembles Excel too much. Second item on the agenda is the integration in SharePoint with a demonstration of three possibilities:

• Full page - The lazy solution
• PerformancePoint Services Dashboard - The smart solution
• WebPart page - The customizable solution

Last but not least the session will include “Tips & Tricks” including how to remove the Excel look. How to control the layout with “Named Items” and the "Name Manager" and how you can burst the limits from PivotTables with the of use "Cube Functions" and "Names Sets".

SessionID: 3828

B(r)inging Maps to SQL Server

Back to calendar

Event Date: 02-10-2012 17:00 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Simon Lidberg, Mikael Colliander

Title: B(r)inging Maps to SQL Server

Description:

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.

SessionID: 3752

SQL Server 2012 Memory Management

Back to calendar

Event Date: 02-10-2012 17:00 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Neil Hambly

Title: SQL Server 2012 Memory Management

Description:

SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one. And that’s just the beginning of the changes for SQL Server memory.

This session will dive into SQL Server 2012's new memory architecture. We'll see how to diagnose memory performance issues and gain insight into memory pressure issues. We'll also cover the settings to adjust memory configuration levels and their impact.

SessionID: 3657

Designing Hybrid Systems for the Enterprise

Back to calendar

Event Date: 03-10-2012 09:00 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Buck Woody

Title: Designing Hybrid Systems for the Enterprise

Description:

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.

SessionID: 3892

SQLCAT - SQL 2012 OLTP

Back to calendar

Event Date: 03-10-2012 09:00 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Ewan Fairweather

Title: SQLCAT - SQL 2012 OLTP

Description:

SQL Server 2012 provides enhancements to internal components and programmability features in the relational engine. In this session we’ll focus on common challenges our OLTP workloads face:

• Describe how new features can benefit and how they relate to older functionality.
• We will look at what you should consider for use as you design a system, maintain it and troubleshoot it
• How Sequence objects can be leveraged to unblock latch contention scenarios • The internal enhancements we have made to the memory manager and what you need to know about it • Walk through practical examples of how to use the new XEvents UI and harness it’s debugging capabilities so that you can get a real insight into what is going on in your system.

SessionID: 3660

Zero to Cube

Back to calendar

Event Date: 03-10-2012 09:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Adam Jorgensen

Title: Zero to Cube

Description:

This session focuses on showing the attendees how easy it is to lower the barrier to analytics using Analysis Services. We will discuss and demonstrate the best practices for preparing your data for analysis, building a cube and consuming that cube with presentation layer components. This is all done live with full audience participation. It's an exciting and fun time for all. This session was a top 10 at two previous Summits in the US and was a pakced house at SQL Rally US and SQL Saturdays.

SessionID: 3874

SQL Server 2012 Security for Developers

Back to calendar

Event Date: 03-10-2012 10:15 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Andreas Wolter

Title: SQL Server 2012 Security for Developers

Description:

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.

SessionID: 3663

Optimising Column Stores with Statistical Analysis

Back to calendar

Event Date: 03-10-2012 10:15 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Thomas Kejser

Title: Optimising Column Stores with Statistical Analysis

Description:

You may already know that ordering the records in a table before you add a column store index may increase compression. And if you don't, I will show you just how it does to get us on the same page.

But the real question is: WHICH order of the column is the right one?

In this session, I will walk you through some basic statistical entropy analysis to discover the near optimal sorting of data. This will increase compression (And speed) of column stores. I will use anonymised datasets from real customer data to prove my points.

As a side effect of the analysis we will do together, it is also possible to discover missing multi-column statistics on a table. Using this new knowledge, we will be able to add new statistics to the database table to increase the likelihood of getting good query plans.

SessionID: 3541

The Best Microsoft BI Tools You’ve Never Heard Of

Back to calendar

Event Date: 03-10-2012 10:15 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Chris Webb

Title: The Best Microsoft BI Tools You’ve Never Heard Of

Description:

Think you know all about the Microsoft BI stack? Think again! This session will cover experimental and obscure Microsoft BI tools that you might not have seen before, including:

• Data Explorer from SQL Azure Labs, for self-service ETL in the cloud and in Excel
• NodeXL, for graph analysis in Excel
• Layerscape, for visualising data on maps using Excel and Microsoft World Wide Telescope
• The Excel Data Mining addin

…plus how to use them alongside more mainstream tools such as PowerPivot and Analysis Services.

SessionID: 3898

SQL Server 2012 Query Optimizer Deep Dive

Back to calendar

Event Date: 03-10-2012 12:45 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Conor Cunningham

Title: SQL Server 2012 Query Optimizer Deep Dive

Description:

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

SessionID: 3795

Power View: A Peek Behind the Curtain

Back to calendar

Event Date: 03-10-2012 12:45 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Stacia Varga

Title: Power View: A Peek Behind the Curtain

Description:

Power View is the new data visualization and self-service BI tool that will debut in SQL Server 2012. To successfully roll-out this technology to your user community, you need to understand its architecture and data dependencies. Come to this session to get past the razzle dazzle that most Power View sessions offer, and peek behind the curtain to learn how to properly configure your environment to support Power View and how to prepare data for user consumption within Power View.

SessionID: 3895

SQLCAT - Data Movement Considerations for the Hybrid Solutions between Cloud and on-Premise

Back to calendar

Event Date: 03-10-2012 12:45 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Alexei Khalyako

Title: SQLCAT - Data Movement Considerations for the Hybrid Solutions between Cloud and on-Premise

Description:

There is a lot of excitement around moving parts of the business workload into the Cloud. One of the most interesting approaches is to build combined solutions where the ‘traditional’ SQL and Cloud services could be combined together in so called ‘Hybrid’ configuration. The question we want to discuss is: we know how to get data into the SQL Server quick and efficiently. Will those techniques also work when moving data into the Cloud? Please join the session to learn about our observations when we applied the data loading best practices to the Hybrid solutions and the best practices we identified for the Hybrid configurations.

SessionID: 3788

Windows Server 2012 Infrastructure for SQL Server

Back to calendar

Event Date: 03-10-2012 14:00 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Michael Frandsen

Title: Windows Server 2012 Infrastructure for SQL Server

Description:

In this session I will go into the new storage features in Windows Server 2012.

Through working with the Core Windows Server team in Redmond during the development of Windows 8 I did a lot of work with technologies which have been around for some time, but unavailable to Windows Server installations. We will talk about Infiniband, Multi-path I/O, RDMA, RoCE, NAND Flash storage, latency and much more.

SessionID: 3786

SQL Server Parallel Data Warehouse

Back to calendar

Event Date: 03-10-2012 14:00 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Henk Van der Valk

Title: SQL Server Parallel Data Warehouse

Description:

Learn all about the future of SQL Server DWH and performance of the flagship: SQL Server Parallel Data Warehouse!

SessionID: 3632

The Evils of User-Defined Functions

Back to calendar

Event Date: 03-10-2012 14:00 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Hugo Kornelis

Title: The Evils of User-Defined Functions

Description:

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.

SessionID: 3732

A Dive into Data Quality Services SQL Server 2012

Back to calendar

Event Date: 03-10-2012 15:15 - Category: Regular Session (60 minutes) - Track: Business Intelligence (BI)

Speaker(s): Steve Simon

Title: A Dive into Data Quality Services SQL Server 2012

Description:

Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.

SessionID: 3537

Cloud-Ready Data Services

Back to calendar

Event Date: 03-10-2012 15:15 - Category: Regular Session (60 minutes) - Track: Development (DEV)

Speaker(s): Scott Klein

Title: Cloud-Ready Data Services

Description:

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.

SessionID: 3550

Upgrading Your High-Availability Solution to SQL Server 2012 AlwaysOn Availability Groups

Back to calendar

Event Date: 03-10-2012 15:15 - Category: Regular Session (60 minutes) - Track: Database Administration (DBA)

Speaker(s): Victor Isakov

Title: Upgrading Your High-Availability Solution to SQL Server 2012 AlwaysOn Availability Groups

Description:

With SQL Server 2012 AlwaysOn Availability Groups Microsoft has substantially changed the way you can design your high-availability solutions. With read-only replicas that can be used for offloading your reports, backups and consistency checks this promises to be technology that can deliver a number of business benefits. In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the architecture of this new feature in SQL Server 2012 and the high-availability opportunities it presents. Victor will also cover how AlwaysOn Availability Groups can change how you maintain your database solutions so as to minimize the impact on production databases.