SQL Server Books and Sample SQL Server Book Chapters
| Book : A Developer's Guide to SQL Server 2005 Author : Bob Beauchemin, Dan Sullivan Publisher : Addison Wesley Professional Chapter No : 4 Chapter Title : In-Process Data Access SQL Server, .NET and the SqlClient data provider are the main topics of this sample chapter. Programming with the SqlClient, SqlContext class, Connection and Command classes and the transactions are well summarized within the chapter. |
 |
| Book : Transact-SQL Cookbook Author : Ales Spetic, Jonathan Gennick Publisher : O'Reilly Chapter No : 8 Chapter Title : Statistics in SQL Although SQL Server is not a statistics program neither it is designed for statistical calculations, you can use the hidden potential of SQL Server for common statistical operations like means, modes, standard deviations, variances, correlations, moving averages, and weighted moving averages. This chapter provides recipes for the readers to show how can they benefit from the SQL Server in statistical calculations. |
 |
| Book : Microsoft SQL Server 2005 For Dummies Author : Andrew Watt Publisher : Chapter No : 2 Chapter Title : New Features in SQL Server 2005 In this chapter, as can be understood easily SQL Server 2005 enhancements and SQL Server's improved security features are dealed with. Improved XML support, CLR (Common Language Runtime) support, error handling improvements, new data types, HTTP endpoints are only some of the SQL Server issues summarized within this book sample chapter. |
 |
| Book : Pro SQL Server 2005 Assemblies Author : Robin Dewson, Julian Skinner Publisher : Apress Chapter No : 3 Chapter Title : The SQL Server .NET Programming Model This book, Pro SQL Server 2005 Assemblies provides detailed and with example tutorials on how to build .NET assemblies and how to use .NET assemblies with in SQL Server 2005. The book has sample applications with full code which you can also download from http://www.apress.com/book/downloadfile/2556 and examine how assemblies building in C# also in VB .NET code. .NET assemblies are not replacements for T-SQL stored procedures or triggers. They should be dealed as enhancements in T-SQL. The book also examines the ins and outs of assemblies. When .net assemblies can be used or not. The sample chapter deals with using the standard ADO.NET provider for SQL Server from within a SQL assembly. Also SqlContext and SqlPipe classes are examined with details and sample code. |
 |
| Article Name: Working with tempdb in SQL Server 2005 Authors : Wei Xiao, Matt Hink, Mirek, Sunil Agarwal Publisher : Microsoft TechNet This white paper describes how SQL Server 2005 uses tempdb. The SQL Server system database, tempdb, has undergone a number of changes in SQL Server 2005. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. |
 |
|
Book Name : SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach Author : Joseph Sack Publisher : Apress Sample Chapter : 6 Sample Chapter Title : Full-Text Search Full-text search fonksiyonu size uygulamalarınızda daha gelişmiş ve akıllı aramalar yapabilmenize olanak sağlar. Full-text search kullanarak LIKE ile yaptığınız aramalara göre daha iyi sonuçlar elde edersiniz. Download edebileceğiniz bu kitap bölümünde (sample chapter) MS SQL Server 2005 ortamında Full-Text Search 'ten faydalanabilmeniz için oluşturmanız gerekli Index 'ler ve Catalog 'ları nasıl oluşturabileceğiniz ve çalıştırmanız gereken T-SQL komutları ve sözdizimi (syntax) ile ilgili bilgiler, Ranked Search gibi kavramlar örneklerle anlatılmış. |
|
|
Book Name : Microsoft SQL Server 2000 High Availability Author : Allan Hirt, Cathan Cook, Kimberly L. Tripp, Frank McBath Publisher : Microsoft Press Sample Chapter : 9 Sample Chapter Title : Database Environment Basics for Recovery Microsoft Zirvesi 2005'te de konuşmacı olarak yeralan ve Sql Server 2005 için benzer konularda birikimlerini katılımcılar ile paylaşan Kimberly Tripp'in de yazarlığını yaptığı bu kitapta SQL Server 2000 için High Availability konusu yani sistemin mümkün olan her koşulda ayakta ve çalışıyor olması için yapılması gerekenler işleniyor. |
 |
|
Book Name: Murach’s SQL Server 2012 for Developers Author: Bryan Syverson, Joel Murach Publisher: Mike Murach & Associates, Inc. Sample Chapter: 3 Chapter Title: How to retrieve data with the SQL SELECT statement This chapter shows developers how they can code using SELECT statements for retrieving data from a single SQL Server database table. For T-SQL developers this chapter is an entry for more complex SELECT statements. |
 |