Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type







Sessions Found: 46
This session provides a blueprint for launching and maintaining enterprise Power BI solutions. Power BI enables self-service and personal business intelligence for the masses. Launching a Power BI solution is easy. Preparing for increasing data volumes, data variety, and evolving requirements often creates challenges for solution teams. We'll review 1) Data platform considerations: When to use Analysis Services, Direct Query, Power BI Premium? 2) Data architecture considerations unique to Power BI. Design a solution optimized for end user experience, Q&A, Maps, Security, Mobile, and future data sources. 3) Project management considerations such as requirements gathering, change control, and proper documentation. 4) Enterprise Governance: Administrative settings, Licensing, Sharing, Workspaces, and Apps. Attendees will get documentation templates, links to best practices articles, and reference materials so they can create their own blueprints for excellence with Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 07

Time: 10:15 AM - 11:15 AM

Room: 2230

In this presentation we will explain and demonstrate how to use advanced analytics using Power BI's built-in tools for clustering, regression, forecasting, and R-scripted visuals.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: 2200

The world's most powerful virtualization platform, VMware vSphere, contains a number of hidden gems that DBAs can use to make their SQL Servers more highly available and perform better. The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Advanced

Session Code:

Date: October 07

Time: 10:15 AM - 11:15 AM

Room: 2225

In this session we will explore and evaluate Healthcare data that is freely available to the public. You will see how easily we can consume and integrate the data to analyze and investigate. In the demos you will see some of the latest enhancements and features that have been included with Power BI such as ArcGIS (Esri) maps, forecasting, Top N filtering, grouping / binning, clustering, custom R visuals, and maybe a few more along the way. If you are interested in Open Data, Healthcare, or have to perform a lot of data manipulation in Excel or other tools to provide analysis for your job then this is the session for you. Leverage the free capabilities of Power BI, advanced analytics, and help simplify your everyday workload and wow your boss!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 07

Time: 2:15 PM - 3:15 PM

Room: 2230

Do you have many SQL instances in your enterprise?  Do you have to maintain multiple dev/test/uat/pre-prod/prod environments?  Need to spin up new instances often?  Do you need a way to ensure these environments are all set up correctly and consistently and be notified of changes to them?  If so, you need an enterprise-wide auditing system!  I will be presenting my free, open source, system that does the following: 1) Collects information an all of your SQL instances daily, 2) sends you a report of any changes that have occurred (new/old/changed values), 3) lets you set up rules for all/some of servers and checks these rules on a daily basis (ie - backup compression should be turned on, Max memory should be less than 2TB, etc) and will even send you the SQL to fix any rules that failed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Intermedia

Session Code:

Date: October 07

Time: 2:15 PM - 3:15 PM

Room: 2225

Cloud and Data are big buzzwords these days, but how can you make the work for you?  There are so many great articles out there telling you how great the cloud and data are, but now you can experience it first hand!  In this pre-con you will gain hands on experience with various data technologies in Azure and how they can come together to create a practical data solution.  Technologies will include Azure SQL DB, Azure SQL DW, Azure Data Factory, Azure Data Lake, and Power BI.  You will go through steps to provision an environment, extract, load, transform and gain insight from the data.  You will also see how AI can be connected into this solution with minimal effort.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Full Day PreCon (Friday Oct 6) (480 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: October 06

Time: 8:00 AM - 4:00 PM

Room: 2120

Join me and get some new perspective on what your DBA is doing, and why!

Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins, this session will go over the reasons we back up our databases, our systems, etc.  Considerations such as Single points of failure, High Availability/Disaster recovery, Business Continuity and others will be discussed in this interactive conversation.   It will be conversation heavy, with supporting slides to download, and one Database backup demo at the end if time permits.

Everyone involved in a technical role needs to at least know that the things they have created will be recoverable in the event of a disaster, or even just an "oops" moment.   The CIO/CTO should know how long critical systems will be down when bad things happen.  Backups are everyone's responsibility...whether asking the right questions or implementing the process.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 07

Time: 10:15 AM - 11:15 AM

Room: Theater

As Data Science becomes more prevalent, operationalizing models built by Data Scientists as in-database analytics using SQL R Server often falls to the IT Staff.  In this talk, we discuss the process of translating a standalone model to R Server, pros and cons of different approaches, and potential pitfalls.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 07

Time: 10:15 AM - 11:15 AM

Room: 2200

The role of data and IT professionals is evolving from simply responding to requests about business to one of helping shape the business strategy. The integration of these professionals into the strategy process is a transformation that presents communication challenges and requires more visibility by people typically known to be introverts. In this session we will discuss some of the barriers causing relationship pains as well as some techniques and strategies to begin building stronger relationships with the managers and end users so data can thrive and customer satisfaction can proliferate.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 07

Time: 3:55 PM - 4:55 PM

Room: 2215

Welcome to the exciting journey of designing and implementing Data Driven Business Solutions with SQL stack and PowerBI. During this session, you will learn how classic data warehouse architecture is implemented with new tools and features. You will dive into good practices to discover common pitfalls and advantages in physical architecture and rise to tell a story about Business with data visualizations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 07

Time: 1:00 PM - 2:00 PM

Room: 2215

Thank you for attending SQLSaturday #682
Speaker:

Accompanying Materials:

No material found.

Session Type:
Welcome and Closing (30 minutes) (30 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 07

Time: 5:05 PM - 5:35 PM

Room: Theater

This is a hands-on session where attendees will gain practical experience on a walking tour of Microsoft’s Power BI platform from source Data to Dashboard deployment.  This session will acquaint you with the agile and capable Power BI terrain including the two major components of the Microsoft Power BI platform; Power BI Desktop and Power BI Service.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: Theater

Data Lake is a big buzz word these days.  if you aren't careful, that lake can quickly turn into a swamp that takes the value away from your data.  What does it take to actually make one and not have a data swamp?  In this session we will talk about what a data lake looks like, what is needed to make a data lake and best practices in building and maintaining one.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
NoSQL / Big Data

Level: Advanced

Session Code:

Date: October 07

Time: 1:00 PM - 2:00 PM

Room: 2220

So many ways to handle database information on Azure: Table Storage, NoSQL, CosmosDB, SQL as VM’s, multiple flavors of SQL-as-a-service, open-source SQL-as-a-service, data lake, Azure Data Warehouse, etc. How and why should I choose one (or a particular combination) over the others? What’s so special about each one?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: 2220

This class is designed for New or Non-DBAs struggling with SQL admin tasks, and having to Google things daily.

I will teach you SQL Server fundamentals so that you will have confidence in:

•	What makes up a SQL Server
•	How a database is structured
•	How to install and what to look out for
•	Finding what you need in Management Studio
•	SQL Security Basics
•	How to create and manage backups
•	How to create a database
•	Basic performance troubleshooting
•	Picking a Disaster Recovery option for your environment

These are taught from a foundational standpoint, in simple to understand terms so that you can build on them with confidence.

My teaching is heavy on interaction, with examples from years of experience/mistakes. There will be a mix of slides and demos.  I will skip many advanced features that are out of scope of a beginner class, as I don't want your head to explode!

Join me for the day and you will walk out with a strong grasp of SQL Admin basics!
Speaker:

Session Type:
Full Day PreCon (Friday Oct 6) (480 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 06

Time: 8:00 AM - 4:00 PM

Room: 2205

Transactional Replication gets a bad rap for being fragile and somewhat difficult to manage. Given that reputation, we decided to try to accomplish some of the same things that it does using alternative means. Let me regale you with the tale of that journey. You may come out of it with a newfound appreciation of Replication or you may find yourself asking "that's pretty neat!". Only one way to find out, though…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Intermedia

Session Code:

Date: October 07

Time: 1:00 PM - 2:00 PM

Room: 2225

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:
Develop, Rinse, Repeat
Test Until Your Five Year Old Can Do It
Human Intervention Creates Human Error- Automate EVERYTHING.
How the shorter development cycle build business success.
How the DBA can do more with less.
Discover the power of virtualization and powerful agile development practices providing more value to even the most senior database expert. We’ll demo different scenarios surrounding DevOps, virtualization and how to make the DBA pivotal to DevOps success.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 07

Time: 9:00 AM - 10:00 AM

Room: 2225

Take your T-SQL skills to the next level.  Regardless of your current level there will be something here you'll be glad you didn't miss.  Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg.  If queries are basic arithmetic then this is basic algebra.  First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more .
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Advanced

Session Code:

Date: October 07

Time: 2:15 PM - 3:15 PM

Room: 2115

Everybody loves a free lunch. Come to this session to learn about all the SQL Server freebees.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 07

Time: 3:55 PM - 4:55 PM

Room: 2225

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events.  Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years.  Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them.  Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more.  We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way.  You may never go back to Profiler again!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Administration

Level: Beginner

Session Code:

Date: October 07

Time: 10:15 AM - 11:15 AM

Room: 2135

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