Blog: Dinesh Priyankara

208 blogs updated: 7 min. ago
SQL Server Always Encrypted - Serving applications using Azure Key Vault and Certificate Store
Here is my second video related to Always Encrypted. This video discusses the way of configuring CMK for serving multiple applications hoste...
16-10-2017 09:25:07 Dinesh Priyankara SQL Server
Introduction to Always Encrypted
Here is my second video that speaks about Always Encrypted feature. This video shows How Always Encrypted works, how it should be configured...
12-10-2017 17:21:53 Dinesh Priyankara SQL Server
Introduction to Azure HDInsight
I have written few posts on HDInsight and thought to make series of Video on it as well. Here is the first one, with this video, I discuss, ...
03-10-2017 09:02:47 Dinesh Priyankara SQL Server
Self-Service Business Intelligence with Power BI
Author: Acuity Training - Training Provide for Excel Business Intelligence Understanding Business Intelligence There was a time that Busines...
18-09-2017 16:38:39 Dinesh Priyankara SQL Server
SQL Server 2016 - CREATE/ALTER PROCEDURE must be the first statement in a query batch
Everyone knows that SQL Server started supporting CREATE OR ALTER statement with SQL Server 2016 and it can be used with few objects. Howeve...
17-09-2017 19:36:16 Dinesh Priyankara SQL Server
SQL Server TRY_CONVERT returns an error instead of NULL
Can this be happened? The functions TRY_CONVERT and TRY_CAST have been designed for handling errors and they should return NULL when there i...
13-09-2017 19:25:20 Dinesh Priyankara SQL Server
Run Hive Queries using Visual Studio
Once HDInsight cluster is configured, we generally use either the portal dashboard (Powered by Ambari) or a tool like PuTTY for executing qu...
13-09-2017 08:50:19 Dinesh Priyankara SQL Server
SQL Server - Merging Partitions - Does it physically move data from a data file to another?
Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database i...
12-09-2017 10:21:04 Dinesh Priyankara SQL Server
How to refer files in HDInsight - Azure Storage using different ways
If you have started working with Big Data, you surely need to check the Microsoft support on it via Azure platform - HDInsight service. HDIn...
11-09-2017 18:27:45 Dinesh Priyankara SQL Server
SQL Server - Dropping Primary Key will drop the Clustered Index?
Everyone knows that SQL Server creates a Clustered Index when we add a Primary Key if there is no Clustered Index already exist in the table...
09-09-2017 16:25:29 Dinesh Priyankara SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.