SQL Rally Schedule
Thursday, May 12
BI
DBA
DEV
PD / WILD
CARD
8:30 - 9:30
SQL Server Parallel Data Warehouse - Under the Hood
Brian Mitchell
The Dirty Dozen: PowerShell Scripts for the...
2011-04-05
1,126 reads
SQL Saturday #74 Jacksonville
For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already...
2011-03-30
1,515 reads
SSAS - Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share.In the cube he...
2011-03-22
1,285 reads
Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime.The benefit of doing so allows you to change...
2011-03-14
34,699 reads
SSAS – Changing the Dimension ALL Member Name
All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.For example, let’s...
2011-03-07
2,170 reads
SSAS - Preserve Measure Null Values
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in...
2011-02-28
5,867 reads
Testing SSAS Security in Excel
There are many posts available that describe how to test Analysis Services security from inside the development environment.Today I would...
2011-02-21
1,503 reads
SQL Rally Performance Tuning SSAS Session
Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning...
2011-02-16
1,239 reads
Pre-Order SharePoint 2010 Business Intelligence 24-Hour Trainer
I wanted to announce that you can now pre-order your copy of my latest book to be released called SharePoint...
2011-02-07
954 reads
SQL Rally BI Sessions
This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder...
2011-02-01
1,197 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