Nr: 196
SQLSaturday #196 - Denmark 2013
SessionID: 10191
SQL Server 2012 Parallel Data Warehouse
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
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
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Bruno Basto
Title: SQL Internal Storage
Abstract:
SessionID: 11827
CAST([Transaction Log] as T.SQL)
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
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:
SessionID: 13182
Data mining with Analysis Services
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
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
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Emanuele Zanchettin
Title: SQLServer2012 as semantic search engine
Abstract:
With the increase in the number of documents created, received and stored by computer, consequently increases the difficulty and time to retrieve these documents based on their content and meaning. With SQL Server 2012 and its new features of Filestream and FullText engine, it is possible to go beyond the "classical" management of key words and phrases linked to each document. Thanks to semantic search you can search for documents according to their meaning, find related documents and retrieve similar documents easily and effectively.
SessionID: 14592
SQL Server 2012 AlwaysOn
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
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Niko Neugebauer
Abstract:
This session will concentrate on explanation of how to start using and analysing the data from one of the most popular social networks - Twitter. We shall take a look at the different dashboards and we shall try to understand some of the meanings. This presentation shall try to explore the best of the existing Microsoft technologies for an accessible Twitter data analysis.
SessionID: 16561
Power View from the Data Visualisation Perspective
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:
- investigate Power View based on current cognitive research around Data Visualisation principles
- look at the features of Power View
- look at where Power View is supplemented by other parts of the Microsoft Business Intelligence stack
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
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
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
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
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
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
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:
SessionID: 21032
Getting SQL Service Broker Up and Running
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...
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
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
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
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Regis Baccaro
Title: Database development with SSDT
Abstract:
SessionID: 24150
Kung Fu Migration to Windows Azure SQL Database
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
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
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:
SessionID: 34577
ETL Shootout, SSIS vs Powershell
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: André Kamman
Title: ETL Shootout, SSIS vs Powershell
Abstract:
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
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“)