Posts

How To : Uninstall SQL Server Analysis Services Instance (SSAS)

Image
(1 min read )
You may NOT ever wanted to un-install Microsoft SQL Server Analysis Services instance. Even things were same for me until now. I needed to un-install existing multidimensional instance in client environment and install Analysis Services Tabular instance for development. There are no-straight forward way to do and even the steps provided on Tech-net  did not work for me. Lets have a look at pretty straight forward simple steps to do in order to remove your AS instance. 
Prerequisites :
In order to do this, you might mount the SQL Server Installation image mount and locate as the setup.exe path. In my case its F:\ drive the iso mounted

Steps :

1. Open Command Prompt as Administrator model in the server or PC you need to perform uninstallation.

2. Type the below command and run

F:\setup.exe /ACTION=uninstall /FEATURES=AS /INSTANCENAME=YOUR_INSTANCE_NAME

In above command has below parameters.

1- Installation setup path
2- Action performed. In here we are going to un-install
3- Fea…

#FloodSL Red Alert

Image
I've created a simple Power BI report based on the source published by Department of Government Information, Sri Lanka. It is an urgent responsibility to focus on these areas and evacuate as its more likely to rain in next few days. You can navigate the areas through the map. View the Report

Talk to Your Power BI Visuals With Microsoft Cortana

Image
You may have been modelling data and visualize through Power BI since many years. Have you ever thought speak to the data through Power BI visuals instead click and view. Microsoft Cortana empower us to speak to query the data and get the results without navigate the reports in traditional way.



Here are the 5 steps you need to integrate your Power BI reports with Cortana. (5 mins read)
Step 1One of the very first step is to check whether your Windows version need to be 1511 or higher. You can check it by


Click Windows Icon and type “Your PC”

Check the Version whether greater than 1511.

Step 2


Make sure your power BI account and windows account interconnected. 
Click windows go to settings and Click Accounts 



Click Access Work or School Tab. It shows all the accounts added with your windows account. If you have not added your power BI account here, its time to add and link with your windows PC 



Step 3

Make sure your PC is connected with O365
Go to Cortana icon in your task bar and click …

SQL Server 2016 Temporal Tables Usages

Image
As most of you already aware, the Temporal table capabilities are a lot we can find out and use for our developments both database and data warehousing/analytics. Follow diagram shows major usages of Temporal.



From the below link you can find-our wiki article I've written regarding Slowly Changing Dimension usage of Temporal Tables https://social.technet.microsoft.com/wiki/contents/articles/37614.slowly-changing-dimension-using-temporal-tables.aspx

[Execute SQL Task] Error: An Error Occurred While Assigning VARCHAR(MAX) Value to Variable

Image
You may be encounter problem with when you try to return VARCHAR(MAX) data using Execute SQL Task in SSIS. Below error message will be return most of the time when you wrote T-SQL which return VARCHAR(MAX) column in Execute SQL Task and run the SSIS package. 

The full error message as below,

[Execute SQL Task] Error: An error occurred while assigning a value to variable "SourceQuery": "The type of the value (DBNull) being assigned to variable "User::SourceQuery" differs from the current variable type (String). Variables may not change type during execution. Variable types are strict, except for variables of type Object."
SourceQuery is the variableName try to assigned the VARCHAR(MAX) value.

Solution:
SSIS does not understand VARCHAR(MAX) data type. So, you can't simply store varchar(max) values in ssis variables. As an option, you have to limit the length into something like VARCHAR(8000)

What Is a Slowly Changing Dimension?

Image
In Data Warehousing dimension tables are typically static. But sometimes you may find dimension entities which can be change over the time. Location of the customer, Project of the Employee are few examples for these type of dimension members. When we implement the warehouse ETL process we need to cater this issue. otherwise the business user end either will lose the data or they might see see inaccurate data in the report. In the data warehouse jargon this common issue will called as Slowly Changing Dimension problem or SCD.

There are altogether 7 SCD types. The folloing Five types are the ones widely used in the industry. Below, you can see a illustration of how each type works 😊

In this example shows the customer table, customer location changing from the source. When it comes to data warehouse DimCustomer customer dimension table how it looks like in each SCD type.


Type 0 
In type 0 preserve the original value, when the attribute changes in source operational system are not going …

Microsoft SQL Server 2016 Technical Overview

Image
I'm just started to reading this .... 🙌 Its a great way to learn about all the Microsoft SQL Server 2016 features and capabilities. Here is the Link for get the free ebook of Technical Overview


Microsoft SQL Server 2016 Technical Overview