I am totally pumped up about having the opportunity to present at SQL Saturday #158 in New York City. It should be a good time to network with other professionals in the field and learn some new things about the product. I will be posting an updated version of the presentation with TSQL code before the end of the week. I hope you have time to attend cool event on August 4th, 2012! Topic: Full Text Indexing Basics Abstract: Today’s large data fields (LDF) are full of unstructured information stored…
Month: July 2012
Virtual Box – FTP Server Settings
I am continuing work on PROJECT ALPHA which is chartered to create a test environment for a PERL based Etract Translate and Load (ETL) solution. If you have correctly followed the previous Oracle Virtual Box articles, a working guest image of Windows 2008 Server now exists with the IIS 7.0 Web server role installed. Today, we are going to concentrate on configuring the FTP server. A local windows user account will have a home directory containing the test data file for the Perl program. The series of screen shots below…
Virtual Box – Windows Server Creation
Today, I am continuing working on PROJECT ALPHA. The project is chartered to create a test environment for developing a PERL based Etract Translate and Load (ETL) solution. I am assuming that you have correctly followed all Oracle Virtual Box – VHD Creation steps that we did last time. The installation ISO is listed as a bootable drive and will kick off when the Virtual Image is started. The series of screen shots below will walk you through installing Windows 2008 Server on the new virtual hard disk (VHD). Step…
Virtual Box – VHD Creation
Today, I am continuing working on PROJECT ALPHA. The project is chartered to create a test environment for developing a PERL based Etract Translate and Load (ETL) solution. One requirement of the project is to have a FTP server to stage test files. Window 2008 R2 Server comes with Internet Information Services (IIS) 7.5. As part of the installable server role, we can select the FTP options to meet our requirements. There are many virtual machine vendors of the market: Microsoft Virtual PC, VMWare Player, Citrix XenServer and Oracle Virtual…
Virtual Box – Know your hardware
Before today, I have written many articles that were concentrated on one topic in SQL Server or Perl or Visual Basic. Starting today, I am going to kick off a full blown development exercise named PROJECT ALPHA. The purpose of this project is to create a test environment for developing a PERL based Extract Translate and Load (ETL) solution. The following is a list of business requirements for this ETL project. A runnng trace file will be created in the LOGS directory. Connect to an FTP server using basic authentication.…
Calculating Primes – Part 2
Today I am going to talk about calculating primes. Not the Transformer movie in which Optimus Prime has to help the humans save the world. I am talking about prime numbers, a postive integer that is only divisable by one and itself. All other integers, greater than 1 are non-prime, composite numbers. We are going to refine the algorithm for calculating prime numbers by using the the fundamental theorem of arithmetic. Any positive integer can be divided in primes in essentially only one way. The phrase ‘essentially one way’ means…
Moving System DB’s – Part 3
I was recently approached by my manager to free up a Direct Attached Storage (DAS) device from a test server so that it could be leveraged in a higher environment. To my amazement, both the system databases and binary executables were installed on the drive I needed to move. Today, we are going to concentrate on moving the binary executables from Drives D: and H:. The solution to this technical problem is to trick the database engine in thinking nothing has changed. In reality, two new drives will be carved…
Calculating Primes – Part 1
Today I am going to talk about calculating primes. Not the Transformer movie in which Optimus Prime has to help the humans save the world. I am talking about prime numbers in which the number is only divisable by one and itself. The Algorithm that I am going to introduce is a brute force method for calculating prime numbers. It is great for comparing the computing power of two machines by looking at overall execution times. This routine consists in dividing n by each integer m which is greater than…
Moving System DB’s – Part 2
I was recently approached by my manager to free up a Direct Attached Storage (DAS) device from a test server so that it could be leveraged in a higher environment. To my amazement, both the system databases and binary executables were installed on the drive I needed to move. Today, we are going to concentrate on moving master and resource system databases. Here is a article from MSDN to use as reference. Moving the master database 1 – Open the SQL Server configuration manager. 2 – Select the SQL Server…