Aug 2015 – Pete Brown – Introduction to Powershell for the DBA

When: Thursday, August 13th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Aug 13th, as Pete Brown gives us an introduction to the use of Powershell to help DBAs accomplish there routine tasks.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM. If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/224291356/

For those that might be arriving after 5:30, the door and elevator code is will be 2111#


Summary:

Powershell is a tool that should be in every DBA’s toolbox. When running regular maintenance or ad-hoc procedures against a number of servers, it can greatly reduce time spend on repetitive tasks. In this session we will provide an introduction to Powershell as well as demonstrate some common administrative functions used to manage SQL Server.

About Pete:

Pete Brown is a DB & Middleware engineer with ServiceMaster. In the last 15 years he has supported various technical areas including database, messaging, systems administration, virtualization, networking and telephony. His certifications include Microsoft MCSE, Cisco CCNP R&S, VMWare VCP and ITIL Foundations. Perl and C# are his languages of choice for automation and tool building. As a pastime he develops UC related data decryption and visibility tools for his website, http://www.adhdtech.com/.

Announcing Cortana Analytics Suite

Overview Webinar 7/23 11:30 CST https://info.microsoft.com/CO-Azure-FY16-07Jul-AdvancedAnalytics-Registration.html

Last week at the Microsoft World Wide Partner Conference in Orlando we made a number of significant technology and program announcements to help our customers capitalize on the incredible opportunities provided by big data, advanced analytics and cloud computing.

Firstly, data is now the key strategic business asset. Every device, every customer, every activity – everything that’s happening in the world around us – is producing incredibly rich data that can help us create new experiences, new efficiencies, new business models and even new inventions. Leveraging this data can be the differentiator for a business. For example, IDC estimates companies that are leaders in using data assets to their advantage will capture $1.6 trillion more in business value than those that lag behind.

While data is pervasive, actionable intelligence from data is elusive. Our customers want to transform data to intelligent action and reinvent their business processes. To do this they need to more easily analyze massive amounts of data – so they can move from seeing “what happened” and understanding “why it happened” to predicting “what will happen” and ultimately, knowing “what should I do”. Only then can they create the intelligent enterprise.

The Cortana Analytics Suite brings about this vision by delivering big data and advanced analytics capabilities to help enterprises transform their data into intelligent action. With Cortana Analytics, we are taking years of research and innovation – spanning technology and infrastructure for advanced analytics, including capabilities like machine learning, big data storage and processing in the cloud as well as perceptual intelligence such as vision, face and speech recognition, with the goal of helping enterprise customers make better, faster decisions to accelerate their speed of business. Additionally the Cortana Analytics Suite integrates with Cortana, Microsoft’s digital personal assistant. Cortana works with the Cortana Analytics Suite to enable businesses to get things done in more helpful, proactive, and natural ways.

Cotrana_Analytics

Cortana Analytics Suite enables core analytics scenarios such as real-time recommendations, customer churn forecasting, fraud detection, predictive maintenance and many more. For example, Dartmouth-Hitchcock Health System, the largest hospital in northern New England, is developing a remote monitoring and predictive analytics solution called ImagineCare using the Cortana Analytics Suite. Leveraging predictive analytics, ImagineCare will enable dynamic treatment plans based on the individual patient’s history and profile and patterns observed from a broad corpus of data. ImagineCare aims to significantly enhance patient outcomes by predicting the probability of catastrophic events such as heart attacks and emergency readmissions before they happen.

You can see more of the work Dartmouth Hitchcock is doing with Cortana Analytics here.

Cortana Analytics Suite will be available later this fall as an integrated offering with a simple monthly subscription model that takes advantage of all the relevant analytics and big data capabilities to make better decisions as well as intelligently automate operations. The offering, while customizable to fit the unique needs of organizations, will also provide preconfigured solutions to speed deployment of common scenarios we see across many industries, such as fraud detection, churn analysis and recommendations. I encourage you to get started immediately with many of its individual services that are already available.

For more information on Cortana Analytics Suite visit www.microsoft.com/cortanaanalytics

Microsoft Power BI Preview Technical Overview – June 30th

Are you familiar with the Power BI preview but want to drill down on the technical details and capabilities of the service?

Join Sanjay Soni, Technical Product Marketing Manager for Power BI on Tuesday, June 30th at 10AM PT/ 1PM ET to get an overview of Power BI technical details and architecture, including the Power BI Designer, Content Packs, data sources and on-prem connectivity.

For more information, see: Microsoft Power BI Preview Technical Overview

July 2015 – Dan Evans – What’s new with Power BI?

When: Thursday, July 9th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, July 9th, as Dan Evans fills us in on what’s new with Power BI.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Summary

Power BI for Office 365 today is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device. With the Power BI Public Preview you can now perform the same deep analytics and rich visualizations using just a web browser. Come see the new experience for yourself and learn how to create interactive dashboards, connect to virtually any data source, enable rich analytics with your applications and power your business with real-time analytics. You can sign up today at https://www.powerbi.com/

Bio

Technology consultant with over 20 years’ experience in applying innovative solutions to business needs. Key focus areas are Business Intelligence, Enterprise Performance Management and Data Strategy. Work heavily in promoting technology across North America through involvement with regional user groups (.NET, PASS) and industry-recognized organizations (TDWI, DAMA).

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/223259083/

June 2015 – Adam Belebczuk – Availability Groups 101: An Introduction

When: Thursday, June 18th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, June 18th, as Adam Belebczuk helps us learn about SQL Server’s AlwaysOn Availability Groups.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

Abstract

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we’ll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.

Bio

Adam Belebczuk is a Consultant, Accidental DBA, and Developer with over 10 years of experience in IT, ranging from customer service to server/network administration to software and database development. Adam holds the MCSE: Data Platform and MCITP DBA 2005/2008 certifications, is a frequent speaker at SQL Server Users Groups and SQL Saturday events, and specializes in SQL development, performance tuning, high availability, & disaster recovery.

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220193017/

May 2015 – See y’all at the BBQ Fest

We will not be having our normal monthly meeting in May. Instead, you’re all invited to come sample some of the best BBQ on earth.

This is by invitation only so don’t forget to click one of the links below for your invitation, or by clicking here.

See you there. Don’t forget to bring your appetite. 😉



image002

May 14-15, 2015
By Invitation ONLY!

Presented by:
1E, Aspect, Commvault, Core BTS, HP, Insight, Intel, Jabra, McGladrey, Microsoft, New Horizons, Polycom and Vanick Digital

Register now to reserve your space!

Questions?

Contact Aimee Howell @ 901.375.1533 or email @ ahowell@nhmemphis.com.


As a valued customer, we have your tent waiting…

Please join us in the Smoke Masters Championship BBQ Team Tent (#R-130-131) at the 2015 Memphis in May – World Championship Barbecue Cooking Contest. Presented by 1E, Aspect, Commvault, Core BTS, HP, Insight, Intel, Jabra, McGladrey, Microsoft, New Horizons, Polycom and Vanick Digital.

This event is by INVITATION ONLY, so we encourage you to reserve your seat today.

Dates & Times:

Thursday, May 14 Lunch: 11:30 am – 2:00 pm
Dinner: 4:30 – 7:30 pm
Friday, May 15 Lunch: 11:30 am – 1:30 pm

 

Location:

R130-131 Tent #130 and 131

 

General Information:

Admission to Memphis In May is FREE from 11:00 AM to 1:00 PM. Single Day Tickets are $8 (after 1:00 PM) – Children 6 and under are Free.

Admission to the Smoke Masters tent is free to invited guests.

Apr 2015 – DBA to Data Scientist

When: Thursday, Apr 9th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Apr 9th, as Cherie Sherriff, helps us learn more about the migration from DBA to Data Scientist.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/221087006/


DBA to Data Scientist:

Data Science is one of the technology hot topics and growing career fields. How does the journey start from being a DBA to following a path of data analytics to the point where you become a Data Scientist? What do you need to know and where can you find that information? If you have ever wondered what the difference is, how to get there, what you might need to learn, or even IF you want to go that route, this session will cover the key points to all of these questions and provide you with ample resources to make this journey.

Mar 2015 – A Window into Your Data: Using SQL Window Functions

When: Thursday, Mar 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Mar 12th, as Steve Hughes from Pragmatic Works, helps us learn more about SQL Server’s Window functions.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220657051/


Abstract:
Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.

Bio:
Steve Hughes is an Architect at Pragmatic Works. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored three books and delivered multiple presentations on SQL Server and data architecture over the past six years.

Feb 2015 – Tips and Tricks for Planning a Data Warehouse

When: Thursday, Feb 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Join us Thursday, Feb 12th, as we take a look at Tips and Tricks for Planning a Data Warehouse.

Do you have a new, or on-going, Data Warehouse project but are not sure how to proceed? Planning the design of a Data Warehouse can be a daunting task and overall these projects have a low success rate. Join us as we see what Brian Knight help us learn tips and tricks for planning the design of a data warehouse as well as walk through the actual implementation of dimensional model.

We’ll be review a recent webinar from Pragmatic Works where Brian Knight covers a number of items to keep in my as you plan, or implement, your data warehouse project.

Do you have any tips and tricks, best practices, or horror stories, you’d like to share with us? Join us and hopefully you’ll learn a few things that can help make your data warehouse project successful.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/220131618/

January 2015 – Autogenerate a Dimensional Data Warehouse from Metadata

When: Thursday, Jan 15th, 2015
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Most data warehouse design efforts produce a large amount of metadata in the form of handwritten documentation. If done properly, this documentation provides everything the development team requires to build the dimensional data model and load that model with transformed data using the patterns and best practices that were also specified as part of the warehouse design. Unfortunately, the process of translating requirements to T-SQL scripts and SSIS packages requires tremendous effort and creates assets that are expensive to maintain.

Join us this Thursday, Jan 15th, as we take a look at one of the sessions from the 2014 PASS Summit where Scott Currie will show how to use a metadata database to store the requirements information, and then use this metadata to automatically generate EVERYTHING you need for your data warehouse project: documentation, schemas, SSIS packages, deployment scripts, etc. The code for the solution, which is presently in use in production data warehouses in major international companies, will be provided for all attendees to freely use.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those that might be arriving after 5:30, the door and elevator code is will be 2111#