May Meeting – 2016 0

Speaker – Jessica Moss

Topic – SQL Server 2016 On-Premises Business Intelligence Tool New Features

Business intelligence developers and users everywhere are happily anticipating new updates to the on-premises business intelligence tools for SQL Server.  With the full release of SQL Server 2016 around the corner, Microsoft has released several preview versions of the on-premises tools.  Based on these previews, we can expect to see updates in Reporting Services, such as customizable parameters, mobile reports, and new chart types.  Integration Services also boasts new changes, such as incremental package deployment, better error handling, and new logging levels.  Finally, Analysis Services has additional features, including new DAX functions and extended event viewing.  This session will cover these new items and more in a demo-focused presentation.

April Meeting – 2016 0

Speaker: Kenneth Jensen

Session: SQL Injection and the DBA

Per OWASP, SQL Injection (SQLi) is the number one threat to database driven web sites. But the SQLi menace is not limited to just web attached databases, all databases are threatened.

If you are asking yourself, what is SQL Injection, how can it affect my company or what can I do about it as a database professional, this session is for you.

March Meeting – 2016 0

Speaker: Louis Davidson

Session: Let Me Finish… Isolating Write Operations

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

February Meeting – 2016 0

Speaker: Andy Leonard

Session: Hacking the SSIS Catalog

The SSIS Catalog supports enterprise data integration by providing execution, logging, parameter management, and reporting. But what if your enterprise needs more functionality than the SSIS Catalog provides? Do you have to build your own SSIS Framework? Should you?

December Meeting – 2015 0

Speaker: Jamie Wick

Session: SQL Backups: Choosing the right solution for your environment

Abstract: Backing up databases is (arguably) the most important maintenance task for any database administrator. But the question is: Which solution should you choose for creating and managing your backups? In this session we’ll discuss the options available and demonstrate 2 of the solutions in action (Ola Hallengren’s DatabaseBackup and Minionware’s Minion Backup).

Free Training! 0

FREE TRAINING !

Our good friends Jason Brimhall and Wayne Sheffield have graciously decided to once again provide a full day of SQL Server training for FREE!  The only cost involved is your lunch at Ruby Tuesdays and, of course, your time.  They did a “Free Con” for our locale last year on extended events and Jason will be speaking about extended events at our users group meeting on Wednesday, November 18.  (Don’t forget to register to be eligible for our giveaways!)

This years Free-Con is entitled “Murder They Wrote”  It is an awesome deep dive into some T-SQL coding anti-patterns and what to do about them.  Please register here or if you would like additional information please visit the website (there is an EventBrite registration link there as well)  On a professional note, I can attest to the value from this training.  I have attended this all day session twice as a pre-con for SQL Saturday events.  These events had a cost associated with them and I can honestly say it was training dollars well spent.  Oh did I mention that the training on November 20th is FREE?  Don’t miss out, register today.

November Meeting – 2015 0

Speaker:  Jason Brimhall

Session:  A Masters Passport to Extended Events

Abstract:  As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.

It is time to let those old tools retire gracefully and move into the world of XE. This session will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

October Meeting – 2015 0

Rob Collie

Session: Power BI and SQL Pros: Impact and Opportunity Demystified.

Abstract: “This is a SQL and data warehousing user group. They don’t understand Analysis Services, OLAP, or really even BI as you think of it.” Five years ago, that’s what I was told by a BI user group coordinator immediately after giving a Power Pivot talk – a talk in which I had assumed the exact opposite, and which had yielded a lot of blank faces in the audience.

So… have things changed today? To an extent yes, and to an extent no. But no matter, because this time, I’m ready for you, regardless of your background!

Join us for a lively and interactive (and cartoon-illustrated!) discussion of the following questions/points:

  • What can Power BI do that “pure SQL” cannot?
  • Why PBI’s advertisement as “pretty dashboards” sells it WAY short.
  • How is Power BI different from traditional BI?
  • How can SQL pros benefit from Power BI even if they don’t use it personally?

September Meeting – 2015 0

Glenn Berry

Session: Analyzing I/O Subsystem Performance

Abstract: SQL Server is often I/O bound – but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.