(Jason Thomas) Due to the high compression rates and stellar in-memory architecture of SSAS Tabular, most people with smaller models do not experience performance problems (in-spite of employing bad data modeling techniques and inefficient DAX measures).
Tag: sql server
Azure SQL Database – Transparent Data Encryption
(Marcin Policht) In one of our recent articles published on this forum, we described the main characteristics of row-level security – a new feature introduced in Azure SQL Database V12 as well as in SQL Server 2016 Community Technology Preview 2.
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
(Pinal Dave) When it comes to security related topics, I always read and learn something new from my friend Vinod. He always comes-up with something interesting and when he was at GIDS event, one of the attendees walked and asked a security question.
Performance Problems with IF statement execution in SSAS Tabular
(Jason Thomas) Due to the high compression rates and stellar in-memory architecture of SSAS Tabular, most people with smaller models do not experience performance problems (in-spite of employing bad data modeling techniques and inefficient DAX measures).
Azure SQL Database – Transparent Data Encryption
(Marcin Policht) In one of our recent articles published on this forum, we described the main characteristics of row-level security – a new feature introduced in Azure SQL Database V12 as well as in SQL Server 2016 Community Technology Preview 2.
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
(Pinal Dave) When it comes to security related topics, I always read and learn something new from my friend Vinod. He always comes-up with something interesting and when he was at GIDS event, one of the attendees walked and asked a security question.
Using SMO With PowerShell To Obtain SQL Server Job Information
(Tim Smith) Scripting SQL Server Agent Jobs is useful for backups, disaster recovery or saving revisions. There are many ways SQL Server Agent Job scripts can be generated and in this tip we will look at the SMO library with PowerShell.
Using SMO With PowerShell To Obtain SQL Server Job Information
(Tim Smith) Scripting SQL Server Agent Jobs is useful for backups, disaster recovery or saving revisions. There are many ways SQL Server Agent Job scripts can be generated and in this tip we will look at the SMO library with PowerShell.
Indexed views on any core SQL server edition–The video
(Arthur Olcot) A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to be one of my most read blog posts.
Creating and Managing Docker VM Extensions in Azure
(Krishna Kumar) In this article, I’ll first touch on why containers are important, and how they can be a better solution for some software development tasks than using virtual machines. I’ll then explain some of the jargon around Docker. With that out of the way, I’ll give you a step-by-step guide t
