As you know SQL 2005 has been released and we are already seeing SQL 2008 on the horizon. To keep up to date and step into the future the following should be able to help with understand the products, finding information about solutions using them and developing solutions using them,
SQL Server 2005
SQL Server Premier Field Engineers Deliver SoundBytes
The UK SQL Server PFE team is preparing a series of SQL Server SoundBytes aimed to deliver proactive content to our Premier customers via LiveMeeting. Premier SoundByte sessions will be ideal for customers who need proactive information, for whom it may not be convenient to leave the office to come to a workshop. These sessions are set to run from the beginning of September 2007 through to the end of December 2007 and will range from Clustering a SQL Server 2005 Database System, to Database Mirroring, Configuration Best Practices through to SQL Server in a SAN Environment, Corruption / Detection and Recovery of a SQL Server 2005 System. Please contact your TAM if you are interested in attending a SoundByte Session and they will arrange your attendance for the specific topic, agenda and date / time. For more information regarding these SQL Server 2005 SoundBytes, checkout the UK SQL Server Premier Blogsite :
http://sqlblogcasts.com/blogs/thepremiers/
SQL Server 2005 Books Online (May 2007)
Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The May 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes. Beginning with the February 2007 update, SQL Server 2005 Books Online reflects product upgrades included in SQL Server 2005 Service Pack 2 (SP2).
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en
.NET Rocks! - Bret Updegraff Talks SQL Server Reporting Services
An experienced software designer and developer, Bret Updegraff works as a manager with the Mid Market Microsoft practice of Crowe Chizek and Company LLC. Bret was honored with the Microsoft MVP status from Microsoft in the category of Windows Server System - SQL Server. He is a Microsoft Certified Solution Developer, a Microsoft Certified Application Developer, and a Microsoft Certified Database Administrator. Bret is the president of the Indianapolis Professional Association of SQL Server (PASS) users group as well as the co-author of the book Reporting Services 2005 In Action by Manning Publishing.
http://www.microsoft.com/downloads/details.aspx?FamilyID=153e2378-0313-4718-a99a-1334a6803f6d&DisplayLang=en
SQL Server 2005 Best Practices Analyzer (July 2007)
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. This download is the July 2007 release of SQL Server 2005 Best Practices Analyzer.
http://www.microsoft.com/downloads/details.aspx?FamilyID=da0531e4-e94c-4991-82fa-f0e3fbd05e63&DisplayLang=en
Microsoft Codename "Astoria" - May 2007 Community Technology Preview add on (Silverlight and SQL)
The first CTP of Microsoft Codename "Astoria" shipped in May of 2007 and included a client library to facilitate access to Astoria services from applications built using the .NET Framework.
This add-on extends the CTP by introducing a version of the client library that can run inside the Microsoft Silverlight 1.1 environment. This version of the library also includes an extension to the API that allows developers to execute queries asynchronously, a more natural interaction model for a web-centric application.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6d85055e-3549-48fc-8a2b-f678e6786e3a&DisplayLang=en
Secrets to Fast Detection and Recovery from Database Corruption's
How can you tell whether your data is corrupt ? If you have corruption, how do you work out what's wrong with the database ? How do you ensure you have a valid backup ? If you don't have a valid backup, how and what do you repair ? If you do have a backup, how do you work out whether you should restore or repair ? And at what granularity ? How do you go about determining what went wrong in the first place ? It's all about limiting downtime and data-loss when a corruption occurs—from knowing the tools, to understanding the choices, to planning a successful strategy. Some of the features discussed in this session are: torn-page detection and page checksums, IO read-retry, backup checksums, consistency checks (DBCC CHECKDB and related commands), and database repairs. Facing database corruption is almost inevitable in every DBAs career—make sure you're prepared when it happens to you.
http://blogs.msdn.com/sqlserverstorageengine/
http://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=549
http://msexp.streamnavig.com/msexp/player.asp?e=E0093&s=0559_en_w&f=0559_en&uid=00067FFE82A3AC3D&lng=en&cou=emea#
SQL Server 2008
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.
http://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx
Microsoft SQL Server 2008
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, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights.
http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx
http://download.microsoft.com/download/B/F/2/BF24C54E-5635-4C79-AFB4-0C3F840E79F4/SQLServer2008_Datasheet_Final.pdf
Microsoft SQL Server 2008
SQL Server 2008 (formerly known as SQL Server code name "Katmai"), the next release of Microsoft SQL Server, provides a comprehensive data platform that is secure, reliable, manageable, and scalable for your mission-critical applications. SQL Server 2008 enables developers to create new applications that can store and consume any type of data on any device, and enables all your users to make informed decisions with relevant insights. Microsoft is releasing a Community Technology Preview (CTP) version of SQL Server 2008 in conjunction with the Microsoft Tech-Ed 2007 conference.
http://technet.microsoft.com/en-us/sql/bb498264.aspx
ADO.NET Entity Framework June 2007 CTP
This CTP contains updates to the ADO.NET Entity Framework since the Visual Studio Codename "Orcas" Beta 1 release, including changes in Object Services, Query, Entity Client, and the Entity Data Model Wizard in Visual Studio. Some of the new features include IPOCO, detaching from long-running ObjectContext instances, multiple entity sets per type, support for referential integrity constraints, span support, transactions, serialization, no more default constructors in code-generated classes, improvements to stored procedure support, access to the underlying store connection, directory macros in the entity connection string to support hosted scenarios, native SQL read-only views, UNICODE support in Entity SQL, query plan caching, and canonical functions in Entity SQL.
http://www.microsoft.com/downloads/details.aspx?FamilyID=5c12fe07-e646-49c2-887f-8cc070b37247&DisplayLang=en
MSDN Webcast: Data Programmability and SQL Server 2008 (Level 200) – Friday, August 31, 2007 9:00 AM Pacific Time (US & Canada)
A comprehensive data programmability platform enables developers to build data-centric solutions that target desktops, mobile devices, online Web servers, and enterprise servers using a variety of products, programming frameworks, Web services, and data connectivity technologies that work together to access and manage data. Join this webcast as we discuss the new data programmability features that are supported by Microsoft SQL Server 2008.
MSDN Webcast: Data Programmability and SQL Server 2008 (Level 200)
ttfn
David
Posted
Thu, Aug 16 2007 12:27 AM
by
David Overton