Latest Blog Posts
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015 Summit. This competition was organized and run by Denny Cherry. You can read all about what he thought of the event right here. I was asked to take part… Read more
This is the second deep dive into Power Testing ETL with Power BI. At this point, we have created the source table which will be used in our testing. The next step is to bring in the destination table and create the tests that will be “run” against the… Read more
In case you’ve not been following the news with regards to *government* breaches:
- White House computers hacked – Russia suspected
- US Postal Service hacked – China suspected
- NOAA hacked – China suspected
All three of these news articles released within the past few weeks. The reality is that our networks… Read more
Every now and again you realize that the primary key for a table does not uniquely describe a row. Not really a big deal right? Just add an additional column in order to make it unique and move on. Easy enough if the column already exists and does not allow… Read more
SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need to monitor Database Mirroring status continuously to ensure that everything is working fine. We can use MSDB.SYS.SP_DBMMONITORRESULTS system store procedure to… Read more
Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The following is a screenshot from SSMS MDX query editor. The icon next to each measure can visually tell you if it’s a regular measure or a calculated measure.… Read more
By Steve Bolton
…………There are apparently many subtle variations on Z-Scores, a ubiquitous measure that is practically a cornerstone in the foundation of statistics. The popularity and ease of implementation of Z-Scores are what made me decide to tackle them early on in this series of amateur self-tutorials, on… Read more
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for the non-SQL nature of it.
Finally after promising myself to do so since late 2013, I've actually got around to updating my blog site to the latest version of Orchard.… Read more
It has been a pretty long time since my last blog post but with good reason!
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to build out the test cases. In the previous post, you were able to get a sense of the bigger picture and how the pieces work together. This post will… Read more
There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s a short one that might be more for administrators, but I think for developers it’s very handy as well.
SQL Server tools have included templates for years. I first started… Read more
Should you move your data to the cloud? That is the question. The answer is not simple. While moving data to the cloud is all the rage, the fact is a large majority of the Fortune 500 companies are not keeping any data in the cloud at all. At least… Read more
If you’re looking to warm up for the winter, come on down to Charleston, SC, on December 13, 2014. Charleston will be hosting its second SQL Saturday. Why Charleston?
- Charleston continually wins the award for the friendliest city in the United States.
- Charleston isn’t far from 2014’s #2,…
On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS developer? for the PASS BI virtual chapter. This is great news for the people who couldn’t attend my session at the SQL Server Days and who still want to… Read more
Today I have the honour of presenting a session for the PASS Database Administration Virtual Chapter. The great thing about the PASS Virtual Chapters are that they are completely free, you just need to be a member of PASS in order to register. That’s right, free SQL Server training… Read more
Finding out MDX calculation scripts is a common task
A co-worker recently asked me what the calculation for a calculated measure is in our reporting cube.
If you have the Analysis Services project in Visual Studio locally, it is easy to find what the calculation script is from the Calculations… Read more
In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and NULL is not even equal to NULL either, because NULL means undefined. One undefined value cannot be equal to another undefined value.
In MDX, NULL means an empty…
Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular data in a same report.
In the following snapshot, users will see a summary line that shows the Call Handled 130. The two days, 11/4 and 11/5 will not… Read more