Is Slovensko and Slovinsko the Same Thing? (400)
In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server 2012 work. We are going to use four different algorithms that come in R2 with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. We are going to introduce how Data Quality Services (DQS) help us here. We are also going to tackle the performance problems with string matching merging.
What does “kuraci” mean? (300)
Text mining is becoming more and more popular. Everybody would like to understand data from social media. In this session, we are going to show how you can extract information from documents with SQL Server 2012 Integration Services text mining components. We will analyze this information with further Data Mining methods. We are also going to show how Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents.
SQL Server 2012 AlwaysOn (300)
Business continuity is becoming more and more a central topic for many companies. AlwaysOn is the new solution for high availability and disaster recovery introduced with SQL Server 2012. With the help of live demos, in this session we will cover in details this new technology that extends on the familiar concepts of database mirroring and failover clustering. We will also introduce some other engine enhancements that will help raising the overall service availability.
T-SQL Window Functions (300)
This session covers a group of functions in T-SQL called window functions that can help in addressing a wide variety of querying tasks. The session first describes the limitations and shortcomings of traditional, or classic, T-SQL constructs that are used to address common querying tasks. It then explains how window functions address those limitations very elegantly and efficiently. The session describes the different types of window functions, which are aggregate, ranking, offset and distribution functions, as well as their optimization. The session focuses on enhancements of window functions in SQL Server 2012.
Query Tuning Tips (400)
This session covers multiple query tuning tips that can help you improve the performance of your queries. It covers tips concerning parallelism, how to employ query revisions as a tuning technique, understanding scaling, and more as time permits.
Pivoting and Unpivoting Data, Including Specialized Cases and Solutions (300)
This session covers pivoting and unpivoting of data. Pivoting means rotation of data from a state of rows to a state of columns, and unpivoting means rotating data from a state of columns to rows. This session first covers fundamental techniques to achieve pivoting and unpivoting, but then goes into more specialized cases and their solutions.
Identifying and Solving Sort Warning Problems in SQL Server (300)
Sometimes SQL Server spills sort operation to tempdb although there is no memory pressure. Why and when it happens and why SQL Server raises a "Sort Warnings" event and what does it mean you can find in this session. We will see how to identify this problem in SQL Server 2008 and more elegant in SQL Server 2012 and of course we can discuss how to prevent this problem.
Top 10 things you shouldn’t do with your database (300)
There are always bad thinks that could happen with your database. You will be surprised how many of them are happening as a result of our actions or lack of proper attention. If you know them and how they harm your database system it will be easier to not get there. The session shows the worst practices from the field in administering, implementing and developing SQL Server databases and gives recommendations and tips and tricks how to avoid them.
SQL Server 2012 FileTable (300)
Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FileTable is an extension that is accessible using Transact-SQL - just like any other table inside the database, while at the same time also allows access to the data using the operating system File I/O API - i.e. just like any other folder in the file system.
In this session we will see how to implement, use, and administer FileTables in the latest version of SQL Server.
Relational BI with SQL Server 2012 (300)
With SQL Server 2012 and the introduction of Column Store indexes, huge amount of data can be queried extremely fast. Adding to this also the new OVER extensions that allows more complex data analysis and with other additional T-SQL features made available from the previous release, like MERGE statement, GROUPING SETS and STAR-JOIN optimizations, the possibility to use the relational engine only to create a BI solution is much more appealing right now. In this session we’ll see how far we can go just using T-SQL for BI.
|
|