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 t
Build a SQL Server cluster with this post SQL Server installation checklist.
Build a SQL Server cluster with this pre SQL Server installation checklist.
Build a SQL Server cluster with this poist cluster installation checklist.
Build a SQL Server cluster with this pre cluster installation checklist.
This article covers building a cluster node and a checklist that you can follow.
Having a checklist to follow is key and this tip includes a SQL Server cluster configuration checklist.
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
Previously in this series about how to rebuild the master database, we itemized the steps required to prepare for rebuilding the master database. In the third tip in the series will present how to restore your SQL instance back to the state it was in pri
In a recent tip on Language Integrated Query (LINQ), you have described how it can be used as a query language extension to both VB.NET and C#. As XML has become a popular means to store data for ease of interoperability, how do we use LINQ to query XML d
I recently found myself in a situation where I had to rebuild the master database on one of the nodes of our development SQL 2005 cluster. The process itself is quite simple, the proof is in the preparation however. The chances things will go wrong are
Last week we had a conversion and the bank number was going to change during the process. I knew there was a lot of special code written for the bank and I did not want to miss anything. I needed to find an easy way to scan all tables in the database to f
In this tip we look at how to create a SQL Server alert to be emailed to the database team.
Need to find if a string value exists in your table? This script will help you find all occurrences in all columns in a SQL Server table.
Learn various ways you can use the SQL Coalesce function to pivot data, generate multiple SQL statements and more.
Learn how to write recursive queries in SQL Server by using a Common Table Expression also know as a CTE.
In this tip we look at different ways to prevent disasters from occurring on SQL Server and your databases.
We occasionally come up with a requirement that would be a good fit for a CLR function or stored procedure. For instance we would like to call a stored procedure to get the list of files in a particular folder. How can we return the list of files as a s
When failing over to a standby server in a log shipping pair, we need to restore the latest transaction log backup to make the standby databases ready for access. This process may be cumbersome if it involves manually restoring more than five database in
In this tip I will show you how I use Excel to analyze the data to help determine where your bottlenecks may be and also an easy way to create quick reports and charts for your SQL Servers.
While reviewing the new features in SQL Server 2008, we noticed Transparent Data Encryption. This sounds very interesting. Could you provide us with a basic explanation and how to implement it?
Database backups and maintenance windows for very large database are very frustrating especially if we need to generate full database backups to initialize a database mirroring or transaction log shipping session. As we are looking through the new feature
I was troubleshooting an issue last week on a vendor-developed database when they stated we needed to look at each one of the 50 tables in their database to make sure that all fields expecting default values, had default values assigned. Well, you can im
One of the new SQL Server 2008 features in SSIS is an enhanced Lookup transform that includes the ability to cache the lookup data locally. Can you provide the details of this new functionality and an example of how to use it?