|
|
|
|
|
Total Hits: 404 | 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: 415 | 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: 449 | 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: 3 | Today: 0
|
Author: Edgewood Solutions Engineers
|
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...
|
|
|
|
Total Hits: 2 | 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: 7 | 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. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through querie...
|
|
|
|
Total Hits: 6 | Today: 1
|
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: 8 | 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: 7 | 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: 16 | Today: 0
|
Author: Ray Barley
|
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...
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: Ray Barley
|
Rating:
|
|
We have heard that you can create filters in a Performance Point dashboard then apply them to one or more reports and scorecards. Can you provide some step-by-step instruction on how to do this? The PPS product 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 acce...
|
|
|
|
Total Hits: 31 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
With the recent release of SQL Server 2008, getting up to speed on the technology is necessary from a number of different perspectives. From your view of the world what are the drivers from a business, technology and career perspective? Have you heard insight or opinions related to employers view of SQL Server 2008? Do you have any suggestions when talking to management about moving to SQL Server 2008?...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
At our organization we have had limited exposure to SQL Server 2005 because SQL Server 2000 just works. We have worked with SQL Server 2005 in some particular areas, but we do not have the enterprise experience we need to move forward. We know support will be lifted for SQL Server 2000 and know we need to jump on SQL Server 2005 or 2008 in short order. How can I get some first hand experience and what sorts of things should I try to do? In an earlier tip (Access to SQL Server 2008 Virtual Env...
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Goetz Graefe, Jim Ewel, and Cesar Galindo-Legaria
|
Rating:
|
|
Microsoft® SQL Server™ version 7.0 is a defining release for Microsoft's database products, building on the solid foundation established by Microsoft SQL Server version 6.5. Customer needs and requirements have driven the significant product innovations in SQL Server 7.0. As the best relational database management system (RDBMS) for the Microsoft Windows® family of operating systems, SQL Server is the right choice for a broad spectrum of corporate customers and independent software vendors (ISVs...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
Replication provides a fast and reliable way to disseminate corporate information to multiple locations in a distributed business environment, enabling organizations to move their data closer to knowledge workers in corporate, branch, or mobile offices. This paper provides information about the replication capabilities of Microsoft® SQL Server™ version 7.0, and how they can empower users, improve decision-making, and increase the performance and reliability of existing systems by reducing depend...
|
|
|
|
Total Hits: 5 | Today: 0
|
Author: Henry Lau
|
Rating:
|
|
Shows SAP R/3 database administrators and others who work on very large databases how to tune Microsoft® SQL Server™ version 7.0 for the workload conditions of the SAP R/3 environment. (22 printed pages) Covers:
* Configuration options to consider for Microsoft Windows 2000® Server
* Configuration options for SQL Server in the SAP R/3 environment
* SQL Server index design as it pertains to SAP R/3
"Microsoft SQL Server 7.0 Performance Tuning Guide" is companion reading to...
|
|
|
|
Total Hits: 4 | 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: 6 | 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: 3 | 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: 3 | Today: 0
|
Author: Peter Hussey
|
Rating:
|
|
Designing a Microsoft® SQL Server™ application for optimal performance can seem a daunting challenge. There are so many choices to make—development tools, database design, application structure, query design, choice of interface—and the "right" choices in each of these areas depend on your unique application requirements and on the skills your development team brings to the project. But you don't have time and resources to try out several different approaches to see which one works best for your...
|
|
|
|
|
|
