Michael Coles eBooks

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of TransactSQL functionality in SQL Server 2008 in his book, Pro TSQL 2008 Programmers Guide. Fully functioning examples and downloadable source code bring Coles technically accurate and engaging treatment of TransactSQL into your own hands. Stepbystep explanations ensure clarity, and an advocacy of bestpractices will steer you down the road to success. Pro TSQL 2008 Programmers Guide is every developers key to making full use of SQL Server 2008s powerful, builtin TransactSQL language. TransactSQL is the language developers and DBAs use to interact with SQL Server. Its used for everything from querying data, to writing stored p...

Knowledge and ability to apply XML are de rigueur in todays world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Servers builtin XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. Shows how to store, query, and manipulate XML documents in SQL Server Provides stepbyste...

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the 2008 release of Microsofts flagship database management system quickly. Take full advantage of the features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer. Lightningfast introduction to SQL Server 2008 Written by top experts in the field Provides a solid grounding in key features and technologies What youll learn Manage SQL Server installations through the brandnew Declarative Management Framework Protect yourself from downtime with highavailability featu...