|
|
|
|
|
| | Total Hits: 10 | Today: 0 | Author: Michael McManus | Rating:  |
| | 
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.... |
| | Total Hits: 33 | Today: 0 | Author: Alexander Chigrik | Rating: |
| |
In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5.... |
| | Total Hits: 26 | Today: 0 | Author: Alexander Chigrik | Rating:  |
| |
In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only the sysfiles1 system table is stored in each database).... |
| | Total Hits: 28 | Today: 0 | Author: Tom Pullen | Rating: |
| |
In this article, I want to tell you about data page structure in MS SQL Server 6.5, which are substantially different that what you currently find in SQL Server 7.0 and SQL Server 2000.... |
| | Total Hits: 27 | Today: 0 | Author: Alexander Chigrik | Rating: |
| |
In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 and 2000 for administering and monitoring.
DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they are also used for a variety of miscellaneous tasks, as you will see here.... |
| | Total Hits: 19 | Today: 0 | Author: Randy Dyess | Rating: |
| |
Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft can and will change the behavior of the flag between SQL Server versions, service packs or hot fixes.... |
| | Total Hits: 108 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
This article describes the concept of full-text search, as well as the design and architecture of the SQL Server 7.0 full-text search system. This article also illustrated how the SQL Enterprise Manager facilitated administration with stored procedures and graphical user interfaces. Microsoft® SQL Server™ version 7.0 introduces facilities that support textual queries on data residing in SQL Server as well as textual queries on data in the file system. This document describes support for textual ... |
| | Total Hits: 57 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
The Microsoft® TerraServer stores aerial and satellite images of the earth in a Microsoft SQL Server™ database served to the public through the Internet. It is the world's largest atlas, combining five terabytes of image data from the United States Geodetic Survey, SOVINFORMSPUTNIK, and Encarta® Virtual Globe. Internet browsers provide intuitive spatial and gazetteer interfaces to the data. The TerraServer demonstrates the scalability of Microsoft Windows NT® Server, Enterprise Edition version 4... |
| | Total Hits: 66 | Today: 0 | Author: Tai Yee | Rating: |
| |
Have you ever needed to make sure that data your business uses is copied to every branch office and is consistent across your organization? For example, suppose your corporate headquarters is in Chicago and you have regional offices in Seattle, Phoenix, Atlanta, and New York City. You want to keep a master price list for the products you sell at your home office, but you also want each regional office to have its own copy of the price list. Furthermore, each regional office tracks the orders it ... |
| | Total Hits: 536 | Today: 0 | | Rating: |
| |
October 5, 1999
This presentation covers the internals of the replication mechanism in SQL Server 6.5. It discusses the replication processes in depth and covers administration, performance tuning, and troubleshooting.... |
| | Total Hits: 522 | Today: 0 | | Rating: |
| |
November 2, 1999
This presentation will cover the basic Full-Text Search (FTS) features and functionality introduced in SQL Server 7.0. We will discuss the Full-Text Indexing and Search processes, compare FTS results to the LIKE function. We will also talk about FTS stored procedures, FTS performance tuning, and basic troubleshooting methods.... |
| | Total Hits: 9 | Today: 0 | Author: Dino Esposito | Rating:  |
| |
Universal Data Access (UDA) is Microsoft's solution for integrating different data sources into applications. OLE DB provides an API that allows you to expose heterogeneous data sources through a common set of software toolsâ?"specifically COM interfaces. While it is relatively easy to devise a common API to expose proprietary data in a standardized way, creating a general-purpose, universally valid mechanism for querying data is not as easy. In fact, it probably can't be done.... |
| | Total Hits: 59 | Today: 0 | Author: Angsuman Chakraborty | Rating: |
| |
A much dreaded MySQL error message during queries is "MySQL server has gone away". An alternative message is "Lost connection to server during query". This is a strange problem which afflicts a wide variety of PHP software including but not limited to WordPress. There are several causes for it. Let's look at the common and some rare causes and what you can do to fix it.... |
| | Total Hits: 195 | Today: 0 | Author: Ray Barley | Rating: |
| |
While reviewing the new features in SQL Server 2008, we noticed Transparent Data Encryption. This sounds very interesting. Could you provide us with an explanation and the details to implement it? TDE is a new feature in SQL Server 2008; it provides real time encryption of data and log files. Data is encrypted before it is written to disk; data is decrypted when it is read from disk. The "transparent" aspect of TDE is that the encryption is performed by the database engine and SQL Server cli... |
| | Total Hits: 249 | Today: 0 | Author: Ray Barley | Rating: |
| |
SQL Server 2008 provides the capability of storing BLOBs (e.g. MP3, Word, Excel, PDF, etc.) in the NTFS file system rather than in a database file. I am interested in how to configure the FILESTREAM technology in Management Studio. Could you help us to understand the benefits and provide details on how to implement this new feature in SQL Server 2008? Further, I am interested in how to use this functionality with the C# programming language.... |
| | Total Hits: 268 | Today: 0 | Author: Edwin Sarmiento | Rating: |
| |
In relation to the tip on Policy-Based Management in SQL Server 2008, we would like to implement policies on multiple SQL Server 2008 and even SQL Server 2005 instances. Can you give us a detailed explanation of how we go about doing this? Policies in SQL Server 2008 can be evaluated on the instance on which it was created. But one of the most tedious task that a database administrator needs to do is to go thru each of the SQL Server instances he or she manages and implement those polices. What... |
| | Total Hits: 80 | Today: 0 | Author: Margaret Li and Frank Pellow | Rating: |
| |
This article discusses facets of Microsoft SQL Server 7.0 textual searches such as: how SQL queries can be used on file systems lacking tables; how to use SQL extensions to make full-text queries; and how to work with a combination of file and database information. This article also discusses how BackOffice products (including: SQL Server distributed queries, Window NT Server's built-in Web Server, Internet Information Server (IIS), and Index Server 2.0) support textual searches in SQL Server 7.... |
| | Total Hits: 80 | Today: 0 | Author: Ninia Ingram | Rating: |
| |
Explains how to analyze data from different database management systems with Microsoft® SQL Server™ 7.0 and the Visual Studio® 6.0 Database Tools. (7 printed pages) With the linked server and TOP features in Query Designer you can:
* Access outside OLE DB data sources with the linked server feature.
* Limit the data you want returned by using the TOP clause.
* Improve database performance and efficiency with filegroups.
* Generate unique identifiers with the GUID data... |
| | Total Hits: 553 | Today: 0 | | Rating: |
| |
October 26, 1999
This presentation is designed to give developers an overview of OLE DB provider and data source specific issues with SQL Server 7.0 distributed queries. We will also discuss how to develop and troubleshoot an OLE DB provider to work with SQL Server 7.0 distributed queries.... |
| | Total Hits: 28 | Today: 0 | Author: Alexander Chigrik | Rating:  |
| |
SQL Server 6.5 can use two different methods to update records, depending on the circumstances. They include:
* Direct Update
* Deferred Update
Each method affects performance in a different way, as we shall see in this article.... |
|
|
|
|
|
|
|
|
|
|
|
|
|