Cube Storage: Planning Partitions (Business Intelligence Development Studio Perspective) (Database Journal)

This article introduces partition planning for Analysis Services. Here, we will follow upon our introduction to partitions in Analysis Services, and discuss the importance of planning in partition design.

Full Text Catalog Configuration in SQL Server 2005 Express Edition (Database Journal)

In the previous installment of our series dedicated to the most prominent features available in SQL Server 2005 Express Edition, we have concluded the coverage of its implementation of Reporting Services.

Introducing the Tablix Data Region in Reporting Services 2008 (Database Journal)

This month, I introduce a data region that is new in Reporting Services 2008 . The tablix data region combines the by-now familiar table , matrix and list regions, and actually underlies these options, as we shall see in the examination that follows.

New DBA - Oracle DBA, Oracle Applications DBA, LINUX,RAC, MSSQL ...

Oracle DBA(database administrator),Oracle Applications DBA - 11i,R12,Oracle RAC (Real Application Cluster),dataguard,streams,pmp(project management professional), CISA,Financial Risk Manager,SQL DBA,SQL Server 2008,MySQL ...

Best Practice for renaming a SQL Server Database

In this tip we look at what steps should be taken to rename both the database as well as logical and physical files names for the database.

Umbraco CMS: Install umbraco on Windows Server 2003

If you cannot log in with SQL Server authentication… •Check the log files after a failed attempt. •The default log location is C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\\ERRORLOG and can be opened with Notepad. ...