SQL Server 2005 Distilled
α’αααΈααααα βα’αα‘α·α ααααΌαα·αααα
Need to understand whatβs new in SQL Server 2005, and how it fits with your existing IT and business infrastructure? SQL Server 2005 Distilled delivers the answers you needβquickly, clearly, and objectively.
Former SQL Server team member Eric L. Brown offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more. Brown draws on his extensive experience consulting with enterprise users, outlining realistic usage scenarios that leverage SQL Server 2005βs strengths and minimize its limitations. Coverage includes
- Architectural overview: how SQL Server 2005βs features work together and what it means to you
- Security management, policies, and permissions: gaining tighter control over your data
- SQL Server Management Studio: Microsoftβs new, unified tool suite for authoring, management, and operations
- Availability enhancements: online restoration, improved replication, shorter maintenance/recovery windows, and more
- Scalability improvements, including a practical explanation of SQL Server 2005βs complex table partitioning feature
- Data access enhancements, from ADO.NET 2.0 to XML
- SQL Server 2005βs built-in .NET CLR: how to use it, when to use it, and when to stay with T-SQL
- Business Intelligence Development Studio: leveraging major improvements in reporting and analytics
- Visual Studio integration: improving efficiency throughout the coding and debugging process
- Simple code examples demonstrating SQL Server 2005βs most significant new features
α’αααΈβα’ααααα·αααα
Eric Brown's professional computing work began in earnest in 1996 when he began work at Multiple Zones International as a product manager. While there, he realized the next big wave was the Internet, and raced to get a job at a dot-com. He worked for three dot-coms before ending up on the SQL Server Product Team at Microsoft. At one point in his early DB years, they cut the edge of SQL Server capabilities by owning a 500GB data warehouse running SQL Server 7 and 2000. In the three years he was on the team, he ran βYukonβ readiness. Brown has written a column for SQL Server Magazine, and has written extensively about SQL Server for MSDN Magazine and MSDN online library. Since leaving Microsoft officially, he has worked on this book and started an e-commerce hosting company. He is now working for Quilogy as a senior consultant on the Business Intelligence National Practice.
