Yearly Archives: 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 →

Interesting changes in Database Design of SQL Server 2012

Khilitchandra's Business Intelligence Blog Posted on by

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 →

My article got selected as “Article of Week” on BIDN :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi folks, I would like to share a joy with you all that one of my articles got selected as “Article of Week” in BIDN. BIDN is “BI Developer Network Community“. Visit http://bidn.com for awesome BI articles and tutorials, If you are hungry to learn things from tech experts like Brian Knight, Dustin Ryan, Mike Davis, Devin Knight and many more…

Continue reading →

NOLOCK and With(NOLOCK)

Khilitchandra's Business Intelligence Blog Posted on by

Hi all, I want to share knowledge with you regarding NOLOCK and With (NOLOCK) hint in SQL queries we use in our day-to-day work/activities. According to MSDN, “In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause only when the hints are specified with the WITH keyword. Table hints also must be specified with parentheses. The following table hints are allowed with and without the WITH keyword: NOLOCK, READUNCOMMITTED, UPDLOCK, REPEATABLEREAD, SERIALIZABLE, READCOMMITTED, FASTFIRSTROW, TABLOCK, TABLOCKX, PAGLOCK, ROWLOCK, NOWAIT, READPAST, XLOCK, and NOEXPAND. When these table hints are specified without the WITH keyword, the hints … Continue reading →

Find all SSRS Reports, Report Locations & Data Sources in ReportServer

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, sometimes opening ReportServer or Reports (Report Manager) takes a while. On the other hand querying database for information is faster than waiting for websites to respond. Here is the quick way to check the number of SSRS reports deployed on report server, their locations (paths) and available data sources. Use <Report Server Name> Go

Continue reading →

Fastest way to find-out/understand relationships between tables in MS SQL Database

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys, For most of the BI developers, getting BI related tasks (SSAS, SSIS, SSRS etc.) from multiple teams in company is very common. So in this situation, developer completes a task(s) for one team and goes to another team for different task(s). Once you go to the team for their requirements … lets say for few SSRS reports development or ELT Jobs, you will realize that, they neither have time to give you the proper knowledge transfer nor they could explain the requirements up to the mark how we wanted know in detail. And you have to give the … Continue reading →

Everything about MSBI to learn @ one Place

Khilitchandra's Business Intelligence Blog Posted on by

Guys, Check this out: http://www.microsoft.com/en-us/bi/default.aspx What you will find here: 1. BI TV – industry’s leading Analytics and Business Intelligence TV show 2. BI Lab – a collection of experimental business intelligence projects and applications 3. Blog – BI Subject related Blog entries 4. Evidence – BI Case Studies Thanks, Khilit

Continue reading →