SQL Server 2008 Solutions – Your Data, Any Place, Any Time
Microsoft SQL Server 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization.
SQL Server 2008 Solutions – Redefining Pervasive Insight
SQL Server 2008 Business Intelligence platform provides a scalable BI platform optimized for data integration, reporting, and analysis enabling organizations to deliver intelligence where users want it.
Delivering on the data platform vision, Microsoft continues to invest in and evolve pervasive insight which allows customers to deliver real-time insight broadly and deeply within their organizations, with rich and personalized data experiences. Spend 10 minutes with Tom Casey, General Manager, Microsoft SQL Server to learn about how SQL Server 2008 delivers pervasive insight across the organization.
SQL Server 2008 Reporting Services – Delivering Relevant Information across the Enterprise
Microsoft® SQL Server™ 2008 Reporting Services provides a complete server-based platform designed to support and the entire enterprise reporting lifecycle enabling organizations to deliver relevant information where needed across the entire enterprise.
Microsoft Is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing
“In my opinion, this report is a strong statement about Microsoft’s continued commitment to providing a comprehensive data platform that scales with the needs of enterprise applications and data storage requirements,” said Ted Kummert, corporate vice president of the Data and Storage Platform Division at Microsoft. “Customers such as Danske Supermarket, PREMIER Bankcard and TDC are using the data warehousing functionality of SQL Server 2005 and are seeing amazing business results. With the upcoming release of SQL Server 2008, customers will realize even greater innovations designed to help them access, manage and utilize their business data.”
Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks
The TPC-E benchmark simulates the OLTP workload of a brokerage firm. The focus of the benchmark is the central database that executes transactions related to the firm’s customer accounts. Although the underlying business model of TPC-E is a brokerage firm, the database schema, data population, transactions, and implementation rules have been designed to be broadly representative of modern OLTP systems.
SQL Server 2008 Product Overview
For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The data platform vision of Microsoft helps organizations meet these data explosion needs and the next generation of data-driven applications. Microsoft will continue to invest in and evolve the following key areas to support their data platform vision: mission-critical enterprise data platform, dynamic development, relational data, and business intelligence. Read this paper to learn about the Microsoft Data Platform Vision and how SQL Server 2008 meets the needs of the next generation of data-driven applications.
Business Intelligence in SQL Server 2008
Microsoft SQL Server 2008 makes business intelligence (BI) available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. The result is that employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful. Integration with the 2007 Microsoft Office System enables users to view business performance in a way that they understand and which feels comfortable; and the introduction of PerformancePoint Server 2007, helps customers to gain actionable insight into the entire organization so they can monitor, analyze, and plan their businesses, as well as drive alignment, accountability, and actionable insight across the entire organization.
Microsoft SQL Server 2008 and Microsoft Data Platform Development
Microsoft SQL Server 2008 and the Microsoft data platform provide developers with a comprehensive programming framework in which to create data centric solutions that target mobile devices, desktops, Web servers, and enterprise servers. This data programming environment improves developer productivity by integrating data access and management into the business logic of an application. It provides a comprehensive platform for data access and management from disparate data sources and a scalable solution for data storage and applications.
Online Transaction Processing in SQL Server 2008
Microsoft SQL Server 2008 provides a database platform that is optimized for today’s applications, and that can scale for any size of business. It drives cost-efficiencies by dramatically reducing downtime and enabling dynamic and proactive management that significantly reduces administrative overhead. Finally, SQL Server 2008 provides a highly secure platform that you can trust with your organization’s sensitive, business-critical data.
Server Consolidation with SQL Server 2008
Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services management and reduce hardware and maintenance costs. By providing centralized management, auditing, and monitoring capabilities, SQL Server 2008 makes it easy to manage multiple databases and data services, which significantly reduces administrative overheads in large enterprises. Finally, SQL Server 2008 provides the reassurance of industry-leading performance and scalability, and unprecedented control over server resource to maximize the performance of consolidated data services.
White Paper: Precision Considerations for Analysis Services Users
This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due to the fact that Analysis Services caches query results and the imprecision that is associated with approximate data types. This white paper discusses how these issues manifest themselves, why they occur, and best practices to minimize their effect.
Microsoft technology helps New Zealand banks take mobile payments
Paymark operates New Zealand’s Electronic Funds Transfer at Point of Sale (EFTPOS) infrastructure. Paymark’s two key functions are to authenticate credit and debit card payments and transfer funds to retailers’ bank accounts at the point of sale. The company wanted to extend the service to a wider range of merchants by introducing a remote payments capability, enabling consumers to make real-time bill payments using their mobile phones. Paymark selected Microsoft Certified Partner M-Com’s PayAnywhere mobile payments solution built on the Microsoft® .NET Framework. The flexible and seamless Microsoft development environment allowed the solution to be created quickly and cohesively. This provided cost savings and enabled Paymark to get the solution to market faster. The Paymark Remote service, as it is known, allows Paymark’s customers to offer mobile payment services to New Zealand consumers through their mobile phones.
EMEA Case Study Resources
Word documents and PowerPoint presentations for GCRP
SQL Server 2000: Performance Tuning and Optimization Datasheet
This 4-day workshop provides information on SQL 2000 index and page structures, performance troubleshooting tools, memory architecture, programming efficiency, and optimization techniques.
SQL Server 2005: Performance Tuning and Optimization Datasheet
This 4-day delivery provides participants with in-depth technical knowledge on performance tuning and optimization techniques for SQL Server 2005. Performance tools such as SQLdiag and Performance Monitor are covered in detail.
SQL Server White Papers: Migration from Oracle or Sybase to Microsoft SQL Server
Guide to Migrating from Oracle to SQL Server 2005
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant for Oracle (SSMA Oracle) is explained in depth, with a special focus on converting database objects and PL/SQL code.
Guide to Migrating from Sybase ASE to SQL Server 2005
This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2005. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant for Sybase, the best tool for this type of migration, can help resolve various migration issues.
Aligning Business and IT for Greater Corporate Agility (through SOA)
For a very long time, IT and Business has communicated. While they may be speaking in the same language, are they speaking in the same “dialect”? In this session, William Tay will share his field experience as well as explore Microsoft’s vision for service-oriented architecture:
- what are the best implementation approaches so that instead of being led by the business, IT strategies are driven by business needs
- how Microsoft supports this vision by way of an integrated platform, etc.
Singapore Public Sector – Connected Government Framework
Many of Microsoft’s government customers are working on the challenges associated with creating a SOA environment and the delivery of electronic services (e-services). This session showcases the vision and value of the Microsoft Connected Government Framework (CGF), designed to help Government customers cost-effectively design, deploy and manage e-Government Interoperability solutions. With the ability to integrate with a variety of existing and legacy systems and applications based on industry standards (such as XML, HTTP, and Web services) the Microsoft Connected Government Framework gives customers the flexibility of leveraging their existing investments.
In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver with SQL Server 2005. The SQL Server 2005 JDBC Driver 1.2 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition). This release of the JDBC Driver is JDBC 3.0 compliant and runs on the Java Development Kit (JDK) version 1.4 and higher. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, JBoss, and Sun.
SQL Server 2005 Driver for PHP Community Technology Preview (October 2007)
In its continued commitment to interoperability, Microsoft has released a new SQL Server 2005 Driver for PHP. The SQL Server 2005 Driver for PHP Community Technology Preview (CTP) download is available to all SQL Server users at no additional charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2000.
Events / WebCasts
SQL 2005 Webcasts and Virtual Labs
SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.
TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Part 1 of 3): Your First Project with SQL Server Data Mining (Level 200) – Thursday, November 01, 2007
8:00 AM Pacific Time (US & Canada)
Many users are intrigued and excited to see data mining available in the Microsoft SQL Server product, but many don’t know how to start using these features. In this webcast, we lead you through the first steps to success for your data mining projects. We look at the overall architecture of data mining and the kinds of problems that can be solved. We also look at important points for your first project, such as choosing the right algorithms and testing your mining models.
MSDN Webcast: Building Spatial Applications with SQL Server 2008 (Level 300) – Thursday, November 01, 2007 9:00 AM Pacific Time (US & Canada)
Microsoft SQL Server 2008 delivers new spatial data types that enable you to consume, use, and extend location-based data through spatial-enabled applications. Attend this webcast to learn how to use spatial functionality in next version of SQL Server to build and optimize spatial queries.
TechNet Webcast: SQL Server 2008 Performance and Scalability Technologies (Level 300) – Thursday, November 01, 2007 9:30 AM Pacific Time (US & Canada)
Microsoft SQL Server 2008 supports very large databases, enterprise-scale reporting systems, and data warehouses. It provides growing database systems with tools and features to optimize performance, scale up individual servers, and scale out very large databases. SQL Server 2008 is designed to take advantage of the latest hardware technologies to support server consolidation. Throughout this presentation, we look into SQL Server 2008 performance and scalability technologies and show how you can use these technologies to provide optimal performance and responsiveness for your large data solutions.
TechNet Webcast: Rich Report Design with SQL Server 2008 Reporting Services (Level 200) – Thursday, November 01, 2007 1:00 PM Pacific Time (US & Canada)
Join this webcast to learn more about the report authoring capabilities to be delivered with Microsoft SQL Server 2008 Reporting Services. We provide a deep dive on designing reports with SQL Server 2008 Reporting Services. Learn about all of the new features and usability enhancements in report design. Have you heard about Tablix? Come find out exactly what it is and how it will make report authoring much easier and more powerful.
MSDN Webcast: Build Smart Web Applications with SQL Server Data Mining (Level 200) – Friday, November 02, 2007 11:00 AM Pacific Time (US & Canada)
Web applications typically generate large quantities of data, often capturing important aspects of your customers’ behavior. What you may not realize is that this data can be excellent for data mining, and the results can be extremely useful in building out smarter applications and Web interfaces. In this session, we introduce the concept of a “smart application” and walk through specific examples of how to build these compelling technologies in for your own Web audience.
MSDN Webcast: Building Adaptive Applications with SQL Server Data Mining (Level 300) – Thursday, November 08, 2007 1:00 PM Pacific Time (US & Canada)
There are many interesting and well-known uses of data mining for business analysis. However, for the application developer, data mining can also be useful for building adaptive, “intelligent” applications. In this webcast, we demonstrate how to build a simple application with Microsoft SQL Server Data Mining that collects data about usage as it goes along, and then uses that data to offer smart defaults—a truly adaptive application.
Momentum Webcast: A “Sneak Peek” Overview of SQL Server 2008 (Level 100) – Tuesday, November 13, 2007 11:00 AM Pacific Time (US & Canada)
Join us for this Microsoft SQL Server 2008 webcast to learn all about its new features. SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable, and scalable for your mission-critical applications. We explain how SQL Server 2008 enables developers to create new applications that can store and consume any type of data on any device, empowering all your users to make informed decisions with relevant insights. For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The Microsoft data platform vision enables organizations to meet these data explosion needs and the next generation of data-driven applications. Discover how SQL Server 2008 can help you get the right information to the right people in the right format on the right device.
MSDN Webcast: SQL Server 2008 Advanced Troubleshooting with Extended Events (Level 200) – Wednesday, November 14, 2007 9:00 AM Pacific Time (US & Canada)
Diagnosing production issues affecting Microsoft SQL Server can be difficult and time consuming. Microsoft SQL Server 2008 introduces Extended Events, which provide deep visibility into the inner workings of SQL Server and give the power to diagnose what were once impossible problems while having minimal impact on a running system. In this webcast, we introduce the SQL Server Extended Events features, describe the architecture of Extended Events, and explain how you can use Extended Events to diagnose real issues.
Microsoft Webcast: Business Solutions with SQL Server 2008 (Level 100) – Wednesday, November 14, 2007 11:00 AM Pacific Time (US & Canada)
Learn more about how Microsoft SQL Server 2008 provides customers with a trusted, productive, and intelligent platform for business applications. See how SQL Server 2008 can be used to provide a reliable platform with lower cost for key business scenarios like business intelligence, data warehousing, mission-critical applications, and server consolidation.
TechNet Webcast: Deliver Actionable Insight Throughout Your Organization with Data Mining (Part 2 of 3): Understand SQL Server Data Mining Add-ins for the 2007 Office System (Level 200) – Thursday, November 15, 2007 11:30 AM Pacific Time (US & Canada)
Microsoft SQL Server Data Mining Add-ins for Excel empower information workers with an easy-to-use, yet remarkably complete, set of tools for predictive analysis, directly within their tool of choice – Microsoft Office Excel. Attend this webcast to understand how add-ins can enable your employees to utilize this simple and powerful technology to perform advanced analysis.
Further on-demand webcasts are available here: http://www.microsoft.com/events/series/technetsqlserver2005.mspx
SQL Server 2000 Standard Edition
FIX: The CPU utilization may suddenly increase to 100 percent when there are many connections to an instance of SQL Server 2000 on a computer that has multiple processors
FIX: You cannot capture a dump file for some issues that occur when SQL Server 2000 runs out of virtual memory
FIX: You cannot stop the SQL Server service, or many minidump files and many log files are generated in SQL Server 2000
SQL Server 2005 Standard Edition
FIX: The process stops responding when you run an SSIS package that contains a Flat File destination in x64 versions of Microsoft SQL Server 2005
FIX: Error message when you run the CREATE ASSEMBLY statement to register a CLR assembly in SQL Server 2005: “An error occurred while gathering metadata from assembly ‘<AssemblyName>’ with HRESULT 0x80131”
FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: “The XML data type is damaged”
FIX: Error message when you try to delete some stored procedures concurrently in SQL Server 2005: “Temp table deferred drop doesn’t scale for certain workloads”
FIX: Error message when you run the BULK INSERT statement in Microsoft SQL Server 2005: “The bulk load failed. The column is too long in the data file for row <n>, column <n>”
Error message when an application connects to SQL Server on a server that is running Windows Server 2003: “General Network error,” “Communication link failure,” or “A transport-level error”
How to determine the version of SQL Server 2005 Integration Services
Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service
FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: “Error 137, Must declare the scalar variable <VariableName>”
FIX: High CPU usage occurs periodically on a subscriber when you synchronize a merge publication in SQL Server 2005
FIX: You cannot connect to an instance of SQL Server 2005, and an error message is logged in the SQL Server error log
FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005
FIX: Error message when you use the SQL Server Native Client OLE DB provider to connect to an instance of SQL Server 2005: “Conversions not allowed using bcp_moretext”
FIX: You receive a time-out error message when you try to send a message to the target service of a Service Broker application that you create in SQL Server 2005
FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005
Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: “ERROR Selected writer ‘Microsoft Writer (Service State)’ is in failed state”
FIX: SQL Server Agent replaces the A_DBN token with “master” in a job that responds to a database alert in SQL Server 2005
FIX: The query performance is slower when you run the query in SQL Server 2005 than when you run the query in SQL Server 2000
FIX: After you enable the Address Windowing Extensions (AWE) feature in SQL Server 2005, access violations may occur, and SQL Server 2005 may stop responding
How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult
FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: “Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0”
FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: “21997 Failed to allocate new identity range”
Cumulative update package 5 for SQL Server 2005 Service Pack 2
Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server
FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005
FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: “Column ‘<ColumnName>’ value is out of range for data type ‘float'”
FIX: Only the import operation of the first batch is minimally logged when you import the data in multiple batches in SQL Server 2005
FIX: Error message when you use the “bcp_sendrow” function in a SQL Server 2005-based application that uses a SQL Native Client provider: “For BCP, all variable-length data must have either a length-prefix or a terminator specified”
FIX: When you run a stored procedure that uses some views in SQL Server 2005, the performance is slow compared to SQL Server 2000 if the views use the JOIN operator and contain subqueries
Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: “Unable to update password policy”
FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility
FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: “Data conversion failed” and “SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR”
FIX: Some events are not logged correctly when you enable SQL Server event forwarding on a SQL Server Agent of SQL Server 2000 to forward events to SQL Server 2005
FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs
You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005
SQL Server 2005 Analysis Services
Error message when you run an MDX query against a dimension cube in SQL Server 2005 Analysis Services: “The $<DimensionCube_Name> cube either does not exist or has not been processed”
FIX: The Analysis Services service stops unexpectedly when you run a Multidimensional Expressions query that uses unary operators on a dimension in SQL Server 2005 Analysis Services
FIX: A Multidimensional Expressions query that contains a FILTER function returns an incorrect result in SQL Server 2005 Analysis Services
FIX: Event ID 22 is logged in the Application log when you process an object in a database in SQL Server 2005 Analysis Services
An MDX query returns additional cell data when you use the IsEmpty function on the query axis in Analysis Services with SQL Server 2005 Service Pack 2
FIX: Error message when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services: “Internal error An unexpected exception occured”
An MDX query that contains an Aggregate function returns #Error for the cell values in SQL Server 2005 Analysis Services
A cube is not modified when you process the cube by using the ProcessDefault option in SQL Server 2005 Analysis Services
SQL Server 2005 Reporting Services
FIX: In Reporting Services together with SQL Server 2005 Service Pack 2, the “Save As Report” dialog box stops responding, or the “Open Report” dialog box stops responding in Report Builder
FIX: The content of a group is displayed incorrectly when you change a parameter and then you click a toggle image in SQL Server 2005 Reporting Services
FIX: Error message when you display a parameterized report in a Report Viewer Web part in SQL Server 2005 Reporting Services: “Object reference not set to an instance of an object”
FIX: An object data source may not appear in the Website Data Sources window when you try to set the object data source for a SQL Server 2005 Reporting Services report in Visual Studio 2005
FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2
FIX: Error message when you try to build or to deploy a report server project of SQL Server 2005 Reporting Services: “This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms”
FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale