12 Hours of SQL Server 2012: Agenda
| Timing | Title | Speakers | Abstract |
| 12:12-13:12 | Partially Contained Databases | Steve Verschaeve is a senior consultant and certified trainer at Kohera, Cronos Group and has been working with SQL Server 2000 since 2003. He is also Microsoft certified and currently holds an MCP, MCTS, MCITP and MCT in SQL Server and SharePoint. In his free time, he works as a webmaster for the Belgian SQL Server User Group and is a co-organizer of SQL Server Days. |
Partially Contained Databases(Partial-CBD) has been introduced in SQL Server 2012 RC0. A Partial-CBD is a type of user database sandbox which is isolated from the database engine and therefore has a high portability. They contain alle the necessary settings and metadata which defines a database.In this session we will discus how to set up a Partial-CBD, it's authentication and deploy it to another SQL Server 2012 instance. |
| 13:12-14:12 | An introduction to Data Quality Services (DQS) | Koen Verbeeck Koen Verbeeck is a Microsoft Business Intelligence consultant at Ordina, where he is an active member of the "Business Data Optimization" competence center. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. You can find him answering questions at the MSDN SSIS forum and at SQLServerCentral.com. |
Crap in, crap out. Most IT professionals working with data have probably heard this phrase a few times too many. The process of ensuring data quality is complex, difficult but holds a very important place in the corporate world of business intelligence. However, this process is often neglected or even skipped over in many projects, leading to the popular use of the CICO phrase. With the release of SQL Server 2012, Microsoft addresses this issue by releasing a new feature, Data Quality Services. This session aims to give an introduction to this service, and how it can be used to clean up data, polish it and take it up to a whole new level of "less crappiness". |
| 14:12-15:12 | Power View from the Data Visualisation Perspective | Jen Stirrup is a SQL Server MVP, with a Bachelors degree in Psychology and two Masters in Artificial Intelligence and Cognitive Science. Jen is Joint Owner of Copper Blue Consulting, delivering data and Business Intelligence solutions to global clients. Jen's focus is on the Microsoft BI stack, with a specific passion for Data Visualisation. Jen is a veteran SQL Server Developer with over 12 years SQL experience in delivering end-to-end Business Intelligence solution. Jen blogs for SQLServerPedia as well as her own blog. Jen is also active in the SQL Server community in the UK, Europe and in the US. Jen holds a Europe-wide role in helping to co-ordinate 'Women in Technology' events as a SQLPass volunteer, which covers WIT events in disparate countries from Sweden to Poland. Jen has delivered precons and general sessions as a speaker at SQLBits in the UK. In Europe, Jen has presented at SQLRally Nordic in Sweden, and SQL Server Days in Belgium in 2011. Jen also presented twice at the prestigious SQLPass Summit, which was held in Seattle in October 2011. In 2012, Jen will be presenting in Ireland, Poland, Sweden and in the UK. Jen has presented a webinar for the Professional Association of SQL Server, and also for Microsoft UK Techdays, organised by Technet. Jen also travels the UK to speak at local User Groups which are SQL Server Groups, general IT groups and also data-oriented groups. |
Power View is Microsoft's Data Visualisation tool. Where does it get it right, and where does it get it wrong? Using demos, we learn about Power View whilst assessing it based on current cognitive research around Data Visualisation principles by luminaries such as Stephen Few, Tufte and others.
Please virtually attend this webinar if you really want to think about the best ways of presenting data to your Business Intelligence data consumers, and see how to apply these principles in Power View. Learn how Power View can be used to effectively visualise data in order to drive strategic enterprise decisions. |
| 15:12-16:12 | Building your first Analysis Services Tabular BI Semantic model with SQL Server 2012 | Frederik Vandeputte is a Senior Consultant and partner at Kohera, the largest Belgian Company fully focused on SQL Server and Microsoft Business Intelligence. Frederik is one of the co-founders and the President of the Belgian SQL Server User Group (SQLUG.BE). In January 2008 Frederik, became the first Belgian MVP on SQL Server. |
Forget everything you learned about OLAP, MDX and UDMs and jump into the new era of tabular Business Intelligence Semantic Models (BISM). In this 100% demo driven session Frederik will show you step by step how to build your first Analysis Services Tabular project using SQL Server Data Tools. |
| 16:12-17:12 | What's new in Integration Services 2012? | Nico Jacobs Dr. Nico Jacobs is a SQL Server trainer and consultant at U2U since 2004. Before that, he was a data mining researcher at the computer science department of KULeuven. At U2U, Nico creates and delivers courses on the SQL Server business intelligence stack (SSIS, SSAS, SSRS) and the traditional relational database environment (database development and administration). Level: 300 |
Curious about what changed in SSIS 2012? From improved GUIs to new tasks and components, new deployment model, SSIS parameters (no no, not variables, although we still have those as well), data lineage, … this list seams endless. We'll see how much of them we can explain and demonstrate in an hour… we hope to cover at least 12 topics. |
| 17:12-18:12 | Manageability Enhancements of SQL Server 2012 | Pieter Vanhove is a SQL Server Consultant at Kohera, and has been working with SQL Server since 2000. He has a lot of experience with managing large databases in telecom and finance environments. Pieter has also a profound knowledge in implementing high availability and disaster recovery solutions (Microsoft Failover Clustering, Database Mirroring, Replication). Level: 200 |
Manageability of the Microsoft SQL Server 2012 Release Candidate 0 (RC 0) Database Engine is improved by enhancements to tools and monitoring features. The SQL Server Management Studio and Database Engine Query Editor introduces some new features. Also point-in-time restore, startup options, contained Databases, sqlcmd.exe, Database Engine Tuning Advisor and Dynamic Management View have been improved. In this session, you will get an overview of all those new enhancements. |
| 18:12-19:12 | Building the Perfect BI Semantic Tabular models for Power View | Kasper De Jonge is a program manager on the Microsoft Analysis services team based out of Redmond, WA. He has more than 5 years of experience as a developer and consultant to data warehousing solutions using all products from the Microsoft BI stack, from corporate intranets using SharePoint and Analysis Services to near real time reporting in the cloud. Kasper has spoken at conferences like PASS, SQLSaturday and TechEd. His blog can be found at http://www.powerpivotblog.nl |
Power View is the exciting the ad-hoc data visualization capability in SQL 2012 that relies on a Tabular BISM or PowerPivot workbook. Creating the right experience in Power View is dependent on creating the right model, and in this session we will cover everything from creating a basic model to one that will enable your users to fully realize the capabilities of Power View. |
| 19:12-20:12 | SQL Server 2012 and Big Data | Karel Coenye a senior SQL Server trainer and Consultant at Kohera, has been working with SQL Server in different roles since 1999. Currently working on different database projects as SQL architect while coaching and training other DBAs and developers. Experienced in both full development-environments as in production environments with large server with multiple large databases specialized in tuning, tweaking and monitoring. His IT passion drives him towards the physical and virtual bottlenecks while seeking ways to push systems towards their limits. Level: 300 |
SQL Server 2012 will include big data processing capabilities based on Apache Hadoop, Interest in Hadoop is driven primarily by the need to handle large volumes of loosely or inconsistently structured data such as social network feeds, Web logs, email, documents, and other text-centric information. These data types can be used for applications such as customer sentiment analysis, but they cannot be effectively managed in a relational database such as SQL Server. Microsoft will give customers several ways to exploit data from Hadoop. Available immediately will be final versions of previously announced Hadoop Connectors for SQL Server and the SQL Server Parallel Data Warehouse. In these session we will see what hadoop is, what it is not and how with these connectors it will enable us to pass large volumes of data between SQL and Hadoop, so that the results of big-data processing jobs on Hadoop can be analyzed with our familiar SQL analysis tools. |
| 20:12-21:12 | Extending your data to the cloud | Wesley Backelant In his role as a Technology Advisor at Microsoft, Wesley is responsible for helping customers understand the capabilities of SQL Server and the Microsoft Business Intelligence stack. Before joining Microsoft, Wesley was a Database Architect working on some of the largest implementations of SQL Server in Belgium. Wesley started his professional career in the SQL Server 6.5 timeframe and remained true to his passion ever since. Wesley is active on Twitter where he handles topics related to his favorite technology. |
In this session we will dive into the world of SQL Azure and how it connects to your on-premise SQL Server. We'll discuss the new .bacpac, SQL Azure Import & Export and how to seamlessly move databases to the cloud using DACs. Furthermore we'll see how you can get your data in the cloud with technologies like SQL Azure Data Sync and some of the projects in the SQL Azure Labs like Microsoft Codename "SQL Azure Compatibility Assessment" and Microsoft Codename "Data Transfer". |
| 21:12-22:12 | Database Schema Management & Deployment using SQL Server Data Tools (SSDT) | Gert Drapers is a Principal Group Program Manager in the SQL Server Data Services division, responsible for developer platform and tooling. In this role Gert manages the SQL Server Data Tools team, which builds the next version of SQL Server developer tooling which ships as part of SQL Server 2012. Gert his history with SQL Server dates all the way back to 1988. In 1996 he joined the SQL Server 7.0 engine team as a developer and since then has worked in many different roles, on many different things directly or indirectly related to SQL Server. Most prominent contributions are: SQL Query Analyzer, SQL Agent, SMO, DTS, System.Transactions, MS-DTC and XPSMTP. In July of 2005 Gert started the "DataDude" project which led to the creating of Visual Studio Team System Database Edition; from there on it is all history… Level: 300 |
Database development is complicated by nature! Database engines are stateful, so data loss is always a risk; object dependencies determine the order in which changes need to be applied and the loosely coupled nature of the SQL language can result in unexpected runtime errors. These are just a small collection of examples why database development is hard. The SQL Server Data Tools (SSDT) development environment helps developers getting a better handle on database development, testing, deployment and migrations. The declarative nature lets the developer focus on the final state they want, instead of writing an imperative script on how to change the state of the database directly. |
| 22:12-23:12 | Inside SQL Azure: Self Governing, Self-Healing, Massively Scalable Database Service in the Cloud | Cihan Biyikoglu is a Program Manager in SQL Azure covering the programmability surface for SQL Azure. These days, Cihan is focused on SQL Azure enabling scale-out programmability models for SQL Azure through a new concept called Federations. Prior to joining the SQL Azure team, Cihan was the program manager at Microsoft HealthVault platform and SQL Server as part of the SQLCAT team. Earlier, Cihan also worked on database technologies including Illustra and Informix Dynamic Server at Informix. Cihan Biyikoglu has a masters in Database Systems from University of Westminster in the UK and Computer Engineering degree from Yildiz Technical University in Turkey. |
SQL Azure is built ground up to be a cloud database service with massive scalability, high availability and combines all this with great economics. In this talk, we will look under the hood and see how SQL Azure is able to pull this off. We will look at the internals of the service that make it possible to scale to massive number of connections that can achieve support for vast number of databases and provide practically unlimited throughput across many geographies around the world. |
| 23:12-00:12 | Performance and High-Availability at Scale with SQL Server 2012 | Dandy Weyn Born and raised in Belgium, Dandy started his database career at the age of 16, working on various database projects. As Microsoft Certified Trainer (MCT) he traveled the world consulting and training on SQL Server for Enterprise customers. Dandy is a Sr. Technical Product Manager in the Core Database Product Management team, focusing on Migration and Massive Parallel Processing (MPP) with SQL Server Parallel Data Warehouse. He also participates in providing deep insights into the SQL Server core engine and database management on SQL Server's current and future product features and capabilities by actively being part of the Microsoft Certified Master (MCM) community. You can read more about Dandy's vision and positioning of SQL Server at: www.ilikesql.com. Level: 300 |
Examine how SQL Server 2012 has become an even better solution for Tier 1 and Enterprise applications. In this session we will look how to combine SQL Server 2012 features to optimize for a high available, optimized platform with maximum scalability. You will learn on how AlwaysOn contributes to and optimized data warehousing and OLTP solution. |