|
september 2006 - SQLUG.BE Resource Page
Download this series of developer-oriented videos to view conference breakout sessions about building smart client and browser-based BI solutions leveraging a wide array of extensible capabilities, including key performance indicators, PivotTables, Web parts, and spreadsheet-based Web services Link
This whitepaper describes how to upgrade to Microsoft SQL Server 2005 on your Microsoft CRM 3.0 installation. Download here .
More than 20 free viurtual labs on SQL Server 2005 and Upgrading to SQL Server 2005 .
Here you find some techniques and products that can generate DDL scripts for your database objects and/or INSERT statements for your data. http://www.karaszi.com/SQLServer/info_generate_script.asp
Get Ready for SQL Server 2005 with Microsoft E-Learning. "Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality" A complete...
A PDF file containing the ERD of the SQL Server 2005 system tables Download here .
The DSO/XML Conversion Utility is designed to convert Decision Support Objects (DSO) metadata and objects to/from XML. The DSO object model is an API for creating/modifying Analysis Services objects and this tool is a mechanism for building XML-based “scripts” based on Analysis Services objects. These scripts form a robust data definition...
A complete list of recorded webcasts on SQL Server 2005. Link
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture. Download here .
This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to...
Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server...
SSEUtil.exe is a tool that lets you easily interact with SQL Server. Among other things, it allows you to: • Connect to the main instance or user-instance of SQL Server. • Create, attach, detach, and list databases on the server. • Upgrade database files to match the version of the server. • Execute SQL statements via the console...
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture. Download here .
|