2012 in review
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
600 people reached the top of Mt. Everest in 2012. This blog got about 5,000 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 8 years to get that many views.
What is Document Stores?
In my last article I explained Key-Value Stores. I’ll explain about Document Stores which is one of the subcategory of NoSQL Databases. As name explains this category is store of semi-structured documents which supports formats like JSON. Attractively rather than calling rows they call individual row as document. Read more…
What is Key-Value Stores?
In my previous article I explained about categories of NoSQL Databases and in this series of articles I’ll explain all four categories in details.
Let’s look at the essentially key-value stores. Which are really the most common and the most foundational, and also the most general purpose of NoSQL Database. They are not necessarily the most popular because Key-Value stores tend to be less exotic as compare to other NoSQL Databases. But they tend to fit so many different purposes especially well suited to a great variety of applications. Read more…
NoSQL Categories Breakdown
As covered in my [last post]. In the era of Big Data, good old RDBMS concepts are no longer the right concepts for many unstructured and semi-structured database jobs. Here is another attempt to explain NoSQL with their Architecture and Categories. Read more…
PowerShell script to backup a database and restore on other server.
Many a times as a DBA when we need to refresh our QA or Dev environment with Production environment, we need to have a full backup of Production database and then manually we need to restore them in other environments. The following is a simple power shell script to just take a full backup with copy only option and then restore it on other server. Read more…
Count number of rows in stored procedure
Many a times in our daily life of a SQL development/DBA profile, we have to spend our day across stored procedures, and we need to find out how many rows are there in any stored procedures, especially when we have to do some analysis or while we have to review any stored procedure for evaluation or estimation, the very first thing which comes in everyone’s thought is, how big is the stored procedures , the following are the simple ways to get the approximate number of rows in stored procedure. Read more…
Finding and removing hidden characters in your data using dynamic T-SQL
Today I was struggling with one issue which keeps my SSIS package failing in one of the data imports.And came across one of the blog. The problem was a conversion problem from varchar type to float and I kept getting the following error:
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.
However, my data was numeric I checked it many times… or was it really 100% numeric?
Apparently there are some crazy hidden characters that you cannot see when you just glimpse at data. One of the best ways to find out if your data has some non-numeric characters in it is by running a simple query.
What is NoSQL
Now a days in IT Industry everyone is talking about NoSQL Databases. And most of them are not aware of what exactly NoSQL is where we can implement it. In this article I’m trying to explain about what is NoSQL Databases and how different they are from Relational Databases. In order to understand NoSQL I’ll put some light on Relational Database Model. Read more…
SELECT * Vs SELECT Column Name in SQL Server Query
People always keep saying do not use SELECT * exercise SELECT <column names> instead. But no one put more light on this and this becoming myth in SQL Server and other database management systems. Here are couple of reasons why should we avoid SELECT * and go with SELECT <column names>
Power Pivot and Power View now available in Excel 2013.
In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and Power View add-ins are installed by default. But they are not automatically enabled. You have to do some menu/dialog box acrobatics to turn them on, but it’s a one-time set-and-forget requirement.
If you’d like to try it yourself, click through File|Options|Add-Ins|Manage COM Add-Ins|Go… and then enable the add-ins by checking them off and clicking OK.
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 