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 > Support WebCasts > SQL Server 7.0


Search:
What's New - What's Hot
Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0  Version: 0.00     Price: $0.00  
Total Hits: 31  |  Today: 0Author: Michael McManus      Rating:  
Read Reviews | Write Review |  Your 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....

SQL Server 6.5 Useful Undocumented Stored Procedures  Version: 0.00     Price: $0.00  
Total Hits: 55  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5....

Undocumented SQL Server 7.0 System Tables  Version: 0.00     Price: $0.00  
Total Hits: 46  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your 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)....

Data Page Structures in SQL Server 6.5  Version: 0.00     Price: $0.00  
Total Hits: 51  |  Today: 0Author: Tom Pullen      Rating:  
Read Reviews | Write Review |  Your 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....

MySQL Tip: MySQL Server Has Gone Away Or Lost connection to server during query Fix  Version: 0.00     Price: $0.00  
Total Hits: 79  |  Today: 0Author: Angsuman Chakraborty      Rating:  
Read Reviews | Write Review |  Your 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....

Connecting to Microsoft SQL Server 2008 from Microsoft Visual Studio 2005 and 2008     
Total Hits: 112  |  Today: 0Author: Jackie Goldstein      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2008 offers developers an advanced and powerful database engine and comprehensive programming framework with which to create data centric solutions. Since Visual Studio 2008 and 2005 were released before SQL Server 2008, their respective tools and data designers do not automatically support SQL Server 2008 and its new data types and features. Microsoft is providing SQL Server 2008 support updates for Visual Studio in order to allow the designers to communicate with SQL Serve...

SQL Server 2008 Transparent Data Encryption getting started     
Total Hits: 237  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your 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...

Evaluating and Implementing Policies in Multiple Instances in SQL Server 2008     
Total Hits: 405  |  Today: 0Author: Edwin Sarmiento      Rating:  
Read Reviews | Write Review |  Your 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...

Textual Searches on File Data Using Microsoft SQL Server 7.0     
Total Hits: 215  |  Today: 0Author: Margaret Li and Frank Pellow      Rating:  
Read Reviews | Write Review |  Your 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....

Using Visual Studio 6.0 Database Tools with Microsoft SQL Server 7.0     
Total Hits: 223  |  Today: 0Author: Ninia Ingram      Rating:  
Read Reviews | Write Review |  Your 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...

Microsoft SQL Server 7.0 Storage Engine Capacity Planning Tips     
Total Hits: 137  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article is a guide to storage engine architecture and recommends configuration parameters, best hardware to purchase with SQL Server 7.0, and innovative ways to store large amounts of data through files and file groups. This article also discusses new features in the SQL Server 7.0 storage engine. The I/O subsystem (storage engine) is a key component of any relational database management system (RDBMS). A successful RDBMS implementation requires careful planning at the early stages of the p...

Microsoft SQL Server 7.0 Replication Made Easy     
Total Hits: 138  |  Today: 0Author: Tai Yee      Rating:  
Read Reviews | Write Review |  Your 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 ...

Support WebCast: Creating, Using, Debugging OLE DB Providers for Distributed Queries     
Total Hits: 684  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

Support WebCast: SQL Server 7.0 Full-Text Search and Basic Troubleshooting Methods     
Total Hits: 640  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

How Updates are Performed in SQL Server 6.5  Version: 0.00     Price: $0.00  
Total Hits: 34  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your 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....

Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands  Version: 0.00     Price: $0.00  
Total Hits: 50  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your 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....

Yahoo Geocode, SQL Server 2008 and ASP.NET AJAX     
Total Hits: 410  |  Today: 0Author: Matthew Ellis      Rating:  
Read Reviews | Write Review |  Your Rating: 

Beginning where the article Virtual Earth, SQL Server 2008 and AJAX left off, we’ll add to our real estate application by enabling the insertion of new properties into our SQL Server 2008 database by querying the Yahoo Geocode service to retrieve the longitude and latitude of a specified address....

Access to SQL Server 2008 Virtual Environment     
Total Hits: 309  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Back in June 2007, we announced that SQL Server 2008 is on its way in this tip SQL Server 2008 has arrived. In addition, we talked about how to learn more about SQL Server 2008 in this tip Learning SQL Server 2008. The problem with learning something new is that it often takes a lot of time to setup an environment before you can actually do anything. With server virtualization this is much easier to setup and take down servers at will, but this still requires effort to get the virtual server s...

Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008     
Total Hits: 292  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your 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....

Creating a Scorecard in PerformancePoint Server 2007 (PPS)     
Total Hits: 321  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are just getting started with PerformancePoint Server 2007 and trying to help our business users to develop their first scorecard. For those of you who are new to Office PerformancePoint Server 2007, PPS is a recent addition to the Microsoft Business Intelligence (BI) offering. PPS enables users to develop a variety of reports and scorecards, then compose them into a dashboard which is deployed to SharePoint. Business users can then simply navigate to a URL in a SharePoint site to access t...


1  2  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net