One of those interesting opportunities that open up when using PowerPivot in conjunction with SharePoint 2010 is that of leveraging the PowerPivot cube-like interface of its inherent data model in order to extend the analytical arsenal of an organizatio...

SQL Server Licensing and Pricing...

...

Its All About SQL Server...

"Big Data" is the new buzzword doing the round in the industry. As the name suggests, it is about data and, it is about large and hefty data. But how much volume of data is considered as “Big Data”? Does 10 GB, 50 GB, 5 TB or 50 TB sizes of data is enou...

SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL Server FILESTREAM technology. As per Microsoft BOL, “FileTable lets an application integrate its storage and data management components, a...

Hello! My name is Basit and this is my personnel blog. In this blog you will find technical articles about SQL Server. I'm currently working for Total System Services, Inc as a Senior Database Administrator (DBA)....

This post is our first in series of learning and exploring Google Spreadsheet API. We learn that Google Spreadsheet is a subset of Google Doc. We have uploaded two sample spreadsheets to Google Doc in our first post. In this post, we will learn to pull...

In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive to the new SAN. In this post let us go through the steps that we have followed to move the System,Resource and User databases to the new SAN.The envir...

Technically, JQuery is a JavaScript library. JavaScript is a subset of Java and a scripting language which runs on the client side i.e. on web browsers. There are many popular JavaScript library/framework available today such as MooTool, JavaScriptMVC, ...