X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 sql server tutorial


Microsoft Announces SQL Server 2000
On December 13, Microsoft Corp. announced that the next major release of Microsoft« SQL Server, currently code-named

sql server tutorial  Announces SQL Server 2000 Event Summary REDMOND, Wash. - Dec. 13, 1999 - Microsoft Corp. today announced that the next major release of Microsoft SQL Server, currently code-named Shiloh, would officially be named SQL Server 2000. Microsoft also revealed the features within SQL Server 2000 that will take advantage of the Microsoft Windows 2000 operating system, as well as the ways SQL Server 7.0 customers today can reap benefits from Windows 2000. SQL Server 2000 is due to ship in the first

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » sql server tutorial

Reporting Tools


Analysis and reporting services are an important part of the enterprise resource planning process. Microsoft Dynamics NAV has been designed to give users options for optimal analysis and reporting, and to leave room for partners to provide customized solutions. With the correct reporting tools and Microsoft Dynamics NAV, practical analysis and reporting is available and adaptable to individual users’ needs.

sql server tutorial  Services is not recommended. SQL Server If Microsoft Dynamics NAV is running on SQL Server, data can be accessed directly in SQL. There are some caveats about doing this. First of all, security will have to be maintained in the SQL database. On top of this, you have no access to business logic when accessing data residing in SQL Server, and there is no access to flow fields when doing so, either. That said, this solution enables the use of Reporting Services and if running SQL 2005 the use of Report B Read More

Case Study: SAP Business One Making The Difference For Source 1 Enterprises


For compliance with vendor requirements, Source 1 Enterprises, a supplier of health and beauty products, needed a solution to automate bill-back revenue and current deal sheet promotions. Reporting and alert systems were also needed, to collect potential revenue based on standard vendor terms, in conjunction with the latest promotions. For a solution, the supplier turned to SAP Business One.

sql server tutorial  market. Designed on the SQL Server platform, SAP® Business One could easily integrate with our SQL Server environment. We were also quickly impressed with the ease of custom table generation and the ability to define customer user fields”. Vision33 worked collaboratively with Source 1 Enterprises to understand its current pains and business drivers. Equipped with this valuable insight, Vision33 installed SAP® Business One with three (3) company databases. The solution was then customized to meet the Read More

Best Practices for a Data Warehouse on Oracle Database 11g


Companies are recognizing the value of an enterprise data warehouse (EDW) that provides a single 360-degree view of the business. But to ensure that your EDW performs and scales well, you need to get three things right: the hardware configuration, the data model, and the data loading process. Learn how designing these three things correctly can help you scale your EDW without constantly tuning or tweaking the system.

sql server tutorial  a SQL statement. The SQL Monitoring screens also provide information about the parallel server sets and work distribution between individual parallel servers on the Parallel tab (see Figure 23). Ideally you see an equal distribution of work across the parallel servers. If there is a skew in the distribution of work between parallel servers in one parallel server set then you have not achieved optimal performance. The statement will have to wait for the parallel server performing most work to complete. T Read More

Microsoft Windows SharePoint Services / MS Office SharePoint Server 2007


Collaborative tools are becoming essential to sharing data in today’s office environment. You need a solution that can grow to accommodate new projects and uses—and a storage system that is flexible enough to meet initial demands and adapt to changes. Find out how a multiple-node storage area network (SAN) can maximize the scalability and functionality of your collaboration tools, and ease storage administration.

sql server tutorial  as a set of SQL Server databases which reside in NTFS volumes. For best performance and reliability, these volumes should reside on direct attach storage (RAID storage arrays), or block-level storage on a Fibre Channel (FC) or iSCSI SAN. An iSCSI SAN from LeftHand Networks has ive advantages that recommend it as the best choice: You get all the storage management features and beneits of a modern, state of the art SAN (e.g. thin provisioning, replication, high availability, snapshots). The storage is shara Read More

Rackmount Server Sales Surge


Rack-optimized servers are reported to have increased their quarter-over-quarter unit sales by over 50%

sql server tutorial  Server Sales Surge Rackmount Server Sales Surge R. Krause - August 17, 2000 Event Summary July 31, 2000 - IDC reports that unit sales of rack-optimized Intel-based servers increased over 55% from 4Q99 to 1Q00, compared with a 2% decline for the overall Intel server market. In the meantime, major Intel server vendors are planning to increase their rack-optimized products offerings in the coming months. Market Impact This trend has been obvious for a long time, so we're surprised it took the market Read More

CaminoSoft Managed Server HSM


Companies today are managing ever-increasing amounts of data. Traditional solutions have involved increasing server space by adding more hard drives. Strategically, however, this is like building storage rooms in your house, with no thought as to what will be stored where. That’s why you need an intelligent approach to data management, which doesn’t involve “building more rooms” in your systems.

sql server tutorial  Managed Server HSM Companies today are managing ever-increasing amounts of data. Traditional solutions have involved increasing server space by adding more hard drives. Strategically, however, this is like building storage rooms in your house, with no thought as to what will be stored where. That’s why you need an intelligent approach to data management, which doesn’t involve “building more rooms” in your systems. Read More

Security Auditing In Microsoft SQL Server


As digital information has become more and more critical to businesses, firewalls—which once served as the walls of the fortress, have now become an archaic means of defense. Thus, as threats evolve, responses must change as well. Rather than focusing protection solely on perimeter security, it is imperative to look at protecting data at the source—inside the database.

sql server tutorial  Auditing In Microsoft SQL Server As digital information has become more and more critical to businesses, firewalls—which once served as the walls of the fortress, have now become an archaic means of defense. Thus, as threats evolve, responses must change as well. Rather than focusing protection solely on perimeter security, it is imperative to look at protecting data at the source—inside the database. Read More

Server Platform Revitalization in the Enterprise Applications Space


The whole idea of enterprise application modernization is to renew existing software so that it can satisfy the need for integration and graphical presentation without losing any functionality. IBM is looking towards independent software vendors to help it in this endeavor.

sql server tutorial  Platform Revitalization in the Enterprise Applications Space IBM Response Among many enhancements it made in the late 1990s, IBM added 8- and 12-way processing power to its Power5 platform. Today, it has reached 64-way processing power to the Power5 platform. Substantial price and performance improvements, Lotus Workplace support, Operations Navigator (which eliminates the need for a green screen to perform any system administration), and Windows NT IPCS have been included. Windows NT IPCS is an Read More

Microsoft Eats its Own Dog Food With SQL Server 2000


Microsoft announced that they are running 20 critical internal systems, including their worldwide sales data warehouse, on SQL Server 2000. In the vendor world, this is referred to as “eating your own dog food”. As is the case with all software vendors lately, Microsoft is pushing e-commerce on the Web and support for XML. SQL Server beta release 2 is available immediately.

sql server tutorial  Own Dog Food With SQL Server 2000 Microsoft Eats its Own Dog Food With SQL Server 2000 M. Reed and A. Turner - May 12 , 2000 Event Summary Microsoft announced they are running 20 critical internal systems, including their worldwide sales data warehouse, on SQL Server 2000. In the vendor world, this is referred to as eating your own dog food . As is the case with all software vendors lately, Microsoft is pushing e-commerce on the Web and support for XML. SQL Server 2000 beta release 2 is available Read More

PeopleSoft on Client/Server and Database Issues


To address questions for a TEC customer, we interviewed PeopleSoft's Michael Daniels. The conversation covered issues in the areas of client/server architecture and database management as they relate to the PeopleSoft Enterprise Resource Planning suite of products.

sql server tutorial  on Client/Server and Database Issues Event Summary To answer questions for a Technology Evaluation Center customer, a large utility in the northeastern United States, TEC interviewed Michael Daniels of PeopleSoft on how the PeopleSoft ERP product performs in the areas of client/server architecture and database management. Question: Is PeopleSoft designed as a fault tolerant environment? Exactly how is this accomplished? Is the failover manual or automatic? Mr. Daniels: PeopleSoft clients use a Read More

Securing your Apache Web Server with a thawte Digital Certificate


thawte Technologies is a Certification Authority (CA) which issues SSL Web Server Certificates to organizations and individuals worldwide. thawte verifies that the company ordering the certificate is a registered organization and that the person in the company who ordered the certificate is authorized to do so. thawte also checks that the company in question owns the relevant domain. thawte digital certificates interoperate smoothly with Apache and the latest software from Microsoft and Netscape, so you can rest assured that you purchase of a thawte digital certificate will give your customers confidence in your system and integrity—they will feel secure about transacting on-line. Information is a critical asset to your business. To ensure the integrity and safety of your information, it is important to identify with whom you are dealing and the data you are receiving is trustworthy.

sql server tutorial  your Apache Web Server with a thawte Digital Certificate thawte Technologies is a Certification Authority (CA) which issues SSL Web Server Certificates to organizations and individuals worldwide. thawte verifies that the company ordering the certificate is a registered organization and that the person in the company who ordered the certificate is authorized to do so. thawte also checks that the company in question owns the relevant domain. thawte digital certificates interoperate smoothly with Read More

Ten Cooling Solutions to Support High-density Server Deployment


High-density servers offer a significant performance per-watt benefit. However, they can present a significant cooling challenge. Most data centers are designed to cool an average of no more than 2 kilowatts per rack, but many new servers demand over 40. Thus, innovative strategies must be used to properly cool high-density equipment. Read about 10 approaches that can help increase cooling efficiency in your data center.

sql server tutorial  Cooling Solutions to Support High-density Server Deployment High-density servers offer a significant performance per-watt benefit. However, they can present a significant cooling challenge. Most data centers are designed to cool an average of no more than 2 kilowatts per rack, but many new servers demand over 40. Thus, innovative strategies must be used to properly cool high-density equipment. Read about 10 approaches that can help increase cooling efficiency in your data center. Read More

SAS BI Server


SAS Enterprise BI Server is a comprehensive, easy-to-use business intelligence software solution that integrates the power of SAS Analytics and SAS Data Management to provide insights that power better decisions. It includes role-based, self-service interfaces for all types of users within a well-defined IT governance framework and a centralized point of administration. This helps organizations simplify and speed business intelligence deployment.

sql server tutorial  BI Server SAS Enterprise BI Server is a comprehensive, easy-to-use business intelligence software solution that integrates the power of SAS Analytics and SAS Data Management to provide insights that power better decisions. It includes role-based, self-service interfaces for all types of users within a well-defined IT governance framework and a centralized point of administration. This helps organizations simplify and speed business intelligence deployment. Read More