SQL Server Books
-
Pro SQL Server 2000 Database Design
Published 17 years ago includes sample chapter
by Louis Davidson, Apress, Apress
Database design is one of the most contentious issues in computer science. There is always a delicate balance to be struck between the strict academic rules that govern the design of relational databases and the real-world techniques that programmers apply to get the job done in a certain time frame.
-
Real-World SQL-DMO for SQL Server
Published 18 years ago includes sample chapter
by Allan Mitchell, Mark Allison, Apress
Real-World SQL-DMO for SQL Server delves into the details of administering Microsoft SQL Server using the SQL-DMO object library. Authors Allan Mitchell and Mark Allison have packed the book with explanations and working code that will help you use the library to its full potential. Additionally, Mitchell and Allison offer advice about when (and when not) to use the SQL-DMO application programming interface (API
-
A Programmer's Guide to ADO .NET in C
Published 18 years ago includes sample chapter
by Mahesh Chand, Apress
This essential guide to Microsoft's ADO.NET overviews C#, then leads you toward deeper understanding of ADO.NET. Author Mahesh Chand provides key information about using each of .NET's major data providers, including OLE DB, SQL Server, and the released version of ODBC. Also featured are the methods and properties associated with these data providers' classes. Further, Chand shows you how to work with XML classes, integrate XML into the ADO
-
Database Programming with Visual Basic .NET, Second Edition
Published 18 years ago includes sample chapter
by Carsten Thomsen, Apress
Take your pick: you may either read this book cover-to-cover, or just refer to it when you want ready-made solutions of "drop-in" code. Either way, Database Programming with Visual Basic .NET, Second Edition will teach you to master ADO.NET programmatically and from within the VS. NET IDE. You will learn the concepts of disconnected data access with ADO.NET. You'll also learn to create tables, constraints, projects, stored procedures, views, and triggers.
-
Real World SQL Server Administration with Perl
Published 17 years ago includes sample chapter
by Linchi Shea, Apress
Real World SQL Server Administration with Perl is written with the goal of super-charging your SQL Server administration skills with Perl scripting, taking you to the next level of SQL Server administration. Through a broad range of scenarios, this book shows you how to write Perl scripts (often in combination with T-SQL scripting) to solve a wide variety of SQL Server administration problems.
-
Pro Visual Studio Team System with Team Edition for Database Professionals
Published 13 years ago includes sample chapter
by David Nelson, Jeff Levinson, Apress
It is clear that Visual Studio Team System is the future of development from Microsoft’s perspective. Development is no longer a personal pursuit by one developer in a darkened room; it is a collective effort by a team of peers. VSTS supports this broader vision by providing a complete collaboration platform for the entire project team. VSTS takes a services-oriented approach leveraging Windows SharePoint Services and SQL Server Business Intelligence Suite.
-
Advanced Transact-SQL for SQL Server 2000
Published 20 years ago includes sample chapter
by Itzik Ben-Gan, Tom Moreau, Apress
In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000. Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL.
-
Pro Visual Studio 2005 Team System
Published 14 years ago includes sample chapter
by Jeff Levinson, David Nelson, Apress
It is clear that Visual Studio Team System is the future of development from Microsoft's perspective. We agree. Development is no longer a personal pursuit by one developer in a darkened room; it is a collective effort by a team of peers. VSTS supports this broader vision by providing a complete collaboration platform for the entire project team. VSTS takes a services-oriented approach leveraging Windows Sharepoint Services and SQL Server Business Intelligence Suite.
-
Code Centric: T-SQL Programming with Stored Procedures and Triggers
Published 20 years ago includes sample chapter
by Garth Wells, Apress
If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. You'll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.
-
Pro SQL Server 2005 Assemblies
Published 15 years ago includes sample chapter
by Robin Dewson, Julian Skinner, Apress
Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download. Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they're enhancements, to be used at the right place and right time.