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 […]
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 […]
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 […]
FOREX Conversion in OLAP Cube
I was conducting training recently where the participants asked for a solution on how to convert data from many different currencies into a target currency using an exchange […]
5 Mary series, SSIS using TSQL in MSBI
An All new video on using TSQL task in SSIS to run a query and fetch data from the database and assign it to a table. All part […]