Before this starts you may wonder what is an Active Directory in which case I will quote Wikipedia and say:
“Active Directory serves as a central location for network administration and security. It is responsible for authenticating and authorizing all users and computers within a network of Windows domain type, assigning and enforcing security policies for all computers in a network and installing or updating software on network computers. For example, when a userlogs into a computer that is part of a Windows domain, it is Active Directory that verifies his or her password and specifies whether he or she is a system administrator or normal user”. http://en.wikipedia.org/wiki/Active_Directory
If you wish to obtain more information you can go directly to the source which is Microsoft and obtain more information .
Having said that let us proceed with the tutorial.
Dynamic Management Objects (DMOs) are server objects which are being referenced in the SYS schema. These objects hold information regarding the internal activities of SQL. DMOs are presented either as Dynamic Management Views (DMVs) which are actually views or as Dynamic Management Functions (DMFs) which are in table values functions. As such both can be used as views and functions respectevely.
The overall philosophy of Microsoft is to create a database solution with low TCO (Total Cost of Ownership). SQL-2005 and SQL-2008 dynamically adjust their buffer pool. MS SQL it self will claim as much physical memory as it needs with out releasing it back unless requested to do so. Even if the server it self is not active SQL will keep claiming memory. It will do so up to the point before paging (Windows Page file). It is very typical to see a Windows server running SQL to be using about 500MBs of memory right after a reboot only to see that number increase to the range of GBs after few hours even when the server it self is not busy.
Each instance of MS-SQL is a unique instance and shares nothing with the other instances residing on the same or different server. If more than once instances are running on the same server only one can be the default instance. In order to connect to a named instance you have to specify the name of the server and the name of the instance.
DATABASES in MS SQL
Are a collection of tables, stored procedures, triggers, views and so on. One instance of a SQL Server can operate several databases. Upon install MS_SQL creates several databases that it needs for its operations such as: Continue reading →
Soft Links are popular between admins and programmers in the Unix and Linux world. This feature is available in Windows7 and Windows2008.
Think of it as an advanced shortcut. You have fileA (the soft link) pointing to an actual file. However the major difference with a simple shortcut is that you can actually point applications and processes to use the soft link. The applications/services will have no idea that this is a soft link that points to a different location. This is a feature admins and programmers use when they need to point different systems to one location with out changes a plethora of configuration files.
Assuming that you use PuTTY to connect to SSH servers, what happens if for example you cannot remember the IP address or hostname of a particular SSH server? NMAP is always an option but what if you just need is to see the IP and/or Hostname of that SSH server in order for your brain to go “A-Haaa, that is the one!”. Well here is how you do it.