Build Schedule

Advanced Filters:
  • Track

    clear all

















  • Speaker


  • Level


  • Session Type


Sessions Found: 40
This session is for the those who have security objections related to moving to the cloud or are interested in the security features of the of the Azure SQL Database, a relational database Platform as a Service offering in Microsoft Azure.  There certainly are Azure SQL Database features which have parity with SQL Server engine features (Always Encrypted, TDE, RLS, etc.).  But this session will take a look at security features focused on the Azure SQL Database; server firewall settings, Auditing & Threat detection,  Alert Rules, Role-based Access Control and configuring Azure AD Authentication.  If time permits, we will step through Dynamic Data Making via the Azure portal.  Hopefully the main take away will be a warm and fuzzy (and more secure) feeling about planning for cloud workloads.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 03

Time: 8:20 AM - 9:20 AM

Room: 5-2 (DBA 2)

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 03

Time: 8:20 AM - 9:20 AM

Room: 5-1 (DBA 1)

You want Enterprise Edition of SQL Server? Not gonna happen!  When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has.  Then review items such as basic normalization and  High Availability options available to Standard.   You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 03

Time: 11:10 AM - 12:10 PM

Room: 7-1 (Dev 1)

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Intermediate DBA

Level: Intermedia

Session Code:

Date: December 03

Time: 1:40 PM - 2:40 PM

Room: 5-3 (Dev 2)

In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table.  Unfortunately this case is the exception rather than the rule.  How can you use SSIS to: 
1.    Iterate through all files in a folder and import their content into SQL
2.    Dynamically create and name table based on a data source 
3.    Dynamically create a T-SQL statement at runtime based on run time conditions
This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment.
Each attendee will leave with the knowledge and toolset necessary to:
1.      Use expressions within SSIS packages
2.      Use variables to dynamically create SQL statements
3.      Configure custom dynamic logging
4.      Use package configurations and parameters and environments to make packages more portable at execution
5. 	Replace dynamic SQL using expressions in SSIS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: December 03

Time: 11:10 AM - 12:10 PM

Room: 7-5 (BI 2)

High-end storage is expensive, and SQL Server data compression can make your database smaller. So compress all the tables! 

No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: December 03

Time: 8:20 AM - 9:20 AM

Room: 7-2 (Mixed)

It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Intermediate Dev

Level: Intermedia

Session Code:

Date: December 03

Time: 8:20 AM - 9:20 AM

Room: 5-3 (Dev 2)

In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, and a SQL Server MVP.  Along the way I saw my yearly income triple.  Is it because I know some secret?  Is it because I am a genius?  No!  It is just about laying out your career path, setting goals, and doing the work.  It's about building your personal brand and stepping out of your comfort zone.  It's about overcoming your fear of taking risks.  If you can do those things, you will be rewarded.  I will discuss how you too can go from unknown to well-known.  I will talk about building your community presence by blogging, presenting, writing articles and books, twitter, LinkedIn, certifications, interviewing, networking, and consulting and contracting.  Your first step to enhancing your career will be to attend this session!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 03

Time: 9:45 AM - 10:45 AM

Room: 7-3 (Prof Dev)

In this demo-heavy session, we will extend the EntDNA SSIS Framework Community Edition to become region aware, tackling the problem of running groups of packages around the world on multiple servers, and get the results back to the calling server, all using a centralized, coordinated schedule.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Intermediate BI

Level: Beginner

Session Code:

Date: December 03

Time: 3:05 PM - 4:05 PM

Room: 7-4 (BI 1)

This session is an introduction to the spatial features in SQL Server. In this session, you will learn how to create, procure and leverage spatial data.  You will be made aware of tools you can use to integrate your own spatial data with a variety of public data sources such as the Census Bureau, National Weather Service, etc. Functions and T-SQL commands related to spatial data analysis will be demonstrated. We will end the session by using the geometry data type to actually mimic a bitmapped picture using SQL (that's the fun part!).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: December 03

Time: 3:05 PM - 4:05 PM

Room: 5-3 (Dev 2)

How does one take advice from the top leadership experts and translate into action?  As one's responsibilities grow many more factors come into play to achieving both the realities and perception of high availability.  The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success.   While some will argue this is out of my scope of responsibilities why should I care about the building of professional relationships, managing expectations, helping with setting standards and procedures?  The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem.  Managing customer expectations what do you really mean by 99.99% up time, translating business requirements to operational realities, commonly overlooked items that impact your 4 nines & Avoiding human errors the realities and perception of high availability.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: December 03

Time: 9:45 AM - 10:45 AM

Room: 7-2 (Mixed)

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: December 03

Time: 3:05 PM - 4:05 PM

Room: 7-2 (Mixed)

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.  This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too.  When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: December 03

Time: 11:10 AM - 12:10 PM

Room: 5-1 (DBA 1)

Have you ever thought to yourself  “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!”  If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: December 03

Time: 1:40 PM - 2:40 PM

Room: 7-3 (Prof Dev)

Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a  flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AML experiment. Join me to see how AML might meet your advanced data analysis needs.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Intermediate BI

Level: Intermedia

Session Code:

Date: December 03

Time: 3:05 PM - 4:05 PM

Room: 7-5 (BI 2)

PostgreSQL is a powerful, open source object-relational database system with decades of continuous active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows, is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).

This talk will provide an introduction to PostgreSQL by one of the project's committers, including the overall architecture, major features, data types, and capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: December 03

Time: 3:05 PM - 4:05 PM

Room: 7-1 (Dev 1)

SQL Server Integration Services (SSIS) provides database administrators, business intelligence developers, and application programmers the ability to quickly and easily move and transform data.  Whether your data in on-premises or in the cloud, within SQL Server or stored in text files, clean or dirty, SSIS can help you extract, transform, and load (ETL) the information.  Join this session to learn more about SSIS, specifically how to develop, deploy, and maintain SSIS packages.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: December 03

Time: 1:40 PM - 2:40 PM

Room: 7-4 (BI 1)

Reports, dashboards, and indicators are an essential part of your job as a report analyst.  SQL Server Reporting Services (SSRS) 2016 gives you the ability to create these items to share with coworkers and management.  This session will walk you through how to design, develop, deploy, and maintain reports within your environment.  As a bonus, we will cover mobile reports, introduced in SSRS 2016!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: December 03

Time: 11:10 AM - 12:10 PM

Room: 7-4 (BI 1)

This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data.  We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions.  Real life examples and solutions will provided to give better context to each step in the process.
After the data structure has been created we will focus on how to best “clean” and validate the geographic data.  We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types.
Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports.  This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as:
Events that occurred at a specific address, zip code, and even block range and events within a mile radius.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: December 03

Time: 8:20 AM - 9:20 AM

Room: 7-4 (BI 1)

If you thought the Royal wedding of 2011 was a big deal, then you're about to be blown away! This is a match made in Data Heaven. You're all invited, no need to RSVP, there is plenty of food for thought in this session. There will be some background talk and a demo for querying and creating data on HDFS (using Azure Blobs). As a special gift to the happy couple, we will also have a special demo with JSON documents. This will be the greatest coming together of 2016! See you there!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: December 03

Time: 1:40 PM - 2:40 PM

Room: 7-5 (BI 2)

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