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 :60
by Alvin Ramard
Number of View :60
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 :250
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 :378
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 :2414
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 :5128
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 :6659
by Alvin Ramard
Oct 11 – Sanjay Soni – Top 10 features & benefits of SQL Server Parallel Data Warehouse with integrated PDW and BI Demo
September 25, 2012 in Uncategorized
When: Thursday, Oct 11th
Pizza at 5:30 PM
Meeting at 6:00 PM
Where: New Horizons
4775 American Way
Memphis, TN, 38118
Join us on Thursday, Oct 11th, as Sanjay Soni talks to us about the features and benefits of Microsoft’s SQL Server Parallel Data Warehouse (PDW).
As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.
Abstract:
SQL Server PDW is a pre-configured, pretested, fully integrated MPP (Massively Parallel Processing) Data Warehouse appliance purposely built for demanding analytical workloads. While symmetric multi-processing (SMP) databases work well for small data warehouses and data marts, many organizations are adopting massively parallel processing (MPP) database architectures for more demanding workloads to ensure SLAs are met and costs are kept low. Learn about PDW to achieve breakthrough performance and linear scalability through a shared-nothing, MPP architecture. Benefit from simplicity of a fully integrated DW appliance and its unbeatable value. Please join this session to learn about top 10 features and benefits of PDW as part of overall Microsoft Data Warehousing and BI solution.
Bio:
Sanjay Soni is a SQL Server Parallel Data Warehouse Technology Solution Professional at Microsoft Corporation responsible for technology pre-sales for Enterprise Customers focusing on Microsoft SQL Server Data Warehousing and BI platform technologies for USA (West). He worked as the Data and BI Platform TSP and before that, as a BI Platforms Evangelist in the Microsoft IT BI Engineering and was responsible for enabling BI to the masses at Microsoft. He is an MCDBA, MCTS and specializes in Data Warehousing and BI using MS technologies. Sanjay has authored and presented a variety of papers and sessions in last 15 years at various BI conferences including Tech-Ed, BI Conference, PASS, SQL Connections, SharePoint Conference, TDWI, and with many of these papers published in SQL Server magazine as well as on various web sites including Microsoft.com, Technet etc. Sanjay presents regularly to Customer Organizations through Executive Briefing’s and Direct Engagements on the topics of DW and BI.
Number of View :4470
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 :4807
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 :2582
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 :2145