Home » SQL Server

Power BI Performance Tuning: Data Model

There are many opportunities for performance tuning in Power BI. The main areas are the data model, visualization pane and the service. Power BI always starts with data. Once the data is modeled, the visualizations can be created….

Read More »

Query Store follow up – PASS Performance Marathon

Here are some answers to questions from PASS Performance Marathon presentation on Query Store: An Introduction 1. To turn on/off Query Store, will it impact DB availability? (meaning DB does not need to be offline) No, turning off…

Read More »

Disabling Download Icon From Power BI Report Server

I read that we can remove the Download button from the main menu of Power BI Reporting Services. This is needed to clean up the Portal and remove anything that can be confusing to users. But, the only…

Read More »

SQL Server 2017–Upgrading Reporting Services

Upgrading SQL Server to 2017 Upgrading a SQL Server instance to 2017 has some changes. The first big one has to do with Reporting Services (SSRS). The installation program no longer installs SSRS and suggests to upgrade before…

Read More »

OLAP Acronym returns

After reviewing Azure Data Architecture Guide, I noticed the label Online Analytical Database (OLAP) referenced as the description for Azure Analysis Services. I will call Azure Analysis Services AAS from here on. The AAS is using tabular models…

Read More »

Power BI – 5 Nice On Premise Features That Can Be Used Part 1

Thank you Microsoft for porting Power BI reports to SQL Server Reporting Services (SSRS). This goes along way with IT shops that are still On-Premise. There is no denying that more development is going to Azure. Some IT…

Read More »

Analysis Services Series on SQLShack

Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with Multidimensional Cubes as well as Tabular Models. The start…

Read More »

Query Data Store–SQL Server 2016

SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to do performance tuning on T-SQL queries. This new feature of SQL Server 2016 is contained within a database…

Read More »

SQL Server 2016–Live Query Statistics

WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while the query runs. Never saw that coming. And even a bonus, you can use SQL Server 2016 Management…

Read More »

Live! 360–Speaking at SQL Server Live Orlando 2016

If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different areas of IT (including SQL Server) with some of the great experts presenting sessions for 5 days. The…

Read More »