SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SQL Server and T-SQL Development Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




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.
A Developer's Guide to SQL Server 2005
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.
Transact-SQL Cookbook
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.
Microsoft SQL Server 2005 For Dummies
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.
Pro SQL Server 2005 Assemblies
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.
Working with tempdb in SQL Server 2005
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ış.
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach
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.
Microsoft SQL Server 2000 High Availability
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.

Murach's SQL for SQL Server



download SQL Server 2012 for free evaluation






Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems