Over the past six months I have writing chapters for my next book. The book is titled SharePoint 2010 Business Intelligence 24-Hour Trainer . This was a group effort with a bunch of us from Pragmatic Works consulting. If you want to learn about SharePoint Business Intelligence this book is a must read. Talk to you soon, Patrick LeBlanc, MVP founder www.SQLLunch.com
Read More
Well, one of my goals this year was to focus on branding myself a little more. So I decided to launch www.patrickdleblanc.com . My wife hates the site. She hates it because she thinks it is not professional. I, on-the-other-hand, thinks it reflects who I am. Each image represents how I think about, search for, absorb and share any knowledge I learn about SQL Server. So far I only have the main blog page up, but I am working on adding a few additional pages. This is kind of interesting for me bec...
Join me tomorrow for a little CDC. #47-Introduction to Change Data Capture Speaker: Patrick LeBlanc Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend Date and Time: 2/1/2011 11:30:00 AM CST BIO: Patrick LeBlanc, SQL Server MVP, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medic...
So you don’t have anything to do this Saturday. Well, if you have an insatiable thirst for SQL knowledge like me, come out to SQL Saturday #57 Houston . I will be presenting two sessions: SSIS: Tuning, Configuring and Deploying SSRS: What’s new in R2 This is going to be a great event with several great sessions. See you there! Talk to you soon Patrick LeBlanc, MVP, MCTS Founder www.sqllunch.com
The SQL Lunch and SQL University have combined forces. Come and watch, laugh, and learn. #48-SSIS Tips&Tricks (Advanced SSIS) Speaker: Josef Richberg Add To Outlook: Add To Calendar Date and Time: 1/28/2011 11:30:00 AM CST BIO: A SQL practitioner for over 17 years specializing in performance & tuning. I currently work for Harpercollins Publishers designing, enhancing, and improving, the sql experience for many of the data warehouse applications. I have been heavily involved in designing ...
#46-SQL Azure – Cloud Database Coolness Don't miss this lunch. Speaker: Scott Klein Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=3BGZJG&role=attend Date and Time: 1/26/2011 11:30:00 AM CST BIO: Scott Klein is co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Ent...
SQL Lunch - Building a Performance Point Dashboard Don't forget to attend the SQLLunch tomorrow. #35-Building your first PerformancePoint Dashboard in SharePoint 2010 Speaker: Adam Jorgensen, SQL Server MVP Add To Outlook: Add To Calendar Date and Time: 1/19/2011 11:30:00 AM CST Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=RGZ9KD&role=attend BIO: Adam Jorgensen , MBA, MCDBA, MCITP: BI has over a decade of experience leading organizations around the world in developing and i...
I've actually sat down to write this blog several times. I am never indecisive when it comes to my thoughts or my writings. Most of the time I just write what I feel. For some reason this post was a little challenging. It was hard for me to decide if I want to share my thoughts about what my goals were for the year. After a couple of attempts I decided to share. So, what's next for Patrick? Before I delve to deep into my upcoming goals, I want to revisit 2010. Last year was a very good year for ...
TechEd has listed some potential sessions for TechEd North America 2011 here: http://northamerica.msteched.com/sessionpreference?fbid=I1Ydc71JM4a. They want to know which sessions you are interested in seeing. I have one session on the list. I am not going to say which one, since TechEd did not include the names on the site. I like the idea, this way it's not a popularity contest. If you have time, go and check out what they are doing. Select your preferred sessions. I think it's a great way to ...
The Baton Rouge SQL Server User Group will be hosting its first meeting of the new year. Our meeting place has changed to Louisiana State University in Patrick F. Taylor Hall . Both SQL Saturday's held in Baton Rouge were located here. If you haven't attended a meeting I recommend that you come out to this meeting. We have two great presentations and some really great giveaways. Wait, did I mention that I was speaking. That should definitely get you out. I will be also giving away a copy of our ...
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 Speaker: Pam Shaw Join Meeting: https://www.livemeeting.com/cc/usergroups/join?id=PNZ5F4&role=attend Add To Outlook: Add To Calenda...
Don't miss the SQL Lunch tomorrow. #44-Learning SSIS under 1 hour Speaker: Jose Raul Chinchilla Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=FN36T2&role=attend Date and Time: 12/14/2010 11:30:00 AM CST BIO: Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working as a BI consultant for Convergence Consulting Group, a Tampa based full service consulting firm. Jose has12+ years of experience in...
At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source. A requirement of the report was to create an action that drilled-through to another report. No big deal, right? This is SSRS 101. Well, that was until I realized that the parameters that had to be set on the drill-through report were based on MDX queries. I still didn’t think that it would pose a problem and proceeded to configure the textbox Action to go to another report. After ...
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around 10:30 PM. I met Brian Knight and Tim Moolic (Pragmatic Works COO) and we drove about 1.5 hours to Ashford, WA. We settled in to our cabin on the Creek for a few hours of sleep before we began our BIG adventure. About a month before PASS Brian gave me a call and asked if I would like to join he and Tim on a hike up Mt. Rainier. I hesitated at first, but then quickly decided to do it. So h...
What a long week at PASS (stay tuned for more details about my trip). Now that it's over back to work. Join me and Cade Roux for a SQL Lunch on Tuesday. #41-Get a Lever and Pick Any Turtle: Lifting with Metadata Speaker: Cade Roux Add To Outlook: Add To Calendar Date and Time: 11/16/2010 11:30:00 AM CST Live Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=68R4BF&role=attend BIO: Cade Roux, is the recent founder of Rose Crescent, a software and systems consultancy in New Orlean...
I want to apologize for posting this so late, but there is a SQL Lunch today and one tomorrow. Hope you all can make it. #37- Zero to Dashboard Speaker: Adam Jorgensen Add To Outlook: Add To Calendar Date and Time: 11/3/2010 11:30:00 AM CST 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 ...
VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!! Vote here: http://www.zoomerang.com/Survey/WEB22BD59JCQBT Honestly, I want each of reading my blog to vote for our Pre-con( Full Day Business Intelligence Workshop ). However, as with any voting process you have choices. Well....in most cases you do. We often feel or believe that our vote does not count. I really believe that this is going to be a little different. I am really excited about the SQL Rally and more excited that our Preconference seminar...
Tyler Chessman of Microsoft has started a Business Intelligence Users Group in Houston. The group will meet online and onsite quarterly. The first meeting is tomorrow at 11:15 CDT. If you are interested in attending here are the meeting details: Houston – Microsoft Business Intelligence User Group We would like to invite you to the very 1 st Houston Microsoft Business Intelligence User Group. This event will take place on Wednesday October 20 th , 2010 from 11:15 – 1:00 p.m. at the Microsoft Hou...
Well I am sure most of you noticed that I haven't posted an MDX puzzle in some time. After much consideration I have decided to pass the torch to someone that I feel will devote the time needed to help you all continue with your learning. So with that, I would like to introduce or re-introduce you all to Dustin Ryan the new MDX Puzzle guy. Dustin is a consultant for Pragmatic Works and a regular blogger on BIDN.com. He is also very skilled with MDX. I am not quite sure when Dustin is going to st...
I am excited to announce a new speaker to the SQL Lunch, Ryan Adams. Ryan will be discussing Database Mirroring and how it has become an integral part of high availability and disaster recovery planning. See the following meeting details: Speaker: Ryan Adams Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=6J9BKQ&role=attend Add To Outlook: Add To Calendar Date and Time: 10/19/2010 11:30:00 AM CST BIO: Ryan is a highly skilled Microsoft oriented administrator and has worked for...
After making the trip last weekend to Houston for Houston Techfest with the kids I am off again, but this time alone. On Friday I will fly into Orlando for the Speaker dinner, which is always a lot of fun. On Saturday I will be presenting two sessions. The first is a mini session on Speaking and the second is on using Change Data Capture and SSIS to load a Slowly Changing Dimension . This is my second time speaking at SQL Saturday in Orlando . If you are in the area stop by. Registration is stil...
As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? Sometimes, I actually ask myself that question, but when I think about how the community as a whole operates (quick to answer questions and join discussions) any doubt is quickly removed. Think about this, in what community can you post a question on twitter or send an email to someone you met at a community event and before you know it, you have several responses to your question. I became active in ...
I will be speaking at the South Florida SQL Server User Group on October 13 via Live Meeting. My topic is Introduction to Change Data Capture with SSIS. If you have some time logon and watch the meeting. Time: 6:30 pm EDT Meeting URL: https://www.livemeeting.com/cc/mvp/join?id=PWWZ93&role=attend&pw=47WFd%7EC%5CJ In the presentation I will Introduce Change Data Capture and show how it can be used to incrementally load a Slowly Changing Dimension. Hope to see some of you online. Talk to yo...
Don't miss SQL Server MVP Andy Leonard on the SQL Lunch, Monday, October 11th. #32-SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns Speaker: Andy Leonard Add To Outlook: Add To Calendar Live Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=JG6T72&role=attend Date and Time: 10/11/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 Regio...
I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes this trip even more exciting. This is a free event that offers a diverse set of sessions. The sessions range from What's new in Java to Introduction to Window Azure. I attended the event last year and if my memory serves me correctly there were only two SQL Sessions. Fortunately, I was able to convince the event coordinator, Michael Steinberg, to include a full SQL Track at the event. Thi...