Kodyaz Development Resources

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.

Welcome to Kodyaz Development Resources Sign in | Join | Help

Home

> Sample 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/supplementDownload.html?bID=10032&sID=3232 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.
Kitap Adı: SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach Yazar : Joseph Sack Yayıncı : Apress Bölüm No: 6 Bölüm Başlığı: 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ış.
Kitap Adı: Microsoft SQL Server 2000 High Availability Yazar : Allan Hirt, Cathan Cook, Kimberly L. Tripp, Frank McBath Yayıncı : Microsoft Press Bölüm No: 9 Bölüm Başlığı: 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.
Kitap Adı: Murach's SQL for SQL Server Yazar : Bryan Syverson Yayıncı : Mike Murach & Associates, Inc. Bölüm No: 3 Bölüm Başlığı: How to retrieve data from a single table SQL, veri okuma, veritabanı tasarımı, ileri özellikler üzerine bir kitap. Bu bölümde ise tablodan veri okuma konusu irdelenmiş.

BlinkList Del.icio.us Digg Digg Furl Furl Simpy Simpy Spurl Spurl DZone DZone ma.gnolia Shadows Shadows

Powered by Community Server, by Telligent Systems