

Nov 03, 2020
SQL Server in Microsoft Azure virtual machines
You know that virtual machine you’re using that’s hosted on Windows Server 2012 R2 or System Center 2012 R2? Well, that same virtualisation technology is now available [...]


Oct 13, 2020
Enhancements to Transact-SQL for SQL Server 2014
Did you know that Microsoft has released a new version of SQL Server? (Of course you did!) Well, a new version means new stuff! It is a Microsoft product, so there are [...]


May 30, 2021
Implementing security in SQL Server 2014
Today, I want to discuss some of the security enhancements in SQL Server 2014, but before I do, have you ever considered how SQL Server compares to other database [...]


Jan 21, 2021
Owning the runway with BI Semantic Model
I believe there's some confusion about the BI Semantic Model (BISM), multidimensional models, and tabular models. Further to this is the question of "when can I use MDX [...]


Jan 09, 2021
Power View just got better!
Okay, so have you done our 10778 course? The SQL Server 2012 Data Models and Reports course? Oh, you haven't. I see. Well... you should, it's REALLY good! Anyway, [...]


Dec 12, 2020
The Pros and Cons of SSAS Tabular Models in SQL Server 2012
I’m a BIG fan of the new SSAS Tabular Models, which is a new data model that Microsoft has introduced in SQL Server 2012. In many ways, it’s a technology competing with [...]