Features Supported by the Editions of SQL Server 2012

Hi all, I ran into a nice article which has a 1 consolidated list of all the features of SQL Server 2012 Editions. You can check the details for your infrastructure and solution planning whether what you wanted/needed is supported in SQL Server 2012 or not. And if supported then which edition? Rate this post

Behavior Changes to Analysis Services Features in SQL Server 2012

Hi all, I would like to draw your attention to the few modifications in SSAS behaviors in SQL 2012. The most important difference you will find is the “Cube Browser”. Yes, it’s totally changed. According to Microsoft “The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio …

Continue reading ‘Behavior Changes to Analysis Services Features in SQL Server 2012’ »

Singapore SQL User Group – Special Meet Up: “SQL Server for Private Cloud”

Hi Guys, Singapore SQL User Group is running a special meet up with Microsoft’s visiting speaker from U.S. Topic: SQL Server for Private Cloud Primary Focus: Many customers are deploying virtualized SQL Server in production environment. Join this session to find out about “SQL Server for Private Cloud“, a solution that is part of overall …

Continue reading ‘Singapore SQL User Group – Special Meet Up: “SQL Server for Private Cloud”’ »

Rocking “Catalog Views” in SQL Server 2012

Hi All, Today I came across an article on MSDN regarding the meta-data of SQL Server objects which led me to the “Catalog Views“. What is it? “Catalog View” provides the information which is used by SQL Server Database Engine. So one thing is – “you can definitely trust this method“. Moreover, Microsoft recommends this …

Continue reading ‘Rocking “Catalog Views” in SQL Server 2012’ »

Dazzle your SSRS Report with SparkLines

Hi All, “SparkLines” is a new feature introduced in SQL Server Reporting Services 2008 R2. Fast Facts about SparkLines: •    It is the simplest way to make your data/values intelligent by showing them in visual way. •    Because it’s a tiny-chart representation, makes report elegant, meaningful and non-messy. •    Report users can choose to dig …

Continue reading ‘Dazzle your SSRS Report with SparkLines’ »

A Set of Boon Tools – SSAS DMVs in SQL Server 2012

Hi All, As you must have heard or started using DMVs (Dynamic Management View) available in SQL Server to get information about local server operations and server health. But today I would like to focus specially on DMVs for monitoring SSAS (SQL Server Analysis Services) and dig-down to find out how powerful it can be. …

Continue reading ‘A Set of Boon Tools – SSAS DMVs 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’ »

Enhanced “Generate Scripts” dialog box in SQL Server 2012 RC0

Hi All, I have been monitoring the “Generate Scripts…” functionality of SQL Server Database. One thing bothers me for last few years or since SQL Server 2005 is that once I right-click on any database -> Tasks -> Generate Scripts, I would expect to generate scripts only for that database which I have selected. But …

Continue reading ‘Enhanced “Generate Scripts” dialog box in SQL Server 2012 RC0’ »