SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

AppDev

Mid April Free Training from PASS VCs

Apr 11th, 2011
by Aaron Nelson.
Comments are off for this post

www.sqlpass.orgBuilding 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 31st , 2011 and June 3rd 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

www.sqlpass.orgSSIS 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

End of October Free Training from PASS Virtual Chapters

Oct 22nd, 2010
by Aaron Nelson.
Comments are off for this post

pass_logo

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

Early October Free Training from PASS VCs

Oct 10th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoEnsure 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

End of September Free Training from PASS VCs

Sep 27th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoNext-Level SQLCLR: Parallel Processing and Bulk Load
SSRS R2: The New Stuff
_____________________________________________________________

Next-Level SQLCLR: Parallel Processing and Bulk Load
September 28nd 12:00 PM EDT (GMT -4)
Presenter: Adam Machanic

The power of SQLCLR as a performance tool has been well-documented at this point; certain queries, when re-written the right way using SQLCLR components, can run an order of magnitude more quickly. If you’re already using SQLCLR, or need that extra push, attend this session to discover how to take things one step further using advanced techniques and a custom SQLCLR component that will help you leverage the power of parallelism to burn through your rows more quickly than you ever thought possible. This session includes some of the material that will be covered in Adam Machanic’s full-day PASS Summit post-conference seminar, “A Day of Doing Many Things at Once: Multitasking, Parallelism, and Process Distribution.” More information on the seminar is available here: http://sqlpass.eventpoint.com/topic/details/AD311P

Adam Machanic

Adam is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including “SQL Server 2008 Internals” (Microsoft Press, 2009) and “Expert SQL Server 2005 Development” (Apress, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.

How do I attend?
Attendee URL: LiveMeeting Link
_____________________________________________________________

SSRS R2: The New Stuff
September 29th 12:00 PM EDT (GMT -4)
Presenter: Mike Davis

In this session Mike shows you the new features in Reporting Services 2008 R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls.

Mike Davis

Mike is a MCTS, MCITP, Senior BI consultant, and Trainer at Pragmatic Works.  He is an author of two Business intelligence books.  Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

URL: https://www.livemeeting.com/cc/usergroups/join?id=H2JWQQ&role=attend&pw=tS3%24Gtj%60z

Mid September Free Training from PASS VCs

Sep 9th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoThere’s going to be over 30 hours of free online SQL Server training next week and you’re not going to want to miss out!
Indexes and Other Free Performance Boosts
Building your 1st Performance Point Dashboard in SharePoint 2010
24 Hours of PASS: Summit Preview
_____________________________________________________________

Indexes and Other Free Performance Boosts
September 14th 12:00 PM EDT (GMT -4)
Presenter: Jeremiah Peschka

The database is often viewed as a major performance bottleneck. There are a number of quick, easy, painless techniques that can increase the performance of an application not just by a small amount, but by orders of magnitude. These techniques include simple indexing techniques, T-SQL techniques, and general database application design patterns that give great gains in performance. In this session, you will learn how to look at a database to identify these problem areas and how to resolve common issues that you will encounter.

Jeremiah Peschka

Jeremiah (blog|twitter) is a Database Expert with Quest Software. He is a SQL Server MVP, user group leader, and PASS Director at Large. Jeremiah has a passion for spreading knowledge and writing about himself in the third person. When not using a computer, Jeremiah can be found playing guitar, reading, writing, wandering around central Ohio, or speaking at various SQL Server events.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=DJ8WK2&role=attend
_____________________________________________________________

Building your 1st Performance Point Dashboard in SharePoint 2010
September 14th 12:00 PM EDT (GMT -4)
Presenter: Adam Jorgensen

Many of you have seen the coolness that is PerformancePoint in SharePoint 2010. Come get hands on with Adam as we go through the ins and outs of creating your first dashboard.  See some of the cool visualizations you can use and how they work together to create a cool user experience.

Adam Jorgensen

Adam, MBA, MCDBA, MCITP: BI has over a decade of experience leading organizations around the world in developing and implementing enterprise solutions. His passion is finding new and innovative avenues for clients and the community to embrace business intelligence and lower barriers to implementation. Adam is also very involved in the community as a featured author on SQLServerCentral, SQLShare, as well as a regular contributor to the SQLPASS Virtual User Groups for Business Intelligence and other organizations. He regularly speaks at industry group events, major conferences, Code Camps, and SQLSaturday events on strategic and technical topics.

Live Meeting Link: https://www.livemeeting.com/cc/usergroups/join?id=K5S9BK&role=attend&pw=B%3B4%2F%7D38%3Br
_____________________________________________________________

One more quick note.  There’s this little online event going on the following day called the 24 Hours of PASS and this time it’s been rearranged to be timed better for the massive amount of Data Professionals in the Eastern half of the US [and Canada, Puerto Rico, The Bahamas, Bermuda, Virgin Islands, Netherland Antilles, & Brazil, etc… yeah them places too]

24 Hours of PASS: Summit Preview

Join an exceptional lineup of SQL Server and BI experts from around the world as they present a sneak peek of PASS Summit 2010 in 24 free live webcasts September 15-16.

This installment of 24 Hours of PASS delivers the hottest SQL Server and BI content directly to your computer – with a twist. Instead of running continuously for 24 hours, the September event divides the webcasts across 2 days, with each day beginning at 12:00 GMT (UTC). Check out what time it starts in your neck of the woods.

Dig into data warehousing, MDX, KPIs, and DTS-to-SSIS migration. Learn best practices for sizing database hardware and performance tuning. Get an in-depth look at PowerShell, storage for the DBA, and the latest T-SQL enhancements. And see how to manage teams, make your presentations rock, prepare for your next job, and more.

Tune in to hear your favorite MVPs and PASS Summit speakers, including Kalen Delaney, Andy Leonard, Kevin Kline, Brad McGehee, Allen White, and many more.

Register today for your top picks – or plan to attend them all!

Think the 24 Hours of PASS lineup is impressive? You won’t want to miss PASS Summit 2010 in Seattle, WA, Nov 8-11. The 24 Hours of PASS program gives you a glimpse at the unmatched technical content PASS Summit has to offer across more than 160 technical sessions, 14 pre/post-conference seminars, and invaluable networking opportunities.

Late August 2010 PASS VC Presentations

Aug 24th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logoWriting a better Where Clause
SQL Storage for Performance: Best Practices
_____________________________________________________________

Writing a better Where Clause
August 24th 8:00 AM EDT (GMT -4)
Presenter: Scott Gleason

This session will cover the basics of writing optimized query’s with focus on the ‘where clause’ and ‘having clause’ of a select statement. If you have never attended a query performance session before, you’ll learn a lot!

Scott Gleason
Scott has worked in Jacksonville Florida exclusively as DBA for over nine years. He is currently the Vice President of the Jacksonville SQL Server Users Group (JSSUG) and actively speaks about SQL at SQL Saturdays and Code Camps.

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

SQL Storage for Performance: Best Practices
August 25th 12:00 AM EDT (GMT -4)
Presenter: Amy Styers

SQL Storage Planning for Best Performance What are the different storage optimizations available for SQL server? What are some techniques that can be used to determine performance bottlenecks? Amy will discuss tips and tricks from the field on how to answer these questions for planning and designing your SQL infrastructure from disk up!

Amy Styers
Amy is a Microsoft Infrastructure Architect in the EMC Commercial Solutions Advisory Group where she has been engaged for the last three years discussing with customers their options for highly available, highly scalable, high performing Microsoft applications. She regularly addresses customers with regards to their virtualization initiatives and helps customers make decisions regarding architecting their Microsoft infrastructures both in physical and virtual environments.

Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=S2G482&role=attend

Early July 2010 PASS VC Presentations

Jul 8th, 2010
by Aaron Nelson.
Comments are off for this post

pass_logo

Loops, Lookups and Splits: SSIS Beyond the Basics
Managing Teams
Why Should I use Stored Procedures?
_____________________________________________________________

Loops, Lookups and Splits: SSIS Beyond the Basics
July 13th 9:00 PM EDT (GMT -4)
Presenter: Tim Mitchell

twitterProfilePhoto

In this session, we’ll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the SSIS looping containers, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008.

Tim Mitchell

Tim Mitchell is a Microsoft SQL Server consultant, developer, and speaker. He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, and reporting. He has earned numerous certifications and holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP. Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. See his full profile and blog at www.timmitchell.net.

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

_____________________________________________________________

Managing Teams
July 13th 1:00 PM EDT (GMT -4) / 10:00 AM PDT (GMT -7)
Presenter: Andy Leonard

AndyLeonard

Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams.

Andy Leonard
Andy is an Architect with Molina Medicaid Solutions, SQL Server database and Integration Services developer, SQL Server MVP, PASS Regional Mentor, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. Andy blogs for SQLBlog.com. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.

Click here to join the Live Meeting.

_____________________________________________________________

Why Should I use Stored Procedures?
July 14th 12:00 PM MDT (GMT -6)
Presenter: Jack Corbett

JackCorbett

With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored procedures for Data Access, I personally disagree. This will be a professional and polite open discussion starting with why I believe stored procedures are the best way to access data in SQL Server. Alternate view points welcome.

Jack Corbett
Professional who has worked with SQL Server for 10 yrs (6.5-2008) and experience in .NET development as well. Author of several articles for SQLServerCentral and video author for SQLShare.com. Speaker at several SQLSaturday’s and Florida User Groups. Co-President of OPASS. Lover of all things SQL except Analysis Services and MDX.

Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=7FKD56&role=attend

_____________________________________________________________

← Earlier Posts