sqlsathistory

Nr: 196

Back to Main list

SQLSaturday #196 - Denmark 2013

Start Time (24h) Speaker Track Title
00:00:00 Belkis Ozhorasan Track 3 SQL Server 2012 Parallel Data Warehouse
00:00:00 Bob Duffy Track 2 Migrating to the Azure and the Cloud
00:00:00 Bruno Basto Track 2 SQL Internal Storage
00:00:00 Pedro Correia Track 2 CAST([Transaction Log] as T.SQL)
00:00:00 David Smeets Track 3 Data-driven Subscription using SSIS and SharePoint
00:00:00 Dennis Mark Thorsen Track 3 Data mining with Analysis Services
00:00:00 Erik Svensen Track 2 Design a Metro Style Dashboard with Excel PowerP
00:00:00 Emanuele Zanchettin Track 4 SQLServer2012 as semantic search engine
00:00:00 Gianluca Hotz Track 1 SQL Server 2012 AlwaysOn
00:00:00 Niko Neugebauer Track 4 Analyzing Twitter Data
00:00:00 Jen Stirrup Track 1 Power View from the Data Visualisation Perspective
00:00:00 Jens Vestergaard Track 4 The Power of Custom Assemblies in Analysis Service
00:00:00 Kennie Pontoppidan Track 4 SQL anti patterns
00:00:00 Daniel Lewandowski Track 3 Securing the Cube; SSAS security framework
00:00:00 Mark S. Rasmussen Track 1 Storing Character Data Optimally
00:00:00 Mihail Mateev Track 3 Spatial Data and Windows Azure SQL Database
00:00:00 Michael Frandsen Track 1 Windows Server 2012 Infrastructure for SQL Server
00:00:00 Denny Cherry Track 1 Getting SQL Service Broker Up and Running
00:00:00 Niels Leth Gammelgaard Track 4 Decisions, Decisions...
00:00:00 Peter Larsson Track 4 Remodel your old EAV design
00:00:00 Regis Baccaro Track 3 Database development with SSDT
00:00:00 Scott Klein Track 1 Kung Fu Migration to Windows Azure SQL Database
00:00:00 Scott Klein Track 1 Cloud Database Scalability with SQL Federation
00:00:00 Salvatore Buccoliero Track 2 Accelerating SQL 2012 Clustering with NAND Flash
00:00:00 André Kamman Track 3 ETL Shootout, SSIS vs Powershell
00:00:00 Andreas Wolter Track 2 Tracing with Extended Events. - Adios Profiler

SessionID: 10191

SQL Server 2012 Parallel Data Warehouse

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Belkis Ozhorasan

Title: SQL Server 2012 Parallel Data Warehouse

Abstract:

This session will give the attendee an overview on the architecture of Parallel Data Warehouse v2. It will give a perspective on where the PDW will fit in to the big picture of Big Data and the use cases where the PDW will be most efficient. The session will also include an introduction on how queries are built for the PDW solution.

SessionID: 10546

Migrating to the Azure and the Cloud

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Bob Duffy

Title: Migrating to the Azure and the Cloud

Abstract:

So your CTO wants you to migrate your mission critical database application to the cloud. What's involved and what are the pitfalls?

In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.

SessionID: 10991

SQL Internal Storage

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Bruno Basto

Title: SQL Internal Storage

Abstract:

This session describes how SQL Server internally stores table data. Although you can use SQL without understanding the internals of data storage, a deep knowledge of how data is stored will improve the development of efficient applications. This session explores the basic of metadata that keeps track of data and index storage information.

SessionID: 11827

CAST([Transaction Log] as T.SQL)

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Pedro Correia

Title: CAST([Transaction Log] as T.SQL)

Abstract:

The aim of this session is to take the audience in a quest for the original (or equivalent) T-SQL, that was in the origin of the different transactions recorded, by inspecting the transaction log records and dissecting its data. In a session that tackles several internals storage issues, needed to fulfill its objective, we will go in a travel that starts by the end of the log and will, hopefully, only end at the birth of the database.

SessionID: 12425

Data-driven Subscription using SSIS and SharePoint

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: David Smeets

Title: Data-driven Subscription using SSIS and SharePoint

Abstract:

SQL Server Reporting Services provides data-driven subscriptions to render reports based on information in a database table. This is a very nice feature but the down side is that you are required to purchase an Enterprise license (or BI license in SQL 2012) of SQL Server in order to use this feature. Customers like this feature but don't want to pay for the Enterprise license so I searched for an alternative with standard licenses. In this session I will show the alternative where the end user can still create his own subscription in SharePoint. Step-by-step I will create an SQL Server Integration Services package that renders reports to a SharePoint library on values stored in the database.

SessionID: 13182

Data mining with Analysis Services

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Dennis Mark Thorsen

Title: Data mining with Analysis Services

Abstract:

This will be an introduction to options available in Analysis Services for data mining. We will discuss Data mining project life-cycle (CRISP-DM), Target variables (categorical vs continuous), What models are available in SSAS and a bit on configuring them, Model viewing, Model evaluation , What is a categorization matrix and gain chart? DMX langauge and integration to SQL Studio and SSIS

SessionID: 13959

Design a Metro Style Dashboard with Excel PowerP

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Erik Svensen

Title: Design a Metro Style Dashboard with Excel PowerP

Abstract:

See how you can implement a Metro Style Dashboard in Excel based on a PowerPivot model in excel and how to make it dynamic with the Excel CUBE functions.

SessionID: 14130

SQLServer2012 as semantic search engine

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Emanuele Zanchettin

Title: SQLServer2012 as semantic search engine

Abstract:

SessionID: 14592

SQL Server 2012 AlwaysOn

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Gianluca Hotz

Title: SQL Server 2012 AlwaysOn

Abstract:

Business continuity is becoming more and more a central topic for many companies. AlwaysOn is the new solution for high availability and disaster recovery introduced with SQL Server 2012. With the help of live demos, in this session we will cover in details this new technology that extends on the familiar concepts of database mirroring and failover clustering. We will also introduce some other engine enhancements that will help raising the overall service availability.

SessionID: 15398

Analyzing Twitter Data

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Niko Neugebauer

Title: Analyzing Twitter Data

Abstract:

SessionID: 16561

Power View from the Data Visualisation Perspective

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Jen Stirrup

Title: Power View from the Data Visualisation Perspective

Abstract:

Power View is Microsoft's Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others. We will:

Come to this session if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View.

SessionID: 17806

The Power of Custom Assemblies in Analysis Service

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Jens Vestergaard

Title: The Power of Custom Assemblies in Analysis Service

Abstract:

Sometimes you are stuck with customer demands where common solutions just aren't scalable

within the Analysis Services (SSAS) regular toolbox. This is where custom assemblies come to save the day! Custom assemblies allow you to extend the power of SSAS by using other technologies, as in this case T-SQL and the SQL Server relational engine.

This session will demonstrate how to utilize custom assemblies in Analysis Services to leverage the power of the relational engine and use it directly in MDX. Through the .Net framework and T-SQL we will be able to inject dimension member unique names into MDX. Effectively we are replacing the MDX Crossjoins with the T-SQL Inner joins, whereby gaining scalability and consistency in query perfo

SessionID: 18101

SQL anti patterns

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Kennie Pontoppidan

Title: SQL anti patterns

Abstract:

You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.

We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.

SessionID: 19146

Securing the Cube; SSAS security framework

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Daniel Lewandowski

Title: Securing the Cube; SSAS security framework

Abstract:

Secure, Enable, Maintain, Sustain. In depth discussion on a SSAS security framework with SSIS maintenance toolkits. Create security roles in the cube that enable the business based on underlying data patterns. Presentation covers creation of roles in the cube, with a demo creating SSIS roles with a toolkit based on the adventureworks db model and cube. Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports. This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions.

SessionID: 19595

Storing Character Data Optimally

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Mark S. Rasmussen

Title: Storing Character Data Optimally

Abstract:

So you need to store character data in your database? Easy enough, you just create an nvarchar(MAX) field and you're done, right? It turns out, it's not so simple. First up you need to decide on a data type - should you use text? Char(100)? Varchar(100)? Or perhaps one of the (MAX) types? I'll go through the options we have, including a deep dive on how each data type differs in its storage on disk. Knowing this, we can make intelligent decisions on which type to use, as well as predicting actual performance implications. Knowing how to store character data optimally is an absolutely critical part of your job as a DBA.

SessionID: 20274

Spatial Data and Windows Azure SQL Database

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Mihail Mateev

Title: Spatial Data and Windows Azure SQL Database

Abstract:

advantages of spatial data suing cloud computing. In this lecture will talk about the use of spatial data in the Windows Azure - loading data from Windows Azure SQL Database Spatial, optimizing Windows Azure applications and their use of different types of customers: WEB based, WPF, WP7. We will learn how to import spatial data in different formats in Windows Azure SQL Database Spatial and will create a several sample Windows Azure applications, that use this data.

SessionID: 20367

Windows Server 2012 Infrastructure for SQL Server

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Michael Frandsen

Title: Windows Server 2012 Infrastructure for SQL Server

Abstract:

With Windows Server 2012 a paradigm shift is occurring in how SQL Server platforms are designed and built. Come and hear why you no longer will need a SAN to create a high-available SQL Server, why I/O is no longer a problem and why Hyper-V v3 Means virtualising SQL Server has made a big leap forward

SessionID: 21032

Getting SQL Service Broker Up and Running

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Denny Cherry

Title: Getting SQL Service Broker Up and Running

Abstract:

Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature.

In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting (as time allows).

SessionID: 21440

Decisions, Decisions...

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Niels Leth Gammelgaard

Title: Decisions, Decisions...

Abstract:

Decision-trees are the bread-and-butter of predictive modeling. Conceptually simple, fast to build and easy to interpret - yet quite powerful and versatile. They come in many flavors, from the smallest tree to vast (random) forests

This session will explain the basics of decision trees and demonstrate the process of building, interpreting, tuning, pruning and validating a simple model using the Data Mining components of SQL Server Analysis Services.

SessionID: 22177

Remodel your old EAV design

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Peter Larsson

Title: Remodel your old EAV design

Abstract:

Sometimes you really need an EAV model. In most cases they are ugly and slow.

After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.

There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.

SessionID: 22814

Database development with SSDT

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Regis Baccaro

Title: Database development with SSDT

Abstract:

SQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio. SSDT provides a rich SQL Server development experience with first class language services and VS integration, as well as declarative, model-based tools that can be utilized for both online and offline development. In this session we'll dive into Online and Offline development as well as the Productivity and tools that the SSDT team keeps providing to us.

SessionID: 24150

Kung Fu Migration to Windows Azure SQL Database

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Scott Klein

Title: Kung Fu Migration to Windows Azure SQL Database

Abstract:

SessionID: 24151

Cloud Database Scalability with SQL Federation

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Scott Klein

Title: Cloud Database Scalability with SQL Federation

Abstract:

You have migrated your SQL Server database to Windows Azure SQL Database (AKA SQL Azure), and you have migrated your application to Windows Azure. Now what? As the load on your database begins to increase, the need to scale your new SQL Database instance becomes a realization. In this demo-filled session we'll explore SQL Federation, Microsoft's solution for cloud database scalability. This session will look at the scalability model for the cloud and how SQL Federation solves the scale-out issue. We'll look at the architecture of SQL Federation and you can apply SQL Federation to your cloud database solution.

SessionID: 26938

Accelerating SQL 2012 Clustering with NAND Flash

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Salvatore Buccoliero

Title: Accelerating SQL 2012 Clustering with NAND Flash

Abstract:

A DBA running SQL Server 2008 or above will often think he has no alternative to shared storage in order to run High availability Clustering in terms of both performance as well High Availability. Understand if it is worth trading high latency Shared Storage with low Price/GB to Local, Low latency OS integrated NAND Flash with high price/GB by trading Host Memory and CPU cycles for I/O Using NAND Flash from Fusion-io Also, is there a potential License saving by running lower latency I/O and reducing CPU count?

SessionID: 34577

ETL Shootout, SSIS vs Powershell

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: André Kamman

Title: ETL Shootout, SSIS vs Powershell

Abstract:

I know what you're thinking, Powershell is not an ETL tool. And you're probably right.

But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS. I'll also discuss how you can work around a lot of that instead of switching to Powershell like I did. This session will be around 70% "why is this hard in SSIS and can you work around it?" and 30% "Look how cool Powershell is"

SessionID: 8807

Tracing with Extended Events. - Adios Profiler

Back to calendar

Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Andreas Wolter

Title: Tracing with Extended Events. - Adios Profiler

Abstract:

“Hasta la vista, Profiler.”  – Introduction into Tracing with Extended Events. Focus: historical deadlock Analysis. -

Extended Events, although in the product since SQL Server 2008 have been known to Insiders as an extremely well performing and flexible Tracing-Framework. Since SQL Server 2012 this important feature, which will replace SQL Trace, is available in SSMS. In this introductory to advanced session we will also especially have a look at the System Health Session and how it can be used for historical deadlock-analysis right out of the box. („Hasta la vista, Profiler. Hasta la vista Traceflags 1204, 1222“)