Toggle navigation
FAQ
Venue & Travel
Sponsors
Sessions
Training Days
Wednesday
Thursday
Friday
Saturday
Login
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Tags
AlwaysOn
(5)
Analytics
(3)
Azure
(7)
BI
(8)
data warehousing
(3)
DAX
(6)
DBA
(6)
ETL
(4)
high availability
(7)
master data
(2)
memory
(4)
partitioning
(3)
performance
(25)
Power Pivot
(3)
PowerShell
(3)
Pyramid
(2)
SSAS
(9)
SSDT
(2)
SSIS
(4)
SSRS
(2)
Content Type
Slide Deck
24
OtherSample
11
Video
71
Search
Conference
SQLBits XI
73
Advanced Data Visualisation in Reporting Services 2012
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.
Advanced SQL Server 2012 HA and DR Architectures
In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads.
Always ON Overview & Field Experience
The introduction of Availability Groups in SQL Server 2012 and the flexibility this gives administrators is truly awesome. In these session we will cover what Availability Groups bring to the table
An introduction to the wonderful world of OData
Join me as I guide you through the architecture and capabilities of the OData protocol. Data has been locked inside applications for too long, allow me to show you how to implement OData and open up the data silos inside your company today!
Analysis Services for the DBA
Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
Cleaning Up Dirty Data with SSIS
In this session, we'll review methods for cleaning up dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native components, T-SQL, SSIS scripting, and DQS.
Data loading at warp speeds
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
Data Modeling for Analysis Services Cubes
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.
Database Design: Size Does Matter!
Great database performance starts with great database design. During the design process it is important to select your SQL Server datatypes wisely. Failure to do so will result in wasted disk space, additional I/O overhead, and decreased performance.
DAX Query Engine Internals
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.
DAXMD: SSAS Multidimensional meets DAX and Power View
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.
Dynamic MSBI content generation
In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and changes are constant. This session reviews different methods for generating MSBI content (SSIS, SSRS) dynamically.
Enabling Flash to Support Mission-Critical Applications
In this session we will discuss how using flash with intelligent caching can allow an economical mix of flash and HDDs to be used to provide huge performance gains
Estimation, Statistics and “Oh My!”
At the heart of SQL Server is the cost based optimizer. This is driven by estimates and they in turn are driven by statistics. This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong.
ETL shootout-SSIS vs Powershell
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.
ETL with Hadoop and MapReduce
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.
Everything you always wanted to know about MERGE
In this demo-rich session, Hugo Kornelis shows how the full syntax of MERGE enables more than just synchronizing data. You'll get an overview of all the available options, plus a few surprising pitfalls you may not be aware of.
Excel 2013 - Whats new beside PowerPivot and Power View?
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
Excel 2013 Analytics
Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.
From SQL Traces to Extended Events. The next big switch
This session will give you insight into both of the current tracing technologies in SQL Server. Old SQL Trace has served us well but new times call for new technology. The new Extended Events are a new lightweight tracing mechanism built into SQLOS.
Fusion ioN Data Accelerator – software defined storage
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.
Geospatial Data Types in SQL Server 2012
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.
Gone Clustering in 60 Minutes
This session teaches 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 infrastructures.
Hadoop, Big Data and SQL Server
There has been rapid development in the capabilities of SQL Server to support big data and hadoop following introduction of the HDInsight Service and HDInsight Server. This session covers SQL Server capability and integration points.
High Performance SANLess Clustering
Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of SuperMicro's 2U Twin featuring Fusion ioMemory and achieve higher levels of availability with SIOS
Incremental processing of SSAS Multidimensional databases
Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.
Inside xVelocity InMemory Engine (VertiPaq)
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.
Introduction to the Pyramid Analytics BI Platform
This session will introduce you to the Pyramid Analytics Platform and Architecture and demonstrate some of its innovative and game changing capabilities, from analytics to dashboards to reporting, with full central management and control.
Kerberos for SQL Server and SharePoint the easy way
I would like to present easy to follow principles of Kerberos configuration with handy tips and templates to get this right the first time for your particular environment.
Keynote - Architecting Large-Scale Solutions on Azure
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.
Layered Partitioning - manage very large data sets
“Just use partitioning” is the answer you hear, when you need to manage very large data sets in your Data Warehouse. But how do you design and implement it? We will walk through different ways to design partitioning, including layered partitioning.
Lean and Mean: Running SQL Server on Windows Server Core
Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management, along with lots of tips and tricks.
Lightning Talks
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
Maintain SQL Server System and Performance with PowerShell
This session will demonstrate scripts to gather server inventory data and SQL Server and operating system performance data with PowerShell and provide reports to stay on top of your servers.
MDX vs. DAX: Currency Conversion Faceoff
Compare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Features covered can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal.
Modern Data Warehousing Strategy
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.
Monitoring and Performance Tuning for AlwaysOn
SQL Sentry will present their revolutionary new software which provides enhanced visibility and manageability for advanced AlwaysOn topologies.
Moves Like Jagger: Upgrading to SQL Server 2012
Upgrading SQL Server is one of the most challenging and risky operations that you will perform as a DBA. Make the wrong move, and you could be heading for the exit. In this diverse session, we'll take an in-depth look at moving to SQL Server 2012.
New Analytic Functions in SQL server 2012
There are new functions introduces with the release of MS-SQL Server 2012. To perform analytic operation in T-SQL , this time Microsoft has added couple of very handy functions.
Optimizing SQL Server Performance in a Virtual Environment
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
Quantifying the cost of Compression
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.
Query Tuning in the Clouds
Just because you're using an Azure SQL database does not mean you can avoid tuning queries. This session will introduce you to the tools you have available to identify poor performing queries, understand, and fix them. All in the cloud.
Real World Data Movement with Attunity Replicate
In this lunchtime session, Attunity will highlight real customer implementations of Attunity Replicate and the Microsoft BI technology stack that enabled them to achieve competitive advantage.
Real world SSDT
SQL Server Data Tools (SSDT) provide a new declarative model for building SQL Server databases. Come and learn more from Craig and Jamie who have both been using SSDT to do that for many months.
Scaling Out SSIS With Parallelism
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
Searching Binary Data in SQL Server 2012
A look at binary data in SQL Server and full-text searching of the content of binary files.
Seeking SQL Server Secrets
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.
SQL 2012 Always on Deep Dive
Always On Availability Groups offer a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in SQL 2012 emphasizing key features and benefits.
SQL Azure for the DBA
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
SQL Server 2012 Memory Management
SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one, discover all these important changes
SQL Server 2012 Statistical Semantic Search
Learn about Statistical Semantic Search, the newest addition to Full-text Search in SQL Server 2012.
SQL Server in Windows Azure Infrastructure as a Service
Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.
SQL Trivia Bowl
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!
SSIS 2012 logging and monitoring
In this session we will learn about the SSISDB catalog views. We will use this info plus our own info to build a monitoring solution for SSIS using SSRS.
Table-Based Database Object Factories
Ever had to write a large number of similar stored procedures, audit triggers, archive tables, views, etc.? Let SQL Server do the work for you! With some custom functions, stored procedures and extended properties, this no longer has to be a chore.
Tame Your Unruly Data...With Constraints!
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
The Developer Side of Master Data Services
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. Take your MDS Project on a higher level.
The Posh DBA: Troubleshooting SQL Server with PowerShell
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
Thwarting Database Defects
This demo-packed session introduces you to database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.
Top Ten Crucial Dev Skills to Make Your DBA Happy
Attend this session to learn about 10 techniques that developers can apply to their code which will calm your DBAs’ fears and earn their admiration
Transact SQL Performance Tips
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.
Transforming PowerPivot into Enterprise BI with Pyramid
PowerPivot is a breakthrough for self-serve BI but is not easily deployed in the enterprise. Join us for this fast-paced, technical demonstration on how to upgrade PowerPivot into secure and scalable Analysis Services tabular cubes
Troubleshooting the most difficult SQL Server problems
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!
T-SQL : Bad Habits & Best Practices
This session will cover a collection of minor bad habits that can occasionally lead to major problems, and a set of best practices that you should always have in mind.
Unit Testing in TSQL
A two-in-one presentation
Using SQL Server 2012s Always On
In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution.
Using Windows Azure to provide SQL Server Disaster Recovery
This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.
War stories from implementing SQL Server 2012 AlwaysOn
I will illustrate how SQL AlwaysOn can be used as a tier 1 solution. I will go through the barriers and misconceptions that I tackled whilst implementing it within the real world.
Why APPLY?
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.
Windows Azure For SQL folk
We aim to cover the fundamental concepts that you should know on the Cloud and Windows Azure. In this demo based hour we will step through building Azure applications, deploying and managing them and what storage choices you will face.
Windows Azure SQL Database Troubleshooting
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.
XML: The Marmite of SQL Server
The pros and cons of using XML to store and access data with SQL Server 2008.
Ye olde tavern quiz
Join the Dell Software Group (formerly Quest Software) for our traditional fun filled lunchtime quiz. we’ll question your knowledge from middle age to cutting edge technology and best practices
<<
1
>>