This comprehensive reference provides expert tips and real code examples to teach advanced database programmers to write more efficient and better-performing code that takes full advantage of Transact-SQL (T-SQL).
Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using the new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.
This book recognizes that aspiring database administrators need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it.
This book is for Visual Basic developers who want to integrate SQL Server 2000 into their applications. It covers everything you need to know to work with SQL Server 2000, including SQL Server 2000 tools, managing database security, building and deploying English query applications, and more.
Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition. This comprehensive book covers databases, tables and T-SQL, coding procedures and triggers, and Reporting Services.
Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust.