(Baya Pavliashvili) Microsoft Analysis Services (MSAS) offers exceptional performance for analytical queries. Reports that show the breakdown of revenues by customer, time and geography are probably the most common example of online analytics. What makes MSAS so great for analytical queries? One sim

(Terry Troisi) It’s 4:30 P.M. on Friday and your boss comes to you in a panic. The e-commerce system is down, and the database is to blame. You go through your usual what’s-going-on checklist and all you can tell is the CPU on the SQL Server is pegged at 100 percent. You check Profiler, but no high

Sixteen new webcasts are scheduled for December, covering such topics as SQL Server 2005 Upgrade Process, Integrating Windows SharePoint Services with SQL Server Reporting Services, SQL Server 2005 Failover Clustering for SQL Server 2000 Users and more.

(Jeffrey Juday) SQL Server 2005 Integration Services (SSIS) is a new Extract, Transform, and Load (ETL) tool that ships with SQL Server 2005. As with many of Microsoft’s development tools, you can extend SSIS to perform other operations not already bundled with the product. SSIS provides the SSIS Cl

(Scott Bekker) Think of SQL Server 2005 as a bulldozer ready to reshape the industry. Now pull back your mental camera and imagine it as the leader of a phalanx of Microsoft bulldozers grinding across the IT landscape, heading for more hills to flatten.

(Gregory A. Larsen) SQL Server 2005 provides some new command line utilities. One such utility is “sqlcmd”. The sqlcmd utility is used to run adhoc queries interactively from a command prompt window, or can be used to execute a script containing T-SQL statements. The sqlcmd utility is a great improv

(graz) With the introduction of SQL Server 2005, Microsoft has created a new .NET management API for SQL Server called SQL Management Objects (SMO). As I started working with SQL Server in earnest following its release I discovered a few limitations that I hoped to correct using SMO. This article de

(Sachin Kainth) To check whether nested triggers are turned on or off in SQL Server, you can issue the following command in Query Analyzer.

(Steven Warren) Now that your data is backed up, you will need to learn how to restore your data when it is applicable. You might want to restore your data because of a hardware failure or restore data to a backup or standby server. The reasons are endless but the most important thing is to be prepa

If the lazy aggregation process is suspended multiple times for the same partition because of other processing operations in Microsoft SQL Server 2000 Analysis Services, the following Error event may be logged in the event log: Event Type: Error Event Source: MSSQLServerOLAPService Event Cat