Showing posts with label SQLLunch. Show all posts
Showing posts with label SQLLunch. Show all posts

Tuesday, January 11, 2011

First SQL Lunch of the Year - SSRS Tips and Tricks with Pam Shaw

Last Year was a great year for the SQL Lunch.  We had so many great presentations.  I am really excited about this year and what we have coming up.  There are three lunches scheduled for this month and we are going to be making a BIG announcement about what we are doing in May on the SQL Lunch.  Stay tuned.
45-Tips & Tricks for dynamic Reporting Services Reports

Lunch Image

Speaker: Pam Shaw

Join Meeting:  https://www.livemeeting.com/cc/usergroups/join?id=PNZ5F4&role=attend

Add To Outlook: Add To Calendar

Date and Time: 1/13/2011 11:30:00 AM CST

Topic: #45-Tips & Tricks for dynamic Reporting Services Reports
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

BIO: Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.

Patrick LeBlanc, MCTS, SQL Server MVP

Founder www.SQLLunch.com

Monday, October 4, 2010

SQL Lunch One Year Anniversary

I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I was getting the site up and trying to find a couple of speakers to ensure that we had a good start. I was able to convince Tim Mitchell to speak and the rest is history. Thanks to everyone that has attended all of the lunch events and thanks to all of the speakers who gave their time to make the site a success.

During the first year I gained a co-host (Adam Jorgensen) and several new friends along the way. I also hired the first SQL Lunch employee, Patrick Jr. (my son). He and I are working hard on improving the site and the notifications. Thanks again to everyone and see you at the next SQL Lunch. As always, we are looking for speakers so email us at webmaster@sqllunch.com if you are interested in speaking.

Talk to you soon,

Patrick LeBlanc, SQL Server MVP, MCTS

Founder SQL Lunch

Sunday, July 18, 2010

Practice Your PASS Session on the SQL Lunch

We at the SQL Lunch would like to extend an invitation to all of the PASS speakers.  If you are looking for a place to practice your PASS session please email us at webmaster@sqllunch.com.  Don’t worry, you can have up to 90 minutes or you can break your session into small 30 minute sessions.  It’s completely up to you.  This is our way of saying thanks to all of you for giving your time and knowledge to all of us in the SQL Community.

Also, it is completely up to you if the sessions are recorded and if any materials are shared.  Thanks again.

Talk to you soon,

Patrick LeBlanc, SQL Server MVP, MCTS

Founder www.TSQLScripts.com and www.SQLLunch.com.

Visit www.BIDN.com, Bring Business Intelligence to your company.

Thursday, July 8, 2010

Free Data Warehouse Training – Let's Get Dimensional

Join Adam Jorgensen, tomorrow on the SQL Lunch to learn about Dimensional Modeling.  Go to SQL Lunch and add this event to your calendar or use the link in this posting.  To receive notifications about upcoming SQL Lunches please go here.  Every week this month we will be hosting a lunch time meeting. 

Title:  #27 - Let's Get Dimensional

Add to OutlookAdd to Calendar

Date:  7/22/2010

SpeakerAdam Jorgensen

Join Meetinghttps://www.livemeeting.com/cc/usergroups/join?id=Z9N87J&role=attend

Description: Learn the basics or dimensional modeling, the foundation for any good data warehouse, with Adam Jorgensen on SQLLunch. Adam will take us through why how dimensional modeling is different from your typical applications database, why it’s different, and some mistakes to avoid. We will review some existing models and take your questions on you modeling challenges. We’ll review common scenarios and discuss why they are the best approach.

BIO:  Adam Jorgensen , 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.

Talk to you soon,

Patrick LeBlanc, SQL Server MVP, MCTS

Founder www.TSQLScripts.com and www.SQLLunch.com.

Visit www.BIDN.com, Bring Business Intelligence to your company.

Tuesday, July 6, 2010

Free SSIS Training – SQL Lunch #24 (Looping in SSIS)

Join Brad Schacht this week on the SQL Lunch to learn about Looping in SSIS.  Go to SQL Lunch and add this event to your calendar or use the link in this posting.  To receive notifications about upcoming SQL Lunches please go here.  Every week this month we will be hosting a lunch time meeting. 

Title:  #24 Looping in SSIS

Add to OutlookAdd to Calendar

SpeakerBrad Schacht

Join Meeting:  https://www.livemeeting.com/cc/usergroups/join?id=SBMB3K&role=attend

Description:  In this session Brad will walk you through the loops available in SQL Server Integration Services. Topics to be covered include the ForLoop and the value it provides, as well as the most common uses for the ForEach Loop; such as looping over files. Setup and configuration will be discussed along with when a loop should be used. We will also discuss how to use these loops to dynamically name a file for archiving after it is done being used inside the package.

BIO:  Brad is a BI Consultant and Trainer for Pragmatic Works. His experience on the Microsoft BI platform includes DTS, SSIS, Reporting, and migrations and conversions. His background in creating custom solutions for clients and partners provides great experience for delivering real-world value through his courses. Brad uses this experience to make the topics real for those he’s working with and teaching. Brad also participates as a speaker at events such as SQL Saturday and is an active member of the Jacksonville SQL Server User’s..

Talk to you soon,

Patrick LeBlanc, SQL Server MVP, MCTS

Founder www.TSQLScripts.com and www.SQLLunch.com.

Visit www.BIDN.com, Bring Business Intelligence to your company.

Tuesday, June 1, 2010

SQL Lunch Call for Speakers – Quarter 3

One of my quarterly goals is to get speakers for the SQL Lunch webcasts.  Q1 and Q2 of 2010 are in the books, so its time to start working on Q3.  To all of you out there who want to share your knowledge with all of us, please send an email to webmaster@sqllunch.com if you are interested in speaking on the SQL Lunch.  Include a short bio, the topic that you want to discuss and a brief description of the topic.  Please attach a head shot so I can share your picture with the world.  Remember the SQL Lunch webcasts are 30 minutes or less.   It does not matter if you are  a seasoned speaker or a new speaker, we at the SQL Lunch welcome you with open arms. 

Talk to you soon,

Patrick LeBlanc, MCTS

Founder www.TSQLScripts.com and www.SQLLunch.com.

Visit www.BIDN.com, Bring Business Intelligence to your company.

twitter:  @sqllunch, @patrickdba

Wednesday, April 14, 2010

Editing Saved SSIS Packages

During my last SQLLunch, Introduction to SSIS, I was asked an interesting question by one of the attendees. He asked, how do you edit a package once it’s saved in the SQL Server package store? My response was to open your SSIS project and edit the package from Business Intelligence Development Studio (BIDS). His response was, I did not save the project. Huh, what? That’s what I thought. He tried to explain further, but I did not quite understand. He said I will be at the user group on Wednesday night, which I spoke at, and elaborate a little.

As promised he arrived on time at the user group meeting ready to explain his problem and expecting a solution. After we chatted for a little I realized the problem. He asked me to open SQL Server Management Studio (SSMS) and connect to my local SQL Server Integration Services (SSIS). Then he said expand the Stored Packages folder then the MSDB folder.

clip_image002

He then said, see there they go, but how do I edit them. Then I understood. When he completed a package it was saved to the SQL Server, and once he was done he closed the project without saving. As a result, the packages resided on the server, but he did not have the project that contained his packages. So he could not edit them.

I explain to edit them, open BIDs and create a new SSIS project. Then right-click on the SSIS packages folder in the Solution Explorer and select Add Existing Package and the following dialog box will appear.

clip_image004

Since his packages were saved on the SQL Server, I told him to accept the default, SQL Server, for the Package location. Then I told him to choose his server name, and finally click the ellipses button next to the textbox labeled Package path and the following dialog will appear:

clip_image006

Select the package you want to edit and it will be included in the project. Once complete double-click the new package in the solution explorer and you can begin editing the package.  I explained to him to always save his SSIS projects when complete so he could always open the project for editing to avoid the extra steps. 

So for all of you that don’t save your SSIS projects and you want to edit them after they have been deployed, follow these steps.

Talk to you soon

Patrick LeBlanc, MCTS

Founder www.TSQLScripts.com and www.SQLLunch.com.

Visit www.BIDN.com, Bring Business Intelligence to your company.

Wednesday, November 18, 2009

SQL Lunch Recordings Now Available

After several tries I think we finally have it working.  If you were unable to attend the last two SQLLunches, go to www.SQLLunch.com and go to the Archived November meetings.  They are both available for your viewing.  If you have any questions or comments about the SQL Lunch, please send an email to webmaster@sqllunch.com.

Talk to you soon

Patrick LeBlanc, founder TSQLScripts.com and SQLLunch.com

SQLDownSouth

Monday, November 16, 2009

Today’s SQL Lunch – Integrating Table Valued Parameters with Reporting Services 2008

Meeting URL: Join Meeting

Click the above Meeting URL around 11:30 AM CST on 11/16/2009 to join the meeting

Date: 11/16/2009

Time: 11:30 AM

Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=NHHGB9&role=attend

Presenter: Patrick LeBlanc, currently the Sr. Database Administrator for Lamar Advertising. I have worked as a SQL Server DBA for the past 9 years. My experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. I am the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Area SQL Server User Group.

Topic: Integrating Table-Valued Parameters with Reporting Services

Patrick LeBlanc, currently the Sr. Database Administrator for Lamar Advertising. I have worked as a SQL Server DBA for the past 9 years. My experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. I am the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Area SQL Server User Group.

If you would like to receive email notification about upcoming SQL Lunches go here:

http://www.sqllunch.com/Register.aspx

Talk to you soon

Patrick LeBlanc, found TSQLScripts.com and SQL Lunch

SQL Down South