Guest    Sign in   |   Join   |    Home
Skip Navigation Links
ArticlesExpand Articles
Forums
BooksExpand Books
ResourcesExpand Resources
Authors List
News and Events
MSDN Comm. Dis.Expand MSDN Comm. Dis.
Guest Book
Link to us
Contact us
About us
 

  
  
• 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




















 Copyright © 2006 Innovation-Hut. All Rights Reserved. |  Terms of Use  |    Privacy Statement   |   FAQ