SQL Clone
SQLServerCentral is supported by Redgate
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, 801 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, 646 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, 539 reads

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