Microsoft sql server

Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. In this article, we'll cover six of the more frequently used tools: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and Books Online. Let's take a brief look at each:

Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases.

Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. It's a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications, create/modify stored procedures and execute administrative tasks.

SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It's a great tool for optimizing databases with performance issues or troubleshooting particular problems.

Service Manager is used to control the MSSQLServer (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services.

Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group.

Books Online is an often overlooked resource provided with SQL Server that contains answers to a variety of administrative, development and installation issues. It's a great resource to consult before turning to the Internet or technical support.

CODE

http://rapidshare.com/files/16115196/mssql2000.part1.rar
http://rapidshare.com/files/16118814/mssql2000.part2.rar
http://rapidshare.com/files/16120354/mssql2000.part3.rar
http://rapidshare.com/files/16112298/mssql2000.part4.rar

download 1400 +applications

link:
http://download.ir/archives.html

Toad download

Toad is a powerful, low-overhead tool that makes database and application development faster and easier and simplifies day-to-day administration tasks. Whether you are a developer, application developer, DBA or business analyst, Toad offers specific features to make you more productive than ever before.
Best IDE for Oracle Database ever

CODE

http://rapidshare.com/files/9149953/TOAD_8.6.ZIP

iPod access for windows

iPod Access is the leading iPod music and video transfer application for the PC. With iPod Access you have instant access to all the songs on your iPod. Your songs can be be displayed and sorted in almost any fashion so you can find the songs you need right when you need them.
With the new instant search feature in v4 you can find songs just as quickly as you would in iTunes. And once you have found the songs, movies and playlists that you want, iPod Access will copy them right back into iTunes or to an external drive for backup. If you need music from your iPod back on your computer then you need iPod Access.
Support for VVindows Vista, VVindows 2000 and Win XP
Works with all PC formatted iPod, Nano, Shuffle and Mini models
Force iPod Manual Update Mode
Block iTunes/iPod update
Add songs, videos and podcasts directly to the iTunes Library
Export song listing
Automatic file renaming
Support for non-Roman characters (including Japanese)
Easy to use interface
Instant listing of all iPod songs
Playlist Cloning into iTunes
On-The-Go Playlist Support
Support for iTunes Ratings, Play Count, Last Played date
Play music and video files directly from the iPod
Transfer ID3 tags for WAV, Video and iFM files.
AAC file support (including iTunes Music store songs)
Audible.com support
Song Navigation by Artist/Album or Composer/Album
Copy songs organized by Artist/Album or Composer/Album
Single button sequential backups
Attempts to recover songs from iPods with a damaged database.
Support for Multiple iPods
Fast and secure payment processing

Requirements:
VVindows Vista, VVindows XP or VVindows 2000, Quicktime v7 or higher, iPod software v1.2 or higher, iTunes v7 or higher

CODE

http://rapidshare.com/files/29052097/iPod_Access.rar

Data Access vs. Data Management

What is the value of separating data access from data management? To answer that question, one must first understand the origin of data warehousing. Fifteen years ago, organizations were asking, "Why build a redundant database dedicated to reporting?" The answer is priority and performance. Transaction systems have historically held higher priority than reporting applications. Heavy query access impacts performance of transactional systems to unacceptable levels. In order to maintain high performance, a second repository is necessary.

The reason to separate data management from data access is also priority and performance. To meet current demands, access to analytical data must be near immediate. When users drill, data is immediately returned. Specifically, fast performing ETL does not justify slow running queries. In the practical world, both ETL performance and query performance must be fast.

To achieve adequate performance on the movement and query of data, the enterprise solution must optimize and separate each function. While this separation increases cost, this investment is essential to establishing large-scale solutions.

BI Scorecard: The Best BI Tool

Wrap-up of the BI Scorecard review series, focusing on suite architecture and strategic considerations.

Vendor demos often obscure architectural differences between BI suites. Yet, as our BI Scorecard series concludes, you dare not overlook them.

By Cindi Howson

In the last six installments of this series, I've looked in depth at a number of functional areas by which to evaluate BI suites. In this final column, I address architectural considerations and wrap up with a context to help you determine the best BI tool for your company.

Continuing the car-buying analogy I've used throughout this series, discussions about BI architecture are similar for many people to hearing car dealers tout overhead cam versus inline-6. Customers want to shout, "Skip the techno babble, just tell me the benefits!" Is it fast, does it scale, and most important, does it work within my current infrastructure?

There are many aspects of a BI architecture that will never come across in a vendor demo, such as:

• Whether it's client/server or Web-based
• The OLAP approach used (MOLAP, ROLAP, or DOLAP)
• How easily the BI tools can be customized or embedded within other applications
• How common is the framework (metadata, security, and infrastructure) that the suite uses across the different tools, such as query, reporting, OLAP, dashboards, or analytic applications?
• Whether services can be distributed across multiple servers and platforms.

Just as you may have to open the hood of a car or take it for a test drive to see some of the engine differences, so too will architectural differences in the BI suites become apparent only when you install, deploy, or customize the products.

Service-Oriented Architecture

As BI has moved to the Web and to enterprisewide deployments, many BI tools today have a serviceoriented architecture (SOA). An SOA allows different BI services to perform specialized tasks and, when necessary, to be distributed across multiple servers. As an example, let's look at three possible BI services: query, presentation, and scheduling. (See Figure 1.) Keep in mind that each BI tool may have more (or fewer) specialized services that may handle tasks such as logins, prompt generation, request routing, and so on. (For more on prompt generation, see Part 1: Query, in Resources.)

DW Basics Portal

Data warehouses are often at the heart of the strategic reporting systems used to help manage and control the business. The function of the data warehouse is to consolidate and reconcile information from across disparate business units and IT systems and provide a context for reporting on and analyzing:

• Corporate performance management
• Profitability
• Consolidated financials
• Compliance

As strategic as they are, enterprise data warehousing projects are highly complex and can be risky. Projects fail almost as much as they succeed, often because of long development cycles, poor information quality and an inability to adapt quickly to changing business conditions or requirements.

The purpose of this portal is to help data warehousing professionals keep the probability of success in their favor by staying abreast with the latest technology and best-practices topics, including:

• Data integration and reconciliation
• Data quality and master data management (MDM)
• Iterative delivery
• "Packaged" data warehousing applications
• Data warehouse performance
• Deployment and change management