SQLSaturday #196 - Denmark 20134/20/2013 12:00:00 AM(GMT+01:00) Brussels, Copenhagen, Madrid, ParisSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat196Microsoft DenmarkTuborg Boulevard 12Hellerup , Denmark29003058SolidQ NordicPlatinumhttp://www.solidq.dkhttp://www.solidq.com/SiteCollectionImages/Web/logo.png601703088PlatonPlatinumhttp://www.platon.net/http://www.sqlsug.dk/sponsors/platon.jpg601703173Fusion-io Denmark ApS - c/o Beierholm Statsaut. RePlatinumhttp://www.fusionio.comhttp://www.sqlsug.dk/sponsors/logo_Fusion-io.jpg601703268Kapacity A/SGold Sponsorhttp://www.kapacity.dkhttp://www.kapacity.dk/images/KPI_Logo_Redbox_SQL.jpg601703147KMD A/SGold Sponsorhttp://www.kmd.dkhttp://www.kmd.dk/PublishingImages/Kommunikation/Billedarkiv/Logoer/72dpi/logo_72.jpg601703073d60Gold Sponsorhttp://www.d60.dk/http://sqlsug.dk/sponsors/Logo_d60.jpg6017031724D KonsulenterneSilver Sponsorwww.4d.dkhttp://www.4d.dk/_layouts/1030/4d/gfx/4dLogo.png601702909Rehfeld Silver Sponsorhttp://www.rehfeld.dkhttp://dikutal.dk/sites/default/files/imagecache/sponsor_logo/logos/rehfeld.png601703055Red Gate SoftwareSilver Sponsorhttp://redg.at/12sjcJyhttp://www.red-gate.com/assets/images/common/logo.png601703063Geniiius ApSBronze Sponsorhttp://www.geniiius.comhttp://www.geniiius.com/Uploads/GeniiiusLogo_170x60.jpg6017012807André Kamman I’m a SQL Server consultant based in the Netherlands, an MVP and I'm part of the team that runs the Dutch PASS Chapter SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers.
Currently the better part of my day is spent with SSIS.
In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that ;-)@andrekammanhttp://andrekamman.comhttps://api.twitter.com/1/users/profile_image?screen_name=@andrekamman484813851Andreas WolterAndreas Wolter is a Microsoft Certified Master SQL Server 2008 (MCM) and holds numerous other certifications, including MCT, MCITPDD, MCITPBID, MCITPDA, MCDBA, and MCSA.
He has worked with SQL Server for over a decade as trainer, consultant and architect and as being active member of the PASS since several years he is a speaker at various international conferences.
His company, Sarpedon Quality Lab (www.SarpedonQualityLab.com specializes on scalable, performing and secure OLTP OLAP deploymen@AndreasWolterhttp://de.linkedin.com/in/andreaswolterhttp://www.vb-magazin.de/forums/blogs/andreaswolterhttps://api.twitter.com/1/users/profile_image?screen_name=@AndreasWolter484814359Belkis Ozhorasan
Belkis has been a db developer and DBA for the last 12 years on SQL Server since 7.0 working with DBMS project of Land Registry Office of Turkey at Microsoft Partner, and Oracle DBA at Altay Sti which is the Turkey partner of Lockheed Martin. Before that; she was research assistant teaching database courses at university. She has been working as a Senior Premier Field Engineer at Microsoft on SQL Server last 2,5 years.
http://www.linkedin.com/in/belkisohttps://api.twitter.com/1/users/profile_image?screen_name=484813091Bob DuffyBob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and now Analysis Services “Maestro” certified.
Bob currently is the lead database architect at the Prodata SQL Centre off Excellence in Dublin, Ireland where he helps enterprise customers with design, performance tuning, benchmarking and pretty much anything to do with SQL Server or Business Intelligence.
@bob_duffyhttp://www.linkedin.com/pub/bob-duffy/2/943/b63http://blogs.prodata.ie/authors/bob.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@bob_duffy484812443Bruno BastoSenior trainer and senior consultant at Rumos. First certification in SQL Server 6.5 in 1998. Work with MSFT tools and infrastructure since 1992 with projects in the financial marketing, banking and project management. Responsible for several training projects for software solutions with MSFT infrastructure delivered in Portugal, Brazil and USA.@bvbastohttp://www.linkedin.com/profile/view?id=13726197trk=tab_prohttp://sql.pt/https://api.twitter.com/1/users/profile_image?screen_name=@bvbasto484813253Daniel LewandowskiDaniel has been a college instructor and high school teacher, network engineer, and tour guide along the way to starting LewiCool Consulting. MicroSoft Business Intelligence Consultancy with BI experience in enterprise organizations spanning multi-million dollar corportations to government, telecom to education. Striving to enable business with technology, with secure maintainable sustainable solutions that help the business attain success in whatever the endeavor. @lewicoolchttp://www.linkedin.com/pub/danielkinghttps://api.twitter.com/1/users/profile_image?screen_name=@lewicoolc484813599David SmeetsDavid Smeets has been active as A BI professional for 8 years now. Currently he is working as a SharePoint BI Consultant at CTG Belgium where he has completed several SharePoint BI projects and assisted clients in improving their BI environment. In 2012 he was a speaker for the Belgium BIWUG and active as a speaker for Sharepoint Europe. In 2012 he also won the Belgium Microsoft contest: So you think you can demo (BI track) with a HealthCare BI solution.@SmeetsDavidhttps://api.twitter.com/1/users/profile_image?screen_name=@SmeetsDavid484814952David Peter HansenDavid Peter Hansen is a BI Technical Solution Lead at Maersk Line, the world largest shipping company. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He specialises in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions.@dphansenhttp://www.linkedin.com/in/davidpeterhansenhttp://dave.dkhttps://api.twitter.com/1/users/profile_image?screen_name=@dphansen484813797Dennis Mark ThorsenMaster of science in Economics
IT Consulting since 2006
Interests:
SQL Server Business intelligence
.NET
Data mining
Sharepoint@dennistdk1http://www.linkedin.com/in/dennismarkthorsenhttp://dennismarkthorsen.blogspot.dk/https://api.twitter.com/1/users/profile_image?screen_name=@dennistdk1484813180Denny CherryDenny Cherry (MCSA, MCDBA, MCTS, MCITP) is the Manager of Information Systems for Awareness Technologies in Marina del Rey, California. In this role he manages not only the production databases, but also the entire production environment including the VMware environment, SAN Storage Array, Windows Domain and all production virtual servers.@mrdennywww.linkedin.com/in/mrdennyhttp://itke.mrdenny.com/SQL-serverhttps://api.twitter.com/1/users/profile_image?screen_name=@mrdenny484812416Emanuele ZanchettinIn 1998 my adventure begins with DB2, Access and Oracle. Since 2007 almost completely immersed in SQLServer technology: 2K, 2005, 2008*, 2012 and SQLAzure. Also, recently I have acquired skills on MySQL. I had participated as a speaker about SQLServer technologies at XeDotNet Community (Venice - Italy) and SQLSaturday#176 (Pordenone - Italy), now as the first time in DK.@_thinkIT_it.linkedin.com/pub/emanuele-zanchettin/18/921/34/http://www.thinkit.it/https://api.twitter.com/1/users/profile_image?screen_name=@_thinkIT_484812306Erik SvensenInformation worker and Business Intelligence specialist in a wide variety of business applications. Particularly interested MS Excel, MS-SQL Server, SSAS and SSRS.@donsvensenhttp://dk.linkedin.com/in/eriksvensenhttp://eriksvensen.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@donsvensen484812120Gianluca HotzGianluca Hotz is a consultant, trainer and speaker at SolidQ specialized in architecture, database design, high availability, capacity planning, performance tuning, system integration and migrations for Microsoft SQL Server. He has been working as a consultant in the IT field since 1993 and with SQL Server since 1996. He is among the original founders of ugiss.org, where he is serving as vice-president since 2001, for his contribution to the community he has been a SQL Server MVP since 1998.@glhotzhttp://it.linkedin.com/in/ghotzhttp://www.ghotz.comhttps://api.twitter.com/1/users/profile_image?screen_name=@glhotz484812845Jen StirrupJen is best-known for her work in Business Intelligence and Data Visualisation. Jen is a SQL Server MVP who is the current holder of the SQLPassion Award, presented by PASS at Summit 2012, for her work in helping the European SQL Server community. Jen has presented at TechEd North America, TechEd Europe, SQLPass and SQLBIts, along with SQLSaturday events throughout Europe. Jen runs Copper Blue Consulting with Allan Mitchell, delivering business-critical solutions that add business value.@jenstirruphttp://www.linkedin.com/in/jenstirruphttp://www.jenstirrup.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jenstirrup484812227Jens VestergaardJens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services to report in Reporting Services, Targit or similar tool. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in MS SQL Server, Jens has also worked with Microsoft. Net platform for more than 10 years. @vestergaardjhttp://www.linkedin.com/in/jvestergaardhttp://www.t-sql.dkhttps://api.twitter.com/1/users/profile_image?screen_name=@vestergaardj484813548Kennie PontoppidanKennie Nybo Pontoppidan works as a database/BI consultant for the company Rehfeld in Denmark. He has worked in the dangerous field between developers and dba’s for the last 7 years and done his part of performance mistakes as a developer before that in his 13 years in the it industry. He enjoys working with databases (Oracle and SQL Server) and really, really enjoys working using sql. He holds a master degree in pure math, statistics and theoretical physics and a second one in IT operations@KennieNPhttp://www.linkedin.com/in/kenniehttps://api.twitter.com/1/users/profile_image?screen_name=@KennieNP484812971Mark S. RasmussenMark, a SQL Server MVP, has worked extensively with SQL Server, primarily focused on performance optimization and internals. Besides SQL Server, Mark is also proficient in the Microsoft .NET development stack with a decade of experience. Fueled by his interest in the nitty-gritty details, Mark started the OrcaMDF open source project that aims to provide a completely standalone parser for SQL Server MDF files. Furthermore he blogs actively at http://improve.dk and tweets at @improvedk@improvedkhttp://www.linkedin.com/in/markrasmussenhttp://improve.dkhttps://api.twitter.com/1/users/profile_image?screen_name=@improvedk484813662Michael FrandsenWorked in the IT industry for just over 22 years, 18 of these as a consultant.
I have a close relationship with Microsoft RD in Redmond, with the Windows team for 20 years, ever since the first beta of Windows NT 3.1, SQL server for 19 years, since the first version, v4.21a – I am in various advisory positions in Redmond and am involved in vNext versions of Windows, Hyper-V, SQL Server and Office/SharePoint
Focus areas: High performance, Scalability, Consolidation, VLDB,DW,BI, High-Availabilihttp://dk.linkedin.com/in/michaelfrandsendk484813058Mihail MateevMihail Mateev is a Senior Technical Evangelist, Team Lead at Infragistics Inc. He worked as a Software developer and team lead on WPF
and Silverlight Line of Business production lines of the company. Mihail worked
in various areas related to technology Microsoft: Silverlight, WPF, Windows Phone 7, Visual Studio LightSwitch, WCF RIA Services,
ASP.Net MVC, Windows Metro Applications, MS SQL Server and Windows Azure. He is also SQLSaturday Bulgaria administrator.@mihailmateevhttp://www.linkedin.com/pub/mihail-mateev/1/6b3/4b1http://blogs.infragistics.com/blogs/mihail_mateev/https://api.twitter.com/1/users/profile_image?screen_name=@mihailmateev484814920Mikael WedhamMikael Wedham is the first Microsoft Certified Master on SQL Server 2008 in Sweden.
He has worked as a developer and database administrator since 1993, and also been a support technician.
In 1997, Mikael became a Microsoft Certified Trainer, and is now an appreciated teacher in the .NET and SQL areas.
He has also helped the Swedish Microsoft Technical Education centers develop a program for coaching towards certification.
Mikael was one of the first in Sweden giving lectures in Microsoft O484813758Niels Leth GammelgaardNiels Gammelgaard works as a consultant with Platon A/S in the area of BI and advanced analytics. With experience both as a predictive analyst and solution developer, he enjoys working will all aspects of value extraction from data. He holds a PhD in mathematical physics.http://www.linkedin.com/profile/view?id=5088430trk=tab_pro484813900Niko NeugebauerNiko Neugebauer is a Community Evangelist for PASS. A SQL Server MVP with over 15 years experience in IT, he is very passionate about SQL Server and Community. He is a founder and a leader of the Portuguese SQL Server User Group, SQLPort (http://www.sqlport.com). His passion about SQLSaturday led him to organise the first SQLSaturday outside of North America – SQLSaturday #78. Niko has already presented at PASS Summit, SQLRally Nordic, and SQLSaturdays all around the world.@NikoNeugebauerhttp://pt.linkedin.com/in/webcaravelahttp://www.nikoport.comhttps://api.twitter.com/1/users/profile_image?screen_name=@NikoNeugebauer484813728Pedro CorreiaPedro Correia was born in 1976 on the 265th day of that year. He is currently responsible for the Data Information System that supports the Portuguese e.school Program that delivered more than 1.5 million laptops to students and teachers in Portugal. He is also a SQL Server trainer and teaching is one of his passions. 2012 was a year focused on the certification of competences and skills gained over the years, namely becoming one of the few Microsoft Certified Master - SQL Server 2008.@pjcorreiasqlhttp://pt.linkedin.com/in/pjcorreia/http://sql.pthttps://api.twitter.com/1/users/profile_image?screen_name=@pjcorreiasql484812304Peter LarssonPeter Larsson is a key player for performance written code.
He can turn a 10 hour query into a 3 minute piece of code. Peter is also a SQL Server MVP since 2009. He often hangs out at SQLTeam.com (27k+ posts) and other various sites where he helps all people understand SQL Server.@SwePesohttp://www.sqltopia.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SwePeso484814921Regis BaccaroRégis has 10 years of experience with Business Intelligence, SQL Server, SharePoint and .Net. His background and work experience mixes technology and business, providing him a unique edge to contribute to BI projects and developing, being able to effectively interact with technical and business decision makers.
He has a wide experience as speaker at different IT conferences and contributor to books and whitepapers. Latest the Microsoft upgrade guide to SQL Server 2012.
@regbachttp://dk.linkedin.com/in/regisbaccarohttp://theblobfarm.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@regbac484812474Salvatore Buccoliero Sr. Systems Engineer at Fusion-io since 2012. Responsible for Scandinavian customers deploying low latency Nand flash. Works as architect, consultant and trusted advisor. Working topics range from Open source DB’s on all types of Linux flavors to Windows with SQL server. Install types range from Single server optimizing Cubes to multiple broadcasting streaming servers over cloud based internet gaming communities.@thomaskejserhttps://api.twitter.com/1/users/profile_image?screen_name=@thomaskejser484812121Scott KleinScott Klein is a Windows Azure Technical Evangelist for Microsoft, focusing on Windows Azure data services, including Windows Azure SQL Database and Windows Azure Storage. Scott has been working with SQL Server for over 20 years. Prior to Microsoft Scott was one of the first 4 SQL Azure MVPs. Scott is the author of over ½ dozen books, including Pro SQL Azure by APress. He can also be found speaking at conferences around the world, such as TechEd, DevConnections, and SQL PASS.@SQLScotthttp://www.linkedin.com/in/sqlscotthttp://www.scottlklein.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLScott484812122Scott KleinScott Klein is a Windows Azure Technical Evangelist for Microsoft, focusing on Windows Azure data services, including Windows Azure SQL Database and Windows Azure Storage. Scott has been working with SQL Server for over 20 years. Prior to Microsoft Scott was one of the first 4 SQL Azure MVPs. Scott is the author of over ½ dozen books, including Pro SQL Azure by APress. He can also be found speaking at conferences around the world, such as TechEd, DevConnections, and SQL PASS.@SQLScotthttp://www.linkedin.com/in/sqlscotthttp://www.scottlklein.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLScott48481211512115SQLSatruday 196Track 1DiscoveryCoffee Break4/20/2013 3:20:00 PM4/20/2013 3:50:00 PM1211512115SQLSatruday 196Track 2JupiterCoffee Break4/20/2013 3:20:00 PM4/20/2013 3:50:00 PM1211512115SQLSatruday 196Track 3Meeting room A+BCoffee Break4/20/2013 3:20:00 PM4/20/2013 3:50:00 PM1211512115SQLSatruday 196Track 4EnterpriseCoffee Break4/20/2013 3:20:00 PM4/20/2013 3:50:00 PM1211612116SQLSaturday 196Track 4EnterpriseLunch Break4/20/2013 12:30:00 PM4/20/2013 1:00:00 PM1211612116SQLSaturday 196Track 3Meeting room A+BLunch Break4/20/2013 12:30:00 PM4/20/2013 1:00:00 PM1211612116SQLSaturday 196Track 2JupiterLunch Break4/20/2013 12:30:00 PM4/20/2013 1:00:00 PM1211612116SQLSaturday 196Track 1DiscoveryLunch Break4/20/2013 12:30:00 PM4/20/2013 1:00:00 PM1211712117SQLSaturday 196Track 1DiscoveryRegistrations4/20/2013 7:30:00 AM4/20/2013 8:30:00 AM1211712117SQLSaturday 196Track 2JupiterRegistrations4/20/2013 7:30:00 AM4/20/2013 8:30:00 AM1211712117SQLSaturday 196Track 3Meeting room A+BRegistrations4/20/2013 7:30:00 AM4/20/2013 8:30:00 AM1211712117SQLSaturday 196Track 4EnterpriseRegistrations4/20/2013 7:30:00 AM4/20/2013 8:30:00 AM1211812118SQLSaturday 196Track 4EnterpriseRaffle4/20/2013 6:10:00 PM4/20/2013 7:00:00 PM1211812118SQLSaturday 196Track 3Meeting room A+BRaffle4/20/2013 6:10:00 PM4/20/2013 7:00:00 PM1211812118SQLSaturday 196Track 2JupiterRaffle4/20/2013 6:10:00 PM4/20/2013 7:00:00 PM1211812118SQLSaturday 196Track 1DiscoveryRaffle4/20/2013 6:10:00 PM4/20/2013 7:00:00 PM1212012120Gianluca HotzTrack 1DiscoverySQL Server 2012 AlwaysOnBusiness 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 AM4/20/2013 11:10:00 AM1212112121Scott KleinTrack 1DiscoveryKung Fu Migration to Windows Azure SQL DatabaseAs 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 AM4/20/2013 9:30:00 AM1212212122Scott KleinTrack 1DiscoveryCloud Database Scalability with SQL FederationYou 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 PM4/20/2013 6:00:00 PM1222712227Jens VestergaardTrack 4EnterpriseThe Power of Custom Assemblies in Analysis ServiceSometimes 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 perfo4/20/2013 10:10:00 AM4/20/2013 11:10:00 AM1230412304Peter LarssonTrack 4EnterpriseRemodel your old EAV designSometimes 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 PM4/20/2013 6:00:00 PM1230612306Erik SvensenTrack 2JupiterDesign a Metro Style Dashboard with Excel PowerPSee 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 PM4/20/2013 6:00:00 PM1241612416Emanuele ZanchettinTrack 4EnterpriseSQLServer2012 as semantic search engineWith 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 PM4/20/2013 2:10:00 PM1244312443Bruno BastoTrack 2JupiterSQL Internal StorageThis 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 AM4/20/2013 9:30:00 AM1247412474Salvatore Buccoliero Track 2JupiterAccelerating SQL 2012 Clustering with NAND FlashA 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 AM4/20/2013 12:20:00 PM1280712807André KammanTrack 3Meeting room A+BETL Shootout, SSIS vs PowershellI 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 AM4/20/2013 11:10:00 AM1284512845Jen StirrupTrack 1DiscoveryPower View from the Data Visualisation PerspectivePower 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 PM4/20/2013 4:50:00 PM1297112971Mark S. RasmussenTrack 1DiscoveryStoring Character Data OptimallySo 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 PM4/20/2013 2:10:00 PM1305813058Mihail MateevTrack 3Meeting room A+BSpatial Data and Windows Azure SQL DatabaseSpatial 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 PM4/20/2013 2:10:00 PM1309113091Bob DuffyTrack 2JupiterMigrating to the Azure and the CloudSo 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 AM4/20/2013 11:10:00 AM1318013180Denny CherryTrack 1DiscoveryGetting SQL Service Broker Up and RunningMicrosoft 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 PM4/20/2013 3:20:00 PM1325313253Daniel LewandowskiTrack 3Meeting room A+BSecuring the Cube; SSAS security framework 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 PM4/20/2013 3:20:00 PM1354813548Kennie PontoppidanTrack 4EnterpriseSQL anti patternsYou 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 AM4/20/2013 9:30:00 AM1359913599David SmeetsTrack 3Meeting room A+BData-driven Subscription using SSIS and SharePointSQL 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 PM4/20/2013 6:00:00 PM1366213662Michael FrandsenTrack 1DiscoveryWindows Server 2012 Infrastructure for SQL ServerWith 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 forward4/20/2013 11:20:00 AM4/20/2013 12:20:00 PM1372813728Pedro CorreiaTrack 2JupiterCAST([Transaction Log] as T.SQL) 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 PM4/20/2013 2:10:00 PM1375813758Niels Leth GammelgaardTrack 4EnterpriseDecisions, Decisions...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 AM4/20/2013 12:20:00 PM1379713797Dennis Mark ThorsenTrack 3Meeting room A+BData mining with Analysis ServicesThis 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 SSIS4/20/2013 11:20:00 AM4/20/2013 12:20:00 PM1385113851Andreas WolterTrack 2Jupiter Tracing with Extended Events. - Adios Profiler“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 PM4/20/2013 4:50:00 PM1390013900Niko NeugebauerTrack 4EnterpriseAnalyzing Twitter DataThis 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 PM4/20/2013 3:20:00 PM1418014180Key NoteTrack 4EnterpriseKeynoteKeynote4/20/2013 9:40:00 AM4/20/2013 10:00:00 AM1418014180Key NoteTrack 3Meeting room A+BKeynoteKeynote4/20/2013 9:40:00 AM4/20/2013 10:00:00 AM1418014180Key NoteTrack 2JupiterKeynoteKeynote4/20/2013 9:40:00 AM4/20/2013 10:00:00 AM1418014180Key NoteTrack 1DiscoveryKeynoteKeynote4/20/2013 9:40:00 AM4/20/2013 10:00:00 AM1435914359Belkis OzhorasanTrack 3Meeting room A+BSQL Server 2012 Parallel Data WarehouseThis 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 AM4/20/2013 9:30:00 AM1492014920Mikael WedhamTrack 4EnterpriseWhat's with my backups? How stuff works.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 PM4/20/2013 4:50:00 PM1492114921Regis BaccaroTrack 3Meeting room A+BDatabase development with SSDTSQL 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 PM4/20/2013 4:50:00 PM1495214952David Peter HansenTrack 2JupiterLayered Partitioning - manage very large data setsLoading 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 PM4/20/2013 3:20:00 PM