April 2009 - Technical Rollup Mail - SQL
News Technical RollUp https://blogs.technet.com/trm/default.aspx
Documents With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers. While SQL Trace can be used to satisfy many auditing needs, SQL Server Audit offers a number of attractive advantages that may help DBAs more easily achieve their goals such as meeting regulatory compliance requirements.
Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008 https://msdn.microsoft.com/en-us/library/dd263442.aspx Microsoft.com Engineering Operations (MSCOM Ops), the team responsible for architecting and managing many of the most heavily trafficked Microsoft Web sites, recently documented substantial replication performance improvements for both push and pull subscriptions in Microsoft® SQL Server® 2008 running on Windows Server® 2008—up to 100 times faster than Microsoft SQL Server 2005 running on Windows Server 2003. This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication. Connectivity Options for Microsoft® SQL Server® 2008 Integration Services This white paper provides an overview of the connectivity options that are available with SQL Server 2008 Integration Services. SQL Server 2008 Integration Services supports an ever-expanding range of connectivity options for a wide variety of data sources. New connectors that have an increased the emphasis on performance and the addition of ADO.NET data sources and destinations contribute to making Integration Services an excellent choice for ETL operations. Managing Unstructured Data with SQL Server 2008 This 11-page paper discusses how Microsoft SQL Server 2008 provides a flexible solution for storing unstructured data and combining it with relational data to build comprehensive solutions that encompass the full range of data across an organization. What's New for XML in SQL Server 2008 This 16-page paper discusses how Microsoft SQL Server 2008 builds on the extensive support for XML by extending support for XML schema validation and XQuery, and by enhancing the xml data type. Practical SQL Server 2008 for Oracle Professionals This white paper reviews many of the key comparisons between SQL Server 2008 databases and Oracle databases, and is intended for Oracle professionals looking to extend and use their Oracle knowledge to manage SQL Server. SQL Server Integration Services with Oracle Database 10g https://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/OracleSSIS.docx This paper focuses on the advantages of using SQL Server Integration Services (SSIS) to extract data from heterogeneous sources and import data into Microsoft SQL Server for Business Intelligence (BI) analysis and reporting. Oracle Database 10g data is used as the primary data source. The audience for this paper includes IT professionals, database administrators, and system architects. The reader should have a general understanding of databases and Microsoft SQL Server and Oracle Database 10g. Readers should use the referenced databases on their preferred hardware platform. Downloads Microsoft SQL Server 2005 SP3 Readme Before you install Microsoft SQL Server 2005 Service Pack 3 (SP3), download, extract, and read the SP3 Setup documentation, and review the SP3 Readme files.
Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008 This paper provides an overview, benchmark results, and recommendations for implementing selected Microsoft SQL Server 2008 features that can improve the performance of Microsoft Dynamics CRM 4.0 and secure the CRM database.
Using Analysis Services with the Project Server 2007 Cube Building Service Walks through the process of creating an Analysis Services repository, and then describes the configuration steps necessary for the Project Server 2007 computer and client computers in order to get the Cube Building Service working properly.
SQL Server Data Mining Add-ins for Office 2007 Download SQL Server 2005 Data Mining Add-ins for Office 2007. This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
Microsoft SQL Server Protocol Documentation The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.
System Center Operations Manager 2007 SP1 Documentation This download contains documentation for System Center Operations Manager 2007 SP1.
Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers How to configure Kerberos authentication for Microsoft SQL Server reporting with Enterprise Portal Role Center pages.
Microsoft Dynamics AX 2009 White Paper: Configuring Enterprise Portal and Role Centers with SQL Reporting Checklists and information to help administrators set up and configure Microsoft Dynamics AX 2009 Enterprise Portal and Role Centers with Microsoft SQL Server reporting.
Events/Webcasts
SQL 2008
TechNet Webcast: Migrating Databases from Oracle to SQL Server 2008 (Level 300)
TechNet Webcast: Scaling Online Transaction Processing Applications with SQL Server 2008 (Level 300)
New KB's Other SQL Svr Compact Edtn 3.5 AL: FIX: Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses" https://support.microsoft.com/kb/958478/EN-US
SQL Svr Compact Edtn 3.5 AL: After you execute the SqlCeEngine.Compact method against a SQL Server Compact 3.5 client database that is synchronized to a central database server, some changes to the client database may not be uploaded https://support.microsoft.com/kb/967502/EN-US
SQL 2000 SQL Svr 2000 Desktop Engine: INF: New Switches in MSDE Service Pack 3 Setup (Updated) https://support.microsoft.com/kb/810826/EN-US
SQL Svr Enterprise Edtn 2000 EN: How to impede Windows NT administrators from administering a clustered instance of SQL Server (Updated) https://support.microsoft.com/kb/263712/EN-US
SQL Svr Standard Edtn 2000 EN: BUG: Database maintenance plan on system databases fails on integrity check if "Attempt to repair minor problems" is selected (Updated) https://support.microsoft.com/kb/290622/EN-US
SQL Svr Standard Edtn 2000 EN: MS09-004: Description of the security update for SQL Server 2000 GDR and for MSDE 2000: February 10, 2009 https://support.microsoft.com/kb/960082/EN-US
SQL Svr Standard Edtn 2000 EN: MS09-004: Description of the security update for SQL Server 2000 QFE and for MSDE 2000: February 10, 2009 https://support.microsoft.com/kb/960083/EN-US
SQL Svr Standard Edtn 2000 EN: You cannot apply security update 960082 in a Windows 2000 or Windows Server 2003 environment https://support.microsoft.com/kb/967092/EN-US
SQL Svr Standard Edtn 2000 EN: ISA Server 2004 and ISA Server 2006 may be affected by the security updates in Microsoft Knowledge Base articles 960082 and 960083 https://support.microsoft.com/kb/967094/EN-US
SQL Svr Standard Edtn 2000 EN: SharePoint users are incorrectly offered a SQL Server 2000 Desktop Engine (Windows) update when they try to install the security update in Microsoft Knowledge Base article 960082 https://support.microsoft.com/kb/967096/EN-US
SQL 2005 SQL Server 2005 Service Pack 2: MS09-004: Vulnerabilities in Microsoft SQL Server could allow remote code execution https://support.microsoft.com/kb/959420/EN-US
SQL Server 2005 Service Pack 2: MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009 https://support.microsoft.com/kb/960089/EN-US
SQL Server 2005 Service Pack 2: MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009 https://support.microsoft.com/kb/960090/EN-US
SQL Server 2005 Service Pack 2: The Windows Internal Database (WYukon) is removed when you use the Add or Remove Programs item in Control Panel to uninstall a security update for SQL Server 2005 https://support.microsoft.com/kb/967095/EN-US
SQL Svr 2005 Analysis Svcs EN: How to configure SQL Server 2005 Analysis Services to use Kerberos authentication (Updated) https://support.microsoft.com/kb/917409/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run some Multidimensional Expressions (MDX) queries that reference some calculated members in many connections at the same time in SQL Server 2005 Analysis Services: "An unexpected error occurred" https://support.microsoft.com/kb/960971/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run a Multidimensional Expressions (MDX) query that contains a calculation in SQL Server 2005 Analysis Services: "An unexpected exception occurred" https://support.microsoft.com/kb/960977/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: You cannot connect to an instance of SQL Server 2005 Analysis Services through HTTP when you configure Internet Explorer to use a .pac file https://support.microsoft.com/kb/961146/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: A syntax error occurs when you try to use the lift chart to validate a mining model that uses an Oracle data source in SQL Server 2005 Analysis Services https://support.microsoft.com/kb/961920/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you synchronize a database in SQL Server 2005 Analysis Services: "Errors in the metadata manager. The dimension with ID of '<Dimension ID>', Name of '<Dimension Name>' referenced by the '<Cube Name>' cube, does not exist" https://support.microsoft.com/kb/967625/EN-US
SQL Svr 2005 Reporting Svcs EN: FIX: You are prompted to provide the credentials when you view a history snapshot for a SQL Server 2005 Reporting Services report if you use stored credentials for the data source of the report https://support.microsoft.com/kb/967180/EN-US
SQL Svr 2005 Reporting Svcs EN: Error message when you try to print a SQL Server 2005 Reporting Services report on a client computer: "Unable to load client print control" https://support.microsoft.com/kb/967511/EN-US
SQL Svr 2005 Reporting Svcs EN: FIX: Error message when you try to export a report to a PDF file in SQL Server 2005 Reporting Services: "Non-negative number required" https://support.microsoft.com/kb/967618/EN-US
SQL Svr Developer Edtn 2005 EN: How to use Kerberos authentication in SQL Server (Updated) https://support.microsoft.com/kb/319723/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to resolve permission issues when you move a database between servers that are running SQL Server (Updated) https://support.microsoft.com/kb/240872/EN-US
SQL Svr Enterprise Edtn 2005 EN: 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 (Updated) https://support.microsoft.com/kb/283811/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to move databases between computers that are running SQL Server (Updated) https://support.microsoft.com/kb/314546/EN-US
SQL Svr Enterprise Edtn 2005 EN: How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port (Updated) https://support.microsoft.com/kb/823938/EN-US
SQL Svr Enterprise Edtn 2005 EN: You may not be able to connect to an instance of SQL Server by using an anonymous login (Updated) https://support.microsoft.com/kb/839569/EN-US
SQL Svr Enterprise Edtn 2005 EN: SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update (Updated) https://support.microsoft.com/kb/957008/EN-US
SQL Svr Express Edtn 2005 EN: Error message when you use the SQL Server Error and Usage Reporting tool on a 64-bit Windows operating system: "The Error Reports Location path name cannot be empty" https://support.microsoft.com/kb/967598/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server service cannot start when you change a startup parameter for a clustered instance of SQL Server 2000 or of SQL Server 2005 to a value that is not valid (Updated) https://support.microsoft.com/kb/912397/EN-US
SQL Svr Standard Edtn 2005 EN: How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005 (Updated) https://support.microsoft.com/kb/917825/EN-US
SQL Svr Standard Edtn 2005 EN: You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005 (Updated) https://support.microsoft.com/kb/917828/EN-US
SQL Svr Standard Edtn 2005 EN: Error message when you install SQL Server 2005 or SQL Server 2008: "The file C:\Windows\Microsoft.NET\Framework\[version_number]\mscorlib.tlb could not be loaded" (Updated) https://support.microsoft.com/kb/918685/EN-US
SQL Svr Standard Edtn 2005 EN: The use of third-party detours or similar techniques is not supported in SQL Server (Updated) https://support.microsoft.com/kb/920925/EN-US
SQL Svr Standard Edtn 2005 EN: How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult (Updated) https://support.microsoft.com/kb/932881/EN-US
SQL Svr Standard Edtn 2005 EN: Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service (Updated) https://support.microsoft.com/kb/942176/EN-US
SQL Svr Standard Edtn 2005 EN: You cannot restore a database from a backup file when you use a SQL Server login ID that has the dbcreator server role to connect to an instance of SQL Server 2005 https://support.microsoft.com/kb/950891/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 8 for SQL Server 2005 Service Pack 2 (Updated) https://support.microsoft.com/kb/951217/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you install Cumulative Update 10, Cumulative Update 9, or security update 954606 (security bulletin MS08-052) for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system: "Unexpected Error Occurred" (Updated) https://support.microsoft.com/kb/959132/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released (Updated) https://support.microsoft.com/kb/960598/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The SQL Server service stops when you run one of the DBCC CHECK commands on a SQL Server 2005 database or when you create a database snapshot for a SQL Server 2005 database https://support.microsoft.com/kb/961123/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You cannot kill a session that is running a query on a linked server in SQL Server 2005 (Updated) https://support.microsoft.com/kb/961237/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you insert a string to a table by using the SQL Native Client (SNAC) OLE DB provider or the SNAC ODBC provider in a SQL Server 2005-based application, the string is truncated https://support.microsoft.com/kb/961396/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An unresolved deadlock occurs when you perform an online reindex operation that runs on parallel threads in SQL Server 2005 https://support.microsoft.com/kb/961479/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The tempdb database is corrupted when you start some transactions that use the snapshot isolation level on a database that has row versioning enabled in SQL Server 2005 https://support.microsoft.com/kb/961739/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 2 for SQL Server 2005 Service Pack 3 https://support.microsoft.com/kb/961930/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A query notification is not fired correctly if the query contains inner joins and the IS NULL clause in SQL Server 2005 https://support.microsoft.com/kb/961935/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you synchronize data for a SQL Server Compact Edition subscriber in SQL Server 2005: "A call to SQL Server Reconciler failed. Try to resynchronize. HRESULT 0x80004005 (29006)" https://support.microsoft.com/kb/962003/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005: "The Database ID <Database ID>, Page (<N>:<N>), slot <N> for LOB data type node does not exist" https://support.microsoft.com/kb/962209/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 12 for SQL Server 2005 Service Pack 2 (Updated) https://support.microsoft.com/kb/962970/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The execution plan does not use the forced index when you use the INDEX optimizer hint in a query that runs against a synonym in SQL Server 2005 https://support.microsoft.com/kb/963684/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you run an UPDATE statement against a table that has a FOR UPDATE trigger that joins the DELETED and INSERTED tables, the query takes a long time to finish https://support.microsoft.com/kb/967169/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you open Replication Monitor for a transactional publication in SQL Server 2005: "Initial snapshot for publication <PublicationName> is not available" https://support.microsoft.com/kb/967192/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The values of some SQL Server 2005 SSIS pipeline counters are always 0 when you try to view them in a terminal session https://support.microsoft.com/kb/967316/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you apply a snapshot file that is exactly divisible by 1 MB in SQL Server 2005: "The process could not bulk copy into table dbo.<tablename>. (Source: MSSQLServer, Error number: 20253)" https://support.microsoft.com/kb/967527/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An empty result set is returned when you run an SSIS package that contains an Execute SQL task in SQL Server 2005 Service Pack 2 https://support.microsoft.com/kb/967570/EN-US
SQL Svr Std Edtn 2005 64Bit EN: The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005 (Updated) https://support.microsoft.com/kb/941154/EN-US
SQL 2008 SQL Svr Enterprise 2008 EN: Microsoft SQL Server Database Engine Input/Output Requirements https://support.microsoft.com/kb/967576/EN-US
SQL Svr Standard 2008 EN: When you attempt to install SQL Server 2008 from DVD, the Full Text Search Installation may fail if you have installed SQL Server 2008 Express Edition previously |