April 2010 - Technical Rollup Mail - SQL
News
Awareness of Issue: On a computer that has a multicore processor, if the ratio of logical processors to physical sockets is not a power of 2, you cannot install SQL Server 2005 - https://support.microsoft.com/kb/954835
Blog by Bob Dorr
Other
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Downloads
SQL 2005
SQL Server JDBC Driver 3.0
Download the SQL Server JDBC Driver 3.0 CTP, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and the performance testing results for each technique.
SQL 2008
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.
Microsoft Connectors v1.1 for Oracle and Teradata
Download the SSIS Connectors Version 1.1 for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2008.
Events/Webcasts
In the previous installment of our series, we looked at the solution architecture within the Microsoft Visual Studio 2005 Team Edition for Database Professionals and described the tools you can use to manage changes to the schema and version control. Complete the series by attending this second webcast, as we dive into testing our schema and database code. We examine the features in Team Edition for Database Professionals that help you manage and validate application schema. We also look at generating test data, creating unit test plans, and more as we explore the capabilities of this exciting addition to the Microsoft Visual Studio 2005 Team Suite.Presenter: Mike Benkovich, Developer Evangelist, Microsoft CorporationMike Benkovich is a database technology specialist and a Microsoft developer community champion based in Minneapolis, Minnesota. Focusing on the effective use of relational technologies for scalable, high-performance, and mission-critical applications, Mike has worked as an architect, project manager, developer, and technical writer. He speaks regularly at technical conferences and corporations. View other sessions from SQL Server 2005: Discover the Next Paradigm for Database Development. If you have questions or feedback, contact us. ...
2/15/2007 6:00 PM Pacific Time (US & Canada)- 2/14/2011 12:00 AM | Duration:58 Minutes
Microsoft offers an array of Online Analytical Processing (OLAP) APIs for everything from developing top-notch dedicated OLAP applications to just adding OLAP functionality to your existing applications. In this webcast, we cover the ADOMD.NET object model for OLAP data access, the Analysis Management Objects (AMO) library for OLAP database management, and XMLA for a SOAP-based combination of the two. We also look at AdomdServer, which makes it possible to store Microsoft .NET common language runtime (CLR) procedures and functions for your OLAP cubes. Join this session to learn how to write applications and queries that take full advantage of the OLAP capabilities in Microsoft SQL Server 2005.Presenter: Andrew J. Brust, Chief, New Technology , twentysix New YorkAndrew Brust is chief of new technology at twentysix New York, a Microsoft Gold Certified Partner. With more than 18 years of experience programming and consulting, Andrew is the Microsoft Regional Director for New York and New Jersey, a Microsoft Most Valuable Professional (MVP) for Microsoft Visual Basic, and a member of the Microsoft Business Intelligence Partner Advisory Council. Andrew coauthored Programming Microsoft SQL Server 2005 (Microsoft Press, 2006). A highly rated speaker at international conferences, Andrew is vice-chairman of the New York Software Industry Association (NYSIA) and a member of the International .NET Association Speaker Bureau. To avoid possible problems, we suggest you temporarily disable pop-up blocker software before viewing the webcast. View other sessions from SQL Server 2005: Discover the Next Paradigm for Database Development. Register to view this on-demand webcast and download a .wmv of the webcast now. By registering, you will also receive a confirmation email the following day with a link to the PowerPoint download.If you have questions or feedback, contact us. ...
12/19/2006 7:00 PM Pacific Time (US & Canada)- 12/18/2010 12:00 AM | Duration:94 Minutes
MSDN Webcast: SQL Server 2005 Express Tips and Tricks (Level 200)
Sometimes even the most seasoned developers need helpful advice to make their jobs easier and their products better. Attend this webcast to learn some of these practical tips and tricks for Microsoft SQL Server 2005 Express Edition, the free database offering from Microsoft. In this session, we cover topics such as writing SELECT statements and reading query plans, using the SqlClient namespace, stored procedures, error handling, and transactions.Presenter: Bill Graziano, Microsoft SQL Server Most Valuable Professional, ClearData Consulting View other sessions from SQL Server: Upgrade Your Skills To 2005. If you have questions or feedback, contact us. ...
3/6/2007 5:00 PM Pacific Time (US & Canada)- 3/5/2011 12:00 AM | Duration:68 Minutes
MSDN Webcast: SQL Server MasterClass: Tuning Your SQL Server 2005 Database (Level 200)
Relational databases enable us to capture and manage large amounts of information. When the data grows and the application slows, what can you do to make it right? In this webcast, learn tips and tricks for tuning your Microsoft SQL Server 2005 database using the tools at your disposal. We also show you techniques that can help you identify the real cause of the problem and where to look next.Presenter: Mike Benkovich, MSDN Developer Evangelist, Microsoft CorporationMike Benkovich is a database technology specialist and a Microsoft developer community champion based in Minneapolis, Minnesota. Focusing on the effective use of relational technologies for scalable, high-performance, and mission-critical applications, Mike has worked as an architect, project manager, developer, and technical writer. He speaks regularly at technical conferences and corporations.To avoid possible problems, we suggest you temporarily disable pop-up blocker software before viewing the webcast.View other sessions from SQL Server 2005: Discover the Next Paradigm for Database Development. Register to view this on-demand webcast and download a .wmv of the webcast now. By registering, you will also receive a confirmation email the following day with a link to the PowerPoint download. If you have questions or feedback, contact us. ...
11/13/2006 7:00 PM Pacific Time (US & Canada)- 11/12/2010 12:00 AM | Duration:65 Minutes
MSDN Webcast: Top 10 Dynamic Management Views in SQL Server 2005 (Level 200)
Join this session as we provide an overview of Dynamic Management Views (DMVs) now available in Microsoft SQL Server 2005. In this webcast, presenter Greg Low shares details on the 10 DMVs he considers most useful. We demonstrate how each of these top 10 DMVs might be used in a production environment, with an emphasis on performance tuning or troubleshooting applications. We also describe how you can use these DMVs for ongoing server monitoring.Presenter: Greg Low, Consultant, ReadifyThe lead consultant for Microsoft SQL Server 2005 with Readify, Greg Low is an internationally recognized consultant, developer, and trainer. He is a Microsoft SQL Server MVP, an MSDN Regional Director for Australia, and host of the "SQL Down Under" podcast. Greg has been working in development since 1978 and holds a PhD in computer science. He is also president of the Queensland MSDN Users Group and the Queensland SQL Server Users Group. View other sessions from: SQL Server 2005: Discover the Next Paradigm for Database Development.If you have questions or feedback, contact us. ...
5/25/2007 9:00 PM Pacific Time (US & Canada)- 5/24/2011 12:00 AM | Duration:69 Minutes
TechNet Webcast: Deploying Kronos Workforce Management Solutions Using SQL Server 2008 (Level 200)
Kronos Workforce Central is one of the most widely deployed solutions used for employee management in nearly every industry. Using Microsoft SQL Server 2008 database software to power Workforce Central lets you take full advantage of the capabilities of Workforce Central, and you can use the built-in data mining capabilities and reporting features in SQL Server 2008 to gain insights into your labor force that were previously hidden. In this webcast, we discuss why SQL Server 2008 should be your choice for deploying Kronos, and we talk about some of the technical considerations for deploying Workforce Central using SQL Server 2008. Presenters: Allan Hirt, SQL Server MVP, Megahirtz, Anu Chawla, Director, Microsoft Corporation and Daniel Pronley, Director Pre-Sales Technology, Kronos Incorporated Allan Hirt has been using Microsoft SQL Server since 1992, while on a college internship at Sybase, and he has worked with all of the Windows versions of SQL Server since Microsoft SQL Server 4.21a. He has also worked with other relational database management systems over the years, including Oracle, Sybase, and Informix, and he can relate to non-SQL Server database administrators. For the past ten years, Allan has traveled throughout the world, working with customers and delivering training. He is currently based in the Boston, Massachusetts, area. Allan has authored or contributed to whitepapers, webcasts, training courses, and books, and is also a frequent speaker at conferences like Microsoft TechEd and the Professional Association for SQL Server (PASS) Community Summit. Allan's most recent book is Pro SQL Server 2008 Failover Clustering (Apress, 2009), and his most recent whitepaper on consolidation was published in October, 2009. Anu Chawla joined Microsoft in 2003 as a technical evangelist in the Developer and Platform Organization. In his current role as a Business Development Manager he works with strategic Global ISV partners. Prior to Microsoft he worked at Siebel Systems for 4 years as a Principal Consultant and Technical Account Manager. At Siebel he helped several large companies such as Philips Medical, Nike and T-Mobile integrate their Siebel CRM Systems with SAP ERP. Anu has an MS in Computer Science and MBA. Dan is currently the Director of Technology inside the Presales group. He is responsible for creating and dispensing technology branding for Kronos Workforce Management Software. Working directly with engineering, product marketing, sales, presale and service to craft techonolgy-based messaging and provide training on how the value of the application and implmentation can lower the customer's total cost of ownership. Dan has been with Kronos for 16 years and has been in his current position for 2 years. View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time If you have questions or feedback, contact us. ...
2/3/2010 4:00 PM Pacific Time (US & Canada)- 2/3/2012 12:00 AM | Duration:60 Minutes
TechNet Webcast: Security Talk: Auditing in SQL Server 2008 (Level 300)
In this webcast, we provide an in-depth introduction to the new auditing feature introduced in Microsoft SQL Server 2008. Audit is a much anticipated feature for security-sensitive customers, especially those who need to meet regulatory compliance needs, and it provides a number of advantages over previous auditing solutions, including performance benefits, multiple log targets, and granular auditing. We also discuss and demonstrate end-to-end use cases and scenarios for the SQL Server Audit feature. Presenter: Il-Sung Lee, Senior Program Manager, SQL Server, Microsoft Corporation Il-Sung Lee is a program manager for the Engine team in the Microsoft SQL Server product group, and he is the project manager owner for SQL Server Engine Security component. Il-Sung has more than twelve years of experience in the database industry as a developer and a program manager focusing on database security and database communications. His current goal is to advance the capabilities of SQL Server in areas such as authentication, authorization, cryptography, audit, and data leak prevention. He has presented at numerous domestic and international conferences over the past several years. Il-Sung graduated with a mechanical engineering degree from McGill University and subsequently worked for several years at IBM in their Information Management group prior to joining Microsoft, initially with the SQL Server Protocols team before moving to the Core Security Infrastructure area. View other sessions from Security360: Learn Best Practices to Guide Your Security Strategy If you have questions or feedback, contact us. ...
2/25/2010 9:00 PM Pacific Time (US & Canada)- 2/25/2012 12:00 AM | Duration:60 Minutes
TechNet Webcast: Supporting HIPAA Compliance with SQL Server 2008 (Level 200)
In this webcast, we provide insights for firms concerned with Health Insurance Portability and Accountability Act (HIPAA) compliance that are looking for ways to take advantage of Microsoft SQL Server 2008 features to help meet their compliance requirements. SQL Server 2008 provides numerous robust technical security and auditing features and functionality. We focus on features supporting the technical safeguard requirements of the HIPAA Security Rule and pay particular attention to features used by firms storing, processing, or transmitting electronic protected health information (ePHI), including database auditing capabilities, Transparent Database Encryption (TDE), Extensible Key Management (EKM), policy-based management, and reporting services. Presenters: Paul Rozek, Senior Security Advisor, Jefferson Wells International, Inc., Danny Shaw, Global Director, Information Security Center of Expertise, Jefferson Wells International, Inc. and Chip Zodrow, Senior Technology Advisor, Risk Advisory Services Practice, Jefferson Wells International, Inc. Paul Rozek has more than 30 years of professional experience in the field of information security, audit, and control. He is currently a senior security advisor with the Jefferson Wells Information Security Center of Expertise. Paul is one of the subject matter experts within the Center's Privacy and Regulatory Compliance practice and has worked with numerous clients in support of their healthcare regulatory compliance initiatives. Previously Paul was chief information security officer for a major international service bureau and an IT audit officer with a major regional financial holding company. Paul holds the Certified in the Governance of Enterprise IT (CGEIT) certification and a master's degree in project management. Paul is also an active member of multiple professional organizations and a regular presenter at local, regional, and international conferences. Danny Shaw has over 25 years experience in technology and security risk management. He has provided business systems and related technology services to the largest professional services firm in the world, Fortune 500 companies, and other firms in industries such as banking, manufacturing and healthcare. Currently Danny is the Global Director of the Information Security Center of Expertise (COE) for Jefferson Wells. Danny has previously served as the Chief Information Officer (CIO) for a global financial organization. Danny is a certified Holistic Information Security Practitioner, Certified Data Processor, and a Project Management Professional. He has also held thought leadership position with Pricewaterhouse Coopers Business Process Outsourcing IT Council. Chip Zodrow has over 15 years experience with the technologies supporting information systems. He has developed and supported software and database systems for various industries including healthcare, telecommunications, financial and Department of Energy/Department of Defense. Chip is currently a Senior Technology Advisor in the Risk Advisory Services Practice for Jefferson Wells. His accomplishments include designing, deploying and maintaining software systems utilizing the Microsoft .NET architecture supported by SQL Server databases including versions 7 through 2008. Adding to his skill set is his comprehension and awareness for IT quality assurance, risks & controls and audit while supporting real-world operations and complying with regulatory requirements including Payment Card Industry, HIPAA and Sarbanes-Oxley. View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time If you have questions or feedback, contact us. ...
2/24/2010 6:00 PM Pacific Time (US & Canada)- 2/24/2012 12:00 AM | Duration:60 Minutes
In this webcast, we present the results of a recent series of customer case studies on the costs of database administration for Microsoft SQL Server and Oracle database software solutions. The case studies revealed that on average the SQL Server database administrators (DBAs) were able to manage over four times as many mission-critical databases as their Oracle counterparts. In addition, the SQL Server DBAs spent a higher percentage of their time deploying new business applications, and they deployed new databases faster than the Oracle DBAs. Come hear how the results of these case studies can help you better evaluate the manageability of these two leading database platforms and possibly lower your ongoing IT operations costs. Presenter: Greg Shanker, Managing VP of Analysts, Alinean Inc. Greg manages the analyst organization, developing engagement best practices, and serving as project manager and analyst for several major Alinean accounts. Greg has more than twenty years of experience with leading firms in the software industry, including IBM, Oracle, and SAS. Throughout his career, Greg has driven innovation through strategic planning and establishing best practices in sales and marketing roles. Prior to joining Alinean, Greg lead the ROI Program Office for IBM Tivoli, where he developed value models for the Tivoli portfolio of systems management products and trained and supported the field sales organization's value selling initiative. Under Greg's leadership, Tivoli achieved a 10 percent increase in incremental sales, a reduction of 30 percent in sales cycles, and an increase of 50 percent in the win ratio for strategic opportunities by leveraging value selling. The ROI training and deployment program Greg instituted is viewed as a best practice within IBM and the industry. Greg has extensive experience with several IT disciplines, including systems and network management, security, data management, storage, data warehousing, business intelligence, and enterprise resource planning. Greg holds a bachelor's degree in mathematics and computer science from Vanderbilt University and a Master of Business Administration (MBA) degree from the University of North Carolina, Chapel Hill. View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time If you have questions or feedback, contact us. ...
2/26/2010 5:00 PM Pacific Time (US & Canada)- 2/26/2012 12:00 AM | Duration:60 Minutes
New KB's
SQL 2005
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" (Updated)
https://support.microsoft.com/kb/967511/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Data loss may occur if the database mirroring thread stops responding for a long time during an automatic failover process in SQL Server 2005 or in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/978791/EN-US
SQL 2008
SQL Svr Enterprise 2008 EN: The SQL Server 2008 builds that were released after SQL Server 2008 was released (Updated)
https://support.microsoft.com/kb/956909/EN-US
SQL Svr Standard 2008 EN: The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released (Updated)
https://support.microsoft.com/kb/970365/EN-US
SQL Svr Standard 2008 EN: FIX: You cannot synchronize binary large object (BLOB) data by using a transactional replication when you set the SubscriptionStreams parameter of the Distribution Agent to a value that is larger than 1 in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/975171/EN-US
SQL Svr Standard 2008 EN: You receive an error message when you set up a SQL Server 2008 failover cluster on a subnet that only contains IPv6 addresses
https://support.microsoft.com/kb/975951/EN-US
SQL Svr Standard 2008 EN: FIX: The Ghost Cleanup task uses 100% of the CPU on an idle system in SQL Server 2008
https://support.microsoft.com/kb/978430/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you use Query Builder to modify an existing query of an SSRS 2008 report: "The Query designer cannot load due to a problem with the selected cube <cube name>"
https://support.microsoft.com/kb/978894/EN-US
SQL Svr Standard 2008 EN: FIX: A parameter value is replaced by its default value when the parameter is hidden and in a snapshot report in SQL Server 2008 Reporting Services
https://support.microsoft.com/kb/978930/EN-US
SQL Svr Standard 2008 EN: Cumulative update package 10 for SQL Server 2008 (Updated)
https://support.microsoft.com/kb/979064/EN-US
SQL Svr Standard 2008 EN: FIX: Charts that are in a tablix of an SSRS 2008 report display incorrect data
https://support.microsoft.com/kb/979379/EN-US
SQL Svr Standard 2008 EN: FIX: Log entries are missing for the OnPreExecute event and the OnPostExecute event in SQL Server 2008 Integration Services
https://support.microsoft.com/kb/979496/EN-US
SQL Svr Standard 2008 EN: FIX: SQL Server 2008 clustered resources cannot come online if you have enabled the FILESTREAM feature for Transact-SQL access
https://support.microsoft.com/kb/979577/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when the EMF printing renderer is under stress or when you try to print multiple reports at the same time in SSRS 2008: "System.Exception: SelectClipRgn failed: Win32 error:997"
https://support.microsoft.com/kb/979740/EN-US
SQL Svr Standard 2008 EN: FIX: Policy-Based Management incorrectly applies a policy evaluation to all target types in SQL Server 2008
https://support.microsoft.com/kb/979774/EN-US
SQL Svr Standard 2008 EN: FIX: The ddl_event_notification_events notification is registered successfully even when Service Broker is disabled in SQL Server 2008
https://support.microsoft.com/kb/979925/EN-US
SQL Svr Standard 2008 EN: FIX: "User '<User>' does not have permission to run DBCC showfilestats for database '<Database Name>'" error message when you try to open the Properties dialog box of a database in SSMS 2008
https://support.microsoft.com/kb/980037/EN-US
SQL Svr Standard 2008 EN: FIX: An MDX query that references a calculated measure and references a dimension that uses custom rollup formulas returns an incorrect value in SSAS 2008
https://support.microsoft.com/kb/980252/EN-US
SQL Svr Standard 2008 EN: SQL Server 2008 SP1 Cumulative Update 7 introduces trace flag 4136 that can be used to disable the "parameter sniffing" process
https://support.microsoft.com/kb/980653/EN-US
SQL Svr Standard 2008 EN: Correcting the lack of cryptographic salt variation on SQL Server sa login hash
https://support.microsoft.com/kb/980671/EN-US
SQL Svr Standard 2008 EN: The results of an MDX query on a calculated member do not have the formatting that you defined on the calculated member in SQL Server 2008 Analysis Services
https://support.microsoft.com/kb/980925/EN-US
SQL Svr Standard 2008 EN: FIX: A perspective unexpectedly displays dimensions and measures that were not specified when you view the perspective in Report Builder versions 1.0 or 2.0 in SQL Server 2008
https://support.microsoft.com/kb/980930/EN-US
SQL Svr Standard 2008 EN: FIX: Header rows of a tablix do not always appear at the top of pages in an SSRS 2008 report
https://support.microsoft.com/kb/980949/EN-US
SQL Svr Standard 2008 EN: FIX: "Attempting to set a non-NULL-able column's value to NULL" error message when you run a query that uses the ISNULL() function to select values of a nullable column in SQL Server 2008
https://support.microsoft.com/kb/981037/EN-US
SQL Svr Standard 2008 EN: FIX: ".NET Runtime version 2.0.50727.3603 - Fatal Execution Engine Error (000006427F44AE16) (80131506)" error message when SSRS 2008 is rendering large reports or large models or when SQL Server 2008 is running a CLR object
https://support.microsoft.com/kb/981108/EN-US
SQL Svr Standard 2008 EN: The SQL Server 2008 installation fails and corrupts the SQL Server 2008 R2 installation