Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 24
Quote: “A good DBA is a lazy DBA”. When you have to manage a few SQL Servers, it’s not that hard to be a lazy DBA and to automate your day to day activities. But when you have to manage over 100 instances, it can become a tough job. Just imagine how you will deploy a new maintenance job on all your instances? Are you going to connect to each server one by one? Not really… Microsoft provides an enhanced set of multi-server management tools. The purpose of this sessions is to point out which SQL Server tools you can use for multi-server management. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Query plan shows how your query is physically executed and without a doubt, it is the best way to analyze most of the performance problems. We will delve into the internals of query plan operators, investigate how they work and where to look into query plan to find any problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Advanced

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

CUBE-functions are a little understood and seldomly used feature of Excel, but they have tremendous power for creating high-impact, custom reports that don’t look like pivottables at all. In this demo-rich presentation we start out by giving an introduction to what they actually do, then dive right into how to make them work for us. In the end we will investigate their use with Excel Services, Powerpivot Services and PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

DAX is still relatively new for many BI practitioners, but it has being used for more than 4 years now, also in large installations that push the xVelocity in memory engine to its limit. In this session, we will share some of the lessons learned from the field, where real customers have problems harder to solve than Adventure Works scenarios. How do you make a database fit in memory, if it does not fit? How do you handle billions of rows with complex calculation? Can you perform reporting in any time zone, with time intelligence, in an efficient way? What tools do you use to benchmark and choose the right hardware? How do you scale up performance on small and large databases? What are the common mistakes in DAX formulas that might cause performance bottlenecks? These are just a few examples of the problems that you will see in this session. You will learn the solutions found and how far you can push the limits of the system.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. 
When Indexing also combines 2 of the Enterprise features: Partitioning & Compression, we can often see substantial gains.

Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.

Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

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. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide 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 you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS is a powerful tool for extracting, transforming and loading data, but creating the actual SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over again. There are no easy ways to handle metadata and schema changes, and if there are new requirements you might have to go through all the packages one more time.

It's time to bring the Don't Repeat Yourself principle to SSIS development. In this session I will use the free BIDS Helper add-in to show you the basics of Biml and BimlScript, how to generate SSIS packages automatically from databases and flat files, how easy those packages can be changed, and how to move common code to separate files that can be included where needed. See why they say Biml allows you to complete in a day what once took more than a week!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

HDInsight on Azure improves your access to Hadoop and lowers the friction to getting started with learning and using big data technology, as well as to scaling to the challenges of modern information production. This session will cover a brief introduction to HDInsight Service on Microsoft Azure with hands-on scripts and demo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

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 focuses on tools and methodology to load test Analysis Services in highly concurrent environments. Including how to locate resource bottlenecks and the appropriate configuration settings that can help improve performance.
 
Sample source code will be supplied to help you load test analysis services. We will be focused on the MOLAP engine, but techniques are equally applicable to the  tabular model.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone knows that hardware today is immensely powerful in all aspects- CPU, memory and even IOPS (with proper configuration). It is less appreciated that in recent versions the SQL Server query optimizer can quickly find a good executions plan from a staggering number of possibilities. And yet it is also generally understood that performance is still an important topic today. This apparent paradox stems from the fact that when mistakes happen in software – especially for database query optimization, it can happen in spectacular fashion. Several examples of SQL that can experience catastrophic performance problems are presented, along with the method of diagnosis and corrective action.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Did you know that Power View is not any longer limited to getting data from Tabular models ? Now that Power View users can connect to multidimensional BI Semantic Model (Cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. 
The session we'll present
- An understanding of the Multidimensional Model Objects in Power View
- How to create a Shared Report Data Source Connection to a Multidimensional Model
- How to create a Power View Report with a Multidimensional Model Data Source
- An visual exploration of a Multidimensional Model by using Power View
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will demonstrate some of the functionality of the scripting components in Integration Services based on practical use-cases and real world applications. You'll see how to parse stange fileformats, how to create your own Data-Driven subscription of Reporting Services among other things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

It's probably rare that you have to install a SQL Server instance manually. You most likely have some unattended install scripts ready and perhaps even a script, using powershell, which configures the newly installed SQL Server according to your (corporate) standards.

But "at home" developers can click a few buttons in Windows Azure and have a SQL Server available within minutes. They are starting to be less impressed with your one-day process. In this session I'll walk you through the steps that you can take to create your own private cloud. Including rolling out sysprepped SQL Server vm's, giving your internal customers self-service capabilities but without losing control over your (corporate) standards. Did you know that you can even get a user interface for your internal customers which looks exacly like the Windows Azure interface?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session aimed at the novice query tuner we'll explore what big results may be yielded through the smallest of query tweaks. We will explore impacts of removing unnecessary joins, predicate blunders and problems with returning too much information.  The end result is to improve those bad queries and make you look like a tuning superstar.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

You can learn SQL in three days but it'll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn't work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven't done them yet.

We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SQL Server 2014 brings to market new capabilities to simplify cloud adoption and help you unlock new hybrid scenarios. This demo-filled session will highlight these top features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud  by providing new disaster recovery and backup solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will present a live comparison between the SMP and MPP versions of SQL Server, with a special attention to architecture , hadoop integration and Performance! The spirit of the session will be “Forget the slides… let’s just do live Demos!”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: August 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 24
Back to Top cage-aids
cage-aids
cage-aids
cage-aids