Free Training

Speaking at SQL Saturday #108 in Redmond

Comments are off for this post

If someone had told me two years ago that this Saturday I’d be speaking for the second time this year [let alone in my entire life] on the Microsoft campus in Redmond I’d have suggested they seek professional (ahem, psychiatric) help.

A surprise to us all, I survived the community vote and will be speaking at SQL Saturday #108 in Redmond, WA this weekend. I’m very excited that A) at least *some* people aren’t tired of hearing me speak [yet] and B) I get to speak on the Microsoft campus!!!!! Smile

The folks at Idera are sending Wes Brown ( blog | twitter ) and myself out to this event as part of their ACE program. If you’ve never been to one of Wes’ sessions, you need to go. I offer a money back guarantee that you will laugh at least once during his session. The reason I bring all this up is that they are now recruiting a fresh crop of ACEs for 2012. If you’d be interested in finding out more about the ACE program, drop David Fargo ( twitter | email ) a line by this Friday and tell him that you’d like to hear more.

Start Time	Capitol Hill – Room: Room 2003	Montlake – Room: Room 2007	Pioneer Square – Room: Room 2011	Queen Anne – Room: Room 2015
07:45 AM	Registration Registration Registration Level: Beginner	Registration Registration Registration Level: Beginner	Registration Registration Registration Level: Beginner	Registration Registration Registration Level: Beginner
08:45 AM	Buck Woody KeyNote Level: Beginner	Buck Woody KeyNote Level: Beginner	Buck Woody KeyNote Level: Beginner	Buck Woody KeyNote Level: Beginner
09:45 AM	Steve Stedman Unleashing Common Table Expressions in SQL Server* Level: Intermediate	Paul Turley Dashboard Design: Making Reports Pop Level: Intermediate	Brad McGehee Inside the SQL Server Transaction Log Level: Intermediate	John Huang Parallel Task Scheduling with T-SQL Level: Advanced
11:00 AM	Mark Simms The Elephant in the Room (Hadoop for DBAs) Level: Intermediate	Wil Sisney 5 SSIS Tricks to Take You from Beginner to Awesome Level: Beginner	Mark Tabladillo Enterprise Data Mining with SQL Server Level: Intermediate	Hugo Kornelis Advanced indexing Level: Advanced
12:00 PM	lunch Session Presentations by Red-Gate and Quest. Level: Beginner	lunch Session Presentations by Red-Gate and Quest. Level: Beginner	lunch Session Presentations by Red-Gate and Quest. Level: Beginner	lunch Session Presentations by Red-Gate and Quest. Level: Beginner
02:00 PM	Piotr Palka Database lifecycle with Visual Studio 2010 and TFS Level: Beginner	Donabel Santos SQL Server Reporting Services – Beyond the Basics Level: Intermediate	Merrill Aldrich PowerShell 101* Level: Beginner	Argenis Fernandez Troubleshooting SQL Server with SysInternals Tools Level: Advanced
03:15 PM	Dev Nambi Database Development: Keep It Agile, Not Fragile* Level: Intermediate	Douglas Barrett Data Warehousing Update Level: Advanced	Aaron Nelson PowerShell for Data Professionals Level: Intermediate	Diane Robey Merge Replication for High Availability Level: Intermediate
04:30 PM	Rick Morelan Basic Performance Tips and Gotchas* Level: Beginner	David Eichner SRS Report Builder for Business Intelligence Level: Beginner	Kevin Kline Top 10 Admin Mistakes on SQL Server Level: Intermediate	Wesley Brown Fundamentals of SAN, NAS and IP Storage Level: Intermediate
05:30 PM	Prize Drawings Prize Drawings, thank yous. Level: Beginner	Prize Drawings Prize Drawings, thank yous. Level: Beginner	Prize Drawings Prize Drawings, thank yous. Level: Beginner	Prize Drawings Prize Drawings, thank yous. Level: Beginner

Late April Free Training from PASS VCs

Apr 15th, 2011

by Aaron Nelson.

Comments are off for this post

PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP
_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT -4)
Marco Shaw

Marco provides an overview of using sysprep for Windows Server 2008R2, and SQL Server 2008R2, which also now supports this feature. This is especially useful when wanting to get up a new (lab or even production environment) quickly. He will be doing this using only Microsoft Hyper-V & Windows PowerShell without any other external tools.

Marco Shaw
Marco ( blog | twitter ) is a consultant with CGI and has over 12 years of IT experience. He has been awarded a Microsoft MVP award for the last 4 years in the Windows PowerShell category.

LiveMeeting: Registration Link
_____________________________________________________________
Designing Cubes for Performance
April 20, 2011, 12 PM EDT (GMT -4)
Stacia Misner

Building a cube is simple. After all, you have a lot of wizards at your disposal to do the development work. But building a cube that delivers data quickly requires you to make additional changes to the database design. In this session, you’ll learn what steps you need to take in the development process to ensure the cube is designed for optimal performance, whether you’re using Analysis Services 2005 or Analysis Services 2008. You learn not only how to properly design dimensions, aggregates, and partitions, but why these design principles improve performance.

Bio:
Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions since 1999. With more than 25 years of experience in IT, she is the author or co-author of ten books about BI. Her most recent books include Business Intelligence in Microsoft SharePoint 2010 and Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 and Office 2010. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.

LiveMeeting: Link
_____________________________________________________________
Database Standards SOP
April 21, 2011, 1 PM EDT (GMT -4)
Thomas LeBlanc

Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. This discussion comes from 21+ years of developing databases for application developers. The use of identity columns for primary keys, and the need for a unique constraint on transaction tables that do resort to ID columns will be covered.

Thomas LeBlanc
Thomas is a semi-retired Senior DBA turned ETL Lead Architect @ Amedisys in Baton Rouge, LA. Worked in the IT field for 21 years experience w/ COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing and developing Normalized & Dimensional database has become his passion. Full-time DBA work started about 9 years ago. he has been blessed with speaking at SQLRally this year. Free time is spent helping other & improving his relationship with family & God.

LiveMeeting: Link

Mid April Free Training from PASS VCs

Apr 11th, 2011

by Aaron Nelson.

Comments are off for this post

Building Applications That A DBA Will Love
All About Analysis Services
_____________________________________________________________

Building Applications That A DBA Will Love
April 12, 2011, 12 PM Eastern
Presenter: Andy Warren
Attendee URL: LiveMeeting

It’s natural for the focus to be on the end user when we build applications, but it’s important and worthwhile to build into our design some things that make it easier for the DBA to provision, tune, and support the product we deliver. So what does a DBA care about? Performance of course, but also security, scalability, space usage, and yes, even documentation. This presentation will cover tips in a number of areas that address the concerns of the DBA, and we’ll talk about why you should care about making the DBA happy too!

Andy Warren

Andy Warren is a SQL Server consultant and trainer who occasionally writes some code too. He’s on the PASS Board of Directors, was a founding partner in SQLServerCentral.com, started the SQLSaturday event format, and is currently a SQL Server MVP. Andy blogs at www.sqlandy.com, and can be reached via Twitter as @sqlandy and on LinkedIn at www.linkedin.com/in/sqlandy.

How do I attend?
Attendee URL: LiveMeeting
_____________________________________________________________

Efficient and effective processing of OLAP CUBES with AMO and XMLA
Fri April 15th 12PM EST (US)
Speaker: Steve Simon

Topic Description:

Within the financial industry, rapid and effective decision making is critical to our client relationships. Analytical tools such as OLAP cubes help make this a reality. In many 24 X 7 enterprises, data capture and cube updates occur on an ongoing basis throughout the business day. We are able to achieve this through the innovative utilization of SQL Server Integration Services (SSIS). This intermediate level hands-on presentation will show the attendee how we have utilized Analysis Management Objects (AMO) commands and SSIS to ‘fire’ our OLAP CUBE updating processes. The presentation will discuss the high level concepts behind Analysis Management Objects (and the XMLA that is generated from the commands) and the scenarios under which we can benefit from their usage. Topics covered will be the updating of dimensions, measures, partitions, the cube and more.

Bio:

Steve Simon is an Assistant Vice President with State Street Corporation in Boston. He has been involved with database design and analysis for over 26 years. Steve has presented papers at eight North American PASS Summits (in Orlando, Seattle WA (4), Denver CO (2) and San Francisco CA), two at PASS Europe 2009 and one at PASS Europe 2010. He has just recently presented his PASS 2008 Summit presentation in Johannesburg South Africa. Steve is actively involved with the SQL Server community within the Boston area and is a regular presenter at the New England Code Camps and SQL Saturday events and participates actively on many of the Microsoft User Forums. He is also the Virtual Chapter leader of the Professional Association for SQL Server (PASS) Oracle – SQL Server Virtual Chapter and is a PASS regional mentor. He will also be presenting a data mining paper at SQL Teach in Montreal between May 31^st , 2011 and June 3^rd 2011.

URL: https://www.livemeeting.com/cc/usergroups/join?id=RPN4J9&role=attend&pw=J%25%7E*7r%229d

PASS AppDev VC Presents: SSIS Tips & Tricks

Dec 27th, 2010

by Aaron Nelson.

Comments are off for this post

SSIS Tips & Tricks
12/28/2010 12 Noon Eastern Time (GMT-5)
Josef Richberg

Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of “parallel path choicing”. Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination (to get around the identity column conundrum). See how to use Script Tasks to build directory scanners for efficient file import techniques. We’ll also go over some the tunable properties of the Data Flow object.

Josef Richberg
Josef is a DBA for HarperCollins Publishers working with SQL Server and SSIS. He has over 17 years’ experience designing, building, and tuning SQL Server. Josef was the recipient of the ’2009 Exceptional DBA’ award and actively blogs at http://josef-richberg.squarespace.com.

How do I view the presentation?
Attendee URL: Live Meeting link

Atlanta PowerShell User Group – November Meeting

Nov 15th, 2010

by Aaron Nelson.

Comments are off for this post

Atlanta & Virtual PowerShell User Group - November Meeting This month is a special meeting as the Atlanta PowerShell User Group and the Virtual PowerShell User Group are joining forces to bring you Ed Wilson, the Scripting Guy. He will be joining us to give his presentation on PowerShell Best Practices.

Please register so we know how much pizza to order. Orrrrr, don’t complain when we run out of pizza again.

When:
Tuesday, November 16, 2010 from 6:00 PM – 8:30 PM (ET)

Agenda:
6:00pm: Networking, free pizza and soft drinks, and open discussions.
6:30pm: User Group News and Information – Mark Schill
6:45pm: PowerShell Best Practices – Ed Wilson

Where:
New Horizons Atlanta
211 Perimeter Center Parkway
Suite 200
Atlanta, GA 30346

Speaker Bio:

Ed Wilson is one of the Microsoft Scripting Guys and a well-known scripting expert. He is a Microsoft-certified trainer who has delivered a popular Windows PowerShell workshop to Microsoft Premier Customers worldwide. He has written 8 books including 5 on Windows scripting, including: Windows PowerShell Scripting Guide, and Microsoft Windows PowerShell Step by Step both published by Microsoft Press.

He has also contributed to nearly a dozen other books, and is currently working on a PowerShell Best Practices book. Ed holds more than 20 industry certifications, including Microsoft Certified Systems Engineer (MCSE) and Certified Information Systems Security Professional (CISSP). Prior to coming to work for Microsoft he was a senior consultant for a Microsoft Gold Certified Partner where he specialized in Active Directory design and Exchange implementation.

In his spare time he enjoys woodworking, underwater photography, and scuba diving.

Live Meeting URL for remote participants: https://www.livemeeting.com/cc/UserGroups/join?id=8RFF4R&role=attend&pw=dDs%405B%21-X

Atlanta PowerShell User Group: To receive the latest news and updates from the user group, sign up for the ATLPUG Mailing List at http://powershellgroup.org/content/atlanta-powershell-user-group-mailing-list.

End of October Free Training from PASS Virtual Chapters

Oct 22nd, 2010

by Aaron Nelson.

Comments are off for this post

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

Mid October Free Training from PASS Virtual Chapters

Oct 19th, 2010

by Aaron Nelson.

Comments are off for this post

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

Announcing the New PowerShell Virtual Chapter of PASS!

Oct 13th, 2010

by Aaron Nelson.

4 comments

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. Smile 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)

How do I attend? Registration for the event is now open.
*When you register you’ll get a calendar reminder for the event.

Free Training

Speaking at SQL Saturday #108 in Redmond

Late April Free Training from PASS VCs

Mid April Free Training from PASS VCs

PASS AppDev VC Presents: SSIS Tips & Tricks

Atlanta PowerShell User Group – November Meeting

End of October Free Training from PASS Virtual Chapters

Mid October Free Training from PASS Virtual Chapters

Announcing the New PowerShell Virtual Chapter of PASS!

Search

Categories

Archives

Search

Free Training

Search

Tags

Categories

Archives

Search