You are browsing the archive for Meetings.

Apr 10 – Dan Evans – SQL Server 2014 Launch – Accelerate Your Insights

April 5, 2014 in Meetings

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

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


Update: The “deck” from Thursday’s meeting can be downloaded from here: SQL Server 2014 Overview with Data Insights – Memphis PASS April 2014k


On April 1st, Microsoft released SQL Server 2014 and it was no joke. Join us Thursday, April 10th, as Dan Evans takes us through our first look at SQL Server 2014.

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

For those arriving after 5:30, the door code will be posted here as soon as soon as it becomes available.

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/175483982/

Abstract:
Big data. Small data. All data. You have access to an ever-expanding volume of data inside the walls of your business and out across the web. The potential in data is endless – from predicting election results to preventing the spread of epidemics. But how can you use it to your advantage to help move your business forward?

Data is growing exponentially and it’s now possible to mine and unlock insights from data in new and unexpected ways. Empower your business to take advantage of this data by harnessing the rich capabilities of Microsoft SQL Server and the familiarity of Microsoft Office to help organize, analyze, and make sense of your data – no matter the size.

Want to learn more? Join us and see how to drive real-time business, from apps to insights, through a deeper look into the comprehensive in-memory technologies in Microsoft SQL Server 2014 and Power BI for Office 365. Attending this event will allow you to get a running start on understanding the extensive innovations we’re delivering around data that will empower your business with the tools you need to quickly uncover business insights and make smarter business decisions.

Bio:
Dan Evans is a Senior Technology Solution Professional on the BI and Analytics platform at Microsoft. He brings over 20 years’ experience developing and delivering innovative analytic solutions on the Microsoft platform. Dan has presented at numerous regional and national conference including TechEd, PASS, DAMA, and TDWI, regarding best practices and architecture utilizing both on premise, cloud and hybrid solutions. He now supports many regional user groups including PASS, DAMA, TDWI, and the newly formed Modern Excel User Group (MEUG).


Number of View :1691

Files from 2014-03-13 Meeting

March 17, 2014 in Meetings

Files from the 2014-03-13 meeting have been uploaded to Downloads

Here’s the direct link for the Zip file: 2014-Mar 13th – Sathya Nekkanti – SQL 2008 Data Structures


Number of View :1170

2014-Mar 13th – Sathya Nekkanti – SQL 2008 Data Structures

March 1, 2014 in Meetings

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

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

Join us on Thursday, Mar 13th, as Sathya Nekkanti, from FNC Inc., talks to us about SQL 2008 structures.

Please Note: Those arriving after 5:30 PM will need the door code to get in. Be sure to RSVP if you plan to attend so you will receive the code. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/169874692/

Abstract:
Sathya Nekkanti will discuss SQL server 2008 data structures, specifically covering Data Compression, Sparse columns and Filestream. Sathya will discuss how the Data compression works in SQL server 2008 and how to understand the data structure of the compressed data. He will talk about when to use sparse columns, how the data structure looks internally with sparse columns, some of the traditional alternative ways of storing heterogeneous data instead of sparse columns, and their benefits and pitfalls. Finally, he will dive into the FileStream feature in SQL server and its data structure.

Bio:
Sathya Nekkanti is a Microsoft certified IT Professional for SQL server 2008 for development and DBA as well. Currently working for FNC Inc. for the past 13 years in the role of Senior Manager/Database Architect, primarily focusing on several banking FNC systems Database Architect Design and maintenance. Before joining FNC Sathya worked for PlanetRX.com where he worked on design and work flow engine for retail and prescription orders. Prior to PlanetRx Sathya worked on several Banking applications for international transactions applying SWIFT(Society for Worldwide Interbank Financial Telecom) principles.


Number of View :7392

Feb 2014 Meeting Rescheduled or Cancelled

February 11, 2014 in Meetings, Notices

We regret to announce that, due to a scheduling conflict, we will not be having our usual meeting this coming Thursday, Feb 13th.  We will let you know as soon as possible whether or not the meeting is rescheduled to next week, with a different topic and speaker.


Number of View :384

2014 – Jan 9th – Dan Evans – Deep Dive into BI on the Fly

January 6, 2014 in Meetings

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

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Happy New Year everyone.

Join us on Thursday, Jan 9th, for the chapters first meeting of the new year. We’ll begin the meeting with some important news regarding Memphis PASS Chapter and then a short discussion about the future of the group. After that Dan Evans will take us for a deeper dive into BI on the Fly.

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

Abstract:

BI on the Fly – With Excel as the predominant data analysis tool, all users can perform deep, rich data location, integration, delivery, and visualizations using everyday tools. Excel has the ability to quickly locate data with Data Explorer and structure information in PowerPivot to create strong correlations between items and create a foundation for further analysis. Come hear more about combining PowerPivot for self-service BI reporting with GeoFlow for 3D visualizations to provide a comprehensive and compelling view of information to engage others in true collaborative BI.

Bio:

Dan Evans is a senior Technical Solution Professional (TSP) with Microsoft focusing on Business Intelligence and Data Analytics.  Dan builds trusted relationships with accounts in the Heartland District to advise customers on the benefits of using the Microsoft Data platform by growing awareness and supporting adoption.   He holds several technical and professional certifications (MCP, MVP, CBIP) in the industry and has presented at national conferences like TechEd, PASS and TDWI.

 

Eventbrite - Memphis PASS - Dan Evans - Deep Dive into BI on the Fly


Number of View :7121

Dec 12th – Kathi Kellenberger – Writing Better Queries with T-SQL Window Functions

November 28, 2013 in Meetings

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

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Dec 12th, as Kathi Kellenberger talks to us about we can improve our querying skills by using the T-SQL Window Functions.

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

Writing Better Queries with T-SQL Window Functions

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

Bio

Kathi Kellenberger is a senior consultant with Pragmatic Works. She has written more than 24 articles on SQL Server topics, is author of “Beginning T-SQL 2008,” and is co-author of “Professional SQL Server 2005 Integration Services,” “Beginning T-SQL 2012,” and “SQL Server MVP Deep Dives.” When Kathi isn’t working, she enjoys cycling, singing (she started #sqlkaraoke), and spending time with family and friends.

 

Eventbrite - Memphis PASS - Kathi Kellenberger - Better Queries with Window Functions


Number of View :15564

Nov 14th – Jorge Segarra – What is a BI DBA?

November 10, 2013 in Meetings

When: Thursday, Nov 14th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Nov 14th, as Jorge Segarra talks to us about what is a BI DBA.

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

What is a BI DBA?

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment then come join us on Thursday.

Bio

Jorge Segarra is a DBA consultant for Pragmatic Works and a SQL Server MVP. In addition to being a member of the Jacksonville/Tampa SQL Server User Groups, he is a former Regional Mentor for PASS. Jorge has co-authored the Apress book “SQL 2008 Pro Policy-Based Management” as well as the “SQL Server 2012 Bible” and was a Red Gate Software Exceptional DBA of the Year 2010 finalist. He also founded SQL University, a community project aimed at helping people learn SQL Server from the ground up, which you can find at http://sqluniversity.org

 

Eventbrite - Memphis PASS - Jorge Segarra – What is a BI DBA? - Nov 14th


Number of View :8227

Oct 10th – Dan Evans – BI on the Fly

October 8, 2013 in Meetings

When: Thursday, Oct 10th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Oct 10th, as Dan Evans talks to us about BI on the Fly.

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

Abstract:

With Excel as the de-facto tool, users now have many new ways to perform business-context related analysis. Come learn more about the components that make Excel 2013 and the rest of the Microsoft BI stack a powerful companion to complement existing SQL Server-based initiatives.

  • Flash Fill
  • Quick Analysis
  • Quick Explore
  • Power Pivot
  • Power View
  • Power Query
  • Power Map

See other options on how to integrate Apps or load into SharePoint, Office 365 and Azure as well.

Bio:

Dan Evans is a 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 in the Southeast through involvement with regional user groups (.NET, PASS) and industry-recognized organizations (TDWI, DAMA).

Specialties include Business technology solutions, data warehousing, business intelligence, project management, technical strategic planning and new business development. Dan has spoken at TDWI, TechNet and PASS on industry best practices in these areas.

Dan is also the president of the Memphis PASS Chatper (Mem-PASS).

Eventbrite - Memphis PASS - Dan Evans - BI on the Fly - Oct 10


Number of View :10011

Aug 8th – Steve Anderson – Using Microsoft SQL Server Analysis Services & Reporting Services for Data Analytics

August 6, 2013 in Meetings

When: Thursday, Aug 8th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Aug 8th, as Steve Anderson walks us through an example of how to use Analysis Services & Reporting Services for Data Analytics.

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

Abstract:

Steve Anderson will walk us through an example of how to use Analysis Services & Reporting Services for Data Analytics.

Bio:

Steve Anderson is a database and analytics professional who received a Master of Engineering Management degree from Christian Brothers University and a Bachelor of Science in Computer Engineering from The University of Memphis. He is currently a Database Marketing Manager for a financial services institution in San Francisco CA. Mr. Anderson specializes in: Database Marketing, Data Analysis, Data Warehousing, Report Development & Business Intelligence. His expertise expands across several industries – sports, entertainment, financial services, gaming, and retail.

Eventbrite - Memphis PASS - Steve Anderson - SSAS & SSIS for Data Analytics


Number of View :77769

No MEM-PASS Meeting July – 2013

July 11, 2013 in Meetings

I regret to announce that there will be no Memphis PASS Chapter meeting for the month of July 2013.

What would you like for for the August 2013 meeting? Please let us know.

Hope to see you all in August.


Number of View :872

Switch to our mobile site