Wordpress - decipherinfosys.wordpress.com - Systems Engineering and RDBMS
General Information:
Latest News:
SQL Server Virtualization 25 Apr 2013 | 06:47 pm
Excellent Tips by Michael Otey on virtualization for SQL Server: http://sqlmag.com/sql-server/sql-server-virtualization-tips
Difference between UNICODE and UTF-8 files in Windows Notepad 25 Feb 2013 | 07:16 am
While generating flat files through SSIS for a feed process at a client site, we noticed that the developer had left the file encoding to be UNICODE with the thought that it would be the best practice...
A new iPhone app 1 Sep 2012 | 12:16 am
Wanted to blog about both our 5 Million views milestone which happened yesterday as well as about a new iPhone app that is available in the market and created by our friends at iHelpPlusApps.com. Of l...
Sqoop graduates from Apache Incubator to a Top Level Project 6 Apr 2012 | 12:43 am
Sqoop – the Big Data Tool has moved out of the Apache Incubator to a Top Level Project (TLP). In case you are not aware of Sqoop, it is the key data tool to transfer volumes of data between Hadoop an...
Bug: Scope_Identity() and @@Identity can return wrong values during parallel execution plans 5 Apr 2012 | 10:42 am
Ran into a weird issue today at a client site and upon further researching it, found out that it is a known issue in the SQL Server version that was being used at the client site. The issue was that ...
Online Index Operations involving certain large data types are allowed in SQL Server 2012 4 Apr 2012 | 06:53 am
Prior to SQL Server 2012, when you did online index operations (available in Enterprise Edition), if the index contained certain large data types (specifically varchar(max), nvarchar(max), varbinary(m...
Editions in SQL Server 2012 and Licensing 28 Mar 2012 | 07:41 am
SQL Server 2012 is available in these editions: Enterprise Edition Standard Edition Business Intelligence Edition Developer Edition Web Edition, and Express Edition Out of these, the Enterprise...
Virtual Labs for SQL Server 2012 23 Mar 2012 | 12:08 pm
MSFT has released a bunch of virtual labs to easily come up to speed with the new features of SQL Server 2012. So, if you are restrained due to hardware/software and are finding it difficult to convi...
Sample Databases for SQL Server 2012 23 Mar 2012 | 01:20 am
In case you are looking for the AdventureWorks Sample Databases for SQL Server 2012 version, you can download them from codeplex – here is the link for all the downloads (Data files, Script files etc....
Excellent comparison of Pig vs Hive 22 Mar 2012 | 12:06 pm
We had recently blogged about Hadoop and the different sources for learning Hadoop and getting up to speed on it. One of the points that we missed out on was a mention of Pig and Hive. Hive and Pig ...
