Browsed by
Category: SQL Server

Disabling Download Icon From Power BI Report Server

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 I saw online was to connect thru SQL Server Management Studio (SSMS) and connect to the Reporting Services Instance – .\PBIRS. here what I get in Dev and prod. You can connect to the instance by specifying the Report Server web link:…

Read More Read More

SQL Server 2017–Upgrading Reporting Services

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 the in place upgrade of the engine and/or Analysis Services (SSAS) is performed. I really like how the Product Updates and instal Setup Files screens do not even show up if everything passes.   Here is a screen from the upgrade path….

Read More Read More

OLAP Acronym returns

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 and not multidimensional cubes. Lately, OLAP has not been seen as an overall description of the tabular model. There were references to semantic model replacing cube’s data source view. It is good to see this in official Microsoft documentation. While recording or…

Read More Read More

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

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 departments I have networked with are using a Hybrid approach – new stuff not under regulation can go to Azure, but current running application reports new this option for Power BI with SSRS. Using Power BI reports with Reporting Services is a…

Read More Read More

Analysis Services Series on SQLShack

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 was a Best Practices article for Dimensional Modeling and other items that help with a smooth transition to creating an SSAS database. Here is a link to that article. The flow of the articles starts with the multidimensional cube, then the next…

Read More Read More

Query Data Store–SQL Server 2016

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 with configuration options for storage of history and query plans. The option has many benefits you can take advantage of today, but also this is an option for future upgrades to new SQL Server versions because of the history contained in the…

Read More Read More

SQL Server 2016–Live Query Statistics

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 Studio (SSMS) to watch queries run on versions 2014, 2012 and 2008 R2. SSMS 2016 can be installed by itself without the server installation. Go here for the installation. Once you install SSMS, you can start to view this addition in SSMS.like…

Read More Read More

Live! 360–Speaking at SQL Server Live Orlando 2016

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 sessions are on December 5th thru the 9th in Orlando, FL at Royal Pacific Resort. This is a link with a discount code for up to $500 dollars off – http://bit.ly/LSPK47_REG Here are the three I am giving. SQT07 New Performance Tuning…

Read More Read More

Using a Lookup Component in SSIS for Surrogate Keys in a Fact table

Using a Lookup Component in SSIS for Surrogate Keys in a Fact table

There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to repeat for facts and dimensions. This might be because the consistency Dimensional Modeling suggests for the design of fact and dimension tables. The SSIS Lookup component provides options to divert handling of non-conformed data or you can use your T-SQL skills up front where a diversion is not necessary. The most common use of a Lookup…

Read More Read More

Analysis Services: Solving Hierarchy Errors of Uniqueness

Analysis Services: Solving Hierarchy Errors of Uniqueness

Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group the measures by dimension attributes helps with a quick analysis and flexible/interactive reporting. Configuring these attributes as hierarchies has some details that are not at first obvious. The error message when these problems exist is not extremely helpful for someone new to cubes. Let’s look at creating a Date hierarchy with Year, Quarter, Month and Day. Our cube…

Read More Read More