With the cube processed we are now ready to browse or query the cube to fetch some data from it. There are many way of doing this; the […]
Popular Posts
Trending Posts
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
Recent Posts
Editors Choice
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
SSAS: – Defining a measure
Now that the dimension has been defined we need to add a measure to our cube in order to be able to answer the question “What is distribution […]
SSAS: – Define translation
In previous posts we explored the properties of a cube and some basic tasks that we would need to perform as part of creating and managing a cube. […]
Querying SQL Azure database from online portal using the Manage URL
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 […]
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 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 […]