Daily Archives: February 12, 2012

Auto Generate (Some particular)Change Scripts in SSMS

Khilitchandra's Business Intelligence Blog Posted on by

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

Khilitchandra's Business Intelligence Blog Posted on by

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

Khilitchandra's Business Intelligence Blog Posted on by

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 →