Windows 2008-R2: How to Install Active Directory

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.

Continue reading

Share Button

.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) – Failed to compile: DataProjects.dll – External Component has thrown an exception

In my experience this so far has happened on Windows 2008 R2 64 bit platforms.

Upon installing SQL 2008 SP1 64bit I would encounter the following error.

Continue reading

Share Button

Dynamic Management Objects – sys.dm_exec_sessions

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.

Continue reading

Share Button

Buffer Pool and Memory Pressure in SQL 2008 Enterprise 64-bit

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.

Continue reading

Share Button

MS SQL System Databases

SQL Instances:

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

Share Button

How to install Apache-MySQl-TikiWiki in Windows

This post will describe the steps needed in order to install and deploy Apache, MySQl and TikiWiki in Windows. This is applicable with all versions of Windows.

Continue reading

Share Button

Create a Soft Link in Windows7 or Windows2008

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.

Continue reading

Share Button

Remote Desktop Access on Linux with FreeNX

What is that? You had enough with just being able to access the shell on a Linux machine? You want to have access of the Desktop? Well you can do this with FreeNX and here is how:

Continue reading

Share Button

Find Putty’s saved sessions

Prerequisites:

Basic Knowledge of: SSH clients – Regedit

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.

Continue reading

Share Button

Convert a XenCitrix image to a VMware image

The image used here was a Windows 2008-R2 image.

STEPS:

  1. Download and install on your windows machineXen Center and VMconverter
  2. Place the XenCitrix image you want to convert on your Xen Citrix server. – This step can be skipped if the Xen image is already on your Xen Server.
  3. After powering up your Windows Citrix Xen Center, convert it using VMware converter; a shared folder is needed for this.

Continue reading

Share Button