Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Sample Chapters > SQL Server


Search:
What's New - What's Hot
A Comparison of SQL Server 7.0 with SQL Server 2000  Version: 0.00     Price: $0.00  
Total Hits: 157  |  Today: 0Author: Sergey Vartanyan      Rating:  
Read Reviews | Write Review |  Your Rating: 

Should you stick with SQL Server 7.0, or spend the big bucks to move to SQL Server 2000? To help you make your decision, here are some things to think about....

How to join tables where columns include NULL values     
Total Hits: 398  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When building database tables you are faced with the decision of whether to allow NULL values or to not allow NULL values in your columns. By default SQL Server sets the column value to allow NULL values when creating new tables, unless other options are set. This is not necessarily a bad thing, but dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved....

Book Review: A Guide to SQL Server 2000 Transactional and Snapshot Replication     
Total Hits: 1050  |  Today: 0Author: Vyas Kondreddi      Rating:  
Read Reviews | Write Review |  Your Rating: 

As the title suggests, this is a book about SQL Server replication, and just about SQL Server replication. Yes, at last, there is a dedicated, comprehensive book, that covers all aspects of SQL Server 2000 transactional and snapshot replication. After reading all the important and interesting chapters from this book, I can happily say that, this is the definitive book on SQL Server 2000 replication, and a must have and must read for any SQL Server DBA, interested in learning the ins and outs of ...

Implementing the Physical Database     
Total Hits: 1050  |  Today: 0Author: Thomas Moore, Ed Tittel      Rating:  
Read Reviews | Write Review |  Your Rating: 

This chapter deals with the physical components of a SQL Server database system. Beginning with the server hardware, organizing the data storage and creating the physical files is where a lot of future performance will be determined. There are many options to consider for a production environment, and one thing is certain: The minimum installation requirements will not be sufficient. The computer hardware components are only the beginning of the physical elements. Although we tend to think of th...

SQL In Simple English - Part II     
Total Hits: 1130  |  Today: 0Author: Kiran Pai      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains the basics of SQL as a Q A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful....

Programming Windows Solutions with ADO.NET     
Total Hits: 1032  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sample Chapter 10 from "Programming Microsoft® SQL Server™ 2000 with Microsoft Visual Basic® .NET". Chapter 1 introduces you to ADO.NET conceptually and shows you how to create a simple ADO.NET application using Visual Studio .NET graphical design tools. This chapter builds on the ADO.NET introduction in Chapter 1 and the intervening chapters that enhance your SQL Server and Visual Basic .NET skills. Think of this chapter as a "how to" guide for solutions to typical database problems with ADO.NE...

Designing a Microsoft SQL Server System     
Total Hits: 988  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Sample Chapter from "Microsoft SQL Server 2000 Administrator's Companion". Before you even begin loading the operating system and Microsoft SQL Server, you should have a good idea how you want to design your SQL Server system. By carefully designing your SQL Server system, you can avoid costly downtime caused by having to either rebuild the system or reinstall SQL Server with different options. In this chapter, you will learn how to design a SQL Server system. In this book, the SQL Server syst...

Data Warehouse Design Considerations     
Total Hits: 1351  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Data warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. Although data warehouses are built on relational database technology, the design of a data warehouse database differs substantially from the design of an online transaction processing system (OLTP) database.
The topics in this chapter address approaches and choices to be considered when designing and imp...

Using Microsoft Data Transformation Services (DTS)     
Total Hits: 1855  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sample chapter from "Data Mining with Microsoft® SQL Server™ 2000 Technical Reference". In this chapter, I’ll explain how DTS works and how to program it, and I’ll show you, step-by-step, how to automatically download the mushroom data used in Chapter 5 from the mushrooms database’s FTP site, run the DTS transformation steps needed to format and store the data, and train the data-mining model. We’ll create a unit to do all this with the click of a button or through an automated task....

Interview with Robin Dewson, Author of Beginning SQL Server 2000 Programming     
Total Hits: 1538  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this exclusive interview, Robin shares some of his knowledge and experience on how to get the best performance from SQL Server....

Normalization Techniques     
Total Hits: 1658  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sample chapter 6 from "Professional SQL Server 2000 Database Design"...

Introduction to SQL     
Total Hits: 1430  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sample chapter 1 from "Beginning SQL Programming"....

Creating the Sample Database     
Total Hits: 1484  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sample chapter 5 from Beginning SQL Server 2000 Programming. If you are new to SQL Server 2000 programming, you might want to check out this sample chapter....

Retrieving XML Data Using Transact-SQL     
Total Hits: 690  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Sample chapter from "Programming Microsoft® SQL Server™ 2000 with XML".
To help you retrieve XML data from the database, SQL Server 2000 provides an extension to the Transact-SQL SELECT statement in the form of the FOR XML keywords. By appending FOR XML to a SELECT statement, you can indicate to the SQL Server query processor that you want the results to be returned as an XML stream instead of a rowset. In addition to including the FOR XML keywords, you must also specify a mode to indicate...

The Simplest SQL Notification Application: Stock Quotes     
Total Hits: 1345  |  Today: 0Author: Shyam Pather.      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this chapter, you'll see your first SQL-NS application. Think of this chapter as a tour: My intent is simply to show you around the various facilities that the platform offers so that you get a feel for the application model and the process of coding to it. We will look at code in this chapter, but simply for the purpose of understanding the concepts behind the application. A line-by-line explanation of the code at this stage would drown out the simpler picture that I'm trying to show. That s...

ADO.NET and System.Xml v. 2.0--The Beta Version, 2nd Edition     
Total Hits: 1039  |  Today: 0Author: Alex Homer, Dave Sussman, Mark Fussell      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET 2.0 and SQL Server 2005 share a great deal of functionality and complementary technologies. This chapter concentrates on three core areas of functionality: Multiple Active Results Sets (MARS), SQL Server Query Notifications, and SQL Server user-defined types (UDTs)....

SQL In Simple English - Part I     
Total Hits: 1051  |  Today: 0Author: Kiran Pai      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains the basics of SQL as a Q A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful....

Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases     
Total Hits: 1555  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sample chapter from "MCSE Microsoft® SQL Server™ 2000 Administration Readiness Review; Exam 70-228". The Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases domain examines the tasks administrators will face on a day-to-day basis. These tasks include:
Creating a database and ensuring that the database performs well
When creating a database, administrators must take into consideration certain SQL Server configuration settings, such as database and log file location. These se...

The Query Analyzer     
Total Hits: 1424  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Sample Chapter from "Microsoft SQL Server 2000 Programming Step by Step". In the previous lessons, we’ve used the Enterprise Manager to create and maintain database objects and to perform basic data operations. In this lesson, we’ll look at another one of Microsoft SQL Server’s graphical tools—the Query Analyzer....

Accessing XML Data from .NET Applications     
Total Hits: 1169  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A sample chapter 7 from "Programming Microsoft® SQL Server™ 2000 with XML, Second Edition". Application development on the Microsoft Windows platform has had various evolutionary, and sometimes revolutionary, stages. The original Windows API consisted of a number of 16-bit dynamic link library (DLL) files with documented entry points and functions that programmers could call, passing the appropriate parameters. In Windows 95 and NT, this API was upgraded to 32–bit DLLs. As a result, the collecti...



Disclaimer - Privacy
© 2002-2017 DevASP.net