SQL Server 2005 provides the database application programmer with a rich new development platform by hosting the .NET Framework Common Language Runtime environment (CLR). With new capabilities come new roles and responsibilities for the Database Administrator (DBA).
Read the rest of this entry »
Database administrators in enterprises today face the challenging task of determining an appropriate physical design that consists of partitioned tables, indexes, and indexed views and that both optimizes server performance and is easy to manage.
Read the rest of this entry »
Welcome to Sams Teach Yourself Microsoft SQL Server 7.0 in 21 Days. We hope this book will help not only teach you about SQL Server but also prove valuable for everyday work involving SQL Server. We have worked hard to see that the skills you learn from this book will easily translate into real-world methods and solutions.
Read the rest of this entry »
SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005.