|
• SQL Server
Welcome to the SQL Server section of the Innovation-Hut technical Articles. In this section, you will find
a lot of
SQL Server articles on various new ideas and techniques,
concerning learning the SQL Server, and a lot
of tips, resources, and free source code.
Resource Governor – Administrator’s Choice
Danish Sami
November 2007.
Resource Governor or RG is SQL Server 2008's new feature through which one can easily manage system resources like CPU, I/O. With RG you can define resource limits, priorities and enable consistent performance.
Read This Article
Analyzing Database Server Performance
Ahmed Morad
November 2007
SQL Server Performance is affected by many factors like the Processor, Memory, Hard Disks, Network Interface Cards…etc. To be able to detect the source of problems with a SQL Server machine, we need to monitor some counters and indicators, which indicate the source of the problem that the server is facing.
Read This Article
Creating a Windows Group for SQL Administrators
Ahmed Morad
December 2007
SQL Server runs with two authentication modes, "Windows Authentication" or "Windows and SQL Server Authentication". Windows Authentication mode, which is the default one, presents a higher access control on the SQL Server instance since it allows only the users listed in the Domain's Active directory, or local users to obtain a connection to a SQL Server instance and its databases.
Read This Article
|
|