Business Technical Ebooks

Expert SQL Server 2008 Development is aimed at SQL Server developers primed to advise beyond Books Online. Author and old developer Alastair Aitchison shows you how to conceive most SQL Server utilization as if it were some another identify of development. You’ll see to control investigating in SQL Server and to right care with errors and exceptions. The aggregation also covers critical, database-centric topics much as managing concurrency and securing your accumulation and cipher finished comely privileges and authorization.

Alastair places pore on good utilization and architectural practices that module hold you embellish a meliorate developer, confident of artful high-performance, robust, maintainable database applications. He shows you how to administer celebrity features in SQL Server much as coding and hold for hierarchic data. If nonindustrial for SQL Server is what puts the clams on your table, you crapper do no meliorate than to feature this aggregation and to learn the expert-level practices that it provides.

• Promotes expert-level practices
• Leads to broad performance, ascendible code
• Improves productivity, effort you bag in instance for dinner

What you’ll learn

• Productively appendage errors and exceptions.
• Exploit features for managing abstraction and profane data.
• Manage tree-structured accumulation using the new, hierarchid type.
• Write cipher that easily survives broad concurrency.
• Program defensively.
• Create comely and reusable effort environments for your code.
• Secure cipher and accumulation finished coding and comely covering of privilege.