Learn tips for administering SQL Server securely. Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation. Collation ...

When trying to install SolidWorks on a Windows computer, you may encounter an issue when the installation is trying to install Microsoft SQL Server. So, the installation works fine until it reaches ...

For sheer spectacle and dramatic content, the flap between PeopleSoft and ardent suitor Oracle is hard to beat. Want dramatic revelations? How about the fact that Oracle – long-viewed as a tough ...

Three cheers for the BabelFish translation system. The only words I recognized in this Austrian TechNet blog post were "Katmai" and "SQL Server." After doing a little on-the-fly Web translation, I ...

Nodes can run as SQL compute nodes, SQL storage nodes or HDFS data nodes. In the HDFS case, SQL Server and Apache Spark run co-located, in the same container. All of this interoperability is enabled ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Examine the similarities and differences between Windows security and SQL Server security and you'll find that most of the concepts you already know from managing a network will map quite nicely into ...

Or perhaps you could opt for per-named-user licensing, in which case SQL Server 2000 Standard Edition will set you back $1489 for five seats; $2,249 for ten seats; and $179 for each additional seat.