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

Microsoft has expanded the information about expanding hierarchies in SQL Server Books Online (BOL) since SQL Server 6.x. But the BOL solution merely displays the output; you can’t join the results with other views, tables, or results. My T-SQL coding solution fills this gap. Also, the solution I pr