Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2010

Access Analysis Services via T-SQL?

It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database by actually moving the aggregate values to Analysis Services and having the Stored Procedures from SQL Server access the Analysis Services cube by using straight T-SQL. I see that it…

Read more

0 comments, 393 reads

Posted in Sam Bendayan's 2 Cents on 22 March 2010

BiTemporal Tables, anyone?

I'm doing some interesting research on using BiTemporal tables and I was wondering if anyone out there has any real-world experience using these. Basically these are tables where you have effective dates and audit dates in the same table. You may know these by other names, such as 'Valid Time…

Read more

0 comments, 258 reads

Posted in Sam Bendayan's 2 Cents on 11 March 2010

More posts coming soon...

Haven't been around for a while, but doing some interesting work with Database Refactoring and Effective Dating...more posts coming soon....

Read more

0 comments, 218 reads

Posted in Sam Bendayan's 2 Cents on 10 March 2010