|
March 2007 - SQLUG.BE Resource Page
"This paper outlines the recommended best practices for designing OLAP databases in Microsoft SQL Server 2005 Analysis Services to better meet the functional and performance needs of users. Designing a database for Online Analytical Processing (OLAP) databases is very different from designing a database for Online Transaction Processing...
"This white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system. Each topic describes a feature and best practices. For additional information on the specifics...
The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later. Download here.
Business Intelligence (BI) just became a lot easier! The release of the 2007 Microsoft® Office system, used in conjunction with Microsoft® SQL Server 2005, delivers numerous benefits in terms of Return on Investment (ROI) for a company, design and implementation for its Information Technology (IT) department, and ease of use for...
This document is designed to help customers and partners gain a better understanding of report models for Report Builder, how they work, and how to manage them. This paper applies to SQL Server 2005 Reporting Services only, as the Report Builder and report model functionality are new to this version of the product. This paper is...
Gartner published an update to their Magic Quadrant for Data Warehouse Database Management Systems, 2006 Check out the Magic Quadrant for Business Intelligence Platforms, 1Q07
"Introduced in SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This paper provides a detailed discussion of the index process and provides guidelines and best practices...
An opensource tool which scripts out SQL Server 2000/2005 database objects to individual files in a manner which mimics Microsoft's Visual Studio for Database Professionals [aka, "Data Dude"]. These files can then be placed under proper source management control. http://sourceforge.net/projects/script-sql-db/
Are you using SQL Server Replication? Check out this site, it's loaded with tips, tricks and scripts regarding replication. http://www.replicationanswers.com
This data schema series is designed for new database administrators and enthusiasts to quickly get started learning the basics of managing and administering SQL Server 2005 Express Edition in real-world environments. These fully-functional starter data schemas cover a wide-range of scenarios that are designed to help you quickly...
This video series is designed specifically for SQL Server beginners—individuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases. #1 What is a Database? (28 minutes, 15 seconds) #2 Understanding Database Tables and Records (24 minutes, 56 seconds) #3 More about Column...
|