SQLSaturday #196 - Denmark 2013 4/20/2013 12:00:00 AM (GMT+01:00) Brussels, Copenhagen, Madrid, Paris SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat196 Microsoft Denmark Tuborg Boulevard 12 Hellerup , Denmark 2900 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 3058 SolidQ Nordic Platinum http://www.solidq.dk http://www.solidq.com/SiteCollectionImages/Web/logo.png 60 170 3088 Platon Platinum http://www.platon.net/ http://www.sqlsug.dk/sponsors/platon.jpg 60 170 3173 Fusion-io Denmark ApS - c/o Beierholm Statsaut. Re Platinum http://www.fusionio.com http://www.sqlsug.dk/sponsors/logo_Fusion-io.jpg 60 170 3073 d60 Gold Sponsor http://www.d60.dk/ http://sqlsug.dk/sponsors/Logo_d60.jpg 60 170 3147 KMD A/S Gold Sponsor http://www.kmd.dk http://www.kmd.dk/PublishingImages/Kommunikation/Billedarkiv/Logoer/72dpi/logo_72.jpg 60 170 3268 Kapacity A/S Gold Sponsor http://www.kapacity.dk http://www.kapacity.dk/images/KPI_Logo_Redbox_SQL.jpg 60 170 2909 Rehfeld Silver Sponsor http://www.rehfeld.dk http://dikutal.dk/sites/default/files/imagecache/sponsor_logo/logos/rehfeld.png 60 170 3055 Red Gate Software Silver Sponsor http://redg.at/12sjcJy http://www.red-gate.com/assets/images/common/logo.png 60 170 3172 4D Konsulenterne Silver Sponsor www.4d.dk http://www.4d.dk/_layouts/1030/4d/gfx/4dLogo.png 60 170 3063 Geniiius ApS Bronze Sponsor http://www.geniiius.com http://www.geniiius.com/Uploads/GeniiiusLogo_170x60.jpg 60 170 12115 SQLSatruday 196 Track 1 Discovery 4/20/2013 3:20:00 PM 4/20/2013 3:50:00 PM 12115 SQLSatruday 196 Track 2 Jupiter 4/20/2013 3:20:00 PM 4/20/2013 3:50:00 PM 12115 SQLSatruday 196 Track 3 Meeting room A+B 4/20/2013 3:20:00 PM 4/20/2013 3:50:00 PM 12115 SQLSatruday 196 Track 4 Enterprise 4/20/2013 3:20:00 PM 4/20/2013 3:50:00 PM 12116 SQLSaturday 196 Track 4 Enterprise 4/20/2013 12:30:00 PM 4/20/2013 1:00:00 PM 12116 SQLSaturday 196 Track 3 Meeting room A+B 4/20/2013 12:30:00 PM 4/20/2013 1:00:00 PM 12116 SQLSaturday 196 Track 2 Jupiter 4/20/2013 12:30:00 PM 4/20/2013 1:00:00 PM 12116 SQLSaturday 196 Track 1 Discovery 4/20/2013 12:30:00 PM 4/20/2013 1:00:00 PM 12117 SQLSaturday 196 Track 1 Discovery 4/20/2013 7:30:00 AM 4/20/2013 8:30:00 AM 12117 SQLSaturday 196 Track 2 Jupiter 4/20/2013 7:30:00 AM 4/20/2013 8:30:00 AM 12117 SQLSaturday 196 Track 3 Meeting room A+B 4/20/2013 7:30:00 AM 4/20/2013 8:30:00 AM 12117 SQLSaturday 196 Track 4 Enterprise 4/20/2013 7:30:00 AM 4/20/2013 8:30:00 AM 12118 SQLSaturday 196 Track 4 Enterprise 4/20/2013 6:10:00 PM 4/20/2013 7:00:00 PM 12118 SQLSaturday 196 Track 3 Meeting room A+B 4/20/2013 6:10:00 PM 4/20/2013 7:00:00 PM 12118 SQLSaturday 196 Track 2 Jupiter 4/20/2013 6:10:00 PM 4/20/2013 7:00:00 PM 12118 SQLSaturday 196 Track 1 Discovery 4/20/2013 6:10:00 PM 4/20/2013 7:00:00 PM 12120 Gianluca Hotz Track 1 Discovery 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. 4/20/2013 10:10:00 AM 4/20/2013 11:10:00 AM 12121 Scott Klein Track 1 Discovery As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master. 4/20/2013 8:30:00 AM 4/20/2013 9:30:00 AM 12122 Scott Klein Track 1 Discovery 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. 4/20/2013 5:00:00 PM 4/20/2013 6:00:00 PM 12227 Jens Vestergaard Track 4 Enterprise 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 4/20/2013 10:10:00 AM 4/20/2013 11:10:00 AM 12304 Peter Larsson Track 4 Enterprise 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. 4/20/2013 5:00:00 PM 4/20/2013 6:00:00 PM 12306 Erik Svensen Track 2 Jupiter 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. 4/20/2013 5:00:00 PM 4/20/2013 6:00:00 PM 12416 Emanuele Zanchettin Track 4 Enterprise 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. 4/20/2013 1:10:00 PM 4/20/2013 2:10:00 PM 12443 Bruno Basto Track 2 Jupiter 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. 4/20/2013 8:30:00 AM 4/20/2013 9:30:00 AM 12474 Salvatore Buccoliero Track 2 Jupiter 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? 4/20/2013 11:20:00 AM 4/20/2013 12:20:00 PM 12807 André Kamman Track 3 Meeting room A+B 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' 4/20/2013 10:10:00 AM 4/20/2013 11:10:00 AM 12845 Jen Stirrup Track 1 Discovery 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: - 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. 4/20/2013 3:50:00 PM 4/20/2013 4:50:00 PM 12971 Mark S. Rasmussen Track 1 Discovery 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. 4/20/2013 1:10:00 PM 4/20/2013 2:10:00 PM 13058 Mihail Mateev Track 3 Meeting room A+B Spatial Data is very important for the new applications, related with Data Visualization and BI. Windows Azure offers possibility to use 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. 4/20/2013 1:10:00 PM 4/20/2013 2:10:00 PM 13091 Bob Duffy Track 2 Jupiter 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. 4/20/2013 10:10:00 AM 4/20/2013 11:10:00 AM 13180 Denny Cherry Track 1 Discovery 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). 4/20/2013 2:20:00 PM 4/20/2013 3:20:00 PM 13253 Daniel Lewandowski Track 3 Meeting room A+B 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. 4/20/2013 2:20:00 PM 4/20/2013 3:20:00 PM 13548 Kennie Pontoppidan Track 4 Enterprise 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. 4/20/2013 8:30:00 AM 4/20/2013 9:30:00 AM 13599 David Smeets Track 3 Meeting room A+B 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. 4/20/2013 5:00:00 PM 4/20/2013 6:00:00 PM 13662 Michael Frandsen Track 1 Discovery 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 4/20/2013 11:20:00 AM 4/20/2013 12:20:00 PM 13728 Pedro Correia Track 2 Jupiter 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. 4/20/2013 1:10:00 PM 4/20/2013 2:10:00 PM 13758 Niels Leth Gammelgaard Track 4 Enterprise 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. 4/20/2013 11:20:00 AM 4/20/2013 12:20:00 PM 13797 Dennis Mark Thorsen Track 3 Meeting room A+B 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 4/20/2013 11:20:00 AM 4/20/2013 12:20:00 PM 13851 Andreas Wolter Track 2 Jupiter “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“) 4/20/2013 3:50:00 PM 4/20/2013 4:50:00 PM 13900 Niko Neugebauer Track 4 Enterprise 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. 4/20/2013 2:20:00 PM 4/20/2013 3:20:00 PM 14180 Key Note Track 4 Enterprise Keynote 4/20/2013 9:40:00 AM 4/20/2013 10:00:00 AM 14180 Key Note Track 3 Meeting room A+B Keynote 4/20/2013 9:40:00 AM 4/20/2013 10:00:00 AM 14180 Key Note Track 2 Jupiter Keynote 4/20/2013 9:40:00 AM 4/20/2013 10:00:00 AM 14180 Key Note Track 1 Discovery Keynote 4/20/2013 9:40:00 AM 4/20/2013 10:00:00 AM 14359 Belkis Ozhorasan Track 3 Meeting room A+B 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. 4/20/2013 8:30:00 AM 4/20/2013 9:30:00 AM 14920 Mikael Wedham Track 4 Enterprise What does really take place when you do a full backup? Has it always been like that , or has the method used for taking backups changed? What is included in a backup and why doesn't it clear my log. Differential and log backups explained, as well as a quick look how tho find what your backupdevices contain. The explanations will be accompanied by scripts and discussion about VLFs, LSNs and other useful acronyms. Also included is a full demo about how you could track the sequence of your backups, and how to detect missing logchains. 4/20/2013 3:50:00 PM 4/20/2013 4:50:00 PM 14921 Regis Baccaro Track 3 Meeting room A+B 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. 4/20/2013 3:50:00 PM 4/20/2013 4:50:00 PM 14952 David Peter Hansen Track 2 Jupiter Loading and managing large data sets in your Data Warehouse is not always a trivial task. Especially if the source systems can re-deliver data and you want to replace an old subset of your data. The quick answer you always hear is “just use partitioning”, but nobody really tells you how you should design or implement it. This session will show one way to load and manage your very large data sets, by using layered partitioning. We will walk through partitioned tables and partitioned views, before moving on to the concept of layered partitioning. 4/20/2013 2:20:00 PM 4/20/2013 3:20:00 PM