I am totally pumped up about having the opportunity to host a SQL Saturday #156 in Providence RI. I have been involved with the local PASS group, SNESSUG for almost four years and the current chapter president for one. I have definitely grown from the experince! I will be centering the keynote speach on the value of professional associations, a recent topic of Buck Woody at Simple Talk. With a product as big as SQL Server (TSQL, SSIS, SSAS, & SSRS), it is great to chat with others doing work…
Basic Training – Data Types – Part 5
I am continuing my series of talks on fundamental topics like data types. I am proud to be a United States Army Reservist (USAR) Veteran. Just like boot camp I went to so long ago, I am going nick name the series BASIC TRAINING. The most basic unit of any database is a TABLE which consists of COLUMNS. A vital decision during the initial database design is to choose the data types that will capture the information you want in the least amount of space. Today, I am exploring date…
Basic Training – Data Types – Part 4
I am continuing my series of talks on fundamental topics like data types. I am proud to be a United States Army Reservist (USAR) Veteran. Just like boot camp I went to so long ago, I am going nick name the series BASIC TRAINING. The most basic unit of any database is a TABLE which consists of COLUMNS. A vital decision during the initial database design is to choose the data types that will capture the information you want in the least amount of space. Today, I am exploring unicode…
Basic Training – Data Types – Part 3
I am continuing my series of talks on fundamental topics like data types. I am proud to be a United States Army Reservist (USAR) Veteran. Just like boot camp I went to so long ago, I am going nick name the series BASIC TRAINING. The most basic unit of any database is a TABLE which consists of COLUMNS. A vital decision during the initial database design is to choose the data types that will capture the information you want in the least amount of space. Today, I am exploring character…
Basic Training – Data Types – Part 2
I am continuing my series of talks on fundamental topics like data types. I am a proud United States Army Reservist (USAR) Veteran. Just like boot camp I went to so long ago, I am going nick name the series BASIC TRAINING. The most basic unit of any database is a TABLE which consists of COLUMNS. The most important decision during the initial database design is to choose the data types that will capture the information you want in the least amount of space. Today, we are reviewing Approximate Numerical…
Basic Training – Data Types – Part 1
Just the other day, I was tasked with redesigning a data warehouse’s star schema that grew to over 4 terabytes in size. After completing the project, I realized that if the original designers knew more about storage (data types, data pages, index pages), the explosive growth would have not been so bad. I ended up putting the database on a diet of daily table partitions and page compression. Today, the database is 20% of it’s orginal size. In short, I am going to start off a series of talks covering…
New York City – SQL Saturday #158
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…
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…