Louisville SQL Server and Power BI User Group

Welcome to the Louisville SQL Server & Power BI Users Group!

Our group is generally made up of folks that hail from the Derby City and surrounding Ohio River Valley area, who all have a passion for Microsoft SQL Server and the technologies that surround it. 

We are a diverse group with skills ranging from "accidental DBA's" to senior administrators, seasoned developers to big data analysts and all of the other backgrounds that fall in between.

Do you love to learn? 

Do you love sharing what you know about the complex challenges of working with SQL Server?

Then come join us, and make yourself at home.  

 

Next Meeting

Thursday,

August

13

Transforming Data Using the T-SQL PIVOT / UNPIVOT Operators

Join us on Thursday, August 13 for the next meeting of the Louisville SQL Server Users Group! We will meet at the Humana Training Center in the Waterfront Plaza in downtown Louisville.  We plan to have food arrive at 11:30am, with the meeting starting at 11:45am and ending at 1:00pm (our normal schedule).

We have TWO meeting sponsors this month – Dell Software and our Gold sponsor KiZAN:

Dell Software helps customers unlock greater potential through the power of technology—delivering scalable, affordable and simple-to-use solutions that simplify IT and mitigate risk. This software, when combined with Dell hardware and services, drives unmatched efficiency and productivity to accelerate business results. Visit http://www.dellsoftware.com.

KiZAN Technologies, a Microsoft Gold Partner for over twenty years, provides a full array of solutions to solve the most challenging issues businesses face today. We deliver consulting services to solve business needs primarily in the Central Region centered on Microsoft-based technologies. Our organization was listed as one of Business First's Fast Fifty, showing that KiZAN is one of the fastest growing private companies headquartered in Louisville, KY. Combining world-class products with our commitment to excellence has enabled us to be the local and regional technology solution provider of choice. Visit http://www.kizan.com today!

Please come out for our August meeting, thank our sponsors, and learn about PIVOT and UNPIVOT!

Featured Presentation:

Transforming Data Using the T-SQL PIVOT / UNPIVOT Operators

Jeff Foushee, Enterprise Database Administrator Humana Inc

Ever wish your horizontal data were vertical for easier data storage, or vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating "OUTER JOIN" or "UNION” so often that you wind up back in Kansas when your read them aloud? Join Jeff Foushee as he explains SQL Server's lesser-known PIVOT and UNPIVOT operators using SQL 2014. After this session, you will no longer need to rotate your monitor!

About Jeff:
Jeff Foushee has his MCITP certification in both SQL Server and Windows Server. He is also an Enterprise DBA at Louisville-based Humana, Inc., where he supports almost 20,000 databases on 1,800 SQL Servers. His latest endeavor has been around building a warehouse/website in C#/MVC to automate many database-related processes.

Supplementary Materials

The following event attachments are available to you:

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids