Tag SIG

Get Your Learn on in June!

There is, once again, a lot of great content coming out of PASS this month. The best part is: it’s free!. Check out what’s coming up:

Introduction to SSIS
with Ryan Fonnett
Tuesday June 9th 12:00pm EST
SSIS is a high performance Microsoft ETL tool that is part of the Business Intelligence Design Studio. It is primarily used to pull data from one or more data sources into an in memory dataset that is massaged and then loaded into one or more data destinations. The presentation will include an introduction to SSIS and a couple of demos that will help you with designing and building your first SSIS package!
For dial in information, click here
To add this meeting to your calendar, click here

SQL Server 2008 for Developers
with Mladen Prajdic
Tuesday June 16th 1:00pm EST
What should developers know about database design so they don’t have performance and logical problems? What’s new in SQL Server 2008 that helps solve some business problems that sometime required “hacking” before. Concurrency design models and isolation levels.
For dial in information, click here
To add this meeting to your calendar, click here

Women In Technology Monthy Meetup
Wednesday, June 24th 4:00pm EST
You are cordially invited to join the Monthly Meetup of the Women In Technology chapter! Currently we are discussing content and functionality of our website and planning the annual WIT Luncheon at PASS.
Please email Denise McInerney (Denise.McInerney@sqlpass.org) if you need a local number for a country other than US or Australia.
For dial in information, click here
To add this meeting to your calendar, click here

Highly Available SQL Server Upgrade Assault Tactics
with Jason Massie
Tuesday, June 23rd 12:00pm EST
In this debriefing, we will look at various methods to minimize downtime during major version upgrades. This will include upgrading from SQL Server 2000 to SQL Server 2005 and SQL 2008 as well as SQL Server 2005 to SQL Server 2008. We will cover key planning and testing skills that can cut substantial time off the upgrade and minimize problems after the upgrade. We will also cover the technologies that you can add to your arsenal when planning an HA upgrade assault. All hands on deck as we do battle against upgrade downtime.
For dial in information, click here
To add this meeting to your calendar, click here

Create Smarter and More Useful Cubes
Speaker: Sunil Kadimdiwan
June 23rd 12:00pm EST
There are several enhancements in Analysis Services 2008. In this session I will demonstrate how you to take advantage of the enhanced Dimension and Aggregate Designers. How can we establish relationship between attributes? What are the best practices to follow so that you can avoid common mistakes? By following these steps we will create smarter and more useful Cubes.
For Dial in information, click here
To add this meeting to your calendar, click here

Datawarehouse Partitioning
Presenter: Brian Knight
Tues: June 30th, 2009 12:00PM EST
Partitioned tables are tables whose data is horizontally divided into units which
may be spread across more than one file group in a database. Partitioning makes
large tables or indexes more manageable by letting you access or manage subsets of data quickly and efficiently, while maintaining the integrity of the overall collection. Within the data warehouse, fact tables are often good candidates for partitioning.This presentation will introduce table partitioning and
demonstrate strategies and methodologies for managing large fact tables using the partitioning capabilities of SQL Server 2005 and 2008.
For dial in information, click here
To add this meeting to your calendar, click here

Meet the New App Dev SIG Marketing Coordinator

It’s time to meet the new PASS App Dev SIG Marketing Coordinator: me!

What exactly will I be doing? Well, according to Blythe I will be doing the following:

  • Work directly with Blythe at PASS HQ to determine marketing strategy of the Application Development SIG
  • Come up with creative ways to get meeting information and new content out to the community
  • Work with other SIG groups to share marketing resources
  • Form press gangs Recruit volunteers
  • Help drive overall direction of the App Dev SIG
  • Bring Blythe delicious pastries from around the globe

What this REALLY means is that I’ll be working with PASS and with you, the community, to find new ways to raise awareness of the Application Development SIG, attract quality speakers, recruit you into service via some type of “draft” system, and find out what us App Dev SIG folks can do to help you.

Join a SIG, save an out of work actor.

Join a SIG, save an out of work actor.

Are you going to see me standing around on street corners waving App Dev SIG signs? It’s possible, especially if I need to bring back pastries from exotic locations like Schenectady, NY or Hartford, CT. However, more importantly, it means what I’ve said previously: I’m going to listen to the community, take that into account, and then accept bribes.

Wait, that’s not right.

I’ll be working with Blythe and Todd to get the word out about the App Dev SIG, drive content creation, and market the bejesus out of this thing. Your bribes of bacon will not work on me, largely because I don’t eat meat.

Dynamic T-SQL Resources

As a follow up to my Dynamic T-SQL presentation, a list of Dynamic T-SQL resources have been posted on the AppDev SIG page of PASS site. Hit up the link for more info.

When I first started writing dynamic SQL, I had a hard time finding any resources on the topic. If you have any that you’d like to share, hit me up in the comments or shoot me an email at jeremiah.peschka@gmail.com and I’ll be sure to review it and put the link up.

Presenting on March 31

On March 31st at 1PM EST, that’s 10AM to those of you on the West Coast, I will be giving my presentation Dynamic SQL: What’s all the fuss about, anyway? via Live Meeting, courtesy of the Application Development SIG. The presentation will last for approximately 1 hour. Here’s a bit more info to get you all kinds of excited about it:

Dynamic SQL is a powerful but difficult tool to master. Jeremiah will show you techniques for creating rock solid, fast, dynamic SQL that will meet the day to day needs of your production system.

Live Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=JP2R3Q&role=attend
Audio Dial-In Information:
Toll free: +1 (866) 379-8990
Participant code: 6489756

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 219 items have been purified.