BEGIN:VCALENDAR METHOD:PUBLISH VERSION:2.0 PRODID:-//SQLBits/com BEGIN:VTIMEZONE TZID:GMT Standard Time BEGIN:STANDARD DTSTART:20081026T020000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10 TZOFFSETTO:+0000 TZOFFSETFROM:+0100 END:STANDARD BEGIN:DAYLIGHT DTSTART:20080330T010000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3 TZOFFSETTO:+0100 TZOFFSETFROM:+0000 END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT UID:SQLBITS1461 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Customer Stories From The Front Line. DESCRIPTION:Our Microsoft Support team deals with a lot of different types of customer issues\, and we want to share some of the stories from these. Join this full-day pre-con to learn from some of the top customer issues a nd trends Microsoft Support has faced. Explore the problem\, and then dive into how we fixed it!\n \;\nOur toolset for these solutions will invo lve tools you use every day\, along with some that push your limits. Did a nyone say\, &ldquo\;Debugger?&rdquo\; We will showcase real-world techniqu es that you can use to troubleshoot and resolve your top database issues\, focusing primarily on the Engine\, but also delving into other areas of S QL Server. And don&rsquo\;t forget about the demos. We will demonstrate ho w each issue occurred\, walk through how we identified and resolved the pr oblem\, and look at new support features in SQL Server 2012 to help you go ing forward. LOCATION:SQLBits Conference - G2 +G3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1462 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Performance Tuning with Indexes: Internals and Best Practice DESCRIPTION:\nIndexes allow SQL Server to access your data in the most effi cient manner. Understanding exactly how \; our indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries.  \;Knowing how indexes are useful can allow us to generalize some best practice\nrecommendations. \; In thi s seminar we&rsquo\;ll look at the following topics:\n\n.\n\nBasic Index S tructures\n \; \; \; Clustered vs nonclustered\n \; \;  \; Unique vs non-unique\n \; \; \; Included columns\n\nTo ols for Exploring Index Structures\n\nIndex maintenance\n \; \;&nb sp\; Page splits\n \; \; \; Fragmentation and Defragmentation\ n\nIndex Design Considerations\n \; \; \; AND&rsquo\;s/ OR&rsq uo\;s\n \; \; \; JOIN&rsquo\;s\n \; \; \; Composit e Indexes\n\nBest Practice Guidelines\n\nColumnstore Index Storage\n\nColu mnstore Index  \;Guidelines\n LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1463 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Extreme Data Recovery DESCRIPTION:Here's your chance to learn data recovery from the big dogs. Tw o Microsoft Certified Masters (MCMs) will take your Recovery game to an al l new level. Take a deep dive into SQL Server recovery and learn how to ha ndle a wide variety of data loss and corruption scenarios. The session wil l cover how to be prepared for\, prevent\, and recover data lost due to de letion or corruption.\n\nLearn the following skills in this session:\n\n Built-in functionality in SQL Server for preventing and detecting corrup tion that you may not even know about\n How to identify a specific tran saction in the transaction log and recover data lost from that transaction \n Categories of corruption and how to manage recovery differently for each one \n\nDon't come empty handed. Bring your laptops\, and we'll prac tice recovering corrupt databases together. LOCATION:SQLBits Conference - 3C PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1464 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:From 0 to DAX DESCRIPTION:This session will be presented by Marco Russo and Alberto Ferra ri. The DAX language is the foundation of self-service Business Intelligen ce using the Microsoft stack. It is the language used to query and program both PowerPivot for Excel 2013 and the new SQL Server Analysis Services T abular model. Learning the basics of DAX is very simple\, but mastering it is a different story because it requires a mindset that requires some stu dy\, for both BI Professionals and Information Workers.\n\nDuring this one -day workshop\, the authors of the best seller books Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model and Microsoft PowerPivot fo r Excel 2010: Give your Data Meaning will guide you in the process of lear ning the DAX language\, through many examples and scenarios\nthat will hel p you understand what are the important concepts of DAX and how to leverag e them in the everyday work.\n\nThe workshop is useful to many profiles:\n Information Workers interested in exploiting the many interesting features of\nPowerPivot for Excel 2013 and BI developers who want to learn the DAX language. LOCATION:SQLBits Conference - Worcester PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1465 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Practical SQL Server Performance Troubleshooting DESCRIPTION:In this precon we will take a default installation of SQL Serve r\, and run a OLTP workload with a several hundred users to generate our i nitial baseline for performance tuning/troubleshooting. Throughout the day we will work across various areas of SQL Server to implement different pe rformance optimizations\, and check how those changes will impact the thro ughput of our test workload. At the end of the day we will have a well-per forming SQL Server which can handle a much larger workload than the initia l (default) installation.\n\nFollowing areas are covered in this precon:\n *) Windows OS Settings\n*) Storage Configuration\n*) SQL Server Instance S ettings\n*) Database Settings\n*) Index/Statistics Maintenance\n*) Locking /Blocking/Deadlocking\n*) Memory Management LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1466 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:SSDT Database projects from the ground-up DESCRIPTION:SQL Server Data Tools (SSDT) database projects bring SQL Server development into the modern era. Come along and learn how SSDT database p rojects can accelerate your SQL Server development and deployments. You wi ll learn about declarative database development\, code navigation\, refact oring\, automated builds\, database unit testing and\, most importantly\, how you can make these tools work to your advantage. \; LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1467 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Real World SSIS: A Survival Guide DESCRIPTION:Moving and transforming data can be a difficult job.  \;Con necting to various endpoints\, applying complex transformations\, performi ng validation checks\, creating an appropriate audit trail\, and other tas ks can make the ETL developer feel like he/she is spinning plates.  \; Even with powerful tools such SQL Server Integration Services\, designing and maintaining a proper and well-performing extraction/transformation/loa ding (ETL) infrastructure is a significant undertaking.\n\nIn this full-da y seminar\, we'll explore some common (and a few uncommon) challenges faci ng ETL developers\, followed by practical solutions and recommended practi ces from the field using SQL Server Integration Services.  \;Presented by business intelligence consultant and SQL Server MVP Tim Mitchell\, thi s seminar brings together his 9 years of professional data management expe rience into 7+ hours of condensed real-world approaches to ETL challenges.  \;Though we'll spend some time covering the academic portion of the concepts presented\, most of our time will be spent in demos to give you m ore than just a theoretical exploration of these methods.\n\nThe following is a partial list of the topics we'll cover:\n\n·\;  \;  \;  \;  \;  \;Data cleansing using SSIS\, T-SQL\, and DQS\n&midd ot\;  \;  \;  \;  \;  \;More than just a green box: va lidating the results\n·\;  \;  \;  \;  \;  \;Man aging variables\, parameters\, expressions\, and scripts\n·\;  \ ;  \;  \;  \;  \;Handling warnings\, errors\, and other ba d stuff\n·\;  \;  \;  \;  \;  \;Identifying and resolving performance bottlenecks\n·\;  \;  \;  \;   \;  \;Defining and maintaining an ETL framework\n·\;  \; &nb sp\;  \;  \;  \;Evaluating the new features of SSIS 2012\n&mid dot\;  \;  \;  \;  \;  \;Choosing and using the right package deployment model\n·\;  \;  \;  \;  \;  \ ;When SSIS might *not* be the best choice LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1468 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Business Intelligence Reporting Tools in SQL Server 2012 DESCRIPTION:9:00 \; \; \;Welcome and What is data visualisation ? What it is not\, and why is it important? What products make up the suit e of SQL Server 2012 Business Intelligence stack?\n09:30  \;Tabular Mo del \;- what is it? When is it best used? What distinguishes it from m ultidimensional cubes?\n10:00 \; \; \;PowerPivot \;- \ ;what is it? When is it best used? What distinguishes it from multidimensi onal cubes? What are the new features in SQL Server 2012?\n11:00 \;&nb sp\; \; \; Break\n11:15 \; \; \;Finding patterns in th e data. \;You will learn about the process involved in finding pattern s in the data\, looking at some of the more well-known data visualisation examples. \;We will learn about: Power View\, using PowerPivot and the Tabular model as a basis. \;We will also look at tips and tricks in o ptimising Tabular Models so that they can render Power View effectively.We will look at other helpful visualisations such as sparklines\, bullet cha rts and marimekko charts.\n12:30 \; \; \; \; \;Lunch\n 13:30 \; \;Further Data Visualisations. \;In this section\, yo u will learn about visualisations and how they are best used. This include s bullet charts\, and other visualisations based on Tufte's "small multipl es" such as sparklines. We will learn:\n \;- We will look at Performan cePoint\, and how we can use PowerPivot as a basis and 'gotchas' in using PowerPivot as a basis for PerformancePoint \;- We will look at Excel S ervices\, and how we can provision self-service using the Tabular Model an d PowerPivot as the basis for Excel and Excel Services\n15:00 \;Multiv ariate statistical \;data. \;In this section\, we will cover the c omplexities of displaying multivariate data since is potentially more comp lex. Here\, we look at ways of displaying multivariate data such as table lenses and crosstab arrangements of Tufte's 'small multiples'. We will use Reporting Services as a technology to surface multi-dimensional data.\n15 :15 \;Break\n16:15 \;Dashboards \;- Putting it all together. W e will look at different ways of implementing Dashboards\, KPIs and other visualisations. This will involve a range of technologies\, from KPIs in P owerPivot\, to the new features in Power View.\n17:30 Close LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1469 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130502T080000Z DTEND:20130502T160000Z SUMMARY:Windows Azure Data Platform Technical Immersion Day DESCRIPTION:This full day seminar provides an immersive\, marketing-free\, deep dive for experienced architects who want to learn architectural and i mplementation best practices that have been developed from implementing re al world large distributed Azure systems that leverage characteristics and features of the Windows Azure platform.  \; This session will be pres ented by members of the Azure Customer Advisory Team and the Data Platform Azure Product Team.  \;\nWe will cover a number of use cases\, includ ing migration of traditional applications to the cloud\, and more modern g reen field application scenarios and needs with a specific flavor and focu s on data platform technologies.  \;We&rsquo\;ll show you how to analy ze where a cloud platform can really make the difference. These considerat ions will include arguments like architecting for costs\, increasing deplo yment and upgrade flexibility\, reduce operating complexity in real applic ation scenarios.  \;\nThe experiences we share and learnings we presen t to you have been acquired working with the most complex customer project s to date.  \; The practices we share are immediately applicable to de sign and implement solutions of every scale. Across the entire seminar we& rsquo\;ll consider different angles\, like achieving scalability at every application layer\, addressing reliability and resiliency requirements\, a nd operating\, monitoring and troubleshooting cloud solutions at scale. Yo u will learn about pros and cons of different options for storing data in cloud solutions\, like Azure SQL Database or SQL Server running in Windows Azure Virtual Machines\, and how to optimize data access layers that need to interact with these different data sources using caching and other app roaches. \;\nAgenda:\n- Architecting scalable and reliable Azure data- centric solutions (1.5h)\n- Implementing a cloud service data access layer (1.5h)\n- Azure Data Platform technologies: performance and scalability c omparison (1.5h)\n- Design for operations: solution monitoring and trouble shooting (1.5h) LOCATION:SQLBits Conference - 3A PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1470 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T080000Z DTEND:20130503T081500Z SUMMARY:Registration and Breakfast DESCRIPTION:Registration and Breakfast LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1471 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T081500Z DTEND:20130503T093000Z SUMMARY:Keynote - Architecting Large-Scale Solutions on Azure DESCRIPTION:While there are many similarities between SQL Server and SQL Az ure\, there are different kinds of applications that are easier to build i n one or the other.  One of the major differences relates to how to build an application that “scales”.  This presentation will provide an introduct ion into the difference between scale-up (SQL Server) and scale-out (SQL A zure) architectures and give you a primer on how you can build a large\, I nternet-facing service that can scale to arbitrarily large sizes on commod ity hardware.  This talk is targeted at SQL Server practitioners to give t hem a working knowledge of how the two platforms differ based on Microsoft ’s experiences with its largest Software-as-a-Service (SaaS) customers run ning on SQL Azure. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1472 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T093000Z DTEND:20130503T095000Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1473 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T095000Z DTEND:20130503T105000Z SUMMARY:Seeking SQL Server Secrets DESCRIPTION:Many experienced DBAs are aware that there are many undocumente d commands and traceflags in SQL Server\, and some DBAs may even keep trac k of all references to such options whenever they read about them in an ar ticle or blog posts\, or hear about them at a conference. \; In this s ession\, I&rsquo\;ll not only tell you about some of my favorite undocumen ted features\, I&rsquo\;ll also tell you some of my tricks for discovering more undocumented secrets. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1479 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T105000Z DTEND:20130503T111000Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1480 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T111000Z DTEND:20130503T121000Z SUMMARY:Windows Azure SQL Database Troubleshooting DESCRIPTION:While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service\, there are new and different featu res\, methods\, and tools that are unique to cloud database computing. Com e learn about techniques to make you more productive in deploying and mana ging a Windows Azure SQL Database application. Learn how to use the Window s Azure Management Portal\, Dynamic Management Views (DMV)\, &ldquo\;Event Table&rdquo\;\, and other tools to assist you in troubleshooting Windows Azure SQL Database common customer problems as seen by Microsoft Technical Support. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1486 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T121000Z DTEND:20130503T124000Z SUMMARY:Lunch DESCRIPTION:Lunch LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1487 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130503T124000Z DTEND:20130503T134000Z SUMMARY:Quantifying the cost of Compression DESCRIPTION:A DBA running SQL Server 2008 or above will often need to under stand if it is worth trading CPU cycles for I/O by enabling row or page co mpression. The benefits can be significant\, but does the cost in core lic ensing offset the storage capacity saved? Often\, comparing the workload b efore and after compression isn't an option. how then can you make an educ ated guess about the cost of compressing tables and indexes?\n \;\nIn this session\, we will use Grade of the Steel type workloads to quantify t he CPU cost of enabling different types of compression. Using CPU profilin g\, we will try to quantify the cost of this feature. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1493 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T134000Z DTEND:20130503T144000Z SUMMARY:Troubleshooting the most difficult SQL Server problems DESCRIPTION:Do you have enough from "normal" performance tuning sessions? Y ou can't hear anything about Indexing and Execution \;Plans anymore? T hen you are right in this session! In this session we will walk into the h eart of SQL Server\, and \;you will see performance bottlenecks and er ror conditions\, from which your production SQL Server's should be \;a fraid of. You will learn some troubleshooting techniques with which you ca n identify and solve the most difficult \;SQL Server problems. Agenda at a glance:\n\n*) Hold Locks with Read Committed\n*) ThreadPool Starvatio n\n*) TempDb Latch Contention\n*) Spinlock Contention\n*) Cross NUMA Node Latency Problems\n*) VMware Memory Balloon Driver LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1499 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T144000Z DTEND:20130503T150000Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1500 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130503T150000Z DTEND:20130503T160000Z SUMMARY:Why APPLY? DESCRIPTION:Most T-SQL developers know that the APPLY operator can be used\ nto invoke a table valued function. But did you know that it can also be u sed to\njoin to derived data sets\, return multiple columns from a sub-que ry\, shred XML\,\ncreate working columns for use with the WHERE and GROUP BY clauses\, and replace\nthe UNPIVOT operator? If not\, then why not take your skills to the next level\, and\ncome see each use case in action\, u sing real-world examples. You&rsquo\;ll leave the\nsession with thorough u nderstanding of the full potential of this versatile\noperator\, as well a s a few new tricks up your T-SQL sleeves.\n LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1506 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Car DTSTART:20130503T160000Z DTEND:20130503T173000Z SUMMARY:Diversity in Technology (DiTBits) DESCRIPTION:Can more diverse networks provide better networks?\nIs business networking useful in our careers?\nHow much has networking helped you in your career?\nHow can you build good social media profiles &ndash\; or are these even necessary?\n\nAttendees can enjoy Cheese and Wine refreshments whilst during the Panel discussion and interaction. Then\, we&rsquo\;ll h ave a Flashmob Speed Networking at the end\, just to tie things together b efore everyone shoots off for the party &ndash\; so bring your business ca rds! LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1507 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T173000Z DTEND:20130503T220000Z SUMMARY:Post Event Party DESCRIPTION:Post Event Party LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1508 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130504T064500Z DTEND:20130504T071000Z SUMMARY:Registration and Breakfast DESCRIPTION:Registration and Breakfast LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1509 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T071000Z DTEND:20130504T081000Z SUMMARY:Layered Partitioning - manage very large data sets DESCRIPTION: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 &ldquo\;just use partitioning&rdquo\;\, but nobody rea lly tells you how you should design or implement it. This session will sho w one way to load and manage your very large data sets\, by using layered partitioning. We will walk through partitioned tables and partitioned view s\, before moving on to the concept of layered partitioning. \; LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1515 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130504T081000Z DTEND:20130504T081500Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1517 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T081500Z DTEND:20130504T093000Z SUMMARY:ETL with Hadoop and MapReduce DESCRIPTION:Big Data is hot! And the magic word is Hadoop. But what is it? And more important: what can I do with it? And how can we use it in our tr aditional BI solutions?\nApache Hadoop is a collection of tools mainly use d nowadays in the Big Data space. With Hadoop (and MapReduce\, Pig and Hiv e) we can use it as part of our ETL process to get insight from our (un)st ructured data sources.\nIn this session we will cover these basics\, but a lso introduce some internals of Hadoop. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1523 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130504T093000Z DTEND:20130504T095000Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1524 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T095000Z DTEND:20130504T105000Z SUMMARY:DAX Query Engine Internals DESCRIPTION:The VertiPaq engine\, which is the core of\nthe new SQL Server Analysis Services Tabular engine\, has an unprecedented level\nof performa nce\, thanks to its fine-tuned architecture and its ability to\nperform fa st cross-fltering. Automatic cross filtering between columns of the\nsame table or related tables is a very powerful feature of DAX. It allows a mea sure\nto evaluate to different values for different cells in a pivot table even\nthough the DAX expression for the measure does not change. Filter c ontext is\nthe underlying mechanism that enables this magic behavior. But it is also a\nvery tricky concept that even befuddles some DAX experts. In this session\, we will\nanalyze the way DAX solves filtering. Starting fr om simple queries\, we will\nfollow the steps DAX does with the filter con text\, discovering the internals of\nthe query engine of DAX. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1530 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130504T105000Z DTEND:20130504T111000Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1531 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T111000Z DTEND:20130504T121000Z SUMMARY:Data Modeling for Analysis Services Cubes DESCRIPTION:Analysis Services OLAP cubes provide an incredibly powerful pla tform for the analysis and reporting of complex data. Unfortunately we oft en find that our source data is not in the right structure to make the bes t use of the cube&rsquo\;s power. This limits the cube&rsquo\;s functional ity\, compromises performance and complicates the reports.\n\nIn this sess ion we&rsquo\;ll look at a number of different data scenarios that we enco unter and explore ways of remodelling the data to optimise it for cubes an d MDX. We&rsquo\;ll see how adding functionality into the ETL layer can ha ve a dramatic effect on the functionality and simplicity of the cube. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1537 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130504T121000Z DTEND:20130504T124000Z SUMMARY:Lunch DESCRIPTION:Lunch LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1538 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130504T124000Z DTEND:20130504T134000Z SUMMARY:Fusion ioN Data Accelerator – software defined storage DESCRIPTION:ioN Data Accelerator software transforms industry-leading open server platforms into powerful shared acceleration devices for multiple ap plications or clusters.\nWith performance that can increase applications u p to 20x\, industry-leading enterprise flash reliability and endurance\, f lexibility for your vendor choice and manageability for performance monito ring. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1544 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T134000Z DTEND:20130504T144000Z SUMMARY:Transact SQL Performance Tips DESCRIPTION:SQL Server optimizer doesn't use and index seek for execution o f your query although the quer is high selective? What is better\, when an d why: LIKE vs: SUBSTRING\, IN vs. EXISTS\, SUBQUERY vs. JOIN. Why you sho uld not use the UPPER or LOWER functions? How to avoid non-SARG-able WHERE clauses? Which query takes about 3 minutes in SQL Server 2008 and only on e second in SQL Server 2012?\n\nIn this session we will answer these quest ions and show how bad designed queries lead to poor execution plans. We wi ll offer recommendations and tips how to avoid performance problems caused by poor query design (functions in WHERE clause\, data type conversions&h ellip\;) and explain how local variables and parameters affect the generat ion of execution plan. LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1550 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130504T144000Z DTEND:20130504T150000Z SUMMARY:Break DESCRIPTION:Break LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1551 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T150000Z DTEND:20130504T160000Z SUMMARY:Geospatial Data Types in SQL Server 2012 DESCRIPTION:The geospatial capabilities in SQL Server are not only powerful \, but easy and fun to use! In this session\, Lenni shows you how to integ rate location-awareness into your own applications with the geometry and g eography data types. We&rsquo\;ll explore the planar and geodetic spatial models\, spatial markup languages such as WKT and GML\, and then put these concepts to use and build several spatial desktop and web applications. D emos show how to integrate with Bing Maps\, and how to use the geospatial methods to easily calculate area\, length\, and distance\, and project new shapes based on intersection and overlap. We&rsquo\;ll also cover the lat est geospatial enhancements in SQL Server 2012. Attend this session and em brace spatial programming today! LOCATION:SQLBits Conference - Theatre PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1474 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T095000Z DTEND:20130503T105000Z SUMMARY:Modern Data Warehousing Strategy DESCRIPTION:The recent introduction of new technologies like PowerPivot\, B I Semantic Model\, columnstore indexes in SQL Server and the more general trend of advances in Self-Service BI and Big Data might be considered thre ats to the classic data warehouse ecosystem. In reality\, a good data ware house is still the best starting point for any kind of analysis\, but it i s necessary to update the strategy of its implementation and evolution in this new era.\n\nThis session will start the conversation about what a mod ern strategy for data warehousing can be in this era. Which type of data m odeling we should use for the data warehouse? What is the role of the data marts? Does the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data? Do the columnstore inde xes remove the need of an analytical server like Analysis Services? We wil l try to answer to these and other questions\, offering an updated approac h to the data warehouse modeling methodology. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1481 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T111000Z DTEND:20130503T121000Z SUMMARY:DAXMD: SSAS Multidimensional meets DAX and Power View DESCRIPTION:This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX la nguage and Power View. It will show how Multidimensional models are mapped to Tabular concepts\, what works and what doesn't work in DAX\, how Power View works with Multidimensional models and what other benefits there are to using DAX with a Multidimensional model. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1488 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130503T124000Z DTEND:20130503T134000Z SUMMARY:SQL Azure for the DBA DESCRIPTION:In this session we are going to look at the some of the flavour s of SQL in Azure\, namely Windows Azure Database and SQL on IaaS. We will discuss the differences between them\, look at what this means from a DBA stand point\, covering aspects such as maintenance\, monitoring\, disaste r recovery. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1494 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T134000Z DTEND:20130503T144000Z SUMMARY:Inside xVelocity InMemory Engine (VertiPaq) DESCRIPTION:The xVelocity engine in SQL Server Analysis\nServices 2012 Tabu lar is a columnar database capable of incredible performances\,\nboth in s peed and compression ratio. In this session\, we will perform a deep\ndive in the internals of the database architecture\, discovering how Vertipaq\ nstores information\, in order to gain better insights into the engine and \nunderstand the best way to model your data warehouse to leverage the fea tures\nof VertiPaq. We will show common and useful techniques to increase the\ncompression ratio and obtain better performances from your Tabular da ta model. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1501 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T150000Z DTEND:20130503T160000Z SUMMARY:Advanced Data Visualisation in Reporting Services 2012 DESCRIPTION:As a report creator and designer\, it's your role to make the m essage of the data come alive for data consumers and decision-makers. This requires a balance between conveying the 'truth' of the data across to th e target audience\, in addition to making the report look interesting that it will draw people's attentions in the first place.\n\nReporting Service s is one of the most widely-used Business Intelligence products within the Microsoft stack. Come to this session to pick up some tips and tricks for advanced reporting writing\, that is also \; in accordance with think ing by Data Visualisation gurus such as Stephen Few and Edward Tufte.\nThi s session will cover more advanced and less well-known features of reporti ng services in order to provide you with some interesting ideas and insigh ts for your next reporting project. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1562 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Car DTSTART:20130503T160000Z DTEND:20130503T173000Z SUMMARY:Are you interested in becoming certified in SQL Server? DESCRIPTION:Are you interested in becoming certified in SQL Server?  \; In this session\, \;Chris Testa-O'Neil will provide an overview of the certifications and \;training offered by Microsoft for SQL Server 201 2  \;and ANSWER YOUR\nQUESTIONS.  \;We'll discuss the value of bei ng certified\, and then discuss the \;different certification paths an d the related training options for each \;path.  \; It is not a te chnical session but will provide the information that\nyou require in orde r to complete the following certification\n\n \;  \;  \;   \; Microsoft Certified Technical Specialist\n \;  \;  \;   \; Microsoft Certified IT Professional\n\n \;An exploration of the ava ilable learning channel to support you meeting\nyour certification require ments will also be explored including\n\n \;  \;  \;  \; & nbsp\;Microsoft Official Courses - (Instructor Led Training)\n \; &nbs p\;  \;  \;  \;Microsoft Elearning\n \;  \;  \; &n bsp\; Microsoft Press Books LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1510 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T071000Z DTEND:20130504T081000Z SUMMARY:Gone Clustering in 60 Minutes DESCRIPTION:Deploying a SQL Server Failover Cluster on Windows Server 2008 has become a lot easier with the availability of online resources. However \, making it easy does not mean ignoring the basic principles of the under lying technology. In this session\, learn the fundamentals and principles behind how Windows Failover Clustering works and how SQL Server leverages on the technology\, allowing you to build highly available database infras tructures. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1518 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T081500Z DTEND:20130504T093000Z SUMMARY:XML: The Marmite of SQL Server DESCRIPTION:Discussion of the pros and cons of using XML to store and acces s data with SQL Server 2008.\nWhat will be reviewed:\na few basic T-SQL XM L commands to generate and access XML data using SQL server\, Typed and Un typed XML and in-built validation options. \; LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1525 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T095000Z DTEND:20130504T105000Z SUMMARY:An introduction to the wonderful world of OData DESCRIPTION:Join me as I guide you through the architecture and capabilitie s of the OData protocol.\nData has been locked inside applications for too long\, allow me to show you how to implement OData and open up the data s ilos inside your company today! \; \; I will also show you how you can use OData in everyday scenarios such as Business Intelligence &\; (Mobile) Development. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1532 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T111000Z DTEND:20130504T121000Z SUMMARY:Maintain SQL Server System and Performance with PowerShell DESCRIPTION:Maintaining a solid set of information about our servers and th eir performance is critical when issues arise\, and often help us see a pr oblem before it occurs. \; Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. \; This session will walk you through a series of Po werShell scripts you can schedule which will capture the most important da ta and a set of reports to show you how to use that data to keep your serv er running smoothly. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1539 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130504T124000Z DTEND:20130504T134000Z SUMMARY:Always ON Overview & Field Experience DESCRIPTION:High Availability technology has evolved to meet the demands of customers with regard to availability\, scalability and Disaster Recovery . The introduction of Availability Groups in SQL Server 2012 and the flexi bility this gives administrators is truly awesome. In these session we wil l cover what Availability Groups bring to the table\, the advances in Data base Mirroring\, Scale out solutions and topology\, and how you can cluste r across different subnets using Always-On.\nYou will also learn about how to deploy the solution\, how to utilize your secondary hardware for bette r return of investment and how the new solution simplifies overall deploym ent and management of high availability in your environment. In addition\, we will also focus on the best practices associated with this new feature and\, with the use of demos\, dive into the details of the solution. You will learn everything you need to know to make the best use of this fantas tic new feature. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1545 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T134000Z DTEND:20130504T144000Z SUMMARY:Using SQL Server 2012s Always On DESCRIPTION:In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "AlwaysOn" features includi ng site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.\n\nAddit ionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load fro m the production database. \; We will also look a unique use case usin g SQL Server 2012's Always On feature to scale out the reads to synchronou s read only copies. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1552 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T150000Z DTEND:20130504T160000Z SUMMARY:Analysis Services for the DBA DESCRIPTION:\nMany DBAs have heard the term Analysis Services\, but don't r eally know what it's for or who would use it. In this session\, Mark will explain the use cases for Analysis Services\, illustrate how it improves p erformance for large data sets and eases report writing\, and will go thro ugh a practical example of building a first Analysis Services solution\, a nd managing Analysis Services in a production environment. LOCATION:SQLBits Conference - Exhibition B PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1475 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130503T095000Z DTEND:20130503T105000Z SUMMARY:Searching Binary Data in SQL Server 2012 DESCRIPTION:More and more data collected in organizations is in an encoded format\, essentially a binary classification of data. These can be images\ , audio files\, video\, or even common formats like Word and Excel files. This data contains lots of important data\, but the formatting must be str ipped out in order for users to effectively search this data.This presenta tion starts with a discussion of the three types of data in SQL Server to set the framework. It demos and explains:\n\n structured data\n semi -structured data\n unstructured data\n\nThe talk then looks at how unst ructured data is stored in SQL Server\, specifically briefly looking at Fi lestream and Filetable.There is a short discussion of full text search\, w ith a look at the changes in SQL Server 2012 before moving on to the iFilt er interfaces which are used to search the binary data while ignoring the encoding. \n\nThere are demos of the basics of CONTAINS and FREETEXT searc hes\, along with some of the more advanced options\, like customizable NEA R and weighting of search terms.The talk finishes with a short look at the new semantic search feature in SQL Server 2012. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1482 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T111000Z DTEND:20130503T121000Z SUMMARY:Lean and Mean: Running SQL Server on Windows Server Core DESCRIPTION:Do you consider the Windows GUI to be a waste of resources? Sta rting with SQL Server 2012\, you can run on top of Windows Server Core 200 8 R2 or 2012. \; In this session we will discuss installation and mana gement of SQL Server on Windows Server Core\, along with lots of tips and tricks. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1489 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130503T124000Z DTEND:20130503T134000Z SUMMARY:Introduction to the Pyramid Analytics BI Platform DESCRIPTION:Microsoft SQLServer offers one of the best integrated data mana gement platforms for Business Intelligence\, from the core RDBMS though as sociated tools such as Integration\, Reporting\, Analysis and Master Data Services. The Microsoft BI front end tools however suffer from being fragm ented\, overly complex and / or lacking in functionality and ability to ex ploit the data platform.\nPyramid Analytics address these issues with an i ntegrated suite of modules for analysis\, and report writing\, coupled wit h a server based management engine that makes deploying sophisticated BI s olutions to large numbers of users a snap.\nThis session will introduce yo u to the Pyramid Analytics Platform and Architecture and demonstrate some of its innovative and game changing capabilities\, from analytics to dashb oards to reporting\, with full central management and control.\nIan Macdon ald\nPrincipal Technologist\, Pyramid Analytics\nIan has over 25 years&rsq uo\; experience in the Business Intelligence software market\, having held senior technical\, product management and marketing roles with Informatio n Builders\, Hyperion Solutions\, HP and Microsoft. Today he leads the tec hnical team developing Pyramid Analytics&rsquo\; business in the UK and Ir eland. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1495 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T134000Z DTEND:20130503T144000Z SUMMARY:SQL 2012 Always on Deep Dive DESCRIPTION:Always On Availability Groups offer a huge leap forward in term s of high availability. This sessions is a demo based introduction to the high availability changes in \;SQL 2012 \;emphasizing key features and benefits.\n\nDuring the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to \;SQL 2012 \;with ZERO down t ime and then use the Availability Group features to simplify reporting\, a vailability and disaster recovery.\n\nThis session will be useful for anyo ne who is working in a high availability environment or currently using re plication to provide reporting and looking for a neater solution.\n\n\nBob Duffy is a SQL Server MVP from Dublin\, Ireland who is both MCA and MCM c ertified. Bob has spent many years helping customers in Ireland with high availability planning. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1502 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T150000Z DTEND:20130503T160000Z SUMMARY:Optimizing SQL Server Performance in a Virtual Environment DESCRIPTION:In this session we'll look over some of the things which you sh ould be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be. \; This will inc lude how to look for CPU performance issues at the host level. \; We w ill also be discussing the Memory Balloon drivers and what they actually d o\, and how you should be configuring them\, and why. \; We'll discuss some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server. \; Then we will finish up w ith some storage configuration options to look at. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1563 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T160000Z DTEND:20130503T173000Z SUMMARY:Advanced Microsoft Certifications for the SQL Server Profess DESCRIPTION:A slide-led discussion about the advanced Microsoft certificati on options\navailable for SQL Server professionals in 2013\, focussing on the Microsoft\nCertified Solutions Master and Microsoft Certified Architec t certifications.\nThe session's objective is to help you understand your options after\nachieving MCSE data platform certification for SQL Server 2 012\, the types of\nskills these advanced certifications look for\, and wh at your next steps\ncould be LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1511 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T071000Z DTEND:20130504T081000Z SUMMARY:War stories from implementing SQL Server 2012 AlwaysOn DESCRIPTION:In this session I will illustrate how SQL Server AlwaysOn can b e used to achieve tier 1 HA. I will speak about what the common misconcept ions are with SQL Server HA. I will then detail what considerations there are within designing and implementing AlwaysOn. This session will also dem onstrate how to implement AlwaysOn\,\nbut more importantly what &lsquo\;Go tchas&rsquo\; I have come across whilst implementing it in the real world. \n LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1519 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T082500Z DTEND:20130504T094000Z SUMMARY:The Posh DBA: Troubleshooting SQL Server with PowerShell DESCRIPTION:It is normal for us to have to face poorly performing queries o r even\ncomplete failure in our SQL server environments. This can happen f or a variety\nof reasons including poor Database Designs\, hardware failur e\, \nimproperly-configured systems and OS Updates applied without testing . As\nDatabase Administrators\, we need to take precaution to minimize the impact of\nthese problems when they occur\, and so we need the tools and methodology\nrequired to identify and solve issues quickly. In this Sessio n we will use\nPowerShell to explore some common troubleshooting technique s used in our\nday-to-day work as s DBA. This will include a variety of su ch activities\nincluding Gathering Performance Counters in several servers at the same time\nusing background jobs\, identifying Blocked Sessions an d Reading &\; filtering\nthe SQL Error Log even if the Instance is offl ine.\nThe approach will be using some advanced PowerShell techniques that allow us\nto scale the code for multiple servers and run the data collecti on in\nasynchronous mode. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1526 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T095000Z DTEND:20130504T105000Z SUMMARY:Windows Azure For SQL folk DESCRIPTION:So what is this cloud stuff and how does it affect database pro fessionals ?\n\nIn this session we aim to cover the fundamental concepts t hat you should know on the Cloud and Windows Azure. In this demo based hou r we will step through \;building Azure applications\, deploying and m anaging them and what storage choices you have when developing application s in the cloud.\n\nThis sessions is Ideally suited to anyone who wants to understand more behind how Azure works\, what it offers and what is probab ly just hype. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1533 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T111000Z DTEND:20130504T121000Z SUMMARY:Everything you always wanted to know about MERGE DESCRIPTION:The MERGE statement can synchronize imported data with base dat a\, inserting new rows and updating existing rows\, all in one go. But ste p beyond basics and MERGE becomes a tool that can do much\, much more.\n\n In this demo-rich session\, Hugo Kornelis will present the full syntax of the MERGE statement\, explain all the options\, and show the possibilities . He will also demonstrate the pitfalls that you need to be aware of if yo u\, or even someone else\, uses MERGE &ndash\; and show you how to solve t hem.\n\nWhether you already used MERGE or not\, this session will show you new ways to tackle problems that would otherwise be much harder to solve. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1540 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130504T124000Z DTEND:20130504T134000Z SUMMARY:SQL Trivia Bowl DESCRIPTION:Let&rsquo\;s have some fun! \; Using a game show style pres entation\, Kevin\nwill test your knowledge of IT pop culture\, IT history\ , computers\, database\ntechnology\, and &ndash\; of course &ndash\; SQL S erver. \;\nWinners get prizes!\n\nFor IT professionals\, not knowing h ow\nthe industry got started is much like an automobile professional who d oesn't \;\nknow where cars came from. \; In addition\,\nthe Intern et is full of recommendations that were written a long time ago which\nno longer apply to current versions of the infrastructure. \; Consequentl y\, a lot of sincere developers and\nadministrators are following protocol s that can hurt\, not help performance\,\nreliability\, and maintainabilit y of their applications. \; \n\nThis SQL Trivia bowl may contain\nques tions about:\n\no \; \; The origins and history of computing\nand data processing\n\no \; \; SQL Server Setup\, Memory\, IO\, and CP U\n\no \; \; Transact-SQL Programming \n\no \; \; Database Design \n\no \; \; Business Intelligence\n\nSo let&rsquo\;s have some fun clearing out the\ncobwebs of old recommendations and faulty assum ptions. \; Learn about SQL Server because it&rsquo\;s not just\ntrivia \, it&rsquo\;s your job! LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1546 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T134000Z DTEND:20130504T144000Z SUMMARY:Incremental processing of SSAS Multidimensional databases DESCRIPTION:Processing of SSAS OLAP databases can be a tricky business\, pa rticularly when it comes to incremental processing of dimensions.  \;J ohn will illuminate the dark interior of SSAS and describes how attribute relationships\, aggregation design and different processing techniques can all have a positive or negative impact on your real-time cubes.\n \;\ nJohn will give you real life examples of why certain approaches work and others do not\, describing some of the pitfalls of each approach.\n\n\nAt the end of the session\, you should fully understand how to use ProcessUpd ate and ProcessAdd to incrementally update dimension data and also various approaches to processing fact partitions including negation strategies. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1553 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T150000Z DTEND:20130504T160000Z SUMMARY:Thwarting Database Defects DESCRIPTION:How would you like to spend less time fixing bugs? Come and lea rn how to use unit-testing effectively in your database code. This fun and demo loaded session will show you how to prevent bugs in your SQL code an d make it easier to maintain at the same time. \n\nIt&rsquo\;s bad enough to spend hours finding and fixing database defects\, explaining to the res t of the team what went wrong and trying to clean up the mess. It&rsquo\;s even worse when a defect causes the end-user to make a bad decision. Data base defects are far too costly and most testing practices do not adequate ly detect or prevent them. \n\nIn this session we will cover a variety of patterns for writing test cases and techniques to overcome barriers that a re unique to database unit testing. \n\nYou&rsquo\;ll learn: \n\n How t o write your tests using an automated testing framework\n The basic str ucture of a test case\, including the AAA pattern\n What tests to creat e based on test identification patterns\, called testing heuristics\n H ow and when to create test data that leads to maintainable test cases.\n What to do with constraints and dependencies. \;\n\n\nBy the end you will be able to write your own tests to get you started on the way to rob ust and easier to maintain T-SQL code. LOCATION:SQLBits Conference - Suite 3 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1476 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T095000Z DTEND:20130503T105000Z SUMMARY:SQL Server in Windows Azure Infrastructure as a Service DESCRIPTION:Join Ewan Fairweather and Silvano Coriani from the SQL CAT team \, who will take you on a tour of the new features that make up the Window s Azure Virtual Machines and Virtual Networks offerings and how they apply to running SQL Server 2012 in a Virtual Machine.  \;We&rsquo\;ll focu s specifically on features that enable you to create highly available Virt ual Machine-based services and how to connect SQL Server Virtual Machines with IaaS and PaaS Cloud Services.\nThey will take you through step by ste p the supported and optimal configurations for SQL Server 2012 AlwaysON\, show you the results of intensive storage and networking tests which have been performed.  \;The recommendations and knowledge that are shared i n this session are all based on real world learnings.  \;\nBy the end of the session you will understand what the recommended patterns and pract ices are for running SQL Server 2012 in Azure Infrastructure as a Service& nbsp\; LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1483 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T111000Z DTEND:20130503T121000Z SUMMARY:Cleaning Up Dirty Data with SSIS DESCRIPTION:Dirty data is everywhere\, and it's headed for a database near you.  \;Extraction\, transformation\, and loading (ETL) can be difficu lt\, but often the most challenging component of that process is the valid ation and clean up of data. Information must be cleansed in such a way tha t it retains its original message and business value\, while conforming to the expectations of the destination system(s). \;\n\n\nIn this sessio n\, we'll discuss some design patterns for addressing different types of d irty data using SQL Server Integration Services.  \;We will review the various cleansing tools accessible from within SSIS including native Inte gration Services components\, T-SQL\, and SSIS scripting.  \;In additi on\, we'll briefly review the new SQL Server Data Quality Services and its integration with SSIS.  \;We'll cap off the discussion with demonstra tions of several methods for data cleansing. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1490 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130503T124000Z DTEND:20130503T134000Z SUMMARY:Enabling Flash to Support Mission-Critical Applications DESCRIPTION:In many cases\, the performance of applications using SQL Serve r is limited by storage performance so it is easy to understand the popula rity of flash storage. With AlwaysOn Availability Groups\, Microsoft®\; has enabled non-SAN storage to support application failover from a primar y to a secondary server.  \;Log shipping with synchronous-commit to a secondary replica emphasises high availability and data protection\, but o ften at the cost of increased transaction latency.  \;Testing by LSI h as shown that using a dedicated network with synchronous-commit\, the LSI& reg\; Nytro&trade\; MegaRAID®\; Application Acceleration card provided up to an 80X improvement in user response times over just using HDDs under an OLTP workload.\n \;\nIn this session by Mike Horner\, LSI Senior F ield Applications Engineer\, we will discuss how using flash with intellig ent caching can allow an economical mix of flash and HDDs to be used becau se typically only a small portion of storage is accessed frequently\, and retaining this data on flash can still provide huge performance gains. &nb sp\;Nytro acceleration products support AlwaysOn and Windows Server®\; Failover Clustering which allows enterprise-class high availability to be supported. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1496 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130503T134000Z DTEND:20130503T144000Z SUMMARY:T-SQL : Bad Habits & Best Practices DESCRIPTION:Bad habits: we all have them. SELECT * is the obvious one\; but in this session you will learn about various other habits and why they ca n be bad for performance or maintainability. You will also learn about bes t practices that will help you avoid falling into some of these bad habits . Come learn how these habits develop\, what kind of problems they can lea d to\, and how you can avoid them - leading to more efficient code\, a mor e productive work environment\, and - in a lot of cases - both. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1503 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T150000Z DTEND:20130503T160000Z SUMMARY:MDX vs. DAX: Currency Conversion Faceoff DESCRIPTION:Compare and contrast how multidimensional and tabular achieve t he same end result in quite different ways. Learn where multidimensional d ecorates the metadata of the model\, while tabular offloads responsibility to DAX. Understand how the design goals of the DAX language &ndash\; whic h are akin to Excel formulas and relational-database concepts &ndash\; dif fer from MDX and traditional OLAP. Features covered can be used in a broad range of scenarios (not only currency conversion)\, adding valuable knowl edge to your SSAS arsenal. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1564 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T160000Z DTEND:20130503T173000Z SUMMARY:Party Setup DESCRIPTION:Party Setup LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1512 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T071000Z DTEND:20130504T081000Z SUMMARY:Unit Testing in TSQL DESCRIPTION:\nGuidelines\n-A template\nError catching\n-Using a CLR proc to catch\nGeneric tests\n-Procedures\n-Functions\n-Dynamic sql\n-Cube LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1520 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T081500Z DTEND:20130504T093000Z SUMMARY:Table-Based Database Object Factories DESCRIPTION:Ever had to write a large number of similar or standardized sto red procedures\, audit triggers\, archive tables\, etc.? Let SQL Server do the work for you! With some custom functions\, stored procedures and exte nded properties\, this is no longer a chore. In this session we will see h ow to create table-based object factories that are capable of producing we ll-formatted stored procedures\, triggers\, audit tables or whatever you n eed them to produce. Whether initial creates or alters post schema changes \, the manual drudgery can be removed!\n\nDuring the session I will explai n what \;automation is \;possible and demonstrate this \;worki ng in practice. I will also show how this can be used in conjunction with DDL Triggers and SQL Server Database Tools to seamlessly fit into the deve lopment process. \n\nI heard a phrase from Jen Stirrup recently\, "If you have to do it twice\, automate it.". Damn straight\, I'm down with that an d you should be too. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1527 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T095000Z DTEND:20130504T105000Z SUMMARY:Excel 2013 Analytics DESCRIPTION:Excel is &ldquo\;The&rdquo\; analytical tool in Microsoft suite for advanced analysts. You can use it as a SQL Server Analysis Services c lient or as a standalone analytical engine. With Excel\, you can analyze b oth\, relational and unstructured big data. With PowerPivot\, Excel become s a single-user Analysis Services in tabular mode. The performance of your analytical processing is amazing. With Power View inside Excel\, you can create ad-hoc reports on the tabular model with minimal effort. With Data Mining Add-in\, you can perform even the most advanced analyzes on your Ex cel data. This session introduces Excel 2013 and 2010 business intelligenc e capabilities. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1534 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T111000Z DTEND:20130504T121000Z SUMMARY:Excel 2013 - Whats new beside PowerPivot and Power View? DESCRIPTION:You probably already heard a lot of the wonders of PowerPivot a nd Power View\, but will you have any other cool new BI features with Exce l 2013. The answer is a big YES!\nThis session will be one long demo\, whe re you will learn about stuff like Flash Fill\, TimeLine Slicers\, creatin g new MOLAP calculated members and measures directly in Excel\, use of Exc el Applications and how the Excel Interactive View gives you the analytica l power of Excel to use on any HTML table on any web page. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1541 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130504T124000Z DTEND:20130504T134000Z SUMMARY:Transforming PowerPivot into Enterprise BI with Pyramid DESCRIPTION:PowerPivot is a breakthrough for self-serve BI but is not easil y deployed in the enterprise.  \;Join us for this fast-paced\, technic al demonstration on how to upgrade PowerPivot into secure and scalable Ana lysis Services tabular cubes with Pyramid&rsquo\;s BI Office suite.  \ ;\nWe&rsquo\;ll then show how Pyramid&rsquo\;s analytics and dashboard too ls fully unleash the power of these enterprise quality cubes. With end-use r driven business logic and calculations\, parameterization\, dynamic sets \, and slick interactive graphics we&rsquo\;ll work through a complex &ldq uo\;Market Basket Analysis&rdquo\; example without writing a single line o f code.\nAvi Perez\nCTO\, Pyramid Analytics\nAvi&rsquo\;s 20+ year experie nce with BI and data analytics has seen him architect and deliver some rev olutionary solutions delivered on the Microsoft BI stack.  \;He now le ads an agile development team that is building the ultimate analytics\, da shboarding &\; reporting platform for the Microsoft BI stack. \;\n\ n LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1547 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T134000Z DTEND:20130504T144000Z SUMMARY:Data loading at warp speeds DESCRIPTION:Data loading is one of the most critical \;challenges \ ;for many systems. The increase in data volumes and the increased \;de mands \;for availability make this task ever more \;challenging.\n In this \;session \;we will cover both theoretical and their count erpart practical aspects of the various means you have at your disposal to optimize your data loading performance.\nWe will unravel the truths and b ust some myths regarding minimally logged operations and \;\nbulk load mechanisms. We will look at internals\, 'secret' trace flags but also rev iew some simpler techniques that you may have overlooked.\nWe will analyze the most common data loading scenarios and provide practical\, proven tip s for optimizing bulk data load performance which can make a difference in orders of magnitude! LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1554 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T150000Z DTEND:20130504T160000Z SUMMARY:Kerberos for SQL Server and SharePoint the easy way DESCRIPTION:Configuring Kerberos can be easy. Indeed\, with favourable cond itions and some preparation\, \; the whole thing can be over in minute s. However\, if hours later it still does not work\, troubleshooting can t ake many days even with help of experts. \n\nAs you all know\, real world implementations can deviate dramatically from lab scenarios considered in common whitepapers. What most resources usually cover is\, at best\, some step by step configuration \;instructions for a particular architectur e. \;Such instructions often lack explanation of \;why it has to b e done that way in terms of the role of every step in the authentication p rocess\, i.e. they do not explain principles\, only give certain examples. \n\nI would like to present easy to follow principles of Kerberos constrai ned delegation and protocol transition with handy tips and templates to ge t this right the first time for your particular environment. The goal is t o explain the meaning of the settings in terms of the role in the Kerberos constrained delegation authentication rather than simply presenting anoth er example of a particular scenario. I will also include a\njargon-busting glossary of terms to help you get started.\n\nThis presentation covers so me very useful resources to help you tame your three-headed monster and ma ke it behave in case it decides to go on a strop. I will also mention some useful tips and resources\non dealing with Claims To Windows Token servic es\, an important part to Kerberos configuration. It plays a very importan t part in delegating authentication for services requiring protocol transi tion (Claims ->\; Windows)\, such as Excel Services\, Performance Point and Power View. LOCATION:SQLBits Conference - Suite 1 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1477 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130503T095000Z DTEND:20130503T105000Z SUMMARY:Top Ten Crucial Dev Skills to Make Your DBA Happy DESCRIPTION:Stereotypes abound for different types of people in the IT worl d. Developers think DBAs are\ncontrol freaks. DBAs think developers are un ruly cowboys. How do we overcome these differences?\nIf you&rsquo\;re a de veloper\, your best strategy is to manage your DBAs&rsquo\; anxieties and demonstrate your\ncompetence and credibility. Attend this session to learn about 10 techniques that developers can apply\nto their code which will c alm your DBAs&rsquo\; fears and earn their admiration.\n\n\nThis session w ill answer questions like:\n\nWhat&rsquo\;s the most common Transact-SQL p rogramming mistake and how do I fix it?\nHow do database designers cause p roblems for future generations of application developers and\ndatabase adm inistrators?\nWhy do inexperienced database administrators make their own job more difficult and less\nefficient?\n\n\n-\n\n\nThere are a short list of mistakes that\, if you know of them in advance\, will make your life m uch easier.\nThese mistakes are the &ldquo\;low hanging fruit&rdquo\; of a pplication design\, development\, and administration.\nOnce you apply the lessons learned from this session\, you&rsquo\;ll find yourself performing at a higher level of\nefficiency and effectiveness than before. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1484 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T111000Z DTEND:20130503T121000Z SUMMARY:Moves Like Jagger: Upgrading to SQL Server 2012 DESCRIPTION:Upgrading SQL Server is one of the most challenging and risky \ noperations that you will perform as a DBA. Make the wrong move\, and you \ncould be heading for the exit. In this diverse session\, we'll take an \ nin-depth look at moving to the SQL Server 2012 platform and review the \n upgrade strategies available for a smooth and successful move.\n\nWe'll co ver preparing and reporting for upgrade\, upgrade strategies\,\nperforming the upgrade\, and how to know the upgrade was successful. And\nwe'll expl ore some advanced scenarios\, including SQL Server 2012 on \nServer Core\, preparing for AlwaysOn availability groups\, upgrading your \nSQL failove r cluster\, and storage migration. After this session\, you too\ncan have &ldquo\;moves like Jagger.&rdquo\; LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1491 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130503T124000Z DTEND:20130503T134000Z SUMMARY:Monitoring and Performance Tuning for AlwaysOn DESCRIPTION:With Availability Groups and FCIs\, SQL Server 2012 AlwaysOn ha s dramatically expanded the possibilities for high availability and improv ed resource management. However\, to reach the full potential of these new features\, better management tools are required. SQL Sentry will present their revolutionary new software which provides enhanced visibility and ma nageability for advanced AlwaysOn topologies. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1497 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130503T134000Z DTEND:20130503T144000Z SUMMARY:Real world SSDT DESCRIPTION:SQL Server Data Tools (SSDT) provide a new declarative model fo r building SQL Server databases. Come and learn more from Craig and Jamie who have both been using SSDT to do that for many months.\nThis cornucopia of real-world experience should be of use to anyone that either is using SSDT or considering using it in the future.\n\nThis will be a demo-heavy\, slide-light session. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1504 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130503T150000Z DTEND:20130503T160000Z SUMMARY:Database Design: Size Does Matter! DESCRIPTION:Great database performance starts with great database design. D uring the design process it is important to select your SQL Server datatyp es wisely. Failure to do so will result in wasted disk space\, additional I/O overhead\, and decreased performance. There is also the risk that your design will not scale as well as it should. Unless you have unlimited har dware purchasing power\, size matters. \;\n\nAttend this session and l earn how smart\, effective database design will ensure your databases perf orm at their peak efficiency. You will learn how to choose the best perfor ming datatypes\, how to measure their effectiveness\, and how to correct b ad datatypes decisions (decision that were not\, of course\, made by you.) LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1565 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T160000Z DTEND:20130503T173000Z SUMMARY:Party Setup DESCRIPTION:Party Setup LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1513 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T071000Z DTEND:20130504T081000Z SUMMARY:Query Tuning in the Clouds DESCRIPTION:Just because you're using an Azure SQL database does not mean y ou can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resourc es. This session will introduce you to the tools you have available to ide ntify poor performing queries\, such as dynamic management objects and oth ers. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix yo ur poorly performing queries.  \;All in the cloud. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1521 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T081500Z DTEND:20130504T093000Z SUMMARY:SQL Server 2012 Memory Management DESCRIPTION:SQL Server 2012 brings a wide range of changes\, including a ke y change in \nhow SQL Server memory is managed. Earlier releases of SQL Se rver have two memory \nmanagers\, which have now been merged into one. And that&rsquo\;s just the beginning of \nthe changes for SQL Server memory. \n\nThis session will dive into SQL Server 2012's new memory architecture. We'll see how to diagnose memory \nperformance issues and gain insight in to memory pressure issues. We'll also cover the settings to adjust memory configuration levels and their impact.\n\nLearn the ways to determine if y our memory is performance is 'Healthy' or needs some TLC LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1528 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T095000Z DTEND:20130504T105000Z SUMMARY:From SQL Traces to Extended Events. The next big switch. DESCRIPTION:This session will give you insight into both of the current tra cing technologies in SQL Server with emphasis on Extended Events.\n\nThe o ld SQL Trace which has served us well over the past 10 or so years is on i ts way out because the overhead and details it produces are no longer enou gh to deal with today's loads.\n\nThe new Extended Events are a new lightw eight tracing mechanism built directly into the SQLOS thus giving us infor mation SQL Trace just couldn't. They were designed and built with performa nce in mind and it shows. Mastering Extended Events requires learning at l east one new skill: XML querying.\n\nWe'll look at how the Extended Events work with only a brief overview of old SQL Trace architecure. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1535 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T111000Z DTEND:20130504T121000Z SUMMARY:Advanced SQL Server 2012 HA and DR Architectures DESCRIPTION:In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads.  \; This will include design patterns and configuration best practices for Availability Groups (AG) and Failover Cluster Instances (FCI) across diffe rent sites as well AG replicas between FCIs. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1542 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130504T124000Z DTEND:20130504T134000Z SUMMARY:Ye olde tavern quiz DESCRIPTION:Join the Dell Software Group (formerly Quest Software) for our traditional fun filled lunchtime quiz. Your gameshow host for this light h earted event will be the Editor in Chief of SQL Serverpedia Richard Dougla s\, we&rsquo\;ll question your knowledge from middle age to cutting edge t echnology and best practices. Come along to test how much you really know and for your chance to win lots of prizes! LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1548 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T134000Z DTEND:20130504T144000Z SUMMARY:Tame Your Unruly Data...With Constraints! DESCRIPTION:Never given time or care\, never forming good relationships\, b ecoming bloated\, corrupt and rife with indistinguishable copies\, and all so horrifyingly pervasive in society. But enough about the Kardashians\, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place\, this session is for you. We will cover constraint basics (not null\, check\, primary key/unique\, foreign keys)\ , provide standard use cases\, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) goo d constraint usage. Attendees will enjoy learning how to keep THEIR data o ff the tabloid page! LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1555 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:DBA DTSTART:20130504T150000Z DTEND:20130504T160000Z SUMMARY:Using Windows Azure to provide SQL Server Disaster Recovery DESCRIPTION:This session provides an architectural blueprint to \;deplo ying disaster recovery solutions combining on-premise and Windows Azure cl oud \;technologies. \; The session looks at a \;design pattern to solve a long standing and often expensive issue of Disaster \;Reco very for the data platform. \; Understanding \;and utilising the s trengths of SQL Server on Windows Azure to provide Infrastructure \;as a Service enables IT to deliver a cost effective solution to business&nbs p\;continuity.\n\nThe session reviews \;capabilities \;of the Azur e platform\, \;including highlighting differences between Windows Azur e SQL Database and \;Windows Azure. \; The session looks at implem enting \;a disaster recovery strategy that combines AlwaysOn to provid e DR. \; The session looks at the prerequisites\, \;challenges\, l imitations and benefits of this architecture &ndash\; including security\,  \;network configuration and performance. LOCATION:SQLBits Conference - Suite 2 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1478 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T095000Z DTEND:20130503T105000Z SUMMARY:Hadoop, Big Data and SQL Server DESCRIPTION:There has been rapid development in the capabilities of SQL&nbs p\;Server to support big data and hadoop following introduction of the HDI nsight \;Service and HDInsight Server. \; The big \;data conce pt is gaining momentum and a hot topic with many data rich \;organisat ions who are interested in mining intelligence from unstructured data sour ces. \; This session will define the terms\, concepts \;and provid e demos of integrating big data into SQL Server solutions.\n\nThe session will cover options for on-premise and cloud \;deployments and examples for BI and data professionals to get started in understanding \;the c apabilities and strengths of this technology. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1485 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T111000Z DTEND:20130503T121000Z SUMMARY:ETL shootout-SSIS vs Powershell DESCRIPTION:I know what you're thinking\, Powershell is not an ETL tool. An d 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 inst ead 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" LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1492 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130503T124000Z DTEND:20130503T134000Z SUMMARY:High Performance SANLess Clustering DESCRIPTION:Learn how to eliminate the bottlenecks and costs of SAN-based c lustering. Leverage the performance of SuperMicro's 2U Twin featuring Fusi on ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection &ndash\; at a price you can afford. Join us and you could win a £\;50 gift card. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1498 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T134000Z DTEND:20130503T144000Z SUMMARY:The Developer Side of Master Data Services DESCRIPTION:The Master Data Services offers an easy to use toolset to work with Master Data. In this session we will explore the hidden power of MDS to integrate this service in our solutions. MDS provides ways to programma tically accessed all tasks. We will see how to automate all the functions of MDS and how to build our own frontends for our data stewards. Take your MDS Project on a higher level. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1505 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130503T150000Z DTEND:20130503T160000Z SUMMARY:SSIS 2012 logging and monitoring DESCRIPTION:Building Integration services packages is one. Creating a monit oring solution for all packages and ETL processes is something different. Good monitoring however can be a live safer\, or \; may be it is simpl y part of your functional specs.\nIn this session we will recap how loggin g worked in SSIS 2008. We will then discuss some of the features introduce d in 2012 and the benefits of project deployment. We will dive into the SS ISDB catalog views and discuss pro&rsquo\;s and con&rsquo\;s of the availa ble views. We will add our own logging to packages to extend the out-of-th e-box logging available in SSIS 2012. We end this demo-only session by bui lding a simple SSRS report on top of the logging we build/configured for o ur packages. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1566 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z DTSTART:20130503T160000Z DTEND:20130503T173000Z SUMMARY:Party Setup DESCRIPTION:Party Setup LOCATION:SQLBits Conference - Exhibiton area PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1514 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T071000Z DTEND:20130504T081000Z SUMMARY:Scaling Out SSIS With Parallelism DESCRIPTION:An introduction to scaling out packages using parallelism with the "Work pile" pattern\, balanced data distributor and "Roll your own" te chniques. This will also cover how to achieve elastic style scale out and how well different approaches scale across CPU cores\, including scaling w ith hyper threading turned on and off and an investigation into what the t he affects of L2 cache splitting. Comparisons will be drawn between achiev ing parallelism using SSIS and the query execution engine\, specifically a round parallelism start up costs\, partitioning workloads between threads and the impact of serial regions on the throughput of parallel schemas. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1522 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T081500Z DTEND:20130504T093000Z SUMMARY:SQL Server 2012 Statistical Semantic Search DESCRIPTION:SQL Server 2012 introduced an important extension to its integr ated Full-text Search\, namely the Statistical Semantic Search. In this se ssion you will learn how to install and configure this new functionality\, how to use it to extend your existing full-text search capabilities\, and how to utilize it properly to improve your information management solutio ns. You will learn how to automatically extract key phrases from your docu ments\, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1529 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T095000Z DTEND:20130504T105000Z SUMMARY:New Analytic Functions in SQL server 2012 DESCRIPTION:In this session I'll be exploring all of the below new analytic al functions of SQL server 2012. \nCUME_DIST \nLEAD  \;\nLAG \nFIRST_V ALUE\nLAST_VALUE \nPERCENTILE_CONT\nPERCENTILE_DISC\nPERCENT_RANK\n\nI'll be explaining how this functions works \, where we can use these functions . How we were achieving the same in earlier version and now how simple it is to achieve the same. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1536 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:BI DTSTART:20130504T111000Z DTEND:20130504T121000Z SUMMARY:Dynamic MSBI content generation 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 yo u 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 content manually? Join me to review differen t existing frameworks for developing content dynamically for Microsoft BI tools. \nThe only existing constant in the nature is the change\, so we be tter be ready to face it. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1543 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:SPN DTSTART:20130504T124000Z DTEND:20130504T134000Z SUMMARY:Real World Data Movement with Attunity Replicate DESCRIPTION:In this lunchtime session\, Attunity will highlight real custom er implementations of Attunity Replicate and the Microsoft BI technology s tack that enabled them to achieve competitive advantage. \;\nJames Rol and-Jones will help spotlight the success of a leading German mobile telec om company using Attunity&rsquo\;s high-performance data replication solut ion for real-time data loading from Oracle and SQL Server to a new replica tion layer and onwards to their Microsoft PDW system. \;\nWe will also present SMART Modular\, a technology leader in the design\, development\, and deployment of current and next-generation memory products. SMART Modu lar has implemented Attunity Replicate on their SAP Oracle implementations and SQL 2012 production systems to replicate data over their WAN for real -time management reporting.\n\n\nAttend this session to learn about these companies&rsquo\; project goals\, the challenges they faced along the way and the innovative solutions they used to successfully achieve company-wid e BI and analytics LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1549 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T134000Z DTEND:20130504T144000Z SUMMARY:Lightning Talks DESCRIPTION:A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love. LOCATION:SQLBits Conference - Suite 4 PRIORITY:0 END:VEVENT BEGIN:VEVENT UID:SQLBITS1556 DTSTAMP:20130619T194710Z CLASS:PUBLIC X-MICROSOFT-CDO-BUSYSTATUS:BUSY TRANSP:OPAQUE SEQUENCE:0 CREATED:20120118T113027Z LAST-MODIFIED:20120118T113027Z CATEGORIES:Dev DTSTART:20130504T150000Z DTEND:20130504T160000Z SUMMARY:Estimation, Statistics and “Oh My!” DESCRIPTION:\n\nAt the heart of SQL Server is the cost based optimizer.&nbs p\; Stop and think about that a minute\, it\nattempts to give the &ldquo\; best plan&rdquo\; based on the cost of the work undertaken. \; How doe s it know the cost of the work before\nits done the work ? This isn&rsquo\ ;t a conundrum\, it doesn&rsquo\;t. \; It estimates! \;\nHow does it estimate ? That is statistics.\n\nThis will be a deep dive into how the optimizer makes its\ndecisions to give you a plan\, the things that can g o wrong and how you can have\ninfluence over these choices.\n LOCATION:SQLBits Conference - Suite