Occasionally you might want to quickly execute a query or run a few scripts on your Azure database without actually connecting from Management studio. For example when you’re […]
Popular Posts
Trending Posts
Recent Posts
Editors Choice
Connecting to a Azure database from SSMS and how to configure database level Firewall
So you finally have an Azure database, but how do you connect to it? Surprisingly simple actually, you can access your database remotely from within SSMS so for […]
Creating a SQL Azure Server and Database
Have you ever wondered how to create a SQL Server and then a Database within the server that is managed within the Microsoft PaaS cloud know as Windows […]
Video on Always ON Part 1, 2 and 3
I just realized I have not uploaded links to some of my older videos so here is a list of videos AlwaysOn Part 1 http://youtu.be/JrV9o2fXuPI AlwaysOn Part 2 […]
Creating a Network and Domain in Windows Server
This blog covers creating a simple domain in order to setup a windows failover cluster. The intention here is not to cover the details of setting up an […]
Create a 5 star rating indicator using SSRS
Today we are going to create a 5 star rating indicator in SSRS. Indicators are available in SQL Server 2008 R2 and above and provide a quick way […]
One of the best graphical representations I have seen in a while
A picture is worth a thousand words, a decent chart is probably worth a million. I have been conducting trainings on MS SQL Server Reporting services recently and […]
MSBI at the Airport
I was recently at Bangalore International Airport and while waiting for a flight was looking for a way to pass the time. I noticed there is an fnb […]
Changing the background colour for a Cell in SSRS conditionally
In this blog we look at how to change the background colour for a cell in SSRS using IIF conditional logic. He below screenshot shows a table with […]
Add a subtotal and Grouping to an existing report in SSRS
In this blog we cover how to add a Grouping to an existing Report. For the original report creation steps please visit this blog. In our report we […]