Microsoft SQL Server 2005

Microsoft® SQL Server™ 2005 is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performance data applications for use in your business.

With Microsoft SQL Server 2005, the world of database development is changing.

As a database developer, you now have the option to appropriately locate your code in relation to its functionality, to access data in native formats such as XML, and to build complex systems that are driven by the power of the database server. Database development is becoming more integrated than ever before, and all of the tools that you need are available right at your fingertips with SQL Server 2005 and Visual Studio 2005.

Visual Studio Integration Tight integration with Microsoft Visual Studio and the .NET Framework streamlines development and debugging of data-driven applications. Developers can build database objects, such as stored procedures, using any .NET language and can seamlessly debug across .NET and Transact-SQL (TSQL) languages. On the client side, efficient data binding allows for faster development of client applications, whereas the ability to embed SQL Server Express simplifies the deployment of lightweight client applications. Integrated Authoring. Author and manage database objects directly from Visual Studio using the designers and extend them using any .NET language (such as Visual Basic, C#, C++, or J#) through the common language runtime (CLR).  Integrated Debugging. True end-to-end debugging across the data and application tier enables you to set breakpoints anywhere and inspect any asset in both TSQL and .NET languages. Integrated Data Binding. Seamlessly map database objects to both Web-based (WebForms) and rich clients (WinForms) through improved drag-and-drop development through the new DataSet Designer and The Grid View, DataList, and DropDownList controls. Integrated Deployment. Dynamically deploy database objects from your development environment to the server. Attach and detach SQL Server Express to your applications to enable the seamless deployment of a lightweight client database with your applications. Enhanced Query and Data Access Spend less time while writing more powerful and maintainable TSQL statements using enhancements such Exception Handling, Recursive Queries, Statement Level Recompile, and several new TSQL data types including XML. You can also create flexible and maintainable systems by taking advantage of the new capabilities provided by ADO.NET 2.0 such as Multiple Active Result Sets (MARS), User-Defined Data Types (UDT), and server-side cursors.   SQL Server Certification MS Certified Technology Specialist Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. MCTS:  SQL Server 2005 MS Certified IT Professional The new Microsoft Certified IT Professional (MCITP) credentials provide IT professionals with a simpler and more targeted framework to showcase their technical skills in addition to the skills that are required for specific developer job roles. The credentials are geared toward IT professionals who administer a Microsoft SQL Server 2005 database. There are currently 2 MCITP Series credentials for SQL Server 2005. For details and specifics on how to earn each credential, click on the titles below. MCITP:  Database Developer MCITP:  Database Administrator

Learn More Today   Microsoft SQL Server 2005 Resources SQL Server Courses SQL Server Resumes   Developer Productivity One of the key barriers to developer productivity has been the lack of integrated tools for database development and debugging. SQL Server 2005 breaks down this barrier by providing tight integration with Microsoft Visual Studio 2005. SQL Server 2005 provides advancements that fundamentally change the way that databases are developed and deployed. Through rich Extensible Markup Language (XML) support and deeper integration with .NET technologies and Microsoft development tools, SQL Server 2005 significantly increases developer productivity and flexibility. Enhancements for developer productivity include: Improved tools. Developers are able to utilize one development tool for Transact-SQL, XML, Multidimensional Expression (MDX), and XML for Analysis (XML/A). Integration with the Visual Studio development environment provides more efficient development and debugging of line-of-business and business intelligence applications. Expanded language support. With the common language runtime (CLR) hosted in the database engine, developers are able to choose from a variety of familiar languages to develop database applications, including Transact-SQL, Microsoft Visual Basic 2005, and Microsoft Visual C# 2005. Additionally, CLR hosting provides developers with increased flexibility through the use of user-defined types and functions. The CLR also provides opportunities to use non-Microsoft code for rapid database application development. XML and Web services. Advancements such as XQuery and a native XML data type will help enable organizations to seamlessly connect internal and external systems. SQL Server 2005 supports both relational and XML data natively, so enterprises can store, manage, and analyze data in the format that best suits their needs. Support for existing and emerging open standards such as Hypertext Transfer Protocol (HTTP), XML, Simple Object Access Protocol (SOAP), XQuery, and XML Schema Definition (XSD) facilitates communication across extended enterprise systems.

Add the above content to:

Google   Y! MyWeb   Furl   Simpy   Spurl   Blink  Del.icio.us   Digg   Technorati