Posted by: Adam Jorgensen | September 26, 2010

My Personal Blog Is Moving

I want to thank all of you who have been following me here. Please come check out my personal blog over at http://www.adamjorgensen.com. I continue to be the editor over at BIDN.com so all technical content is crossposted there.

Thanks !

Adam

Posted by: Adam Jorgensen | September 16, 2010

What is all that Hot Air?

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 focused event, there is usually a SQL track and some great fellowship with your developer piers. This is a great area in FL for developers and I’m excited to carvan across the state and meet my peers over there! Check it out and get registered at http://codecamp.swfldev.net/

10/6 – SQL Lunch – Online – I will be speaking on building your first dashboard in Performance Point. This will be a fun interactive presentation that we all get to participate in! – HTTP://www.sqllunch.com

10/14 – Space Coast SQL Server User Group – Melbourne – We’re going to talk about SharePoint Business Intelligence and Reporting!

10/16 – SQL Saturday – Orlando – It’s time for another great event in O-Town! Join Me in hanging out with Andy, Jack and the Orlando team for a great day! http://www.sqlsaturday.com

10/21 – SSWUG Virtual Conference with Patrick LeBlanc – This is going to be EPIC! They have been conned into letting Patrick and I loose in their studio for the day to teach you guys all kinds of stuff! We’re going to cover making your BI solution real time, SSAS development and SSRS development! It’s going to be FUNNY, interactive and best of all – LIVE and NO DELAY! http://www.sswug.com

 

10/26 – SQL Lunch – Overview of common DAX Expressions – It’s going to be a great lunch covering these new types of expressions in power pivot.

10/28 – South Florida SQL Server User Group – We’re going to talk about SharePoint Business Intelligence and Reporting!

11/3 – SQL Lunch – Online – We’re going to talk about Data Mining in SQL Server and Power Pivot –Get registered it’s going to be fun!

11/9 – SQLPASS Summit – Seattle – Enough said – This is the largest event of the year and will be a blast. I’m doing a session on Zero to cube! It should be a great time.

 

I listed these to say that if I can fit all these in, you can too. Let us know if you want to speak at SQL Lunch or a user group, or some other format. We’re here to help you get started in the community. See you out there!

 

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

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.

Posted by: Adam Jorgensen | September 16, 2010

Let PASS Help you get a job!

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 expand your horizons or meet another priority in your life. I am challenging all of you to post your resume and see what kind of response you get. Don’t do this if your growing where you are, but you can post anonymously and it’s a great way to see who else might be looking for you to help them grow too!

 

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

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.

Posted by: Adam Jorgensen | September 16, 2010

Ready… Set …. Go ! <how many>?

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

image

I guess we learn something new every day! Keep posting your comments and feedback. I love it!

Posted by: Adam Jorgensen | September 8, 2010

White Paper Wednesday – Overview of StreamInsight

Hey folks,

It’s whitepaper Wednesday again and this week we’re talking about "Introducing Microsoft StreamInsight" by: Torsten Grabs, Roman Schindlauer, Ramkumar Krishnan, Jonathan Goldstein.  You can check it out here and read along: http://download.microsoft.com/download/F/D/5/FD5E855C-D895-45A8-9F3E-110AFADBE51A/Microsoft%20CEP%20Overview.docx

StreamInsight is a powerful new addition to the data processing lineup for Microsoft. Many folks don’t understand why this is bundled with SQL Server and from what I can tell it’s mostly for licensing purposes. IT doesn’t really below anywhere else and since it’s mostly API driven it needs to piggyback with another enterprise product. StreamInsight give you the ability to process significant amounts of data in real time, analyze it, make decisions based on that analysis. It’s some pretty cool stuff. The article takes you through the follow based on it’s summary:

"While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, continuous queries, and millisecond latency requirements that make it impractical to persist the data in a relational database for processing. These requirements are shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring. Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships and data abstractions from among seemingly unrelated events and trigger immediate response actions.

This paper provides an overview of the Microsoft SQL Server StreamInsight platform for complex event processing . StreamInsight allows software developers to create complex and innovative CEP solutions along two scenarios: (1) building packaged event-driven applications for low latency processing and (2) developing custom event-driven applications for businesses with high throughput, low latency needs. The paper describes the StreamInsight architecture and major components and demonstrates how to write continuous queries in a declarative way to analyze and process the events flowing through the system ."

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 @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen.

Posted by: Adam Jorgensen | September 6, 2010

PASS BI Virtual Chapter Event

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

I’ve seen Mike speak and he’s great. Make sure you come check this out!

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)|(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. Make sure to follow @PASSBIVC for the updates on Virtual Chapter events!

Posted by: Adam Jorgensen | September 6, 2010

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

 

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)|(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. Make sure to follow @PASSBIVC for the updates on Virtual Chapter events!

Posted by: Adam Jorgensen | September 6, 2010

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

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 BI architecture so that it can be sound and flexible and the same time?  All these questions come out every time someone has to start a BI project. In this session I’ll present a set of standard rules we use to create our BI project, consolidated in more than five years of development (since SQL 2005 was released) and that allow to put some technical rules that helps you to start in the correct way right from the beginning: naming convention, architecture decisions, database unit testing, layering and everything you need to know to build an "Adaptive" Business Intelligence solution. The idea is to be flexible in terms of architectural decision but have some well-known rules in the solution to make it “engineerable”: in one word…"Adaptive"!”

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)|(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. Make sure to follow @PASSBIVC for the updates on Virtual Chapter events!

Posted by: Adam Jorgensen | September 6, 2010

SQL Lunch #38-Restartability in SSIS

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 session Kyle will cover the implementation of checkpoints in your SSIS packages to restart on failures

Get Registered at http://sqllunch.com/Meeting.aspx?lunchid=38

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

Posted by: Adam Jorgensen | September 6, 2010

Building your 1st Performance Point Dashboard in Sharepoint 2010

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 ! – 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)|(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.

Older Posts »

Categories

Follow

Get every new post delivered to your Inbox.