Archive for February, 2012

What do you need to know about – “Report Builder 3.0”

Hi All, People who have been working with SSRS and Report Builder are well aware about the release of new “Report Builder 3.0“. I have summarized following introduction, features & facts about the product. General: If you already know or work with any previous versions of Report Builders then understanding “WHY” is no big deal. […]

bigatorFebruary 26, 2012 · bigatorKhilitchandra Prajapati · bigator8 Comments
bigatorTags: , ,  · Posted in: Report Builder 3.0, SQL Server, SSRS

What you need to know about – “PowerPivot”

Hi All, Today i would like to talk about a booming technical feature by Microsoft i.e. “PowerPivot“. What is PowerPivot? PowerPivot (which is also known as Project “Gemini“) is Microsoft’s hottest business intelligence (BI) innovation. By integrating PowerPivot technology with Microsoft Excel, Excel has gradually becoming most wanted & preferred BI tool (client) in the […]

bigatorFebruary 24, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , , ,  · Posted in: Excel, Pivot Table, SharePoint, SQL Server

Master of Predictive Analysis

bigatorFebruary 22, 2012 · bigatorKhilitchandra Prajapati · bigator2 Comments
bigatorTags:  · Posted in: Funny

Search Country & Location Information based on IP Address

Hi All, Once I ran into the situation where I have to find out the CityCountry name & location (Longitude, Longitude) based on the IP address. This was not difficult but rather not straight-forward as IP addresses are stored into database table as strings which is very obvious because there are no standard data type […]

bigatorFebruary 22, 2012 · bigatorKhilitchandra Prajapati · bigator2 Comments
bigatorTags: ,  · Posted in: General, SQL Server, Tutorial

GodMode in Windows 7

Hi All, If you have a Windows 7, then you can enable so-called “GodMode” to get access to most of the controls of operating system & other components. You simply have to create a folder name with following words. “GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}” (Please exclude ” – double quotes while naming it). Ta-Da. The folder icon will change […]

bigatorFebruary 21, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , ,  · Posted in: General, New Features

“Specify Values for Template Parameters” in SQL Server

Hi All, SQL Server Management Studio provides a dialog box named “Specify Values for Template Parameters” for filling values for the template you have used. This is very handy if you always like interface based interactions with components. E.g. When you choose any template from Template Explorer, you will see template with lots of place-holders […]

bigatorFebruary 21, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: General, Quick Tips, SQL Server, T-SQL

Useful information about available Database Snapshots in SQL Server

Hi All, Once I had to find out few details of available database snapshots in SQL Server. I wrote following script which helped me to find out following: how many database-snapshots are available & live whats the size1 of database snapshot as well as the allotted size2 for database snapshot What collation is assigned to […]

bigatorFebruary 20, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: Database Snapshot, SQL Server

How to set default dimension measure in Cube ?

Hi All, Following script will help you to set default dimension measure for Cube. ALTER CUBE [Adventure Works] UPDATE DIMENSION [Geography].[Geography] , DEFAULT_MEMBER = [Geography].[Geography].[Country].&[United States] Thanks, Khilit

bigatorFebruary 19, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: MDX, SSAS

FileTables in SQL Server 2012

Hi All, FileTables feature introduced in SQL Server 2012. This feature is built on the top of FileStream feature of SQL Server 2012. I published the introduction of FileStream in my previous post. FileTables allows us to store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications […]

bigatorFebruary 19, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: File Tables, General, SQL Server

FileStrems in SQL Server 2012 – Introduction

Hi All, I would like to start this post with a small story. I believe (at least) at one point of time, we might have faced problem searching information from our CD/DVD collection. We used to write information on CDs but that was not enough to cover all the contents of that CD. And when […]

bigatorFebruary 19, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: File Stream, SQL Server, Tutorial