Welcome!

Welcome to the Louisville SQL Server Users Group! We represent the SQL Server community in Louisville, the surrounding metropolitan area, and throughout most of Kentucky. As a technical users group, we focus on monthly meetings, but also provide networking, learning opportunities, speaking opportunities, training, and collaboration for SQL Server professionals throughout the Ohio Valley area. Our monthly meetings occur on the second Thursday of each month, either at lunchtime in the downtown Louisville area or in the evening outside downtown. This alternating approach to meeting times and locations allows us to support as many of our users as possible and provides different venue and time options for our meetings and our attendees. We also partner with various volunteer groups to bring special events to the area, such as SQL Saturdays. Those events typically draw large crowds of SQL Server professionals from Kentucky, Ohio, Indiana, Tennessee, and beyond!

 

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 16,000 databases on 1,500 SQL Servers. His latest endeavor has been around building a warehouse/website in C#/MVC to automate many database-related processes.