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

Omaha SSUG – May 2016 Meeting

Our next SQL user group meeting with be on Tuesday, May 10th.

We will have an open topic night. Since we haven’t met in quite a while, it will be a good time to just socialize and catch up with what’s going on in the community as well as the database world.

We will be meeting at Blue Cross and Blue Shield of Nebraska, 1919 Aksarben Drive.

Food will be served around 5:45 PM and we will start at 6 PM.

RSVP Today!

Omaha SSUG – January 2016

Our next Omaha SQL/BI User Group meeting will be Wednesday, January 20th, 2016 at 6PM. We will be sponsored by Blue Cross and Blue Shield of Nebraska and we will be located at BCBSNE, 1919 Aksarben DR, Omaha NE 68180.

Our January 2016 speaker will be you, the members of the Omaha SSUG!

The Topic:

BYOSP! (Bring Your Own SQL Problem!)

Synopsis:

Having problems with SQL Server? Bring the issue to the meeting! Can get that report just right? Bring the issue to the meeting! Your cube not slicing & dicing the way that you want? Bring the issue to the meeting! Need clarification on a SQL Server feature? Bring it to the meeting! Don’t have anything but want to help out your fellow IT person? Bring yourself to the meeting!

Nothing is out of bounds for this meeting. We’ll take a list of topics from the members and we’ll use the collective brain power of those present to try to get you pointed in the right direction and/or even present a solution to you!

We’ll have a facilitator and access to a test SQL Server so that we can test some of the questions out on.

So bring your laptops, your questions, and your willingness to speak up and help another!

Food will be provided about 15-20 minutes prior to the start of the meeting. Register today to let us know you’re coming and to be eligible for a chance to win some great SWAG!

Registration Link: http://omahamtg.com/Event/Details/225

SQL Saturday Pre-Cons – Registration now open!

Registration is now open for the three pre-con sessions we are holding on Friday, August 14th at UNO’s Mammel Hall – 6708 Pine ST, Omaha, NE 68106.

We have three great sessions:

  • Ed Leighton-Dick: SQL Server Security Master Class
  • Mike Fal: Introduction to Powershell
  • Dandy Weyn: Power BI

The cost to attend a session is $129 and it will be from 8 AM to 5 PM.

Register today! http://www.eventbrite.com/e/sql-saturday-omaha-pre-cons-tickets-17823195658?aff=omahasql

Or register directly below:

[xyz-ihs snippet=”SQL-Saturday-Omaha-397-Pre-Con-Registration”]