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. …

Continue reading ‘What do you need to know about – “Report Builder 3.0”’ »

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 …

Continue reading ‘What you need to know about – “PowerPivot”’ »

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 …

Continue reading ‘Search Country & Location Information based on IP Address’ »

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 …

Continue reading ‘GodMode in Windows 7’ »

“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 …

Continue reading ‘“Specify Values for Template Parameters” in SQL Server’ »

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 …

Continue reading ‘Useful information about available Database Snapshots in SQL Server’ »

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 …

Continue reading ‘FileTables in SQL Server 2012’ »

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 …

Continue reading ‘FileStrems in SQL Server 2012 – Introduction’ »