Powershell (PoSH) is the de facto scripting platform Microsoft has deployed for referencing or manipulating pretty much anything that touches their operating system. Its usefulness is well documented and I find it is a remarkably powerful tool in a DBA...

Jacob has identified some very helpful criteria for assessing when you should "pull the trigger" on an index rebuild as well as a 'best practices' monitoring suggestion. To add to the reply to your initial question, Krishnrajsinh, the question of autom...

Thanks very much for the heads up, Jacob! I will check those out, and look forward to making contributions and continuing to learn myself! - Greg...

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Motivation to blog...

Implementing a star schema would be my recommendation. Normalization of the dimension tables ("snowflaking") can impair the performance of a data warehouse. Whereas conventional databases can be tuned to match the regular pattern of usage, such patterns...