As we discussed the levels in Power BI, the first level is creating dataset.
To start prepare the dataset, first sign in to the power BI here,
This article will talk about, how to create a dataset from local file.
Steps to import the local file,
Microsoft SQL Server 2016 has one of the exciting feature called PolyBase. It is acts as a bridge between relational database and Hadoop.
We can access all structured, unstructured and semi-structured data using known language of SQL.
Polybase allows user to use T-SQL Statements in Microsoft SQL Server Management studio to access data stored in Hadoop or Microsoft Azure blob storage.
Below services should up and running to use this feature.
To check the installed services in system,
Go through my previous article here, about Data storage format in columnstore Index.
There are lots of improvements in Query processing speed when we use columnstore Index.
Temporal is a database feature that was introduced in ANSI SQL 2011 and this is now supported in SQL Server 2016.
It is a new type of user defined table and designed to keep track of all historical changes on the table and make easy to do point in time analysis.
Main reasons to use temporal table,
Prerequisites to create temporal table,
Syntax to create Temporal Table
CREATE TABLE <Table Name>
<column 1> int NOT NULL PRIMARY KEY CLUSTERED
,<column 2> <datatype>
, <column n>
, [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START
, [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END
, PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = <schema>.<tablename> –Optional));
We can give any name instead of ValidFrom and ValidTo, both should be bind in PERIOD.
Alert feature in Microsoft SQL server is one of the prominent feature available in SQL server. Before we understand what Alert feature is and how to make use of the feature, first let us understand about basic meaning of Alert.
Alert is a warning or notification highlighted or notified to individual, group or other subsequent action for the predefined scenarios. Having alert system will keep away any of the future hazardous or hefty loss.
In SQL server Alert work similar as the Alert system available in any of the other systems available in other systems or process. To feel the alert system how it works you can consider the smartphones or any other mobile devices which through warning when there Is a low battery or any communication received.
As simple example earlier, SQL server alert system behaves the same way where it notifies the end user about any performance issues, Starting or stopping the process, intimating the end user through mail or other any communication methods.
SQL server Alert system is managed through SQL Server agent and SQL server agent should be up and running to make use of SQL server Alert System feature.
SQL Server Alert system can notify the end users through following communication methods.