MDX Puzzle #5
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
554 reads
Patrick LeBlanc
MDX Puzzle #4 - Solution
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,565 reads
2010 3rd Quarter Goals
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,013 reads
MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
556 reads
SQL Saturday Wiki
This past weekend I had the opportunity to hangout with some of the brightest upcoming SQL Server Professionals and a...
2010-07-25
614 reads
SQL Server 2008 R2 for the DBA Recording and PowerPoint
I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session...
2010-07-23
536 reads
.NET speaker Idol, Guess who won?
Last night (July 21, 2010) I had the honor of being a speaker at the Baton Rouge .Net User Group. ...
2010-07-22
813 reads
Free Data Warehouse Training - SQL Lunch #27 Let's Get Dimensional
Join Adam Jorgensen, tomorrow on the SQL Lunch to learn about Dimensional Modeling. Go to SQL Lunch and add this...
2010-07-21
826 reads
SQL Server 2008 R2 for the DBA Webcast
Tomorrow at 11:00 AM EST I will be giving a talk on SQL Server 2008 R2 for the DBA. Here...
2010-07-21
511 reads
Practice Your PASS Session on the SQL Lunch
We at the SQL Lunch would like to extend an invitation to all of the PASS speakers. If you are...
2010-07-18
405 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers