Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 59
The statistical language R has many ways to visualize data, as does SQL Server Reporting Services (SSRS). In this session, we take our two favorite methods and show you concepts to standardize and support these languages under the focus of a centralized information-design management. We take ICB standards and proposals for a conceptual, perceptual, and semantic information design and apply it to both languages, with the help of Master Data Services. You will see the concepts, techniques, and visual output in live demos and take away a concept that you can apply to your own SSRS reports or R output. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Reporting Services

Level: Beginner

Session Code:

Date: October 24

Time: 2:15 PM - 3:15 PM

Room: B

Machine Learning is a subfield of computer science which is so pervasive today that you probably use it dozens of times a day without knowing it. Azure Machine Learning is a valuable tool that can be employed by data scientists with different skill levels. Azure ML also supports R and Python custom code, which can be dropped directly into your workspace. In this session, I will show a demo of working with Azure ML. Audience will learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, choose the right algorithm, and then finally to the integration of predictive insights.
This session will show how they can use Azure ML to as a data mining tools. They become familiar with all steps of creating a prediction scenario from importing data, cleaning it, choosing the right algorithm, how evaluate the result, executing R code, and so forth. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Architecture

Level: Intermedia

Session Code:

Date: October 24

Time: 9:15 AM - 10:15 AM

Room: 208

With the advent of SQL Server Integration Services Catalog (SSISDB) a new place of storing, executing and monitoring SSIS packages came into existence. In this session, Wolfgang will show you different aspects of programmability in the context of SSISDB. Beginning with a short overview of the underlying database objects, a deeper look at SSISDB's stored procedures will follow. A side-step from TSQL to C# and the available Integration Services SDK illustrates a different view accessing SSISDB. 
Concluding, the analysing and reporting aspect of SSISB programmability is shown with some exemplified SQL Server Reporting services reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Integration Services

Level: Intermedia

Session Code:

Date: October 24

Time: 9:15 AM - 10:15 AM

Room: 214

Power Query is the self-service data consolidation tool of the Power BI embedded in Excel. Power Query has ability to fetch data from variety of data source, and apply transformations through Power Query Formula language known as M. This session covers advanced transformation samples of M formulas to solve real world data consolidation challenges. Many of useful Power Query formula functions with live demos will be explored through this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: October 24

Time: 9:15 AM - 10:15 AM

Room: 219

Performance troubleshooting doesn't have to be hard, yet getting good at it requires a methodology, practice, and learning a few tools, and a bit about internals.  In this session we'll simulate an I/O bottleneck and walk through the steps required to identify and remediate the problem.  You'll learn how to identify an I/O issue using Wait Stats, Virtual File Stats, and PerfMon.  We'll talk about relevant metrics, how to zero in on a problem, and how a healthy disk I/O subsystem performs.  You’ll return to the office with a suite of tips and tools that will get you on your way to becoming a Performance Tuning Superstar!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Tuning

Level: Intermedia

Session Code:

Date: October 24

Time: 9:15 AM - 10:15 AM

Room: 204

Choosing appropriate performance levels, monitoring and optimizing resource usage of Azure SQL database is of primary interest to SQL database users. Azure SQL DB now has a number of great tools to help sizing, scaling, monitoring and performance tuning your database solutions. This talk will provide an overview of resource usage monitoring, scaling capabilities and techniques as well as performance tuning tools that you can use today, such as Query Store, Index Advisor, Extended Events and DMVs
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: October 24

Time: 11:45 AM - 12:45 PM

Room: A

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Intermedia

Session Code:

Date: October 24

Time: 3:30 PM - 4:30 PM

Room: A

Are you already using Reporting Services (SSRS) but just not loving it?  Has it become clumsy, hard to manage or just plain not great?  In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts.  An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance.   Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication.  Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 24

Time: 10:30 AM - 11:30 AM

Room: 219

Techies and business people will learn how to choose the right projects for Hadoop. We'll talk about how Hadoop fits into end-to-end architectures and when it makes sent to put new Hadoop projects in the cloud, focusing on Microsoft Azure. I will show you HDInsight on Azure as well as Hortonworks HDP and Cloudera EDH/CDH on Azure VMs. http://smallbitesofbigdata.com/archive/2015/02/25/master-choosing-the-right-project-for-hadoop.aspx 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Architecture

Level: Intermedia

Session Code:

Date: October 24

Time: 10:30 AM - 11:30 AM

Room: 208

SQL Server DBAs face a wide range of IT and management challenges today.  The ability to enforce best practices, ensure automatic back up for key data, and an ability to rapidly reallocate system resources “on the fly” to meet time critical business objectives are just a few of the day to day headaches they are asked to address.  Looking ahead the impending end of support of SQL Server 2005, continued business growth, and the possibility of hosting workloads in private, hybrid, and public clouds bring forth additional challenges.  Cisco has been at the forefront of addressing these concerns with a revolutionary system design that combines server, network, and storage, while separating individual workloads from specific server components and driving industry leading performance.  Expanding UCS solutions with key partner and Cisco technologies have lead Cisco to become the market leader for x86 blades.  Please take 45 minutes to learn why thousands of SQL Server customers are choosing Ci
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lunch (Vendor) Session (45 minutes)

Track:
Admin

Level: Beginner

Session Code:

Date: October 24

Time: 1:15 PM - 2:00 PM

Room: 212

Recently, in April 2015, Microsoft aquired the company Datazen a specialist for mobile BI. This aquisition enables Microsoft to offer mobile, self service BI tools for Windows, iOS, Andorid and HTML. Besides using BI solutions on mobile devices online it is also possible to use these BI solutions offline. SQL Server MVP Frank Geisler will give insights into how Datazen works and how you can build BI Dashboards on different Datasources. He will show how a Datazen Server is installed and configured and how the Datazen Apps work on Windows 8. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 24

Time: 11:45 AM - 12:45 PM

Room: 219

Errors can occur anywhere within an SSIS package and the cause and error message can be somewhat cryptic. This session focuses on identifying error causes and handling them dynamically and proactively. The means of dealing with errors is defined by where the error occurs and we will cover error handling in control flow, data flow, and script tasks in great detail. 

You will learn:
•To identify the different error handling methods in control flow, data flow, and script tasks 
•Be able to utilize event handlers to proactively handle errors 
•Be able to redirect data error and proactively handle data flow errors 
•Be able to identify error descriptions and log error details
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Integration Services

Level: Intermedia

Session Code:

Date: October 24

Time: 9:15 AM - 10:15 AM

Room: B

Building a system that is Highly Available is something that requires a lot of thought and work up-front, it is not something that is easy to add after the system is built.

In this session I will help you understand the questions you need to ask, the options that are available to you and design principals & technology that can be leveraged to build a solution that can meet your needs and the needs of your business. Covering elements from the physical storage all the way out to the client application connectivity, we will look at just what it takes to build something that can sustain component failures and keep functioning.

So no matter whether your systems are cloud resident, on-premises or hybrid we will look at how you can make sure they work as planned.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Architecture

Level: Advanced

Session Code:

Date: October 24

Time: 11:45 AM - 12:45 PM

Room: 208

How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration. 

While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Tuning

Level: Advanced

Session Code:

Date: October 24

Time: 2:15 PM - 3:15 PM

Room: 204

Don’t miss this demonstration of the hot new container technology that will change your assumptions about what it takes to implement high-availability clusters on premises or in the cloud. Join DH2i’s OJ Ngo as he transforms standalone SQL Server instances into an automated HA cluster failing over between mixed-OS systems—in just a few minutes. In fact, he’ll have plenty of time left over to show you some other cool tricks with his new cluster, such as: QoS controls at the instance level, SQL and OS updates as fast as an application stop/start, and multi-subnet geo-clustering capabilities.
Speaker:

Session Type:
Lunch (Vendor) Session (45 minutes)

Track:
Admin

Level: Intermedia

Session Code:

Date: October 24

Time: 1:15 PM - 2:00 PM

Room: 208

Dimensional modeling is arguably one of the most important fundamentals of business intelligence. It is still relevant even as new technologies like PowerPivot and SSAS Tabular Models are becoming more popular. Correctly modeling your organization's data not only protects the most important asset your company has but ensures that your data mart or data warehouse will be responsive and capable of accommodating emerging requirements. This session provides a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. Finally we will cover physical design choices.  This case study and demo based session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Features

Level: Beginner

Session Code:

Date: October 24

Time: 10:30 AM - 11:30 AM

Room: 214

Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization?  Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing  and replay.  This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Tuning

Level: Intermedia

Session Code:

Date: October 24

Time: 11:45 AM - 12:45 PM

Room: 204

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so! 

Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. In this session, we’ll be dispelling these misconceptions and demonstrating how dynamic SQL can become a part of every DBA’s tool kit.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code:

Date: October 24

Time: 10:30 AM - 11:30 AM

Room: 212

Audit. The very word strikes fear in the bravest of hearts. But as a DBA, the need to know who is doing what in your production databases is critical.  In SQL Server 2008, Microsoft finally gave us a true auditing tool. But how does it work, what exactly can it track, and how can you handle its output? 

In this session, we cover SQL Server Audit from the ground up. We go from the basics of which events can be audited to a look at how SQL Server Audit works "under the covers", and what that means for performance. While implementing server and database audits, we discuss audit granularity and filtering, as well as the pros and cons of Audit's output options.

Whether it's through the SQL Server Management Studio (SSMS) interface, via T-SQL, or using PowerShell and Server Management Objects (SMO), at the end of this session you'll be able to deploy SQL Server Audit across your enterprise and manage its output, fearlessly. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Features

Level: Intermedia

Session Code:

Date: October 24

Time: 2:15 PM - 3:15 PM

Room: 214

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:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: October 24

Time: 9:15 AM - 10:15 AM

Room: 212

Sessions Found: 59
Back to Top