Introduction This blog explains how you can create a map visualization based report in Power BI desktop. Map visualization is one of the cool features that Power BI provides for doing analysis based on geographical locations. Its pretty useful tool…
Windows Build 2016 : Live Streaming
Here’s a golden opportunity to watch the live streaming of the Microsoft Build 2016 Conference here for those whose are unable to attend. Microsoft Build is an annual conference event held by Microsoft for Developers. And this year its being held from March…
Guest Post: Variant Disaster Recovery Plans in SQL Server 2008
Andrew Jackson one of the fellow SQL professionals had expressed his desire to write a guest blog for me. Here’s the guest post contributed by him on Disaster Recovery Plans One of the foremost responsibility of a SQL Server administrator is…
My Interview Published on Technet Wiki
Glad to share with you all the news that my Technet Wiki had interviewed me and they’ve posted the interview on their official blogs. The link is given below http://blogs.technet.com/b/wikininjas/archive/2016/02/22/interview-with-a-wiki-ninja-visakh16-a-sql-server-mvp-microsoft-partner-amp-mcc.aspx Really feeling nice getting this motivation from Microsoft and being…
Identification and Application of Retrospective Changes Done in Databases
Introduction One of the common scenarios that we have come across during the course of every project life cycle is the need to identify the changes done retrospectively and revert them. This usually happens during subsequent phases of the project…
T-SQL Tips: OFFSET Without FETCH i.e. Skipping Rows in Resultset
Introduction The purpose of this blog is to provide an answer to the below two questions Can we use OFFSET without FETCH in T-SQL? How can we skip some rows while returning a resultset through SQL query? The above questions…
T-SQL Tips: Aggregate Functions in CASE Expressions
Impetus The impetus for this blog comes from a recent discussion that happened in one of the forums of which I’m a member. There was a question asked by one of the fellow members regarding an error he was getting…
T-SQL Tips: Representing NULL as Values in XML
This blog explains the various methods that can be applied for representing NULL values while generating a XML document using T-SQL FOR XML statement. Based on your actual requirement you can opt for any of the methods to get the…
SSIS Tips: Performing Cross Join Using Merge Join Transform in SSIS
Question Can we perform cross join (cartesian product) operation using Merge Join transform in SSIS? Scenario The above question was asked in one of the social forums recently. I was able to give the response to this.I’m sharing the solution…
T-SQL Tips: Execute Individual Packages in Project Deployment Model using Dtexec
Question Can we execute individual packages included in a SSIS 2012 project configured in project deployment model using dtexec utility? Scenario The above question was the main topic of discussion in one of the recent casual conversations with my fellow…