Don’t miss Andy Leonard presenting his PArt Deaux of Design Patterns for SSIS.

Important Info from our SQL Lunch site….

Date and Time: 9/13/2010 11:30:00 AM CST

BIO: Andy Leonard 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.

Topic: #31-SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns

This is part two of a three part series.A brief introduction to the concept and usage of design patterns and a demonstration of the Counts Acquisition in ETL Instrumentation pattern.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Hey folks!

 

You asked for it – so coming up on September 8th we’re doing a SQL Lunch that is going to take a business requirement and create a star schema from it to us for our data warehouse. We will build our dimensional model together from a business requirement and then show how we could use it for reporting, etc.. Make sure to get get registered at SQLLunch.com.

 

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Quick hit mid-week folks! Make sure not to miss the BI Virtual Chapter’s Presentation of Data Mining with PowerPivot with Mark Tabladillo. http://bi.sqlpass.org/

The Summary of his talk is: “Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.”

You can also check him out at MarkTab.net

 

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Hey folks,

The 24 hours of PASS is coming very quickly. http://www.sqlpass.org/24hours/fall2010/. There are so many great sessions that I don’t know what else I will be doing for two days. Make sure to get registered before time runs out.  Here is the Session listing. Go check it out and see where you could pick up some skills that would help you try some new things.. http://www.sqlpass.org/24hours/fall2010/SessionsbyTrack.aspx.

 

 

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Hey folks,

With high availability being so “high” on everyone’s list mirroring is a hot topic. This article by Sanjay Mishra and Prem Mehra talks about all the ways you can implement mirroring with a large number of databases without scaling to multiple instances.

  

The articles’ overview is here” A frequently asked question regarding database mirroring is: How many databases can be mirrored in a single instance of Microsoft® SQL Server®? This question is often raised by customers who are consolidating many databases into fewer instances and the high availability or disaster recovery service-level agreement (SLA) requires deployment of database mirroring.

Sometimes the question is raised when readers misconstrue the restriction documented in the SQL Server Books Online stating that “On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session.“

Check out the article here:http://sqlcat.com/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx

It’s well written and informative.

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

This week we’re highlighting a new whitepaper on  Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products. It’s written by Tom Wisnowski and the ret of the SQL CAT team has contributed..  You can get it here http://go.microsoft.com/fwlink/?LinkID=196600 and it’s a great resource for getting Kerberos working in your SharePoint 2010 environment. All to often I have heard folks saying “Oh  we have to use Kerberos? Isn’t there another option?” This is because Kerberos can be tricky and challenging to deal with.  This paper has some great insights about multiple SharePoint Scenarios. Just read the Summary

“Microsoft® SharePoint® 2010 Products introduce significant improvements in how identity is managed in the platform. It is vitally import to understand how these changes affect solution design and platform configuration to enable scenarios that require user identity to be delegated to integrated systems. The Kerberos version 5 protocol plays a key role in enabling delegation and sometimes may be required in these scenarios.

This document provides you with the information that will help you:

· Understand the concepts of identity in SharePoint 2010 Products

· Learn how Kerberos authentication plays a critical role in authentication and delegation scenarios

· Identify the situations where Kerberos authentication should be leveraged or may be required in solution designs

· Configure Kerberos authentication end-to-end within your environment including scenarios which leverage various service applications in SharePoint Server

· Test and validate that Kerberos authentication is configured correctly and working as expected

· Find additional tools and resources to help you configure Kerberos authentication in your environment”

Check it out and get some good info on getting this set up in your environment.

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Motivational time again!

Have you ever worked on a project where someone was seeking their moment in the sun for an award or promotion? This can sometimes cloud their judgment or to rush something that they otherwise would have taken more time on in order to make a deadline. In my career i have had to dead with both sides of this coin. I have been the line holding that guy back, and that guy working towards improving my standing in an organization. It’s difficult on both sides. The trick is to always deal with the facts and assess risk realistically. Many times managers can have a better sense of the business risk and the DBA can have a better sense of technology risk. These need to be combined into a real picture of what’s going on and the team should weigh in on decisions.  This seems Utopian, but it takes a strong person to stand in front of a truck sometimes. Just remember, if that truck runs over your server, then you’ll be scraping it up..

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Motivational time again!

Sometimes things cannot be explained. Like this guy in the picture. I think he’s gunning for his own show on Bravo. Either that of he finally "took care of" The Bachelorette…. Kidding aside make sure you know how to look into your transaction log, make sure you’re logging in your applications and SSIS packages, and make sure you KNOW HOW TO READ THEM !!  Test for different types of common errors and attempt to trap for them. All too often I see clients who are not doing this and then can’t explain why their packages are failing because a folder permissions got overwritten during a service pack or something similar. Always be able to investigate the unexplainable..

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Motivational time again!

Today I want to talk about being lazy with your data. More likely than not, it’s not your data, it’s your firm’s data. Make sure you’re taking precautions. There are so many features in SQL Server that provide for this type of security.  Now the image below describes a certain type of DBA or BI Admin.  Does this sounds familiar?

1. The backups run like clockwork, we test them every so often. (This means they might only work every so often)…

2. The offshore folks run the backups (Let’s hope they can restore them and find any lost data as well.)

3. What’s an encryption key? (Please ask your manager to smack you on the head.)

The bottom line is, some tasks are push, some are walk behinds, and some are riding. Don’t confuse them and you’ll be just fine!

I’m looking forward to seeing all of you and speaking to you soon.

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen. For more information on the Regional Chapter Mentor program and PASS go to SQLPASS.org.

Hey folks,

It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger Doherty, Prashant Choudhari, Shireesh Thota, Charlie Carson, and Omri Bahat.

You can find it here: http://technet.microsoft.com/en-us/library/ff381683(SQL.100).aspx

There has been a lot of controversy about the latest addition to SQL 2008 R2 as to how to use these new Data Tier applications or DACPACs. This white paper will help you make sense of it all. This article walks you through how this can work in your organization. Here is the summary from the white paper:

“Microsoft’s investments in application and multi-server management will help reduce the complexity around developing, deploying, and managing applications. A core concept of application and multi-server management in SQL Server is the data-tier application (DAC). A DAC, introduced in the Microsoft® SQL Server® 2008 R2 data management software and the Microsoft Visual Studio® 2010 development system, is a self-contained unit of deployment that defines and bundles database objects, SQL Server instance objects that are associated with the database, and deployment requirements of an application. Using DACs, developers and database administrators can automate and facilitate common operations and practices in the lifecycle of database systems.?

Go check this out and keep your eyes peeled for all the other great whitepaper resources we’ll be reviewing on White Paper Wednesdays

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence.

Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world!

Lastly, don’t forget to follow me on twitter for all the latest updates@Adam_Jorgensen.