Omaha SSUG – Sept 2017 Meeting

Our September meeting features Justin Lynch from Google who will be showing a high-level Google Cloud overview, including a demo of Spanner, Google’s relational and scalable ACID-compliant database platform!

Agenda (6-8 PM)
– Presentation will start at a high level overview of GCP
– Innovation at Google
– Machine Learning
– Spanner with the live demo of Spanner from NEXT

Justin Lynch’s Bio
– Googler for 3.5 years and on the Google Cloud Platform team for over a year.
– Account Executive for all things Cloud and previously managed a Recruiting team focused on Leadership within Site Reliability Engineering.

Food
Food will be served 15-20 minutes prior to the start of the meeting.

Location
Blue Cross and Blue Shield of Nebraska (1919 Aksarben Dr)

Omaha SSUG – April 2017 Meeting

Synopsis
Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique:

  • A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis
  • A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise
  • The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision
  • Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content
  • Merging advanced visuals and powerful analytics provides real-world utility, and gives users the power to answer challenging organizational questions.

Hear about these unique capabilities as well as Pyramid’s integration with Power BI.

Speaker
Andrew Mauch

Andrew is a results oriented sales and management professional striving to help companies unlock the power of their data.  Andrew has spent several years managing a consulting organization that built custom BI solutions from the Microsoft platform.  Seeing how companies often struggled with BI, Reporting and Analytics, led him to join Pyramid Analytics.  BI Office is where BI is made simple, putting the power of Analytics in the end user’s hands with the governance of IT.

Sponsor
Pyramid Analytics

Food
Food will be served 15-20 minutes prior to the start of the meeting.

Omaha SSUG – March 2017 Meeting

Our next meeting will be on Wednesday, March 8th, at Blue Cross and Blue Shield of Nebraska, 6PM.

Join us to hear Phil Brammer, Microsoft Data Platform MVP, talk about Microsoft’s new offering – SQL Server on Linux.  Phil will demonstrate the installation, patching, and maintenance of SQL Server on Linux.

Phil Brammer has been a database developer/administrator for 17 years, including ConAgra Foods, PayPal, Blue Cross and Blue Shield, and now Buildertrend in Omaha, NE.

Food will be served 15-20 minutes prior to the start of the meeting.

Please RSVP today to be eligible for SWAG!

Also, Omaha SQL User Group now has a presence on Meetup! You can join the group here.

Omaha SSUG – January 2017 Meeting

Our next meeting will be this week, on Wednesday, January 18th, at Farm Credit Services of America (North Building).

Join us to hear our own Tim Goergen talk about how PowerShell scripting and automation has made his life easier.

Tim Goergen has been a database developer for 10 years, including the last four at Farm Credit Services of America in Omaha, NE.

Food will be served 15-20 minutes prior to the start of the meeting.

Please RSVP today to be eligible for SWAG!

Also, Omaha SQL User Group now has a presence on Meetup! You can join the group here.

Omaha SSUG – October 2016 Meeting

Our next meeting will be this week, on Wednesday, October 12th, at Blue Cross and Blue Shield of Nebraska.

Please RSVP today to be eligible for SWAG!

Our October meeting will be to get together as an open forum to share ideas, solve problems, demo SQL features, eat and network!

Food will be served 15-20 minutes prior to the start of the meeting.

Also, Omaha SQL User Group now has a presence on Meetup!  You can join the group here.

Omaha SSUG – July 2016 Meeting

Our next meeting will be on Wednesday, July 6th, at Blue Cross and Blue Shield of Nebraska.

Please RSVP today to be eligible for SWAG!

Speaker
Craig Allen

Synopsis
Craig Allen is a Microsoft Specialist at EMC and will be presenting on AlwaysOn Availability Groups.

His role as a technical consultant and “MSpecialist” is to help customers gain a strong technical understanding of Microsoft products and solutions, as well as the integration and interoperability between Microsoft and EMC, including joint-development between the two companies.

Craig can assist in the initial planning and evaluation of EMC’s “Proven Solutions for Microsoft”, including requirements gathering, architectural guidance, and integration considerations. He can also work with EMC Consulting and your local Microsoft team to coordinate efforts around solutions development and deployment.

Craig is located in Dallas, TX and comes to EMC with 25 years of experience in IT.

Food
Food will be provided 15-20 minutes prior to the start of our event.

Also, Omaha SQL User Group now has a presence on Meetup!  You can join the group here.

Omaha SSUG – June 2016 Meeting

Our next meeting will be this week, on Wednesday, June 8th, at Blue Cross and Blue Shield of Nebraska.

Please RSVP today to be eligible for SWAG!

SQL Server 2016 should be generally available, and we should have some new faces to meet and greet! We’ll use this time to talk SQL 2016, and the remainder of the time will be open topic. Please bring your questions and we’ll use the group to help answer them.

Food will be served 15-20 minutes prior to the start of the meeting.

Also, Omaha SQL User Group now has a presence on Meetup!  You can join the group here.

SQL Certification Training Opportunity

 

MCSA: SQL Server 2012 Boot Camp 6445N

Lincoln SQL Server User Group is happy to be working with Global Knowledge to bring a SQL Server MCSA Bootcamp to Lincoln Nebraska! We are on a short timeline to get paid attendees so please act quickly. This boot camp is being customized to concentrate each four day training period on one of the three exams. This package is more than just training, but includes the exam fees, study materials, a year of access to training and labs as well as free retake of the course itself. See below for details.

Tailored Schedule: 3 four day training sessions

Hours: 1:00pm to 9:00pm

 

There is a minimum class size of 7 and we must cancel this offering on May 16th if we do not have enough students. So please respond quickly if you wish to attend.

 

Max Class Capacity 16

Dates:

·         Tuesday June 14th through Friday June 17th 2016

·         Tuesday July 19th through Friday July 22nd 2016

·         Tuesday August 16th through Friday August 19th 2016

 

Cost: $6000 all-inclusive for up to 16 attendees.

 

Payment options: Credit Card or PO with Global Knowledge

 

To register and get payment information call

John Danley

President Lincoln SQL Server User Group

402-957-1887

LincolnSSUG@gmail.com

 

Location: Ameritas 5700 O Street, Lincoln, NE

 

Microsoft Exclusives

·         12 months of anytime access to your course labs and lab environment

·         12 months of 24/7 access to mentoring via chat, email and phone

·         12 months of on-demand access to indexed, searchable recordings of your Virtual Classroom or Virtual Classroom Fit class

·         12 months of unlimited retakes of your class

·         30 days of access to the online Microsoft Press E-Reference Library, including all training kits, exam references, and rapid review books

·         30 days of access to a recommended Microsoft reading List designed by our instructors, including topics and chapters within the Microsoft Press E-Reference Library

·         12 months of access to certification practice exams from Transcender that provide realistic Microsoft exam simulations in online and downloadable versions

·         12 months of access to recorded “Power Hours” – an online review session covering key exam objectives conducted by our expert instructors – for each exam

 

Course Overview

 

Gain the database-related skills required for the latest Microsoft certifications through this broad and extensive hands-on training experience. This Boot Camp features an online study program and a choice of delivery methods to suit your learning style preference.

 

In this accelerated learning environment, you will build your skills and prepare for the MCSA: SQL Server 2012 certification exams. This extended-hours boot camp led by senior Global Knowledge instructors includes targeted lectures using Microsoft Learning recommended content as well as twelve months of access to more than 40 hands-on remote labs.

 

This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

 

This course incorporates content from Microsoft Official Courses (MOC):

·         Querying Microsoft SQL Server (M20461)

·         Administering Microsoft SQL Server Databases (M20462)

·         Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Note: Microsoft Learning recommends the above courses, which use SQL Server 2014 for preparation for the following MCSA exams that reference SQL Server 2012. Microsoft Learning has no plans to update the MCSA: SQL Server 2012 exams to SQL Server 2014. All the exam skill objectives, however, are covered in the latest courseware as designed. Please see http://www.microsoft.com/learning for certification details.

 

You Will Prepare for These Exams:

·         70-461: Querying Microsoft SQL Server 2012

·         70-462: Administering Microsoft SQL Server 2012 Databases

·         70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

 

Typical Attendees:

·         IT professionals with at least two years of hands-on experience implementing and administering database systems

·         Database administrators, systems engineers, systems analysts, and technical consultants who want to prepare for their MCSA: SQL Server 2012 credential in an accelerated format

 

Labs

Querying Microsoft SQL Server (M20461)

Lab 1: SQL Server 2014 Tools

Lab 2: Transact-SQL Querying

Lab 3: Write Basic SELECT statements

Lab 4: Query Multiple Tables

Lab 5: Sort and Filter Data

Lab 6: Work with SQL Server 2014 Data Types

Lab 7: Modify Data using DML

Lab 8: Built-In Functions

Lab 9: Group and Aggregate Data

Lab 10: Subqueries

Lab 11: Table Expressions

Lab 12: Set Operators

Lab 13: Use Window Ranking, Offset, and Aggregate Functions

Lab 14: Pivot and Group Sets

Lab 15: Execute Stored Procedures

Lab 16: Program with T-SQL

Lab 17: Implement Error Handling

Lab 18: Implement Transactions

Lab 19: Improve Query Performance

Lab 20: Query SQL Server Metadata

 

Administering Microsoft SQL Server Databases (M20462)

Lab 1: Use SQL Server Administrative Tools

Lab 2: Install SQL Server 2014

Lab 3: Manage Database Storage

Lab 4: Back Up SQL Server Databases

Lab 5: Restore SQL Server 2014 Databases

Lab 6: Import and Export Data

Lab 7: Monitor SQL Server 2014

Lab 8: Trace SQL Server Workload Activity

Lab 9: Manage SQL Server Security

Lab 10: Audit Data Access and Encrypting Data

Lab 11: Perform Ongoing Database Maintenance

Lab 12: Automate SQL Server Management

Lab 13: Monitor SQL Agent using Alerts and Notifications

 

Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Lab 1: Exploring a Data Warehousing Solution

Lab 2: Planning Data Warehouse Infrastructure

Lab 3: Implementing a Data Warehouse

Lab 4: Implement Data Flow in as SSIS Package

Lab 5A: Implementing Control Flow in an SSIS Package

Lab 5B: Using Transactions and Checkpoints

Lab 6: Debugging and Troubleshooting an SSIS Package

Lab 7: Extracting Modified Data

Lab 8: Loading a Data Warehouse

Lab 9: Cleansing Data and Deduplicating Data

Lab 10: Implementing Master Data Services

Lab 11: Using Custom Scripts

Lab 12: Deploying and Configuring SSIS Packages

Lab 13: using a Data Warehouse