E-Book Gallery for Microsoft Technologies
Hi guys, good morning !!! here is the list of cool FREE E-Books from Microsoft Press.
Continue reading →Category Archives: New Features
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?
Continue reading →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 or in Cube Designer has been removed from the product. The control was an Office Web Control (OWC) component. OWC was deprecated by Office and is no longer available.”
Continue reading →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 to control panel icon and you will see the big list of items where you can easily search many controlling options just grouping by “Application” in details view. You can also collapse or expand all groups by right-click & selecting appropriate options. Though it seems … Continue reading →
Welcome Microsoft Help Viewer 1.1
Hi All, With the installation of SQL Server 2012 RC0, you will also find integrated “Help Viewer 1.1“. This is pretty much like MSDN help. You can launch the Help viewer by following method.
Continue reading →Auto Generate (Some particular)Change Scripts in SSMS
Hi All, How are you doing? We all know that Change is a rule of life …. And pretty much that applied to SQL Server as well 
Yes, my point is to find out the changes we have done in current SQL Server so we can deliver into the next environment i.e. UAT/Test or Production etc. People follow lots of ways to find/generate change scripts for SQL objects for their creation and modifications. But I would like to draw your attention to a facility/functionality which is provided by MS SQL Server Management Studio by default. But by default this … Continue reading →
Create SQL scripts quickly using Template Browser – SQL Server 2012 RC0
Hi All, You can quickly create SQL scripts for SQL Server or Analysis Server using Template Browser. It does not cover all detailed scenarios, But it does cover all basic scenarios + you don’t have to worry about the script structure or any deprecated syntaxes etc.
Continue reading →Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools
Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole functionality ready-made in few seconds. Believe it or not, try the following: Open “SQL Server Data Tools” (This is new name assigned to Visual Studio IDE/BIDS in SQL Server 2012 RC0) Use MultiDimensionalProject & create a cube with any method you want. Process & Deploy … Continue reading →
Interesting changes in Database Design of SQL Server 2012
Hi All, I would start this topic with a small real incident happened with me. I worked on SQL 2008 for almost 2.5 years and then I mixed my work with SQL 2008 R2. Once we had some work in SQL 2005 – SSIS package. It was a minor modification by playing with few date columns. I tried to use DATE datatype unknowingly and ssis package was giving me error. I did not concentrate on the DATE datatype which I have used and rather I was searching here and there. And finally I recalled that DATE datatype is not available … Continue reading →
SQL Server 2012 RC0 – Quick Start
Guys, I know we can simply Google this information. But believe me these links are quite enough to your quick start needs for SQL Server 2012 RC0 Where can I download it from? http://www.microsoft.com/download/en/details.aspx?id=28145