One of the handy tools included in SQL Server 7.0 is its Index Tuning Wizard. You can use this wizard to analyze both your existing database as well as sample queries–and then make recommendations as to any indexes you should create to speed up those queries.

Perhaps one of the more compelling hands-off administration abilities of SQL Server is the SQL Mail capability. SQL Mail lets you send, receive and process mail from within SQL Server. The most common use of this is setting up the SQL Agent process to alert you to server conditions. Since many wirel

The main difference you will notice when you open Access 2000 is the Objects Bar (see the next section for more details on this feature). Additionally, there are several welcome enhancements to the database window. A set of New Object shortcuts let you quickly create a new object or use the appropri

Paul Flessner, senior vice president of the .NET Enterprise Servers Group at Microsoft Corp., announced the worldwide availability, pricing and licensing of Microsoft® SQL Server™ 2000 Windows® CE Edition. A new member of the SQL Server product family, SQL Server for Windows CE extends enterprise da

The IDENTITY property provides auto-generated values for a numeric column in your table based on initial (seed) and increment arguments that you supply. The first row that users insert into the table contains the value you supply as the seed argument in the identity column. As users insert new rows

In revamping the way SQL Server implements security in the 7.0 release, Microsoft created a flexible and powerful method for managing users' access both to the SQL Server system and to the databases. The changes also created confusion as administrators tried to upgrade from SQL Server 6.5 securi

Devphiles, Sweden's leading company in the field of e-learning for developers and Konsultmarknaden have entered into a collaboration agreement. The agreement implies that Devphiles will be able to reach a larger proportion of Sweden's developers and therefore give the company a competitive e

SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as we

The Home Shopping Network (HSN) recently migrated from Oracle running on Sun Solaris to SQL Server 2000 running on Windows 2000 Advanced Server to reduce costs, increase performance, and decrease time to market for new functionality. SQL Server 2000’s Data Transformation Services (DTS) lets HSN coor

Devphiles Education-We are on the cutting edge in such areas as Active Server Pages, XML, DHTML, SQL, Java and Visual Basic. Our experts are holding the classes themselves. We conduct tests, and tailor individual trainingprograms. Basic training is available online while the more advanced classes ar