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,123 reads
Devin Knight
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,505 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,275 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,664 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,164 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,857 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,497 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,234 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
944 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,186 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers