Tuesday, December 24, 2013

What is Soundex?

Soundex is how a name of a person is coded as used in the census for locating a person. It is based on how a name sounds rather than how it is spelled.

The name of the person is converted into a 4 character code, the first character in the code is the first letter of the person's name capitalized. The next three characters (they are number) that follow the rule stated here.

Rule 1:
For letters B,F,P,V                           use the number 1
For letters C,G,,K,Q,S,X,Z               use the number 2
For letters D,T                                  use the number 3
For letter L                                        use the number 4
For letters M and N                         use the number 5
For letter R                                        use the number 6

Rule2:
Disregard the letters A, E, I, O, U, H, W, Y (unless they are the first character in the name)

Example:
If the person's name is johnson, the first character in the soundex code is J

As to the rest of the characters in the code, using the above rules we have for johnson the Soundex code J525

The Soundex for Johnson is reduced to JNSN since O and H are not counted and N=5 and S=2 and J is the first character.

By the same rule, the Soundex code for Iowa is I000
Get more info from here:
http://www.archives.gov/research/census/soundex.html

and here:
http://www.ironrangeresearchcenter.org/genealogy/help/soundex/index.htm
 

Thursday, December 19, 2013

Can you run Windows on MAC?

Yes you can. Virtualization makes it possible

Parallels has come out with Desktop 9 for MAC which makes it easy to run both operating systems on a MAC. It costs around $80 presently.

Here is a video from Parallels you want to see:



Follow up on this link for details:
http://www.parallels.com/products/desktop/

Monday, December 16, 2013

Can you get data from SQL Anywhere 16 using MS Excel?

The answer is yes. SQL Anywhere installation adds a ODBC DSN to the computer. MS Query is MS Excel can connect to this data source as shown in this post.

In a number of previous posts we have seen how to access data on SQL Anywhere Server using either ODBC or ADO.NET connectivity. Follow the links here:
http://hodentek.blogspot.com/2013/10/connecting-to-sql-anywhere-16-using.html

http://hodentek.blogspot.com/2013/09/do-you-need-to-connect-to-sql-anywhere_24.html

http://hodentek.blogspot.com/2013/09/do-you-need-to-connect-to-sql-anywhere_20.html

http://hodentek.blogspot.com/2013/09/do-you-need-to-connect-to-sql-anywhere.html

http://hodentek.blogspot.com/2013/08/do-you-need-to-connect-to-sql-anywhere.html

1. Start the SQL Anywhere Server from its link as shown.

 
The Server starts up as shown.


2. Launch MS Access (in the present case MS Access 2010 Professional Plus).
3. Click menu item Data. Click From Other sources and from the drop-down menu
   click From Microsoft Query as shown.

4. Choose Data Source window gets displayed as shown.


5. Click demo* and click OK.
Query Wizard - Choose Columns window  is displayed as shown.

6. Click Contacts (for example) and using the > button transfer all columns to the Columns in your query window.

7. Click Next
Query wizard - Filter Data window is displayed is displayed as shown.

8. If you need to filter data go ahead and choose what to filter. Here no filtering is done.

9.Click Next.
Query Wizard - Sort Order window is displayed as shown.

10. Click Next.
Query wizard - Finish is displayed.

11. Accept default and click Finish. (not shown)

The Import Data window is displayed as shown.

12. If you accept the default location and click OK, the program brings data beginning the cell A1 as shown.

That is all there is to it.


Sunday, December 15, 2013

What is the difference between MS Query and Power Query?

As the name suggests Power Query is more powerful than MS Query. MS Query handles only ODBC data sources but Power Query can handle lot more.

Some details here:
http://hodentek.blogspot.com/2013/12/what-is-microsoft-power-query.html

Both MS Query and Power Query can be accessed in Microsoft EXCEL.

MS Query and Power Query in MS EXCEL 2010 Professional Plus and x32 bit


You have to install the EXCEL add-in for POWER Query from here:
http://www.microsoft.com/en-us/download/details.aspx?id=39379


Here is the ribbon tab for Power Query:
 

Saturday, December 14, 2013

How do I bring up the query designer in SQL Server 2012 Express?

Query Designer is a Graphic User Interface.

It is quite easy.
There are two ways you can do it.

Step 1. Open a Query pane by right clicking either the Server Node or right clicking one
of the user databases as shown.
 SERVER NODE


USER DATABASE NODE

Step 2. Once the query pane is open, click inside the query pane. The main menu
changes
to display the Query menu item as shown.

 


Step 3.Click Query menu item to display a drop-down list and click on Design Query in Editor or Ctrl+Shift+Q
 

This should bring up the designer as shown.


Step 3b. Another way is to right click inside the query pane and choose Design Query in Editor as before.

 

Sunday, November 10, 2013

Read these mostly Microsoft SQL Server related articles on Packt Network

Creating a matrix report using the Analysis Services Cube
Creating a matrix report using the Analysis Services Cube

Excerpt:

nd database , a copy of the Northwind database. In this article by Dr. Jayaram Krishnaswamy, we will be authoring a report based on an analysis services CUBE. Reviewing Jayaram's other OLAP related articles may greatly help in understanding this article. Creating the CUBE will be essential to work with this
Manage SQL Azure Databases with the Web Interface 'Houston'

Excerpt:

version of SQL Server 2008 is R2. This article by Jayaram Krishnaswamy , is based on a project named 'Houston' which is a web based SQL Azure management tool that has not gone into production but can be tested using the SQL Azure Labs portal at http://www.SQLAzureLabs.com . In this article we look at some of the features of this web
Working with Data Application Components in SQL Server 2008 R2

Excerpt:

Jayaram Krishnaswamy In the August CTP Microsoft introduced Data-Tier Applications and several new features were introduced in the Nov 2009 CTP. Registering, Viewing & comparing and upgrading Data-Tier applications were added. This article by Dr. Jayaram
VB.NET Application with SQL Anywhere 10 database: Part 1

Excerpt:

Jayaram Krishnaswamy This article by Jayaram Krishnaswamy shows how you can develop a VB.NET 2.0 application using the integration features provided by the SQL Anywhere database. The SQL Anywhere tools are directly accessible without
Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

Excerpt:

Jayaram Krishnaswamy As noted in Part 1 , OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the intelligence compared to the structured querying
Creating a Web Page for Displaying Data from SQL Server 2008

Excerpt:

Dr.Jay Krishnaswamy This article by Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved data in a GridView Control on a web page. Trying to establish a connection to the SQL Server 2008 is
Migrating a MySQL table using Oracle SQL Developer 1.5

Excerpt:

to migration of databases from third party vendor products to Oracle. This article by Dr. Jayaram Krishnaswamy , shows how the reader may use Oracle's most recent tool, the Oracle SQL Developer 1.5 to work with the MySQL database. An example of migrating a table in MySQL to Oracle 10G XE is also described. The
Microsoft LightSwitch: Querying Multiple Entities

Excerpt:

Querying in LightSwitch can be carried out using the built-in Query Designer but more advanced querying can be carried out using code. This article by Jayaram Krishnaswamy , author of Microsoft Visual Studio LightSwitch Business Application Development , describes the use of the built-in Query Designer in the IDE to query the entities in the data
Processing Twitter and New York Times APIs with ASP.NET Ajax on Microsoft CDN

Excerpt:

Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , we look at two APIs, the Twitter API and the New York Times API and see how we can access data on them using the JavaScript libraries available on the Microsoft
Creating a VB.NET application with EnterpriseDB

Excerpt:

Jayaram Krishnaswamy Getting introduced to working with Postgres was described in the recent article, " installation and some basic features of EnterpriseDB ". Migration of data from SQL Server 2008 was described in "
Microsoft SQL Server 2008 - Installation Made Easy

Excerpt:

Jayaram Krishnaswamy SQL 2008 server is the latest in the line of Microsoft database servers and this article by Dr. Jayaram Krishnaswamy discusses the challenges one may face in installing the Developer version of this product
Microsoft LightSwitch Application using SQL Azure Database

Excerpt:

on August 23rd for the general public while it has been used by MSDN members and Microsoft insiders for couple of months. This article by Jayaram Krishnaswamy shows how you may download and install this program. The article also shows how you may develop a simple database application using this product retrieving data from the Cloud hosted relational
MySQL Data Transfer using Sql Server Integration Services (SSIS)

Excerpt:

Jayaram Krishnaswamy There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the transfer of data from MySQL to Microsoft SQL Server
MySQL Linked Server on SQL Server 2008

Excerpt:

Jayaram Krishnaswamy Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets on disparate databases. This article by Dr. Jay Krishnaswamy explains how
A Simple Pocket PC Application using Visual Studio 2005

Excerpt:

Jayaram Krishnaswamy This article by Dr. Jayaram Krishnaswamy teaches how you may create a .NET Compact Framework (CF) 2.0 forms application. This can be used with Pocket PC 2003, or later devices. In the absence of a device being
VB.NET Application with SQL Anywhere 10 database: Part 2

Excerpt:

Jayaram Krishnaswamy This article by Jayaram Krishnswamy shows how you can develop a VB.NET 2.0 application using the integration features provided by the SQL Anywhere database. The SQL Anywhere tools are directly accessible without
Migrating from MS SQL Server 2008 to EnterpriseDB

Excerpt:

Dr. Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , we will learn about migration of data from MS SQL Server 2008 to EnterpriseDB. Migration Studio bundled with the EnterpriseDB download is a collection of tools to
Creating an Analysis Services Cube with Visual Studio 2008 - Part 1

Excerpt:

data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.   Reviewing Jayaram's other OLAP
Transferring Data from MS Access 2003 to SQL Server 2008

Excerpt:

two non-Microsoft databases. Both Microsoft and proprietary data source providers are available to connect to many different database products. In this article by Dr. Jayaram Krishnaswamy , we will be transferring data from an MS Access database to a database on SQLServer 2008. Both the source of data and the destination database are on the same
Creating a Simple Report with Visual Studio 2008

Excerpt:

Jayaram Krishnaswamy Report Services, Analysis Services, and Integration Services are the three pillars of Business Intelligence in Microsoft's vision that continues to evolve. Reporting is a basic activity, albeit one of the
Windows Presentation Foundation Project - Basics of Working

Excerpt:

Dr.Jay Krishnaswamy This article by Jayaram Krishnaswamy introduces the reader accustomed to working with the traditional graphic user interface in earlier versions of VB to Windows Presentation Foundation . Importantly, it introduces
Exporting data from MS Access 2003 to MySQL

Excerpt:

SettingsJayaram Krishnaswamy>cd C:>cd xamppmysqlbin C:xamppmysqlbin>mysql -h localhost -u root -p Enter password: ********* Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.1.30-community MySQL Community Server (GPL) Type 'help;' or 'h' for help. Type 'c'
Displaying SQL Server Data using a Linq Data Source

Excerpt:

provided by the Linq to SQL classes, a class generator that maps SQL server objects to the model. The class files generated support CRUD operations. In this article by Dr. Jay Krishnaswamy , we will be adding a LinqDataSource control in Visual Studio 2008 to a ASP.NET website and configuring it by providing a data context. The data context will
Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools

Excerpt:

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook () () This article by Jayaram Krishnaswamy  the author of  Learning SQL Server Reporting Services 2012,  provides a summarized overview of SQL Server Reporting Services 2012 and the background information
Using the Data Pager Control in Visual Studio 2008

Excerpt:

or it can be installed manually after installing the ListView. In this article both of them are described. While the number of items displayed in a list can be declaratively coded, it is possible to set it at page load time as well. This article by Dr. Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved
Navigating Pages in XAML Browser Applications

Excerpt:

published to a web server and can be browsed on IE and Firefox. This article by Dr. Jayaram Krishnaswamy shows how to create a XBAP application using Visual Studio 2008; how to navigate between pages in the application; and how to deploy the application to the local intranet web server using built-in support in Visual Studio.
Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps

Excerpt:

Jayaram Krishnaswamy There are several options if one wishes to move a database from a SQL Server 2005 to SQL 2008 Server. First of all there is a 'Copy Database Wizard' in SQL 2008 Server which is meant for transferring
Microsoft LightSwitch: Querying and Filtering Data

Excerpt:

will not be wrong. Just like you take information out of the table, make changes to it and return it to the table, you do likewise with entity sets. In this article by Jayaram Krishnaswamy , author of Microsoft Visual Studio LightSwitch Business Application Development , we will take a look at querying a single entity.
MS Access Queries with Oracle SQL Developer 1.2 Tool

Excerpt:

Jayaram Krishnaswamy This article by Jayaram Krishnaswamy shows how you can install the Oracle SQL Developer 1.2 and connect to an MS Access database. This article will cover the steps right from downloading and installing the
Displaying MySQL data on an ASP.NET Web Page

Excerpt:

database server on a web page using ASP.NET . The table used in this tutorial was the one described in the first article in this series on Exporting data from MS Access 2003 to MySQL . This article by Dr. Jay Krishnaswamy explains how to populate a GridView on an ASP.NET web page by data retrieved from a MySQL Server. MySQL.Data.MySqlClient
SSIS Applications using SQL Azure

Excerpt:

Report Server providing full support with a web service frontend for a variety of reporting needs—from web-based reporting to embedded reporting. In this article by Jayaram Krishnaswamy , author of Microsoft SQL Azure Enterprise Application Development , we will be leveraging SSIS, SSRS, and the tools used to address ETL processes, and Report
jQuery Embedded in Dojo Accordion Panes

Excerpt:

library. In this article by Dr. Jayaram Krishnaswamy , we will experiment embedding jQuery in DOJO 123's Accordion widget and try to identify if there exists any cross-code interactions. The code is also tested for cross-browser suitability. Basic DOJO 123 accordion In my earlier article I had used the version
Oracle SQL Developer Tool 1.5 with SQL Server 2005

Excerpt:

party vendor products to Oracle. Please review the following articles on the earlier versions 1.1 and 1.2: MS Access Queries with Oracle SQL Developer 1.2 Tool and Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2 . In the present article by Dr. Jayaram Krishnaswamy the latest version of this tool [Oracle SQL Developer 1
Binding MS Chart Control to LINQ Data Source Control

Excerpt:

Jayaram Krishnaswamy In this article by Dr. Jay Krishnaswamy , a Microsoft Chart Control will be bound to a Linq Data Source using LinqDataSource control and a pie chart displays the data. We will be going through the following
Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2

Excerpt:

Dr.Jay Krishnaswamy In this article, Jayaram Krishnaswamy shows how to migrate an MS Access database to an Oracle 10G XE Server, describing all the steps involved in the migration process. Introduction
Ground to SQL Azure migration using MS SQL Server Integration Services

Excerpt:

Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , you will learn how to migrate a table from your ground based SQL Server 2008 to your cloud based SQL Azure instance using MS SQL Server Integration Services.
Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard

Excerpt:

Jayaram Krishnaswamy This article by Jayaram Krishnaswamy shows how to migrate a database from SQL Server 2005 (should work for 2000 as well) to SQL Server 2008 using the Copy Database tool in SQL Server 2008. In an earlier article we saw how this can
Connecting to Microsoft SQL Server Compact 3.5 with Visual Studio

Excerpt:

features 128-bit file level encryption. It is referential integrity compliant; supports multiple connections; has transactions support with rich data types. In this tutorial by Jayaram Krishnaswamy , various scenarios where you may need to connect to SQL Server Compact using Visual Studio IDE (both 2008 and 2010) are described in detail. Connecting
Microsoft Chart with XML Data

Excerpt:

nts and SettingsJayaram KrishnaswamyMy DocumentsVisual Studio 2008Chart_XMLWebApp_DataPrincetonXMLDOC.xml"); //Response.Write(Convert.ToString(ds.Tables[0].Columns[0].ColumnName)); Chart1.Series.Add("Series2"); Chart1.Series[0].XValueMember=Convert.ToString(ds.Tables[0].Columns[1].ColumnName); string
Understand and Use Microsoft Silverlight with JavaScript

Excerpt:

and contribute to rich and interactive designs that are well integrated with Microsoft's Expression series of programs. In this article by Jayaram Krishnaswamy we will be using Silverlight 1.0 with JavaScript. We have come a long way from the day the WEB was created in 1992 by T.B.LEE in Switzerland. From
Authoring an EnterpriseDB report with Report Builder 2.0

Excerpt:

Jayaram Krishnaswamy This article by Dr. Jayaram Krishnaswamy shows step-by-step how you may retrieve data from a database on a Postgres Plus server and display the results in a report generated using Report Builder 2.0. Report
Installation and basic features of EnterpriseDB

Excerpt:

cost effectiveness versus Oracle and better scalability than MySQL. It can easily integrate with most applications such as Java, Ajax, Ruby, Drupal etc. This article by Dr. Jayaram Krishnaswamy mainly describes the installation of EnterpriseDB and the basic features to get started on this important database product. Installing
Term Extraction Tasks in SQL Server Integration Services

Excerpt:

stop the flow review it and turn it on to let the data flow to the next step. You may provide a name to the Data Viewer. There are four types of data viewers (Grid, Histogram, Scatter Plot, and Chart) and the 'Grid' type is used in this article. Build the Project and Execute the Package This is easy. Click on the menu item Build
Easy guide to understand WCF in Visual Studio 2008 SP1 and Visual Studio 2010 Express

Excerpt:

suite of products provides an easy to use interface for developing WCF applications. Using these IDEs a number of different types of WCF applications can be built. The emphasis of this article by Dr. Jayaram Krishnaswamy is to show to the user how to leverage the IDE for understanding the ins and outs of a WCF application and learn about the
Microsoft SQL Azure Tools

Excerpt:

the tools that can be leveraged working with SQL Azure, but a few third-party vendors and others have also created tools for SQL Azure. In this article by Jayaram Krishnaswamy , author of Microsoft SQL Azure Enterprise Application Development , we will discuss the Microsoft Tools.   Microsoft
Data Access with ADO.NET Data Services

Excerpt:

operating on the data. In this article by Dr. Jayaram Krishnaswamy , you will learn how to create a ADO.NET Data Service from scratch. You will also learn how you may access data using the URI constructs. The backend data for this tutorial comes from a copy of Northwind database named TestNorthwind on a named instance of SQL Server 2008. In order
Writing XML data to the File System with SSIS

Excerpt:

Jayaram Krishnaswamy This article by Dr. Jayaram Krishnaswamy , shows how you may retrieve XML data from a relational database and write it to a folder on your file system as a text or xml file using Microsoft SQL Server Integration
Working with the Report Builder in Microsoft SQL Server 2008: Part 1

Excerpt:

Jayaram Krishnaswamy Report Builder 2.0 is feature-rich reporting tool with the latest Microsoft Office look and feel. In this two part article by Jayaram Krishnaswamy , we will see how the Report Builder 2.0 provides an extremely
Programmatically Creating SSRS Report in Microsoft SQL Server 2008

Excerpt:

Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , the process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the
Working with the Report Builder in Microsoft SQL Server 2008: Part 2

Excerpt:

Jayaram Krishnaswamy In the previous part of the article, we had a look at the Report Builder overview and described the Report Builder 2.0 interface . In this part by Jayaram Krishnaswamy , we will discuss about Enabling and reviewing