|
|
|
|
|
| | Total Hits: 309 | 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: 253 | 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: 149 | 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: 61 | Today: 0 | Author: Richard Waymire | Rating: |
| |
SQL Server 7.0 security features for developers and administrators and discusses how to best configure and manage secure database servers. This article also includes a section for organizations that are upgrading servers from earlier versions and offers source code for developers. The first integration of Windows NT security with SQL Server occurred with the release of SQL Server version 4.2, when integrated mode was introduced. Further enhancements were released with SQL Server version 6.0, as ... |
| | Total Hits: 124 | Today: 0 | Author: Henry Lau | Rating: |
| |
This performance tuning guide is designed to help database administrators configure Microsoft® SQL Server™ for maximum performance and help determine the cause of poor performance in a SQL Server environment. It also provides SQL Server application developers guidance on how to use SQL Server indexes and SQL Server tools for analyzing the input/output (I/O) performance efficiency of SQL queries.... |
| | Total Hits: 564 | 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.... |
| | Total Hits: 27 | Today: 0 | Author: Alexander Chigrik | Rating: |
| |
In this article, I want to tell you what should you know about some undocumented SQL Server 7.0 trace flags, and how you can use them for administration and monitoring.... |
| | Total Hits: 269 | 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: 244 | 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: 90 | 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: 106 | 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: 105 | 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... |
| | Total Hits: 83 | Today: 0 | Author: Microsoft Corporation | 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... |
| | Total Hits: 108 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
Making better business decisions quickly is the key to succeeding in today’s competitive marketplace. Organizations seeking to improve their decision-making ability can be overwhelmed by the sheer volume and complexity of data available from their varied operational and production systems. Making this data accessible is one of the most significant challenges for today’s information technology professionals. In response to this challenge, many organizations choose to build a data warehouse to unl... |
| | Total Hits: 81 | Today: 0 | Author: Surajit Chaudhuri and Vivek Narasayya | Rating: |
| |
Enterprise-class databases require database administrators (DBAs), who are responsible for performance tuning. One important task of a DBA is selecting a physical database design that is appropriate for the system workload. An important component of physical database design is selecting indexes. The index selection problem has been studied from the early 70s and the importance of the problem is widely acknowledged. In data-intensive applications, such as decision support and data warehousing, ch... |
| | Total Hits: 79 | Today: 0 | Author: Dave Mendlen | Rating: |
| |
The database diagram is a critical document. It helps developers visualize structures of tables and relationships. One of the first things developers want to do when starting to work on a new project is print the entire database schema. The print out from a complex database can cover an entire wall. Sometimes it's easier to understand a database structure if you look at it by subject area. The database diagram tools enable developers and database administrators (DBAs) to create "windows" into th... |
| | Total Hits: 89 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
Replication is an important and powerful technology for distributing data and stored procedures across an enterprise. The replication technology in Microsoft® SQL Server™ allows you to make copies of data, move those copies to different locations, and synchronize the data automatically so that all copies have the same data values. Replication can be implemented between databases on the same server or between different servers connected by LANs, WANs, or the Internet. By combining SQL Server with... |
| | Total Hits: 97 | 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... |
|
|
|
|
|
|
|
|
|
|
|
|
|