SSAS fact table dilemma
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,276 reads
James Serra's Blog
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,346 reads
Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
904 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
891 reads
SQLInspire NYC 2011 Videos available
There are some FANTASTIC videos of the sessions from SQLInspire New York 2011. I highly recommend that you check out...
2012-01-18
531 reads
SQL Server 2012 (“Denali”): SSIS Logging
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,220 reads
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
948 reads
Video/Voice conferencing and Microsoft Lync
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,010 reads
Houston Area SQL Server User Group Presentation
Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...
2012-01-11
595 reads
Surrogate Keys
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,959 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
The New Database CheckDB
Comments posted to this topic are about the item The New Database CheckDB
MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers