Archives: July 2010
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to admit, one of my colleagues and I chatted about this puzzle, and I realized that my requirements were a little unrealistic. As a result, I changed the requirements a little.… Read more
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter goals and post goals for the 3rd quarter. If you all have been following my blog or me on twitter (patrickdba) you know that I was selected as a SQL… Read more
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with a WHERE clause. You can also do the same with MDX, but just like T-SQL there are a few ways to accomplish this. In this puzzle you will see an… Read more
This past weekend I had the opportunity to hangout with some of the brightest upcoming SQL Server Professionals and a couple of old-timers. We were gathered in Orlando, FL by Andy Warren to work on the SQL Saturday Wiki. Essentially, the plans were to improve on the information that… Read more
I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session there were approximately 150 attendees and at the second there were approximately 400 attendees. The recording is available here and you can download the slide deck here. I would… Read more
1. There are three judges that get to ask questions and… Read more
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… Read more
Tomorrow at 11:00 AM EST I will be giving a talk on SQL Server 2008 R2 for the DBA. Here is the description:
Microsoft SQL Server 2008 provides a number of enhancements and new functionality, building on previous versions. Administration, database maintenance, manageability, availability, security, and performance, among others, all… Read more
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 firstname.lastname@example.org. Don’t worry, you can have up to 90 minutes or you can break your session… Read more
Join SQL Server MVP, Andy Leonard, tomorrow on the SQL Lunch to learn some snappy tips and tricks on Transact-SQL development and deployment. 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… Read more
With all the MSDN give away contests, I decided to add another. Here are the official rules for the twitter referral registration contest for SQL Saturday #28 in Baton Rouge, LA on August 14, 2010 on the campus of Louisiana State University.
In case you haven't heard, SQL Saturday Baton… Read more
This week I will speaking at the Greater New Orleans .Net User Group. My topic is Introduction to the SQL Server Profiler. If you want to learn some tips and tricks that you can use when trying to identify performance problems with your SQL Server stop by the meeting. Also,… Read more
Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts in SSRS R2. 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… Read more
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… Read more
The next puzzle comes from a BIDN.com forum post. Here are the requirements:
Columns: Internet Order Quantity and Percentage Of Total (Calculation)
Filter: Return only the TOP 10 Products based on Internet Order Quantity.
Hint: Use the WITH MEMBER statement to perform the calculation. In addition, you will… Read more
This puzzle was a little more challenging than the first, but it was definitely fun and a good learning experience. It introduced a new method that allows you to create session scoped calculation that can be used in your MDX query. You can actually… Read more
I received an email today stating that I had been selected as a Microsoft SQL Server MVP for 2010. This is my first MVP award and I am elated to become part of such a distinguished group. What a great community!!!!
Thanks to all those that nominated me and thanks… Read more