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 AlwaysOn Part 2 AlwaysOn […]
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 […]
Creating a SSRS Report using the Report wizard
In this post we cover how to create a report in MS SQL Server 2012 Reporting Services. The bog covers using the wizard to connect to a database […]