James BI 園地

How-to's
 Analysis Services

• 919160 - How to enable the snapshot transaction isolation level in SQL Server 2005 Analysis Services
• 919711 - How to configure SQL Server 2005 Analysis Services to generate memory dump files
• 933032 - How to hide a dimension name when no members are visible for a security role in SQL Server 2005 Analysis Services
• 933837 - How to make an MDX query return a value in the numeric format in SQL Server 2005 Analysis Services

Integration Services

• 906547 - How to create a dynamic subject or message for the Send Mail task in SQL Server 2005 Integration Services
• 906560 - How to write information to the Application event log by using a Script task in a SQL Server 2005 Integration Services package
• 906562 - How to use the dtutil utility (Dtutil.exe) to set the protection level of a batch of SQL Server Integration Services (SSIS) packages in SQL Server 2005
• 906563 - How to interpret data that is logged by using a SQL Server 2005 Integration Services log provider
• 906564 - How to use SQL Server Business Intelligence Development Studio or the dtutil utility to regenerate the package ID of an SSIS package that was duplicated
• 908460 - How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data Flow task
• 911838 - How to measure the rate at which rows pass through a particular data flow task in a SQL Server 2005 Integration Services (SSIS) package
• 912911 - How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step
• 913967 - How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005
• 934653 - How to use the 64-bit SQL Server Agent to schedule a SQL Server 2005 Integration Services package
• 941151 - How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions
• 942177 - How to determine the version of SQL Server 2005 Integration Services

Reporting Services

• 842425 - How to move a Reporting Services database from a computer that is running Reporting Services to another computer
• 934162 - How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows
• 934163 - How to upgrade SQL Server 2005 Reporting Services on a Windows Vista-based computer
• 934164 - How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
• 938245 - How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"

backup and restore

• 253817 - How to back up the last transaction log when the master and the database files are damaged in SQL Server
• 930615 - How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005

accounts

• 283811 - How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in SQL Server 2005
• 911839 - How to change the SQL Server 2005 service accounts by using the Windows Management Instrumentation (WMI) Provider for Configuration Management
• 937682 - How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism
• 936492 - How to use Windows Management Instrumentation in SQL Server 2005 to change the account of the SQL Server service or the password of the SQL Server service programmatically

connectivity

• 265808 - How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server
• 823938 - How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port
• 244980 - How to change the network IP addresses of SQL Server failover cluster instances
• 318605 - How SQL Server uses a certificate when the Force Protocol Encryption option is turned on

replication

• 953199 - How to configure and troubleshoot the SubscriptionStreams parameter of the Distribution Agent in SQL Server 2005
• 956600 - How to use the SubscriptionStreams parameter of Distribution Agent to test for improved disk subsystem throughput in SQL Server 2005

Miscellaneous

• 912914 - How to use a stored procedure to monitor traces in SQL Server 2005
• 294209 - How to rebuild or move a MSDTC installation to be used with a SQL failover cluster
• 811889 - How to troubleshoot the "Cannot generate SSPI context" error message
• 907511 - How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005
• 295732 - How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed
• 923398 - How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Longhorn Server-based computer
• 237980 - How to convert an Access database to SQL Server
• 306397 - How to use Excel with SQL Server linked servers and distributed queries
• 315521 - How to troubleshoot SQL Server merge replication problems
• 931975 - How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007
• 827968 - How to estimate the size of a SQL Server CE or SQL Server 2005 Mobile Edition database
  
   
• 198891 - How to run a DLL-based COM object outside the SQL Server process
• 231619 - How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
• 271509 - How to monitor blocking in SQL Server 2005 and in SQL Server 2000
• 319716 - How to populate a SQL Server 2005 database by using information from Active Directory
• 908360 - How to configure SQL Server Agent to send job status notifications and alert notifications in SQL Server 2005 64-bit editions
• 908018 - How to create a package template in SQL Server Business Intelligence Development Studio
• 906566 - How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005
• 907877 - How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005
• 912426 - How to detect the status of the SQL Server Express service or start the SQL Server Express service by using Visual Basic or Visual C#
• 914288 - How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server 2005
• 916784 - How to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services
• 919157 - How to display a report that contains a subreport by using the ReportViewer control in Visual Studio 2005
• 928907 - How to improve concurrency in a SQL Server 2005 application by using built-in functions
• 918483 - How to reduce paging of buffer pool memory in the 64-bit version of SQL Server 2005
• 945934 - How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008
• 953200 - How to migrate SQL Server 2005 Service Pack 2 failover clustered instances from Windows Server 2003 Service Pack 2 to Windows Server 2008

Further reading

• MSDN Library: SQL Server 2005 Express Edition User Instances
• Automating Database maintenance in SQL 2005 Express Edition - Part I
• Automating Database maintenance in SQL 2005 Express Edition - Part II
• MSDN Library: Integrating Reporting Services into Your Application

 

 

 

 

 

請大家永躍參與Facebook MSBI 粉思團:http://www.facebook.com/#!/group.php?gid=303757165010