Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 28
In this session, we’ll discuss Agile BI Methodologies and benefits of rapid prototyping of reports using Microsoft BI Tools like PowerPivot and PowerBI. We will also look at what’s new in the PowerBI preview app and cross-platform and cross-browser support.
Speaker:

Session Type:
Sponsored Session (30 minutes)

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: May 30

Time: 9:45 AM - 10:15 AM

Room: 2523

Do you have multiple databases with distinct workloads running on a single SQL Server Enterprise Edition instance? Have you ever had a runaway process or bad query from one system bring an entire instance to its knees, impacting a wide range of end users? If you answered yes to either of these questions, then come learn about Resource Governor for SQL Server. We’ll spend the first part of this introductory session going over the concepts you will need to know in order to implement Resource Governor successfully. Once we've covered the basics, we’ll spend the rest of the session working through a number of demos, reviewing exciting enhancements to Resource Governor in SQL Server 2014, and discussing scenarios in which you can use Resource Governor in your environment right away. Hardware resources are a valuable commodity.  Learn how you can control them effectively in a multitenant environment, ensuring they are assigned where they need to be.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Beginner

Session Code:

Date: May 30

Time: 11:00 AM - 12:00 PM

Room: 2520C

The modern data platform is more than a server in your data center.  It goes far beyond that with the ability to reach beyond your data center to the cloud.  Through cloud offerings, you have the ability to grow past your current hardware limitations and deliver data solutions that grow and expand with your data needs. In this white board session, we'll explore cloud offerings for your data platform and how the support the needs of DBA to provide the infrastructure and performance that data platforms demand.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Intermedia

Session Code:

Date: May 30

Time: 2:15 PM - 3:15 PM

Room: 2520D

Power Query, a free add-in for Excel 2010 and 2013, will enhance the self-service business intelligence offering from Microsoft. With Power Query the business analysis along with the BI developer can combine and shape data from a wide variety of data sources in a quick and easy manner. This task can enable more time to be spent in analysis and discover and less time build ETL plumbing. 

This session will demo the ease of the data extraction process in Power Query. We will explore multiple data sources and even modify the language to create a foundation for further exploration into Power Query.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Self-Service BI

Level: Beginner

Session Code:

Date: May 30

Time: 11:00 AM - 12:00 PM

Room: 2390

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 data type choices can be a real performance killer? 

Attend this session to 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 will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Development

Level: Intermedia

Session Code:

Date: May 30

Time: 8:30 AM - 9:30 AM

Room: 2523

Did you know that SQL Server Availability Groups can be a great solution for disaster recovery?  Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup.  Extending an availability group to multiple sites for disaster recovery becomes more complicated.  A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration.  In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Intermedia

Session Code:

Date: May 30

Time: 2:15 PM - 3:15 PM

Room: 2520B

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI.  In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM").  He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”).  Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: May 30

Time: 2:15 PM - 3:15 PM

Room: 2523

There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will.  Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt.  And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA - Troubleshooting and Performance Tuning

Level: Intermedia

Session Code:

Date: May 30

Time: 1:00 PM - 2:00 PM

Room: 2520B

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.
Speaker:

Session Type:
Regular Session

Track:
DBA - Troubleshooting and Performance Tuning

Level: Beginner

Session Code:

Date: May 30

Time: 3:30 PM - 4:30 PM

Room: 2520B

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. 

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Development

Level: Intermedia

Session Code:

Date: May 30

Time: 3:30 PM - 4:30 PM

Room: 2520C

Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents.  Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.
In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected.  We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Self-Service BI

Level: Beginner

Session Code:

Date: May 30

Time: 8:30 AM - 9:30 AM

Room: 2520D

One goal of a DBA is to automate gathering information such as the specifications of all of your SQL Servers. In this session we will show you the basics of the PowerShell language. Then we will move on to how you can use PowerShell to go through a list of servers and grab information like the processor specs, check if the machine is a virtual image, memory size, SQL version, etc. and produce a formatted Excel file with the information. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Beginner

Session Code:

Date: May 30

Time: 9:45 AM - 10:45 AM

Room: 2390

If you've never queried an XML column you definitely want to attend.  While targeted to beginners this isn't a "Just do this" session.  After this hour I'd like you to truly understand even subtle nuances of basic query syntax.  Seasoned veterans stand a fair chance of learning something new.
Speaker:

Session Type:
Regular Session

Track:
Database Development

Level: Beginner

Session Code:

Date: May 30

Time: 2:15 PM - 3:15 PM

Room: 2520C

Get to know more about the Microsoft Analytical Platform System and how a MPP system is different than a SMP system.

Learn about how the MPP architecture can benefit hundreds of business use-cases and scenarios while providing phenomenal performance gains over a traditional SMP architecture.
Speaker:

Session Type:
Sponsored Session (30 minutes)

Track:
DBA - Architecture and Tools

Level: Intermedia

Session Code:

Date: May 30

Time: 8:30 AM - 9:00 AM

Room: 2520C

AlwaysOn is SQL Server 2012/2014’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity. In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously. 
Speaker:

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Intermedia

Session Code:

Date: May 30

Time: 3:30 PM - 4:30 PM

Room: 2390

This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour. 
Speaker:

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Beginner

Session Code:

Date: May 30

Time: 3:30 PM - 4:30 PM

Room: 2523

As SQL Server professionals, we have a complicated relationship with Excel-based tools. Rather than broadly paint Excel as friend or foe, why not learn how Power Query & Power Pivot can improve the SQL Server solutions you develop? In this session, we’ll cover scenarios where Power Query and Power Pivot can be leveraged to get the most from the proof-of-concept phase of your reporting, ETL, & analytics projects. Learn how Power Query can help you test the quality of your data well before the production ETL is deployed. We’ll also cover how Power Pivot can help you visualize the structure and granularity of your data, and why it’s the perfect “gateway drug” for SSAS cube development. If you've ever had a BI project fall flat because “We didn't know what we didn't know” or want to avoid delivering a hundred reports when the data merits ten, this is the session for you!
Speaker:

Session Type:
Regular Session

Track:
Self-Service BI

Level: Intermedia

Session Code:

Date: May 30

Time: 1:00 PM - 2:00 PM

Room: 2523

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.
Speaker:

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Intermedia

Session Code:

Date: May 30

Time: 3:30 PM - 4:30 PM

Room: 2520D

Having a good understanding what security features are available and what configurations are considered best practice can be crucial to your  company's data security.  My experience at many dozens of companies indicates that more than 90% of all database implementations don't follow some of the most fundamental best practices.  Learn to view security differently and how key builtin security features can be leveraged to make your systems both more maintainable and more secure.
Speaker:

Session Type:
Regular Session

Track:
DBA - Architecture and Tools

Level: Beginner

Session Code:

Date: May 30

Time: 11:00 AM - 12:00 PM

Room: 2520B

SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA - Troubleshooting and Performance Tuning

Level: Advanced

Session Code:

Date: May 30

Time: 2:15 PM - 3:15 PM

Room: 2390

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