Come to this session to pick up some tips and tricks for advanced reporting writing, that is also in accordance with thinking by Data Visualisation gurus such as Stephen Few and Edward Tufte.
In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.
In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.
This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.
Big Data is hot! And the magic word is Hadoop. But what is it? And more important: what can I do with it? In this session we will cover some basics of Hadoop, MapReduce, Pig and Hive.
ioN Data Accelerator software transforms industry-leading open server platforms into powerful shared acceleration devices for multiple applications or clusters. Come learn how and why.
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
A deep dive in the internals of the database architecture, discovering how Vertipaq stores information, in order to gain better insights into the engine and understand the best way to model your data warehouse to leverage the features of VertiPaq.
While there are many similarities between SQL Server and SQL Azure, there are different kinds of applications that are easier to build in one or the other. One of the major differences relates to how to build an application that “scales”. This presentation will provide an introduction into the difference between scale-up (SQL Server) and scale-out (SQL Azure) architectures and give you a primer on how you can build a large, Internet-facing service that can scale to arbitrarily large sizes on commodity hardware. This talk is targeted at SQL Server practitioners to give them a working knowledge of how the two platforms differ based on Microsoft’s experiences with its largest Software-as-a-Service (SaaS) customers running on SQL Azure.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature.
In this session, I’ll tell you about some of my favorite undocumented features, and also tell you some of my tricks for discovering more undocumented secrets.
In this session we are going to look at the some of the flavours 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
In this session we will advice how to avoid common developer mistakes and show how bad designed queries reduce the SQL Server optimizer's capabilities for choosing an optimal execution plan.
Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session!
Most T-SQL developers know that the APPLY operator can be used to invoke a table valued function. But do you know the other ways APPLY can be used? Come learn five additional use cases and leave with a few new tricks up your T-SQL sleeves.
While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.
It's 2AM and Disaster just began... In this session I want to discuss about best practices for surviving disaster, based on my experience in few years in data center. I presented this session as Lightning Talks in Liverpool. Now is the time for full
Karen discusses five (plus a few more) database design blunders with tips on how to avoid them. Audience members will also be able to contribute their war stories of design fails, WTHs and D'ohs.
SSIS in SQL Server 2012 has a lot of new features to help control larger projects. I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) This session will be a will be a walkthrough of this process and a lessons learned
In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.
An in-depth dive into physical table structures
SQL Server Integration Services (SSIS) 2012 includes a new database referred to as the SSIS Catalog. Come to this session to learn what it does and how its going to change how you do SSIS development.
Mission critical is a major focus of SQL Server 2012. There are quite a few changes in this release to ensure that you maximize your uptime and reliability when it comes to SQL Server. This session will start preparing you for what is coming.
Learn how Varigence tools accelerate BI development, enhance reusability, and improve agility through the use of customizable patterns and automation scripts and transform your metadata into comprehensive BI solutions.
This session will cover advanced security topics in the Analysis Services Multidimensional model.
In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to?
Migration, Security, Administration and other tips and tricks.
We'll focus on the awesome new SQL Server 2012 stuff that will make your T-SQL development a breeze. We'll look at new stuff like OFFSET, WINDOWING FUNCTIONS, SEQUENCES, ERROR HANDLING, FORMAT & CONVERT functions and METADATA DISCOVERY.
In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel.
: We are looking at the dawn of a new workload: BigData. In this session I will talk about what BigData is, and which BigData technologies Microsoft are working on.
The Microsoft BI stack has a number of tools for data visualization - Excel, Power View, native Reporting Services, and Performance Point. Come see each visualization applied to the new tabular model in Analysis Services.
Users love flexible analytics but hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea.
Declare how you want your schema to look like, not how you want to implement it. Using the SQL Server Data Tools, you define your database schema in a declarative form and deploy it as such!
Do you want to learn how Microsoft helped one of the largest Financial Services organizations in the world design a Private Cloud infrastructure using Windows Hyper-V and System Center 2012 to standardize and consolidate hundreds of SQL Servers?
This talk will cover how the distributed query feature in SQL Server works, end-to-end. Topics include the query model, metadata, query optimization, execution, distributed transactions, and scale-out scenarios via Distributed Partitioned Views(DPV)
This talk will explain the patterns that we recommend to customers when designing data warehouses. This talk will help people learning about DW for the first time and also give insight for those who wish to learn more.
In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.
But were afraid to ask.
Pyramid Analytics burst onto the Microsoft BI scene with not only a full roadmap for ProClarity users, but also with cube driven dashboards that offer rich functionality – yet are easy to design and deploy by business users.
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
A beginners guide to using Extended Events Sessions to monitor your servers.
SQL Server FastTrack References Architecture gives you the best practices and reference architectures from different hardware vendors to help you create a balanced environment for your data warehouse workload.
More data, less time, storing everything. These ingredients mean it is becoming imperative we do not move the kitchen sink everytime we do our ETL Come to this session to find out how.
Join Quest Software’s Kevin Kline as he takes you on a guided tour of some of the worst and most horrible IT experiences. Some of them were intentional and some were accidental, but all of them will make you wince. Most are great for a laugh!
Introductory Relational Theory Using Lego Bricks to Model Data and Set Operations
Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Hierarchies are the bread and butter of most business applications (departmental diagram, product categories, sales territories, calendar, …). See typical business problems and how they are solved in SQL Server.
Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.
This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.
This session will do a brief overview of Analysis Services 2012 performance topics, and drill into some common methods for investigating performance issues. The talk will be adjusted based on the audience interests.
Join X-IO to learn how customers like Redknee and Temenos are combining SQL Server 2012 with X-IO intelligent storage to generate higher performance at significantly less cost. Learn why storage is on the verge of a revolution.
Presenting your ideas is essential – from a simple team meeting to a hall of thousands of listeners, it’s vital that you have this skill. But how do you make your presentations effective, useful and interesting for everyone.
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We'll also take a look into the ups and downs of each
Are your big queries using every available clock tick, or are they lagging behind? And if your queries are already going parallel, can they be rewritten for even greater speed? In this session you will learn how to take full advantage of parallelism.
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
In this deep(!) dive session. I will walk you through the internal storage format of MDF files. I'll cover how SQL Server stores its own internal metadata, how it knows where to find your data, and how to read it once found.
The Column Store Index is an
exciting new technology in SQL Server 2012. Using column stores, you can
unlock new levels of performance for data warehouses – often gaining an order
of magnitude speedup on queries.
This talk will describe how the new ColumnStore index technology in SQL Server 2012 makes queries go faster. Covering details of the storage and execution model, how this model interacts with modern CPUs to deliver significant performance benefits.
In this presentation, we provide an introduction to SQL Azure Federations and also show
some interesting patterns that provide additional capabilities such as
scale-out query processing, cross-shard schema management and multi-key sharding.
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.
In this session, Noemi and Tom explain how they developed a system to import information from Twitter into a SQL Server data warehouse, and to export their analysis into Google Docs using Red Gate tools to help them on their way.
The addition of spatial data to SQL Server 2008 is one of the most important in terms of integration in line-of-business applications. This talk will discuss the new features and performance enhancements in SQL Server 2012.
Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.
Data is the most important asset in every business. SQL 2012 introduces the new innovative Knowledge Driven Data Quality Services that allows IT and Data Users to define and use Knowledge effectively for data cleansing and validation.
This session will present you with a fascinating behind-the-scenes deep-dive view of the new column store index feature. How do column store indexes work? How are they built? And how can they yield such enormous performance boosts to some workloads?
This discussion will consist of the project team from a recent SQL Server 2012 production deployment delivered for a leading European tour operator - Sundio Group together with partner Coeo and Microsoft SQLCAT.
The fill-factor index option has a huge impact on the performance of your DB. By using a different approach for specific use cases this session will give you the tools to find the most optimal fill-factor for your tables.
Let’s have some fun! Using a game show style presentation, Kevin will test your knowledge of IT pop culture, IT history, computers, database technology, and – of course – SQL Server.
Winners get prizes!
This demo intensive session will show off the new features and enhancements designed to ease adoption for new users and increase productivity for experienced SSIS developers
Learn all about the integration of Business Intelligence Markup Language (BIML) into BIDS Helper and see what it can do for you. BIML can help you automate the creation of SSIS packages, reduce maintenance and help code re-use across projects.
System Center Advisor assesses your servers’ configuration and helps you proactively avoid downtime, performance degradation, and data loss. It only takes 5 minutes to setup and is accessible wherever you have a web browser.
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.
This session reviews the purpose of NUMA, how it changes the internal behaviours of Windows and SQL Server 2012 and NUMA related performance monitoring.
Based on healthcheck reviews of hundreds of SQL Servers across dozens of customers, I'll talk you through the 10 most commonly made mistakes by action or inaction and what you can do to make sure your SQL Servers get a clean bill of health.
Reporting Services is a powerful tool that can make designing reports a snap...most of the time. Design format starts with your report query. Take your queries to the next level with MDX concepts to conquer the trickiest report layouts.
We are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas that require to think out of the box, using advanced data modeling techniques.
Learn how the SQL Server Data Tools can help you migrate your on-premise SQL Server databases to SQL Azure
Microsoft SQL Server is one of the easiest database to setup and administrate. But that doesn't mean it's problem free. Find out the most common DBA mistakes on SQL Server so that you can make sure not to make them!
For the most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most critical component in a SQL Server installation and is used by your applications and also internally by SQL Server.
Sometimes some piece of T-SQL slips by, or falls out of memory.Come and revisit old favorites, and brush up on new T-SQL features and enhancements.This session is chock full of code examples, including before-and-after demos and how-to illustrations.
SQL Server optimizer doesn't use and index seek for execution of your query although the query is high selective? What is better, when and why: LIKE vs: SUBSTRING, IN vs. EXISTS, SUBQUERY vs. JOIN. Why you should not use the UPPER or LOWER functions?
Do you have data warehouse queries that run too long? In this session we’ll address how columnstore indexes speed up queries, best practices for creating and using columnstore indexes, and how to diagnose and treat potential issues.
In this session, Pete Harris, Chris Testa-O’Neill and Christian Bolton will provide an overview of the certifications and training offered by Microsoft for SQL Server 2012.
Unit testing is incredibly beneficial, but is very difficult to do effectively in SSIS. If you have wanted to do this, but aren't sure how, this session will cover the options and demonstrate a free tool for unit testing packages.
In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "Always On" features including site to site configurations to allow of a large scale high availability solution.
In this session, we'll examine the query plan cache to see what plans are saved, what plans are reused, when plans are recreated, methods for observing the contents of the plan cache, and finally,
methods for manipulating plan reuse and recreation.
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast?
Would you like to see examples of advanced SSRS reports that you do not see every day and which are not very easy to build (if you don’t know how) but are very useful for business users?
This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.
We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.
SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.
In this session you'll get a good introduction of the concepts and advantages of Biml as we walk to the creation of Meta Data Driven SSIS Solution.
Data Quality Services is a new product coming in the SQL Server Denali release of Microsoft SQL Server. Come to this session to understand how it can take your data cleansing to the next level.
This session will provide expert advice & best practices for replicating Oracle (& other) data to SQL Server for data warehousing & BI initiatives. Also, become one of the first to see Attunity’s innovative new software in its historic unveiling!
Juneau is a new developer tool in Denali. Brings VS paradigms to SQL Server like Debug, Refactor and Declarative maintenance. Come to this session and learn what these tools are really about.
This session will cover why you should run database unit tests (and when you should not). It will show how to set them up and run them in visual studio 2010
Organizations risk being overwhelmed by data. How can you effectively provide a “single version of the truth”, while unlocking the key trends and insights that will allow your business to succeed? Come to this session to find out how.