|
|
|
|
|
Total Hits: 395 | Today: 0
|
Author: Alex Homer, Dave Sussman, Mark Fussell
|
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)....
|
|
|
|
Total Hits: 724 | Today: 1
|
|
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...
|
|
|
|
Total Hits: 851 | Today: 0
|
|
Rating:
|
|
In this exclusive interview, Robin shares some of his knowledge and experience on how to get the best performance from SQL Server....
|
|
|
|
Total Hits: 1041 | Today: 2
|
|
Rating:
|
|
Sample chapter 6 from "Professional SQL Server 2000 Database Design"...
|
|
|
|
Total Hits: 796 | Today: 0
|
|
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....
|
|
|
|
Total Hits: 15 | Today: 1
|
Author: r.stropek
|
Rating:
|
|
software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server. In this article you can reread the questions. Additionally you get background information about the correct answers....
|
|
|
|
Total Hits: 535 | Today: 1
|
Author: Shyam Pather.
|
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...
|
|
|
|
Total Hits: 397 | Today: 0
|
Author: Thomas Moore, Ed Tittel
|
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...
|
|
|
|
Total Hits: 433 | Today: 0
|
Author: Kiran Pai
|
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....
|
|
|
|
Total Hits: 387 | Today: 0
|
Author: Kiran Pai
|
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....
|
|
|
|
Total Hits: 933 | Today: 0
|
|
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...
|
|
|
|
Total Hits: 377 | Today: 0
|
|
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...
|
|
|
|
Total Hits: 1256 | Today: 0
|
|
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....
|
|
|
|
Total Hits: 459 | Today: 0
|
Author: Mitchell Harper
|
Rating:
|
|
Wrox are well known for their +quot;How-To+quot; series of books, which teach beginning-intermediate developers how to use Microsoft technologies properly and efficiently. Today, Mitchell takes a look at chapter three from +quot;Beginning SQL Server 2000 Programming+quot;, which is published by Wrox Press....
|
|
|
|
Total Hits: 912 | Today: 1
|
|
Rating:
|
|
Sample Chapter 8 from "Data Mining with Microsoft® SQL Server™ 2000 Technical Reference".
Unlike other programming environments, DTS is strictly batch-oriented. This means that it will run steps in a sequential order without waiting for user input or any other user "events." It’s expected to provide an easy way to define those steps and establish the flow of execution to allow you to go from beginning to end in a perfectly predictable manner (barring errors and other exceptions)....
|
|
|
|
Total Hits: 660 | Today: 0
|
Author: Vyas Kondreddi
|
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 ...
|
|
|
|
Total Hits: 622 | Today: 0
|
|
Rating:
|
|
Sample chapter 7 from "MCSE Training Kit: Microsoft® SQL Server™ 2000 System Administration". This chapter prepares you to populate your database from an existing data source. The chapter begins with a discussion of the data transformation, consistency, and validation issues you will encounter when you import data from one or multiple sources into a SQL Server 2000 database. Next, you are introduced to the primary SQL Server 2000 tools used for populating a database. Finally, you learn how and w...
|
|
|
|
Total Hits: 822 | Today: 4
|
|
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....
|
|
|
|
Total Hits: 564 | Today: 0
|
|
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...
|
|
|
|
Total Hits: 452 | Today: 0
|
|
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...
|
|
|
|
|
|
