Applied MDX Refactoring SQL Applications Implementing SQL Server in a utility model WIT Monthly Conference-Call _____________________________________________________________ Applied MDX Monday October 25th 12 pm EDT (GMT-4) Kevin Geoff Learning the basics of MDX is one thing – learning how to incorporate MDX into custom OLAP applications is another. In this presentation, I’ll show several examples of MDX inside SSRS reports, PerformancePoint Services dashboards, and even inside of Excel. We’ll also look at using MDX inside of OLAP calculated members and data-driven KPIs. The attendee will come away with different perspectives on how MDX is necessary to create flexible OLAP reporting. Kevin Geoff Kevin is a 2010 SQL Server MVP ,2005-2008 .NET/C# MVP ,SQL Server/Business Intelligence senior instructor and courseware author – SetFocus, LLC ,Columnist for CoDe Magazine (Baker’s Dozen Productivity Series), and a Developer/consultant in the industry since 1987 How do I attend? Live Meeting link _____________________________________________________________Refactoring Refactoring SQL Applications Tuesday October 26th 12 pm EDT (GMT-4) Jeremiah Peschka Refactoring SQL is not like refactoring application code. This talk will demonstrate proven SQL refactoring techniques that will help you identify where performance gains can be made, apply quick fixes, improve readability, and help you quickly locate places to make sweeping performance improvements. Jeremiah Peschka has years of hands on experience tuning SQL applications for performance, throughput, and concurrency. Jeremiah Peschka Jeremiah is an Emerging Technology Expert with Quest Software. Jeremiah works with different software to identify new techniques and trends in the world of data storage. Over the course of his career, Jeremiah has worked as a system administrator, developer, and DBA. Previously, Jeremiah spent 2 years at Cass Information Systems, a utility billing provider. Jeremiah is involved in the Professional Association for SQL Server. When he is not volunteering with the development community, Jeremiah can be found blogging about data storage, relational databases, and software development at http://facility9.com. He can also be found on Twitter as @peschkaj. How do I attend? Live Meeting link _____________________________________________________________ Implementing SQL Server in a utility model Wednesday October 27th 12 pm EDT (GMT-4) Jason Massie A SQL Server as a Service(SQLaaS) in a utility computing model can be a robust platform providing self service provisioning, better utilization of hardware and power, lower administrative overhead and chargeback capabilities. It can allow your internal and external customers to forget about the database and focus on developing and deploying apps that add value to your core business. In this session, we will cover key benefits of offering the DB in a utility computing model which could be part of your larger SOA strategy. Next, we will look at some key considerations from the DBA and IT decision maker’s perspective that will drive the infrastructure design. Several different architectures will be discussed along with their business driven considerations. We will look at SQL Server 2008 r2 features that are well suited for a utility model as well as SQL Server vNext and 3rd party tools. Lastly, we will look at areas that may require custom development to meet your specific needs. Jason Massie Jason has 10 years experience as a DBA and currently manages the Oracle and SQL Server DBA teams for Terremark. He is a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. You can read more about him at http://jasonmassie.com and contact him at jmassie at terremark.com How do I attend? Live Meeting link _____________________________________________________________ Women In Technology Conference Call Wednesday October 27th 3pm CDT/1pm PDT (GMT-5/GMT-7) Please email Wendy Pastrick ( email | twitter ) for dial in information This will be our final call before the PASS Summit. Final planning for our PASS presence: Welcome Reception, WIT Luncheon, Chapter Lunch Discussion about roles in the chapter At the end of the meeting, we offer Open Mic time for people to share news or ask open ended questions
Introduction to PowerShell Getting started with Steam Insight and Complex Event Processing Applications Using Microsoft BI Tools to Access Oracle Applications Data _____________________________________________________________ Introduction to PowerShell Wednesday October 20th 12 pm EDT (GMT-4) Chad Miller Chad will get us started with an introduction to PowerShell as a command line for one-off tasks or automation in the DBA world. Basic PS principles and syntax will be covered. Get your proverbial DBA feet wet with a tool that can make your database and sysadmin life better than it was before! Bigger, stronger, faster. (Cue Bionic Man theme) Chad Miller Chad hails from the land of rocket launches, oranges, and alligators where he started the Tampa PowerShell User Group. Chad is the DBA for SQL Server and Manager of Database Administration for a shop supporting SQL Server, Oracle, and Informix, acts as coordinator for the SQL Server PowerShell Extensions CodePlex project, and maintains an active blog at http://sev17.com/author/chad-miller/ . How do I attend? Registration for the event is now open. *When you register you’ll get a calendar reminder for the event. _____________________________________________________________ Getting started with Steam Insight and Complex Event Processing Applications Wednesday October 20th 12 pm EDT (GMT-4) Chris Coneybeer Today we find our systems and users need to be able to quickly collect, analyze, and act upon data that is being streamed from an unlimited number of devices or systems in our enterprises. Frequently, this raw data is being collected from many different sources such as sensors on production lines, usage events from a website, or even just consumption data from a power meter. Generally this raw data goes through a time consuming process of collection, aggregation, and then querying before it can be used for business process decisions. SteamInsight is a new platform included with SQL Server 2008 R2 that is used to build Complex Event Processing (CEP) applications that are used to monitor these raw data streams. Using StreamInisght your applications will have the ability to analyze, correlate, and use the data contained in streams while it is in-flight. This is done by creating adapters that are responsible for monitoring streams and then writing queries against the adapters. During this session we will discuss what StreamInsight is, what stories it addresses in system architectures, and then we will look at some examples of using the Stream Insight platform and getting started with your own queries. Chris Coneybeer Chris is a C#/SQL developer with over 10 years of development experience working with Microsoft stack. Currently Chris works as an independent developer for small business and working in the banking industry as a contractor. Since his move the Phoenix area Chris has discovered the value and rich experience that community provides by sharing ideas and having open discussions. Chris enjoys working on connected systems and finding ways to leverage data for technology workers. During the years he has worked with VB6, VB.NET, C#.NET, ASP/ASP.NET, AJAX, XML, WCF, SSRS, SSIS, T-SQL, and other assorted technologies. His current interests include WCF, EF and WF improvements in the 4.0 framework along with SQL2008R2. Chris is the Vice-President of the Southeast Valley .NET User Group (SEVDNUG) in Chandler Arizona which supports local .NET developers through regular meetings and events. Recently he also gotten more involved with the Phoenix Connected Systems User Group(PCSUG) as Membership Director and is working with the leadership to grow the reach of the group. How do I attend? Live Meeting link _____________________________________________________________ Using Microsoft BI Tools to Access Oracle Applications Data Wednesday October 20th 12 pm EDT (GMT-4) Daryl Orts One of the challenges in using Microsoft’s BI tools (Reporting Services, Analysis Services, Excel, PowerPivot) to access Oracle applications data lies in building metadata models to make sense of the data. Whether you’re accessing the data directly in the transaction database or building a data warehouse, you’ll need data models that make sense of the Oracle database schema. This beginner to intermediate level presentation will discuss design approaches for building these models, including commercial products available from the presenter, Noetix Corporation How do I attend? Live Meeting link
After a short summer break we’re glad to get back to business with PowerShell. We’re very excited to have Mark Mitchell ( blog | twitter ) dropping by to show us how to create GUIs with PowerShell Date: 10/19/2010 (Tuesday) 6:00pm EDT (GMT-4) Location: New Horizons Atlanta 211 Perimeter Center Parkway Suite 200 Atlanta, GA 30346 Phone: (770) 270-2000 Agenda: 6:00pm: Introductions and Opening Remarks and free pizza and soft drinks. 6:15pm: Creating PowerShell Graphical Interfaces – Mark Mitchell 7:15pm: Script Club 7:45pm: Giveaway: Multiple copies of Lee Holme’s “Windows PowerShell Cookbook” Speaker Bio: Mark Mitchell has been working in IT for 30 years. He has worked about half his career time as an independent consultant, and the rest in the employment of companies. Mark has built or supported applications ranging from Finance, Mortgage Banking, HR, Transportation, Billing, Manufacturing, Project Management, and Sales Order systems; Running on Mainframe, Unix, and Windows platforms. Mark has worked with and designed Databases from Network(IDMS), hierarchical(IMS), and Relational(Oracle,SQL Server). Compiled languages of Cobol,Pascal/Delphi,VB,C/C++,ABAP(SAP),Java,C#. For Y2K, Mark rewrote a dBase shopfloor management application as an ASP web based application using a SQL Server backend. Mark Mitchell’s Scripting history: 1981 scripting mainframe editors (Wylbur, TSO/SPF-Clists ,VM/CMS) 1984 Dos batch scripts 1996 Unix bash scripting with SED and AWK. 1998 VBScript and Windows Scripting Host 2000 CScript, and Perl 2005 AutoIt 2008 came across PowerShell In January 2009, volunteered to learn enough about PowerShell to do a presentation for the Microsoft Professionals group, And then promptly found an Atlanta PowerShell MVP – Hal Rottenburg ( blog | twitter ) to do it – in January 2010. Mark Mitchell has been active in the Microsoft developer community in Atlanta attending meetings of Microsoft Atlanta Professionals, Atlanta MDF(SQL Server), Atlanta SharePoint User Group, Atlanta .Net User group, and Atlanta PowerShell User Group. He has attended the SQL Saturday, SharePoint Saturday, CodeStock, Devlink, Atlanta Code Camp, and ReMixAtlanta conferences. Mark has built 5 of his own desktop computers over the last 10 years, and one of those computers that has never been connected to the internet – dedicated entirely to music composition and recording, with terabytes of sound libraries. Mark plays Keyboards,Guitar,Bass,flute,violin, and has sung in choirs. He is also a semi-professional photographer. Live Meeting: http://www.livemeeting.com/cc/UserGroups/join?id=JGK9RJ&role=attend&pw=gh%3D*258FbRegistration: http://www.powershellgroup.org/atlanta.ga
We’ve worked with the organizers of SQL Saturday #49 to be able to bring you a full day line up of PowerShell but it get’s even better. In addition to myself and the usual Florida crew of PowerShell-for-SQL speakers, as luck would have it Microsoft Scripting Guy Ed Wilson and the Scripting Wife just happened to be on vacation in Orlando that very weekend! I’ll be doing my intermediate session on PowerShell to give those scripts one last run through before choosing what to show off at the Summit. If you’ve seen my beginner session in Tampa, Jacksonville, or Miami this one picks up and builds on that one. Not much has changed for the intermediate session since Columbia but it is a long car ride down there and I’m not driving so we’ll see if I come up with something new. I hope to see you there. Here’s the lineup: Start Time PowerShell 09:00 AM Maximo Trinidad Working with SQL Server – SQLPS 10:15 AM Aaron Nelson The Dirty Dozen: PowerShell Scripts for Busy DBAs 11:30 AM Aaron Nelson PowerShell 2.0 Beyond the Dirty Dozen 01:15 PM Ron Dameron Why a DBA Should Learn PowerShell (MINI) 01:30 PM Ronald Dameron Automate Login Administration & Compliance Reports 02:45 PM Ed Wilson Windows PowerShell Best Practices for SQL DBA’s 04:00 PM Chad Miller ETL with PowerShell
We are very excited to announce the new PowerShell Virtual Chapter of PASS! What is a Virtual Chapter? PASS Virtual Chapters are forums where SQL Server Professionals from around the world can communicate with others who have similar interests and face similar challenges. Think of it this way, PASS Chapters unite the SQL Server Community from a geographical perspective, Virtual Chapters unite the community based on common interests in a specific discipline. What will the new PowerShell Virtual Chapter do? Our primary mission is holding Live Meetings every month featuring free training from around the world. We plan to archive the presentations for you to watch on demand and highlight articles and blogs that will interest our members. This Virtual Chapter is headed up by top professionals from around the US: Ben Miller ( blog | twitter ), Chad Miller [no relation that I’m aware of] ( blog | twitter ), Lars Rasmussen ( blog | twitter ), Peter Schott ( blog | twitter ), and Aaron Nelson ( blog | twitter ). We will start things off next Wednesday with our first presentation. Here is the schedule through the end of the year. We are currently looking for speakers for next year. Wednesday October 20th 12 pm EDT (GMT-4) – Presenter Chad Miller Wednesday November 17th 1 pm EST (GMT -5) – Presenter Aaron Nelson Wednesday December 15th 1 pm EST (GMT -5) – Presenter Peter Schott Chad Miller will get us started with an introduction to PowerShell as a command line for one-off tasks or automation in the DBA world. Basic PS principles and syntax will be covered. Get your proverbial DBA feet wet with a tool that can make your database and sysadmin life better than it was before! Bigger, stronger, faster. (Cue Bionic Man theme) Chad Miller Chad hails from the land of rocket launches, oranges, and alligators where he started the Tampa PowerShell User Group. Chad is the DBA for SQL Server and Manager of Database Administration for a shop supporting SQL Server, Oracle, and Informix, acts as coordinator for the SQL Server PowerShell Extensions CodePlex project, and maintains an active blog at http://sev17.com/author/chad-miller/ . How do I attend? Registration for the event is now open. *When you register you’ll get a calendar reminder for the event.
Ensure Business Continuity with SQL Server, Windows Server 2008 R2 and Hyper-V Live Migration Maps Integration into Reporting Services Use PowerShell to Get the Most out of SQL Server Women in Technology discussion at SQL Saturday #49 _____________________________________________________________ Ensure Business Continuity with SQL Server, Windows Server 2008 R2 and Hyper-V Live Migration October 12th 12:00 PM EDT (GMT -4) Presenter: Ross Mistry See ways to reduce deployment time and adapt to changes in hardware utilization or capacity requirements quickly, with minimal downtime, using SQL Server and Windows Server 2008 R2 Hyper-V Live Migration. The session will also focus on SQL Server Virtualization alternatives, high availability strategies within a virtualized environment and a real life demonstration of moving a SQL Server Virtual Machine from one physical host to another with Live Migration. Finally, the session will also include case studies based on designs at the Microsoft Technology Center. Ross Mistry Ross Mistry is an Enterprise Architect at Microsoft, bestselling author and a former SQL Server MVP. Ross focuses on designing and implementing SQL Server solutions for Microsoft’s largest customers at the Microsoft Technology Center in Silicon Valley. Ross is a frequent speaker at SQL Server community events such as SQL PASS, SQL Europe PASS, Connections and SQL Bits. His recent books include; Introducing SQL Server 2008 R2 (MSPress), Windows Server 2008 R2 Unleashed (SAMS) and SQL Server 2008 Management and Administration (SAMS). You can follow him on twitter @RossMistry. How do I view the presentation? Attendee URL: Live Meeting link _____________________________________________________________ Maps Integration into Reporting Services October 12th 12:00 PM EDT (GMT -4) Presenter: Matt Smith The purpose of this presentation is to display the functionality of Bing maps integration into SSRS on SQL 2008 R2. Topics include how to use geospatial data, create map layers, and drill through actions to enhance usability of reporting. Matt Smith A Technology professional with over 5 years experience in various areas of software from database development and architecture to application development . Primary focus is on Business Intelligence. Industries include automotive, finance, healthcare, hospitality, education and real estate. Matt takes pride in thinking outside the box, building customer relationships, and his liaison abilities between the technical and business worlds. Personal interests include anything sports or outdoor related, photography, salt water aquariums, and family. How do I view the presentation? Attendee URL: Live Meeting Link _____________________________________________________________ Use PowerShell to Get the Most out of SQL Server October 13th 12:00 PM MDT (GMT -6) Presenter: Allen White PowerShell is the new scripting environment from Microsoft for managing server environments. Because PowerShell supports the .Net Framework, accessing SQL Server in a scripting environment is easier than ever before. Whether you need to access data or manage SQL Server, PowerShell makes it possible. This session will give an introduction to PowerShell, explain the basic ADO.Net objects required to connect with SQL Server, and demonstrate accessing SQL Server from PowerShell scripts, both from a data and a management perspective. Allen White Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He’s spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last four years. He’s active in the Ohio North SQL Server User’s Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at sqlbolg.com How do I view the presentation? Attendee URL: Live Meeting Link _____________________________________________________________ Women in Technology discussion at SQL Saturday #49 October 16th 4:00 PM EDT (GMT -4) Presenter: Kathi Kellenberger This is a general round table discussion about women in technology. This presentation is open to men as well. Kathi Kellenberger Kathi, former SQL Server MVP, is a Data Technology Specialist with Microsoft in St. Louis. She is author of “Beginning T-SQL 2008″ (Apress) and co-author of “Professional SQL Server 2005 Integration Services” (Wrox) and “SQL Server MVP Deep Dives” (Manning) as well as over two dozen technical articles. Before joining Microsoft, Kathi was a DBA for Bryan Cave LLP, an international law firm. She has involved with the PASS community for several years, winning the PASSion award in 2008. How do I view the presentation? Sign up to attend SQL Saturday #49
We’re excited to announce that SQL Server MVP Denny Cherry ( blog | twitter ) will be speaking at our next Atlanta MDF meeting! Topic: Database Virtualization We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. About Denny: Denny Cherry has over a decade of experience managing SQL Server, including MySpace.com’s over 175 million user installation, one of the largest in the world. Denny’s areas of technical expertise include system architecture, performance tuning, replication and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server as well as being a Microsoft MVP. Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management. When: Monday 10/11/2010 6:30 PM Where: 1125 Sanctuary Pkwy., Suite 300, Alpharetta, GA 30004
Yesterday afternoon a conversation popped up on twitter about organizers and speakers already trying to figure out dates for SQL Saturdays in 2011. I’ve been thinking this needs to be worked on proactively for some time now so I jumped right into the conversation. Now I don’t know but a handful of dates for 2011 that a few organizers have mentioned to me but luckily having parsed so much other SQL Saturday data, coming up with a list of when cities have held SQL Saturdays in the past was a piece of cake. 20 minutes total including this post. Hopefully this info will help a few organizers pick dates for 2011. As Promised [yesterday on twitter] here is a “calendar” of all the historical SQL Saturdays and the Saturday that they would fall on if they were held in 2011. To calculate the Saturday I just grabbed the week number from the previous and then just added years from there with some date functions in SQL Server. The number beside the city is the # of times a SQL Saturday has been held on that weekend in that city, not total # of SQL Saturdays period. The cities with zeros are like that because they haven’t held a SQL Saturday on that weekend yet but are scheduled to hold one on that date. Hope that all makes sense (it made sense in my head). Week # Saturday Historical Cities 1 1/1/2011 2 1/8/2011 3 1/15/2011 4 1/22/2011 0 Louisville 2 Tampa 5 1/29/2011 1 Boston 0 Houston 6 2/5/2011 0 Cleveland 7 2/12/2011 1 Tampa 8 2/19/2011 0 Phoenix 9 2/26/2011 10 3/5/2011 1 Charlotte 11 3/12/2011 1 Philadelphia 12 3/19/2011 13 3/26/2011 1 Birmingham 14 4/2/2011 15 4/9/2011 1 Richmond 16 4/16/2011 1 Chicago 17 4/23/2011 2 Atlanta 1 New York City 1 Huntington Beach 18 4/30/2011 2 Jacksonville 1 Wheeling 19 5/7/2011 1 Jacksonville 20 5/14/2011 21 5/21/2011 1 Portland 1 Dallas 22 5/28/2011 1 Birmingham 23 6/4/2011 2 Pensacola 1 Portland 24 6/11/2011 1 Redmond 25 6/18/2011 26 6/25/2011 1 Columbus 27 7/2/2011 28 7/9/2011 29 7/16/2011 30 7/23/2011 31 7/30/2011 1 South Florida 1 Baton Rouge 32 8/6/2011 1 South Florida 33 8/13/2011 1 Baton Rouge 34 8/20/2011 1 Nashville 35 8/27/2011 36 9/3/2011 37 9/10/2011 38 9/17/2011 1 San Diego 1 East Iowa 1 Raleigh 39 9/24/2011 1 Colorado 40 10/1/2011 1 Columbia 1 Kansas City 1 Redmond 41 10/8/2011 1 Gainesville (Atlanta) 1 Greenville 42 10/15/2011 2 Orlando 1 East Iowa 43 10/22/2011 0 Dallas 0 Salt Lake City 1 Louisville 1 Orlando 44 10/29/2011 0 Minnesota 45 11/5/2011 1 Orlando 46 11/12/2011 47 11/19/2011 0 New York City 48 11/26/2011 49 12/3/2011 0 DC 50 12/10/2011 51 12/17/2011 52 12/24/2011 53 12/31/2011