Log in | Register

Raunak Jhawar, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Raunak Jhawar, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



About Raunak Jhawar

This author has not yet filled in any details.
So far Raunak Jhawar has created 32 entries.

SQL Server Microsoft Excel – Power Query

SQL Server Microsoft Excel –  Power Query formerly known as “Data Explorer”, when it was launched for community preview, is an MS Excel Add-in to enhance self-service BI and Analytics user experience using Excel as a data platform. The add-in can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=39379.

In this post, I’ll demonstrate a use case for Power […]

SQL Server Integration Services : Creating Dynamic SQL/MDX using Script Task

Of late I have been working on creating a lot of SQL Server Integration Services packages and a new trick that I have come up with is to use a Script Task to create a dynamic SQL and/or MDX for me using standard SSIS variables and the power of C# (I am not your regular VB […]

SQL Server: Setting up Quorum Node Weight in a Windows Server Failover Cluster

I had a request coming in where I was asked to demo the capabilities of AlwaysOn feature using Availability Groups in SQL Server 2012 (a note on what is availability group deserves an explanation and a separate blog post, till that time you can read an introductory post which I had written here)

I will assume […]

SQL Server 2012 – Introducing Highly Availability using Availability Groups

Case of multi-subnet Windows Failover Cluster

What is Highly Available?

A high-availability solution masks the effects of a hardware or software failure, outage, planned/unplanned maintenance and maintains the availability of applications so that the perceived downtime for users is minimized. For example: Database Mirroring

What is Disaster Recovery?

Disaster recovery (DR) is the process, policies and procedures […]

SQL Server Analysis Services Tabular Model Management using Powershell

This is a relatively a short blog providing a general introduction to SQL Server Analysis Services Tabular Model management using Windows Powershell. You can discover and learn more about Powershell from here, here and here.

Since powershell is a scripting language, there are very useful scripts which already have been published which promise to do […]

By |December 4th, 2012|Categories: SQL Server|Tags: , , |0 Comments

SQL Server Analysis Services – Using the DMV MDSCHEMA_ACTIONS in SSAS

In last blog which was about Microsoft SQL Server Analysis Services – Tabular Model Actions which can be found here, described how to create new Actions in the Tabular Model using BIDS Helper 2012.

Using BIDS Helper, you can not only define new actions on the tabular model but also administer any existing actions such […]

SQL Server 2012 SSAS Tabular Model Actions

With SQL Server 2012, SSAS has undergone a major change. There is BISM (If you are late into the party, read about BISM here and SQL Server 2012 SSAS Tabular Model here). If you ever had a chance to work with multidimensional models or had a chance to do a 1-1 comparison between SSAS […]

SQL Server Analysis Services – Assign a Default Measure in SSAS Tabular Model Solution

It has been rather long time since I had posted any content online. Perhaps I was lazy. Well this post is on SQL Server Analysis Services (SSAS) and precisely here we will be discussing an issue which I observed today while randomly browsing various properties and options in the process of creating a tabular […]

File Properties Task – (SQL Server Integration Service)

SQL Server Integration Service – File Properties Task

Hi. Let’s try to explore more Integration Services, again, and this time I am going to walk you through a custom task. The name of the task is “File Properties Task”. The download is free for the community and you can download the task executable from CodePlex.

Often […]

SQL Server Integration Services – Missing Package Configuration Option

SQL Server Integration Services – Missing Package Configuration Option


Let’s dig more into SQL Server Integration Service and this time it is the package deployment model. With the plethora of changes that the SSIS team has come up with in the new release of SQL Server 2012, the package deployment is the one which is […]