Rebuilding the SQL Server master database - Part 3 (7/3/2008)
So far we have prepared for the rebuild of our master database and have gone through the surprisingly simple rebuild process. (One of those DBA things where you spend all of your time on the preparation for something to go wrong, but everything goes off without a hitch!) Now we find ourselves at the point where we need to recover all the data we have lost in the process: the logins, the jobs, oh those databases too. I guess those may be a tad bit important too! Let's get to work, shall we?
How To Build a Cube From an Existing Data Source Using SQL Server Analysis Services (7/2/2008)
We are just getting started with SQL Server Analysis Services and trying to build our first cube. We have an existing relational data source to use as our starting point. There are a number of steps involved in building an SSAS cube. Can you guide us through the steps to build a cube and provide some explanations?
Maintaining SQL Server database metadata to identify object changes (7/1/2008)
My company sells a packaged software solution to our customers. From time to time, I am called in to troubleshoot and diagnose customer database issues. A lot of times, I find that our support department has added indexes to the customer's model or modified their database source code. Unfortunately, I have to comb through the database to find these changes. Is there a better way?
June 2008 Tips - Recap (6/30/2008)
The June 2008 tips are from the following categories: Analysis Services, Backup and Recovery, Common Language Runtime (CLR), Common Table Expressions (CTE), DBA Best Practices, Disaster Recovery, Functions, Interview Questions, Monitoring, Performance Tuning, Scripts and SQL Server 2008.
How To Build a Cube Without a Data Source Using SQL Server Analysis Services (6/27/2008)
We are new to SSAS and are struggling with how to get started. We don't yet have a relational data warehouse that we can use to populate a cube. When you go to build a cube there is an option to build the cube without a data source. Can you provide us with the details on how to go about doing this?
|