Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 38
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Targaryen

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven't had a chance to dive in and figure out how to develop one yourself? Now is the time!
SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Stark

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Using live demos, this session will demonstrate Tabular mode in SSAS.  With an emphasis on understanding why it works and behaves the way it does, you'll have the foundational knowledge to learn how to develop effectively in this new mode.

If you've been left confused by filter context, nested DAX measures, or the CALCULATE() function, come and get a better introduction.  It's OK to start is a beginner, I just don't want you stuck there.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Baratheon

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Big Data is a concept frequently talked about, but often misunderstood. This session aims to peel back the covers on "Big Data" by talking about industry trends and focusing on the capabilities of Microsoft's Analytic Platform System's Parallel Data Warehouse workload.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Lannister

Level: Intermedia

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite) 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Stark

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Joe Mack from Sogeti will be giving a demo of an end-to-end development scenario using Microsoft's cloud offerings. You'll see how to create and deploy an ASP.NET Azure Web Site for displaying data from an on-premise repository and another Azure Web Site to host a RESTful API to do all the heavy lifting. Joe will also demo an automatic deployment of code to an Azure Web Site on check-in from Visual Studio to Microsoft's cloud-based Team Foundation Services offering.
Speaker:

Session Type:
Regular Session

Track:
Baratheon

Level: Intermedia

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

For most organizations, business intelligence means requesting reports from IT. The IT people then go into the company’s databases to find the requested information and deliver it. If the decision-makers want the data displayed in a certain way, they have to specify it in their requests—or, as often as not, they have to return to the IT office to make another request when they realize they need the data presented differently. But Power BI is what’s called self-service business intelligence. That means for most purposes non-technical users will be able to crunch the numbers without any help from IT. And switching to different graphics and displays is so easy the main difficulty is deciding which one to use.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Stark

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
Baratheon

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Some of the biggest challenges in any large SQL environment are maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Join us in this session to learn best practices for system settings, file system layout, and scheduling maintenance tasks. 

By default, SQL Server does not install with best practices for every environment. In this session, we will discuss the best practices for most SQL Server configurations, and how to automate your SQL Server builds in both physical and virtual worlds. As you may know, completely automating the build process has great benefits, but it also has great trade-offs. We will talk about lessons learned from building a private cloud at a Fortune 100 telecommunications company with thousands of servers. 

You will also learn how use these same methods to ensure your own server build consistency, whether your SQL Servers are in the cloud or on-premises.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Snow

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

High level overview of Change Data Capture, including what it is, how to configure it and how I can benefit by using it to populate my data warehouse.
Speaker:

Session Type:
Regular Session

Track:
Drogo

Level: Intermedia

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

The latest release of Access 2013 allows users to easily create web apps with a SQL Azure backend within the SharePoint environment.  IT departments are better able to manage user rights to these apps, providing better security, preventing data loss and offer a more robust record set.  Attendees will see a real-world app in action and learn about the pros and cons of using Access 2013 web apps.
Speaker:

Session Type:
Regular Session

Track:
Drogo

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Baratheon

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Session Type:
Regular Session

Track:
Snow

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

The key to becoming a great DBA is time.  The best way to regain some time is by spending less time doing the daily mundane work.  Let this mundane effort work autonomously.  We will introduce the basics in monitoring and maintenance.  The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
Speaker:

Session Type:
Regular Session

Track:
Snow

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Do It Yourself Geocoding -- Step-by-step instructions on how to build a CLR assembly that will allow you to directly query various web services for geospatial data. We will also learn how to ensure a high level of confidence in the accuracy of your geospatial data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Targaryen

Level: Intermedia

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns?  Did your gut tell you that this is bad, but you had difficulty explaining why?  Did you know that these Datatype Choices can be a real performance killer?  Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal.  Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now!  When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session

Track:
Stark

Level: Intermedia

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduced the revolutionary idea of columnstore indexes which basically turns the traditional table indexing strategy on its ear. Then in SQL Server 2014, Microsoft upped the ante with updateable columnstore indexes! In this session, you'll get a deep dive into how columnstore indexes work, the performance gains, the limitations and pitfalls, and how to work around them. There will be plenty of real world examples and demos to boot. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Drogo

Level: Intermedia

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you just breaking into the query tuning side of managing your SQL Servers?  In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process.  We will discuss how SQL Server creates and uses plans, and how to collect them.  Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean.  We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance.  We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.

Speaker:

Session Type:
Regular Session

Track:
Stark

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.
Speaker:

Session Type:
Regular Session

Track:
Drogo

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

XML can be a complex and confusing topic.  This session will give a basic introduction to some of the XML technologies needed to work with XML in SQL Server as well as some examples of how to get started.
Speaker:

Session Type:
Regular Session

Track:
Baratheon

Level: Beginner

Session Code:

Date: August 09

Time: 12:00 AM - 1:00 AM

Room: TBD

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