Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type


Sessions Found: 52
This is a deep dive into the data compression features in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in your production systems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 13

Time: 9:15 AM - 10:15 AM

Room: Room 113

Attendees will learn Power BI’s administrative features providing security and best practice methods for development and deployment. As Power BI does not use network security, the importance in things like Group Workspaces to ensure visualizations aren’t lost when people leave the organization are discussed. Practices to increase scalability over time are reviewed.  Development of content packs are explored to increase adoption of Power BI while establishing data access standards using scheduled refreshes with gateways. Licensing strategies and use of One Drives and their impact on update strategies are also reviewed.
Without any guidelines, many organizations proliferate data models over time leading to complaints about data accuracy as updates can be random. Learn processes for the use of gateways and their role to prevent rampant data model and create the ability to maintain the quality of the visualizations over time to provide a usable data framework for Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 13

Time: 3:30 PM - 4:30 PM

Room: Room 114

Running the Availability Group Wizard, or installing a clustered SQL instance can go pretty smoothly.  But in complex and larger networks, that is not always the case.  Even if the wizards complete without error and you think you have a highly available system, you may not.  
This session will review all the gotcha’s and things you need to know before you run the shiny wizard or run some PowerShell to make your HA/DR implementation of SQL a success.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: Room 104

Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 13

Time: 10:30 AM - 11:30 AM

Room: Room 114

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 9:15 AM - 10:15 AM

Room: Room 200

While the web portal makes it easy to deploy SQL Server on Azure Virtual Machines, there are a number of benefits to using PowerShell to do the job. This session will introduce Azure PowerShell command-lets and how to create a basic Azure infrastructure to support a SQL Server VM. We'll include the Azure Resource Manager, how to use ARM VM templates and Custom Script Extension, and how users can modify an existing Azure Gallery template. Desired State Configuration (DSC) will be covered to complete the Azure Powershell automation toolkit, allowing attendees to automate the deployment of dozens or more SQL Server virtual machines. Finally, we will configure Availability Groups and explain their eccentricities in the Azure environment as well as how to make them work effectively.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 8:00 AM - 9:00 AM

Room: Room 200

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 1:00 PM - 2:00 PM

Room: Room 104

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: Room 215

As DBAs, we are asked all sorts of impossible questions.  Who dropped that important table last month?  Why was everything slow last week?  Who made that user a sysadmin?  You’d have to be a mind reader to know the answers to some of those, right?  Not necessarily!  SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide.  In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: Room 200

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: Room 113

With the introduction of R Services in SQL Server 2016, many professionals and clients are using the buzz words: “Statistical Analysis”, “Statistical Approach”, “Predictive Analytics”, “Open Source R” and many more.  This discussion will cover some key differences between the SQL Server R integration and the open source R tools available.  I will cover how an organization can use basic statistical modeling to optimize business processes and improve turn-around-time.  Finally, I will demonstrate how R can be used to predict future business metrics to help drive business decisions to meet the prediction or avoid the predicted outcome.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: August 13

Time: 10:30 AM - 11:30 AM

Room: Room 108/110

Things happened, you got a knock on the head and when you awoke your boss said “congratulations” you are our new DBA, perhaps you came to the role in a more intentional manner or are just DBA curious.  Your environment is running but you are wondering “now what” or “what’s next”.  In this session we will give an overview of a few things that could, perhaps even should be next and give some recommendations as to where you can find more resources on-line and maybe even suggest a few sessions to attend at this very SQL Saturday.  So, what will be covered, recovery strategy (you think I mean backups, I don’t, you’ll see why), a touch on performance tuning with a hint of indexing thrown in, add a pinch of high availability and a smattering of security all of which will give you some idea how to answer “now what”.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 8:00 AM - 9:00 AM

Room: Room 108/110

Abstract: As a beginner database professional, execution plans are intimidating. In this 1 hour session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.
Prerequisites: Basic understanding of T-SQL and the SQL Server Engine.
Sections:
•	You will understand how, why and when the execution plan will be created and saved to plan cache.
•	Reading the execution plan will be much less intimidating as you can talk through the flow and process of a graphical execution plan. 
•	After looking at the key operators you will be able to analyze the operators of your execution plans, the operator properties and identify common performance issues and tuning opportunities.
•	Finally, you will be able to capture the execution plan, save it for later analysis and comparison after modifications have occurred. 


Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 1:00 PM - 2:30 PM

Room: Room 200

The Microsoft Azure ecosystem has exploded in size and variety in recent years.  There are now a multitude of ways to persist your data in the cloud.  Trying to choose among the different options can be a daunting task.  In this session we will examine the use cases, strengths, and weaknesses of the following data services: SQL Database, SQL Data Warehouse, Document DB, Redis Cache, Storage (Table, Queue, and VM), and Azure Data Lake Store.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 13

Time: 1:00 PM - 2:00 PM

Room: Room 113

Even in the career of a SQL Server and/or MSBI expert, you will undoubtedly encounter Oracle databases – most often as source systems or data migrations.  While the underlying structures and languages are mostly similar, there are a few differences which can be stumping.  We’ll highlight some differences, including:	Connecting to Oracle, Databases and schemata, object naming, and differences between T-SQL and PL/SQL, and tool selection.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 13

Time: 3:30 PM - 4:30 PM

Room: Room 113

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important.  Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening.  This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive.  We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers.  Additionally, some suggestions as to where to find more information will be provided. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 1:00 PM - 2:00 PM

Room: Room 108/110

This session will cover what is Streaming Analytics and the various use cases.  We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review.  The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 13

Time: 8:00 AM - 9:00 AM

Room: Room 215

SQL Server memory management is one of the most important aspects of a writing T-SQL code. And yet many of us don’t know the fundamentals beyond “SQL Server will take care of that”. In this session, we’ll go deep into the internal behavior of the plan cache. We’ll cover four main problem scenarios within the plan cache, what causes them, and how to fix them, including:

1.	Bloating – scenarios that cause SQL Server to needlessly waste space in the plan cache. 
2.	Suboptimal plans – scenarios where SQL Server can’t help but choose a bad execution plan, usually self-inflicted.
3.	Parameter sniffing – situations in which SQL Server specifically chooses a bad execution plan do to the type of parameters pass into T-SQL code.
4.	Recompiles – situations where SQL Server is unable to completely process a block of T-SQL code without having to recompile it. 

If you don’t know much about SQL Server memory management, especially if you write T-SQL code, then this session is for you! You’ll learn 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 13

Time: 10:30 AM - 11:30 AM

Room: Room 208/210

No one grows up saying they want to be a DBA yet there are plenty of us out there. Once in the role you never intended to be in you may find it hard to know where to go to answers - or even what questions to ask. You may find yourself struggling for time to accomplish all you need to do. You're going to feel overwhelmed and be looking for support from others but not know where to turn. In this highly interactive session join Tim as he helps you navigate the most common questions you'll likely face in your first years as a DBA - including a few you may not have considered - and where to go for those answers. He will also give you some of those insider shortcuts that it takes years to stumble across if your lucky. Finally we'll discuss your support mechanisms and he community of like-minded people standing by your side globally and virtually.

Walk away from this session renewed, energized, and full of new insights... plus a downloadable cheat sheet for quick reference!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 13

Time: 2:15 PM - 3:15 PM

Room: Room 104

2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type. 

 Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: August 13

Time: 11:45 AM - 1:15 PM

Room: Room 104

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