Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type




Sessions Found: 47
In the excitement of the possibilities that Big Data technology and Data Science techniques are opening, we forgot that correlation is not equal than causation and that any design model has intrinsic limitations. Dr. Deming said "In God we trust, all others must bring data." but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reached, at least, the level of Knowledge and if any at all have reached the pinnacle of Wisdom. We are drowning in a sea of data and we are starving for wisdom. 
How is Data Science and Big Data changing our profession? What is a Data Scientist? What is a Data Engineer? What is a Data Analyst? Which skills do we need?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 23

Time: 2:15 PM - 3:15 PM

Room: 1301

It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels (including 5 key resume truths), working with Recruiters, always attempting the "referral route," leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight our top 14 strategies to help you go from "I'm not finding jobs I'm interested in" and/or "I'm not hearing back on my resume or from Recruiters" to "it's time to prepare for my interview!"
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: March 23

Time: 9:00 AM - 10:00 AM

Room: 2303

2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. This session will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 23

Time: 9:00 AM - 10:00 AM

Room: 120

Are you investing enough time and in right place when it comes to learning new stuff? Or do you feel like you're spending too much time? Or, more commonly, that you're setting goals and then falling off track? All of us struggle to manage learning while sustaining a career and family. But it IS possible! This session is designed to give you a prescriptive solution to the challenges of managing learning; identifying what you need to learn, how much time to invest in learning each topic, scheduling and tracking your learning, and recovering from the interruptions that life throws at us.  My system won't make you rich, but it will make you feel in control of your career learning goals.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 23

Time: 10:15 AM - 11:15 AM

Room: 2303

Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts, KPIs and more. There is a lot to be concerned about when designing reports to provide information to your audience. Today, your company can face lawsuits if your reports are not accessible to all users.  You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience's attention. It is making sure you don't inadvertently introduce accessibility problems that limit who can receive your message, your data. This session while looking at some reporting best practices will also give you information to steer you clear of accessibility concerns to insure access to your results by all consumers of your report.  (Note: Accessibility is governed through the guidelines of the American Disabilities Act)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 23

Time: 3:45 PM - 4:45 PM

Room: 1201

This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy,  etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 23

Time: 2:15 PM - 3:15 PM

Room: 2304

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 23

Time: 1:00 PM - 2:00 PM

Room: 2305

You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 23

Time: 3:45 PM - 4:45 PM

Room: 2305

Power BI is Microsoft's industry leading data analytics discovery and visualization tool that has disrupted the way data professionals interact and derive insights from their data. It is one of the most in-demand and sought-after tools to know in today's IT career market. Join us for a fun and interactive learning opportunity to learn how to ingest, transform and visualize data from a wide variety of sources using Power BI. Learn how to create rich and interactive reports incorporating slicers, drill-down and drill-through actions. Attendees will also learn how to create, publish and share reports and dashboards for desktop and mobile consumption. Attendees will walk-away feeling like real Power BI *superstars, capable of tackling any data project in their paths! *Awesomeness may vary.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 23

Time: 3:45 PM - 4:45 PM

Room: 2304

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a semantic modeling technologies like SQL Server Analysis Services or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 23

Time: 10:15 AM - 11:15 AM

Room: 2305

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Compliance and Security

Level: Intermedia

Session Code:

Date: March 23

Time: 9:00 AM - 10:00 AM

Room: 124

Databases are growing.  The way we use data is changing and growing.  When you have a lot of change, it has to be managed, or bad things happen to your data and your job!  A common problem with database change management is... database change management.  This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy.  There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be.  Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 23

Time: 2:15 PM - 3:15 PM

Room: 1102

This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it's important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We'll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday.  Constraints aren't glamorous, but they matter, and they require an advocate - you! A good session for DBA's, developers, and yes, even managers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 23

Time: 2:15 PM - 3:15 PM

Room: 120

DevOps lives at the fast paced intersection of developers and IT professionals. Our business partners are learning and expanding their analytics toolkit, putting more pressure on technical teams to deliver analytics at an accelerated operational cadence. I'm here to show you how to automate your production database code delivery even in large data warehouse environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 23

Time: 9:00 AM - 10:00 AM

Room: 123

Today's hiring environment is very different from even 1 year ago. If you have applied online to jobs and have not had success this interactive session is for you. Come learn how to craft a resume to start getting results with online submissions. MOre interviews = more offers. Let's learn how to beat the applicant tracking systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 23

Time: 2:15 PM - 3:15 PM

Room: 123

Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption?
The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues.
Highlight of topics
1.	Why corruption occurs?
2.	Detecting corruption – how SQL Servers detects corruption at the page level.
3.	Different types of corruption- e.g. False alarms, memory corruption etc.
4.	Limitation of DBCC & how to speed the DBCC process.
5.	Undocumented DBCC commands.
6.	Monitoring I/O errors.
7.	Verifying backup for corruption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: March 23

Time: 9:00 AM - 10:00 AM

Room: 2304

Database masking, obfuscation, CI, CD... What is this stuff?  This is a story about how we did a complete overhaul on our development life cycle to create more outcomes for our users, resolve communication issues with the team, and provide pre-production databases for our developers through database obfuscation.  We will discuss our why, our team structure, the preparation work completed, the database obfuscation process & tools available.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 23

Time: 10:15 AM - 11:15 AM

Room: 1102

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 23

Time: 10:15 AM - 11:15 AM

Room: 120

Since the end of the previous decade, our profession has been kicked by a set of new models, technologies, and architectures that are revolutionizing our practice. I pretend to clarify the position of SQL as the LINGUA FRANCA for Data and the relational model versus the allegations of deprecation of the relational model, and the NoSQL movement presentation of SQL as a language with no future. These among others are the topics of my presentation.
In this presentation, I will depict the Hadoop evolution from version1 to version 3,  and its relation to legacy architectures models and in particular to SQL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: March 23

Time: 10:15 AM - 11:15 AM

Room: 1301

Nearly everyone one who attends a SQL Saturday has something to share, which others can learn from.  This session covers how to take your knowledge and ideas and turn them into a presentation.  Most of the focus will be on content generation and organization of your idea into a presentation and demonstrations, to allow you to present.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 23

Time: 2:15 PM - 3:15 PM

Room: 2303

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