SQL Server BI, Life, and Running a BI Firm

Who is online?  0 guests and 1 members
Home  »  Blogs  »  AdamJorgensen: September 2010

Communifire Blogs

Blogs RSS Feed

AdamJorgensen :September 2010 postings

AdamJorgensen

Performance Tuning Analysis Services (SSAS) Webinar Today

9/28/2010 by AdamJorgensen  -  Comments: 1  -  Views: [2538]

Thanks for coming to today's webinar. We had a great turnout and hope to see you again soon. I have posted the powerpoint from the session here! Thanks everyone! - Adam

Read More

AdamJorgensen

Thank you all for going Zero to Cube with me!

9/17/2010 by AdamJorgensen  -  Comments: 0  -  Views: [873]

Hey there folks. I am so excited about the tremendous turnout at the 24 hours of PASS . There were so many great sessions. A couple of people did set some records for numbers of bullets on slides (not a good thing) but overall it was a tremendous event! I truly appreciated the great comments and feedback. I am handsome and thank you for mentioning it. Many of you were pumped about the Summit and that was the goal! Thanks to the PASS team and those who worked so hard to pull this together. Great ...

Read More

AdamJorgensen

What is all that hot air? Oh I'm speaking all over the place!

9/17/2010 by AdamJorgensen  -  Comments: 3  -  Views: [875]

Many of you have been wondering where I will be speaking next. So I apologize for not replying to you all individually but here is the current plan. 9/16 – 24 Hours of PASS – Online – This is a killer event and is a preview of the SQLPASS Summit. There is so much great content. Make sure to check it out at http://www.sqlpass.org/24hours/Fall2010/ 9/25 – Southwest Florida Code Camp – Florida Gulf Coast University- Many SQL Pros overlook the value of a great code camp. Even though this is a .NET f...

Read More

AdamJorgensen

Let PASS help you get a job!

9/16/2010 by AdamJorgensen  -  Comments: 0  -  Views: [764]

With so many folks out there struggling and loking for new opportunities you may want to take some time away from Getting you Monster on, rolling the Dice or any other practice and check out the SQLPASS Job Board . This is a great resource for those of you looking to find good talent or post some resumes to find a new opportunity to rid yourself of your current pointy haired boss. There have been some high profile career moves in the SQL World lately but remember that yours should be helping you...

Read More

AdamJorgensen

Ready Set Go

9/16/2010 by AdamJorgensen  -  Comments: 2  -  Views: [754]

I thought I would pass along something I learned this week about batches in TSQL. I always knew about the GO statement terminator, but I didn’t know you could takc on a number to it and get it to repeat itself. For Example: Select top 5 * From FactOnlineSales GO 100 I guess we learn something new every day! Keep posting your comments and feedback. I love it!

Read More

AdamJorgensen

PASS BI Virtual Chapter Event - SSRS 2008 R2 The New Stuff

9/25/2010 by AdamJorgensen  -  Comments: 0  -  Views: [1736]

Quick update from your PASS BI Virtual Chapter folks! September 29th, Mike Davis is doing a session on SSRS R2: The New Stuff . 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. About Mike – Mike Davis, MCTS, MCITP, is a Senior...

Read More

AdamJorgensen

Get ready for the Third Annual SW Florida .Net Code Camp!

9/19/2010 by AdamJorgensen  -  Comments: 0  -  Views: [820]

Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway I’ll be there and so will a lot of other great speakers and Microsoft resources. Get all the details at http://codecamp.swfldev.net/ Thanks ! – Hope to see you guys there! Adam ————————————————————————————————— 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) ...

Read More

AdamJorgensen

PASS BI Virtual Chapter – Adaptive BI: Engineering a BI Solution

9/18/2010 by AdamJorgensen  -  Comments: 0  -  Views: [1062]

Hey there folks – PASS Virtual BI Chapter Event Alert! Don’t forget to come out on Sept 20th and get Adaptive with Davide Mauri.. David’s Abstract reads… “Are you starting to create a BI solution….but where do you begin with? How to setup everything correctly so that you’ll be able to handle new features required by the customers easily and without too much effort? Which standard do you put in place so that everyone who will join the project will be immediately operative? How do you define your ...

Read More

AdamJorgensen

SQL Lunch #38-Restartability in SSIS

9/10/2010 by AdamJorgensen  -  Comments: 0  -  Views: [1136]

Hey There SQL Lunchers – Come out and check out Kyle Walker talking about restartability in SSIS. Specifics to make sure you don’t miss it! Date and Time: 9/14/2010 11:30:00 AM CST BIO: Kyle Walker is a Business Intelligence consultant for Pragmatic Works. He has past experience as a reporting analyst at one of the nation’s leading default solutions companies. He is experienced in Integration Services, Reporting Services, and Database Administration. Topic: #38-Restartability in SSIS In this ses...

Read More

AdamJorgensen

Building your 1st Performance Point Dashboard in Sharepoint 2010

9/12/2010 by AdamJorgensen  -  Comments: 0  -  Views: [3869]

Hey there gang The PASS BI Virtual Chapter is presenting some great stuff this fall. September 14th I’m doing a new session on Performance Point 2010 dashboards. Many of you have seen the coolness that is Performance Point 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. Get registered at http://bi.sqlpass.org/ Thanks ! – ...

Read More

AdamJorgensen

SQL Lunch #31 – SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns

9/11/2010 by AdamJorgensen  -  Comments: 1  -  Views: [2507]

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 applica...

Read More

AdamJorgensen

Let’s get Dimensional – from Requirements to Dimensional Design

9/7/2010 by AdamJorgensen  -  Comments: 0  -  Views: [805]

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 a...

Read More

AdamJorgensen

PASS Data Warehousing/Business Intelligence Virtual Chapter Live Meeting Sessions

9/7/2010 by AdamJorgensen  -  Comments: 0  -  Views: [955]

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 in...

Read More

AdamJorgensen

24 Hours of PASS coming over the next two days

9/14/2010 by AdamJorgensen  -  Comments: 0  -  Views: [753]

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

Read More

AdamJorgensen

test post for debugging6

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [635]

test post for debugging

Read More

AdamJorgensen

test post for debugging5

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [664]

test post for debugging

Read More

AdamJorgensen

test post for debugging4

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [656]

test post for debugging

Read More

AdamJorgensen

test post for debugging3

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [657]

test post for debugging

Read More

AdamJorgensen

test post for debugging2

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [676]

test post for debugging

Read More

AdamJorgensen

test post for debugging1

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [585]

test post for debugging

Read More

AdamJorgensen

test post for debugging

9/6/2010 by AdamJorgensen  -  Comments: 0  -  Views: [610]

test post for debugging

Read More

AdamJorgensen

White Paper Wednesday – Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products

9/29/2010 by AdamJorgensen  -  Comments: 0  -  Views: [2788]

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 a...

Read More

AdamJorgensen

Whitepaper Wednesday - Mirroring a Large Number of Databases in a Single SQL Server Instance

9/22/2010 by AdamJorgensen  -  Comments: 0  -  Views: [1853]

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 consoli...

Read More

AdamJorgensen

Time to get Agile

9/27/2010 by AdamJorgensen  -  Comments: 1  -  Views: [848]

For those of you whose BI projects never resemble your prom night (never getting past first base), it’s probably time to consider a more agile approach. Literally. Agile methodologies can deliver a serious injection of accomplishment and user credibility by delivering the project in chunks. IT has been very successful for us and is a foundation to the types of engagements our clients are most excited about. There is a great book called Agile Project Management with Scrum. Check it out and get ou...

Read More

AdamJorgensen

Awards for SQL Heroism

9/20/2010 by AdamJorgensen  -  Comments: 0  -  Views: [755]

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 a...

Read More