Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

SQL Saturday Omaha Pre-Cons

Phil Brammer

Friday, August 14, 2015 from 8:30 AM to 5:30 PM (CDT)

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Ed Leighton-Dick: SQL Server Security Master Class 24 Tickets Ended $129.00 $4.22
Mike Fal: Introduction to Powershell 22 Tickets Ended $129.00 $4.22
Dandy Weyn: Power BI 26 Tickets Ended $129.00 $4.22

Share SQL Saturday Omaha Pre-Cons

Event Details

Choose from three all-day training events:

Ed Leighton-Dick - SQL Server Security Master Class - 9AM - 5PM - Room 321

Are your SQL Servers protected as well as they could be?  In this full-day course, Ed Leighton-Dick will lead participants in a tour of SQL Server security.  The discussion will begin by giving all participants a common, thorough understanding of the authentication and authorization structures of the data platform, regardless of past experience, followed by a series of topics to apply that knowledge.  By the end of the day, participants will gain familiarity with tools and techniques they can use to protect their systems from common threats.


Mike Fal - Introduction to Powershell - 9AM - 4:30PM - Room 323

Maybe you've only heard of Powershell. Maybe you've seen a little bit of Powershell code, but still don't understand how it works. You've been telling yourself for months now that you need to learn it. Why wait? The time to get started with Powershell is now. This full day session will help build your foundation for learning and using Powershell.  While we will be focusing on using Powershell as a SQL Server Database Administrator (or Developer), much of the material will also review general use for system administrators.  By attending this training, you will gain an understanding of what Powershell is, how you can use it in your day to day management of your environments, and what specific things can be done using Powershell in a SQL Server environment.

This session will cover the following areas:

  • Powershell Basics:  What it is, where it came from, how to write it. 
  • Powershell and SQL Server:  How can we interact with SQL Server using Powershell. 
  • Common Administrative Tasks made easier:  We will look at specific use cases from day-to-day database administration and how they can be automated using Powershell.  Some of these tasks include backups and restores, environment inventories, and database migrations. 
  • Powershell, SQL Server, and Server Core:  Server Core is a strong alternative for running SQL Server and Powershell is a requirement to manage it.  Setup and administration of this through Powershell will be covered. 
  • Desired State Configuration and SQL Server:  Desired State Configuration is a new Powershell feature that can allow for consistent SQL Server builds and deployments.

 


Dandy Weyn - Power BI - 9AM - 5PM - Room 325

Are you ready to Power BI?

With the most recent release of Power BI, you really can take advantage of unlocking insights on any data by using the great capabilities provided through the Power BI platform through native apps for Android, iOS, Windows and browser functionality.

In this full day pre-con seminar we’ll cover:

Power BI – getting it right
First we’ll start with an introduction to each of the components of Power BI, you’ll learn about the evolution, how to get access, and how some of the great capabilities are enabled within some of the data visualizations directly in Excel and learn about the differences with the Power BI Desktop application. In this part we’ll also discuss Power Pivot, Power View, and Power Map data visualizations, as well as use case scenarios to maximize gaining fast insights into any data.
You’ll get an introduction to Dashboard creation using a variety of data sources including content packs.

Getting your data
You’ll learn how to get access to data from a variety of sources going from Excel Workbooks, Database Sources, SQL Database, HDInsight, Dynamics, Text files, Azure, Facebook and more…
We’ll focus on data gathering best practices, how to perform data transformations, and discuss data refresh capabilities. We’ll drill down into content packs, data connectivity and best practices.

Crafting Data Stories and demo gallery
After understanding the data collection process, let’s drill down into data visualizations, design best practices, and how to build beautiful dashboards and interactive reports that reveal the stories and insights hidden in your data.
Make sure to bring your laptop and download the latest Power BI Designer prior, as you will be challenged in bringing your own creativity to the session and are more than welcome to follow along as we go.

Collaborate and Share
Drill down into the key sharing and collaboration capabilities of Power BI by using dashboards, reports and bringing visualizations across multiple devices. You’ll learn how to share and collaborate, and how do get the maximum out of the Power BI capabilities.

Above and beyond
In this section we’ll cover some deeper technical details, workarounds and strategies on how to get the maximum out of your dashboards. We’ll also talk about API, Content Packs and building your own data visualizations. Do you have any questions about competitive platforms and how Power BI compares or fits into the broader Microsoft Business Intelligence and Analytics story? You’ll get them answered in this section of our 1 day pre-conference.


Have questions about SQL Saturday Omaha Pre-Cons? Contact Phil Brammer

When & Where


UNO Mammel Hall
6708 Pine Street
Omaha, NE 68106

Friday, August 14, 2015 from 8:30 AM to 5:30 PM (CDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.