Terminal Server Sessions

Many organizations still have servers running Windows 2003. The default number of sessions for Terminal Server, Remote Desktop Protocol (RDP), is two without add more licenses. If an administrators disconnects from the server instead of logs out, there will be open RDP sessions. If you need to login for some DBA task you are performing, you might get the following screen which states all connections are full. How do over come this situation? There are two solutions that you can try: 1 – Use the admin console option of the…

Just Say No!

Most security administrators are eager beavers when it comes to deploying and running antivirus software on any computer they can get their hands on. This includes Microsoft Windows Servers running your SQL Server Database engine. Do not let security administrators scan your database files and make your 2012 Dell xeon with eight cores perform like a 1996 Gateway Pentium 4 single core. I have seen the results of antivirus software scanning the database files while I am trying to execute basic queries. It is extremely painful.   With that said.…

Access Linked Tables

Today, I am going to build upon the prior ODBC Connection article by showing you how to create a LINKED TABLE in MS ACCESS. I am assuming that you have created a blank MS ACCESS 2007 database named [WILDLIFE.accdb]. I will be using the [WILD LIFE] SQL Server database that was created in a earlier article as the source of our information. First step is to select the external data, more, ODBC database option from the menu. This launches the wizard which walks you thru creating a LINKED TABLE. Second…

ODBC Connection

The ODBC standard was developed in the early 1990’s to allow a software developer to use a single interface to access mutltiple data sources. Microsoft Access is a very versatile application since it can import or link to a variety of ODBC data sources. Today’s article will cover how to define a new ODBC connection. I will be using the [WILD LIFE] database that was created in a earlier article. First step is to open to the administrator tools on the windows operating system. You can find this group under…

2011 Goal Statement

The purpose of this site is to talk about data mining techniques. I have been working in the Information Technology sector for twenty plus years and want to pass along my experience to younger IT professionals. In the next six months, I will be talking about the following topics with plenty of sample code to start your own applications. VBScript began as part of the Microsoft Windows Script Technologies, launched in 1996. It is widely used among system administrators in the Microsoft environment. Every Microsoft Operating system has the cscript…