No May meeting
May 7, 2013 in Meetings
The Memphis PASS Chapter will not have it’s usual meeting this month.
Hope to see you all in June.
Number of View :77
You are browsing the archive for Meetings.
by Alvin Ramard
Number of View :77
by Alvin Ramard
Apr 11 – Lisa Gardner – SQL Server AlwaysOn
March 17, 2013 in Meetings
When: Thursday, Apr 11th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Apr 11th, as Lisa Gardner talks to us about SQL Server Always On.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
SQL Server – Always On
SQL Server AlwaysOn is the new integrated, flexible, cost-efficient high availability and disaster recovery solution that provides redundancy within a datacenter and across datacenters and enables fast application failover providing maximum availability and data protection for your mission critical applications.
AlwaysOn provides flexibility in configuration and enables reuse of existing hardware investments including shared storage.
AlwaysOn Availability Groups
AlwaysOn Availability Groups is a new feature that greatly enhances the capabilities of Database Mirroring and ensures availability of application databases and provides zero data loss protection. Availability Groups provides an integrated set of options including automatic and manual failover of a group of databases, support for up to four secondaries and two synchronous secondaries, fast application failover and automatic page repair.
AlwaysOn Failover Cluster Instances
AlwaysOn Failover Cluster Instances enhances the SQL Server Failover Clustering feature and supports multi-site clustering across subnet which enables cross-datacenter failovers of SQL Server instances. Fast and predictable instance failover is another key benefit which enables fast application recovery.
Bio:
Lisa Gardner is a Premier Field Engineer for Microsoft based out of Columbus, OH. She has been working with SQL Server since version 6.0 with an emphasis on high availability and performance tuning.
Number of View :298
by Alvin Ramard
Mar 14 – Dan Evans – SQL Server 2012 BI Updates
March 12, 2013 in Meetings
When: Thursday, Mar 14th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Mar 14th, as Dan Evans talks to us about what’s new with SQL Server 2012 BI.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
Some new significant announcements have come out in the recent weeks related to SQL Server and the BI stack.
- SQL Server Data Tools for VS2012
- Data Explorer Preview (with Power View and PowerPivot)
- Hortonworks Data Platform for Windows
- Parallel Data Warehouse for SQL Server 2012
Come see and hear more regarding new developments in this area. This discussion will be mostly interactive and totally off script – so come help learn with the instructor about how to take your SQL Server environment to the next level.
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 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).
Number of View :403
by Alvin Ramard
Feb 21 – Rob DeMotsis – What You Should Do as the New SQL Server DBA?
February 9, 2013 in Meetings
When: Thursday, Feb 21st
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Feb 21st, as Rob Demotsis talks what you should do as the new DBA at a new location.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
This will be a back-to-basics presentation.
- The DBA’s role is in today’s business.
- How to quickly understand your environment?
- Ways to make a few quick wins.
- Ways to improve your skill sets.
- And then … an open forum for discussing questions and concerns from the audience.
Bio:
Rob DeMotsis is currently a DBA at Baptist Memorial Hospital. For the last 15 years I have worked throughout Memphis and Dallas/Fort Worth as a SQL Server DBA in various industries. My hobbies include rock and fossil collecting, photography, and reading.
Number of View :2463
by Alvin Ramard
Jan 10 – Shawn Harrison – SSIS 2012 Deployment Models
January 9, 2013 in Meetings
When: Thursday, Jan 10th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Jan 10th, as Shawn Harrison talks to us about SSIS 2012 deployment models.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
There have been many changes to SSIS with the release of SQL Server 2012. One of the most important being the way SSIS packages are deployed. In this webinar, Shawn will demonstrate the two different types of deployment and explain how they work.
Bio:
Shawn Harrison is an SSIS and SSRS trainer for Pragmatic Works. He has presented at SSIS workshops around the country, and actively participates within the SQL community.
Number of View :5377
by Alvin Ramard
Dec 13 – Kevin Boles – Common TSQL Mistakes
November 27, 2012 in Meetings
When: Thursday, Dec 13th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Dec 13th, as Kevin Boles talks to us about the mistakes commonly made by SQL developers.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
Kevin Boles is going to examine a variety of oopsies MANY developers fall prey too – some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. He GUARANTEES that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. Kevin has given this talk about 30 times now and it is always very highly rated!
Bio:
Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over 20 years of database experience and 40000+ man hours of SQL Server relational engine experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning.
You can follow Kevin on LinkedIn: http://www.linkedin.com/in/thesqlguru
Number of View :6832
by Alvin Ramard
Sept 13th Meeting – Robert Cain – Make SQL Server Pop with PowerShell
August 28, 2012 in Meetings
When: Thursday, Sept 13th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Sept 13th, as Robert Cain talks to us about how to use PowerShell to make SQL Server pop.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
PowerShell is everywhere, and that includes SQL Server. In this session we’ll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects). Learn how to handle common DBA tasks, such as checking the status of various services, validating backups, and checking for disk usage. You’ll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Come see how to make your SQL Server Pop with PowerShell.
Bio:
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP in SQL Server, MCTS Certified in BI, and works as a Senior Consultant for Pragmatic Works. He is also a technical contributor to Plurasight Training, co-author of Volumes 1 and 2 of “SQL Server MVP Deep Dives”, as well as “Professional SQL Server 2012 Administration”. A popular speaker, Robert has presented at events such as TechEd, SQL Rally, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Number of View :4861
by Alvin Ramard
Aug 9th Meeting – Shawn Jackson – Tips and Tricks for Dimensional Modeling
August 6, 2012 in Meetings
When: Thursday, Aug 9th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Aug 9th, as Shawn Jackson shows us a few tips and tricks about dimensional modeling.
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
Dimensional modeling is a set of techniques and concepts used in data warehouse design. It is intended to support end-user queries and is oriented around understandability and performance. Dimensional modeling always uses the concepts of facts (measures) and dimensions (context). Facts are typically (but not always) numerical values that can be aggregated and dimensions are groups of hierarchies and descriptors that define the facts. For example, sales amount is a fact; timestamp, product, register#, store#, etc. are elements of dimensions. Dimensional models are built by business process area, e.g. store sales, inventory, claims, etc.
We will cover the basics of dimensional modeling such as defining dimensions and facts, identifying the grain and star schema versus snowflake schema. We will also cover tips and tricks for dealing with more advanced topics such as roleplaying dimensions, fact-less fact tables and the different modeling techniques for slowly changing dimensions.
Bio:
Shawn Jackson has 16 years of experience working as an application developer for Morgan Keegan (now Raymond James) including 12 years of SQL Server experience. In 2007 he began working on Morgan Keegan’s BI initiative and became Microsoft Certified in SQL Server BI. Shawn has since designed, built and implemented their data warehouse. Shawn holds a BS and MS in Electrical Engineering from the University of Memphis.
Number of View :2634
by Alvin Ramard
July 12th Meeting – 2011 PASS Summit Presentation
July 10, 2012 in Meetings
When: Thursday, July 12th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
This month we will do something a little different. Due to our planned speaker not being available for the meeting, we have decided that for this meeting, we will watch one of the presentations from the 2011 PASS Summit, followed by a discussion of the presentation.
Please review the list of presentation listed at http://mem-pass.org/summits/2011/2011summit.htm
We will choose a presentation at the meeting.
Please register if you plan to attend so we can get enough food for everybody. Hope to see you all there.
Number of View :2173
by Alvin Ramard
June 14th Meeting – Dan Evans – PowerPivot and Power View for SQL 2012
June 12, 2012 in Meetings
Abstract:
Microsoft SQL Server PowerPivot for Microsoft Excel (PowerPivot for Excel) is a data analysis tool that delivers unmatched computational power directly within the application that you already know and love—Microsoft Excel. PowerPivot for Excel Help will get you up to speed and enable you to be productive right away.
Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations.
Come learn the benefits (and challenges) of these tools in the Microsoft Business Intelligence (MS BI) feature set. We’ll walk through some of the key components necessary to implement these tools and share some best practices
Bio:
Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.
Here’s the presentation and the scripts from Dan’s presentation:
MEM-PASS April 2012 – PowerPivot and Power View
Here are a few important links that Dan wanted to add as well:
http://www.microsoft.com/en-
http://technet.microsoft.com/
http://technet.microsoft.com/
http://www.microsoft.com/en-
Number of View :2859