Monday, July 07, 2008 12:51 AM
SQL Master
SQL Server Technical Rollup July 2008 - Important & Interested links for you
As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena.
Downloads
Source Code Analyzer for SQL Injection
Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks.
http://www.microsoft.com/downloads/info.aspx?na=22&p=2&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d58a7c46e-a599-4fcb-9ab4-a4334146b6ba%26displaylang%3den
Microsoft SQL Server 2008 Feature Pack RC0, June 2008
Download the June 2008 Feature Pack RC0 for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.
http://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d089a9dad-e2df-43e9-9cd8-c06320520b40%26displaylang%3den
SQL Server 2008 Books Online Release Candidate (RC0)
Download the release candiate (RC0) version of the documentation and tutorials for Microsoft SQL Server 2008.
http://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d19db0b42-a5b2-456f-9c5c-f295cdd58d7a%26displaylang%3den
TechNet Security Series Seminar IV (5 Jun 2008)
Presentation materials for the TechNet Security Series Seminar (29 Feb 2008)
http://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3debd6aeda-2121-4cc5-99e8-601b966f6ec7%26displaylang%3den
Microsoft® Visual Studio Team System 2008 Database Edition GDR June CTP
Microsoft® Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008.
http://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbb3ad767-5f69-4db9-b1c9-8f55759846ed%26displaylang%3den
SQL Server 2005 Driver for PHP CTP (May 2008)
Download the SQL Server 2005 Driver for PHP CTP for May 2008, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.
http://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d85f99a70-5df5-4558-991f-8aee8506833c%26displaylang%3den
Documents
SQL Server 2008 Product Overview
http://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-overview.aspx
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 the 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.
Accessing External Data Sources with Microsoft SQL Server Analysis Services 2005
http://msdn.microsoft.com/en-us/library/aa964120.aspx
This white paper covers a variety of client object models supported by Microsoft SQL Server Analysis Services when connecting to relational data sources. The example problems and solutions were gathered by members of the Analysis Services team while working with users of Analysis Services. (5 printed pages)
Events/Webcasts
Webcast: 24 Hours of SQL Server 2008: Using the Microsoft Data Platform for Easy Data Access with SQL Server 2008 (Level 100)
https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032370154&EventCategory=5&culture=en-US&CountryCode=US
Join this series as we look at Microsoft SQL Server 2008 as a productive data platform. Throughout this series, we use Contoso (Container Overseas Shipping Operation) LTD as our scenario customer while we explore the features that make SQL Server 2008 this platform. Contoso is a shipping company; they arrange the shipping of all kinds of items around the globe, from small individual items to large manufactured items. Contoso has seen growth in its business over the past years, especially in the movement of goods from China around the world. While Contoso is happy with their in-house applications and believe they provide significant business advantage over competitors, Contoso wants to ensure that these applications are running on the best productive platform to maintain this advantage, especially as their business grows worldwide. In this webcast, we look at how Contoso LTD can take advantage of the Microsoft data platform to extend their applications. We concentrate on Microsoft .NET Language-Integrated Query (LINQ) and the ADO.NET Entity Framework with examples of how Contoso can use these technologies to access their data. Join us as we go into detailed coverage of data platform features, LINQ, and ADO.NET Entity Framework
MSDN Webcast: Optimizing Online, Enabling Offline with SQL Server Compact and Sync Services for ADO.NET (Level 200)
https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364885&EventCategory=5&culture=en-US&CountryCode=US
With Microsoft SQL Server Compact, developers can now easily cache data on the client in a compact, yet capable, transactional, queryable document-like database format. To maintain the cache, Sync Services for ADO.NET enables developers to easily cache data directly or over services using Windows Communication Foundation (WCF). Microsoft Visual Studio 2008 delivers new integrated, developer-oriented sync designers making caching an easy task to increase user productivity, decrease the server workload, and simplify data access. Using Sync Services for ADO.NET, developers can enable full offline scenarios as well. Join this webcast to find out what SQL Server Compact and Sync Services for ADO.NET have to offer for the "edge of the network" clients.
|
MSDN Webcast: Introducing SQL Server Compact 3.5 (Level 200) | |
https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364883&EventCategory=5&culture=en-US&CountryCode=US
With Microsoft SQL Server Compact 3.5 and Microsoft Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile-powered devices, or their full desktop clients–benefiting from the power of SQL Server in a compact footprint. Using Visual Studio 2008, we show how SQL Server Compact can be transparently deployed with unique features including updatable result sets and a custom document format, and how to manage the creation and maintenance of your local data. This session is packed with demonstrations that can get you started today.
(source: Technical Rollup from Premier Field Engineering team)