Home
Videos uploaded by user “SQL JUNKIESHARE”
Extend Dialogflow with Webhooks :  Simple weather app
 
10:44
In this video we will look at how to extend the functionality of dialog flow using Webhooks using a simple example to build a weather app. https://slides.com/ak393/deck-4/live#/
Views: 12975 SQL JUNKIESHARE
Import JSON from SQL Server 2016 to MongoDB
 
04:11
In this video we will look into exporting data out of SQL Server 2016 in JSON using BCP and FOR JSON PATH and importing the data into MongoDB using mongoImport shell
Views: 5879 SQL JUNKIESHARE
Deploying SSRS reports 2008,R2 and 2012 , fixing Rsaccess denied
 
08:21
in this demo you will learn how to deploy ssrs reports , fixing rs access denied, difference between report server web service url and report manager url
Views: 51971 SQL JUNKIESHARE
Simple File Watcher Task example using SSIS Script Task C#-4
 
19:31
Based on what we learned so far using variables in SSIS we will use that knowledge to try build a simple file watcher task using C#
Views: 3558 SQL JUNKIESHARE
Setup Nodejs OracleDb module with simple steps
 
09:02
npm --add-python-to-path='true' --debug install --global windows-build-tools if installation process is taking longer than expected please verify the the installation log %USERPROFILE%\.windows-build-tools\ if you have oracle client installed already, make sure the PATH variable has the location, if not you can install the instant client using npm. npm install instantclient set PATH=%cd%\instantclient;%PATH% set OCI_LIB_DIR=%cd%\instantclient\sdk\lib\msvc set OCI_INC_DIR=%cd%\instantclient\sdk\include npm install oracledb
Views: 4558 SQL JUNKIESHARE
SQL 2017 WSFC High Availability Group Setup Demo and New Features
 
36:11
In this video we will look at how to setup two node WFSC SQL 2017 High Availability group setup with availability group listener. Steps: 1) Install two SQL instances on two different nodes of domain network - Done Enable Ip4 - TCP/IP Disable domain firewall or provision the inbound and out bound roles for ports 1433 and 5022 for database mirroring end point Domain account as service account 2) Install Failover Clustering Role 3) Setup WFSC cluster for the two nodes WIN-037K1L9G5V4 and WIN-Q9T3SH46P1G Give cluster computer account full permission to AD computer object 4) Enable SQL HA at instance level on both nodes Setup HA groups Join database in to the HA group Setup listner Take full backup from which ever node we setup HA first, restore on the second node with no recovery. Join the second node to HA group Verify Done !!! SQLHA03 - 10.10.2.6 - SQL HA listner SQLCL03 - 10.0.0.2 - Cluster Node:1 WIN-037K1L9G5V4 - 10.10.10.4 Node:2 WIN-Q9T3SH46P1G - 10.10.10.5
Views: 5075 SQL JUNKIESHARE
Simple cursor in SQL Server with an example
 
10:19
Simple example to create and execute a cursor
Views: 11193 SQL JUNKIESHARE
Quickly Compare Execution plans in SSMS (Compare Show Plan)
 
08:48
In this video we will look into on how we can compare execution plans using SQL Management studio using compare show plan feature in SQL Server SQL management studio
Views: 1800 SQL JUNKIESHARE
SQL server reporting services 2008,R2,2012 Data tools - Developing Spark line reports with examples
 
09:52
how to develop spark line reports, difference between charts and spark line reports
Views: 7082 SQL JUNKIESHARE
Lookup Transformation In-Depth SSIS 2008r2, 2012 (Full ,Partial, No cache) modes
 
57:21
what are different cache modes, Full cache mode Partial Cache mode No Cache mode How to improve the performance of lookup transformation when to choose different cache modes www.sqljunkieshare.com
Views: 26185 SQL JUNKIESHARE
SSIS Script Task Read And Write Variables  - 2
 
06:28
In this Video we will look into how to read a value from a variable and how to update a value of Variable
Views: 3931 SQL JUNKIESHARE
Introduction to JSON in SQL Server 2016 Part1
 
11:10
SQL 2016 New features In this video we will go over quick introduction to JSON and How SQL Server converts SQL data types to JSON data types.
Views: 18171 SQL JUNKIESHARE
How to Query JSON in SQL2016 Part2 -2
 
32:07
In this video we will look at examples using JSON PATH and JSON AUTO to transform relational data into JSON and difference between JSON PATH and JSON AUTO, using formatting options like adding root element, removing array wrapper and how to include null values
Views: 3948 SQL JUNKIESHARE
Create Simple Line Graphs in R using plot()
 
13:04
Line graphs, Multi line graphs, Multiple Line graphs
Views: 1998 SQL JUNKIESHARE
How to Implement TDE for Oracle 12c2 Container and pluggable databases
 
19:36
Setup Wallet: Modify the sqlnet.ora file ENCRYPTION_WALLET_LOCATION= (SOURCE= (METHOD=FILE) (METHOD_DATA= (DIRECTORY=Directory location\))) --set password based keystore - container level ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --set auto login keystore - container level ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE 'C:\app\AkPC\admin\tdewallet\orcl' IDENTIFIED BY password; --open the keystore in root container ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --set master key at root container level ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; --open the keystore in pdb ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY password; --Set database master key in pdb ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY password with backup; CREATE TABLESPACE encrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\encrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT); CREATE TABLESPACE unencrypted_ts DATAFILE 'C:\app\AkPC\oradata\orcl\orclpdb\unencrypted_ts.dbf' SIZE 128K AUTOEXTEND ON NEXT 64K; CREATE TABLE TEST_ENC (TEXT VARCHAR2(100)) TABLESPACE encrypted_ts; CREATE TABLE TEST_UNENC (TEXT VARCHAR2(100)) TABLESPACE unencrypted_ts; insert into TEST_ENC values ('This is a secret'); insert into TEST_UNENC values ('This is a secret');
Views: 301 SQL JUNKIESHARE
SSIS WMI Data Reader Task: How to build a Disk Space Monitoring Solution
 
14:42
In this video we will discuss how to use WMI data reader task to build a space monitoring solution. We use some concepts of WQL and query methodology when using WMI and WMI Data reader
Views: 587 SQL JUNKIESHARE
Script Task Read And Write Variables using Variable Dispenser -3
 
08:43
This is a second method to manage variables in SSIS
Views: 1156 SQL JUNKIESHARE
Microsoft announces major licensing changes with SQL 2016 SP1
 
06:22
MSDN and Microsoft release notes https://www.microsoft.com/en-us/sql-server/sql-server-editions https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/sql-server-2016-service-pack-1-generally-available/ Changes and improvements in SQL 2016 SP1 https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
Views: 811 SQL JUNKIESHARE
Installing and Configuring Sql Server 2008 R2 demo A Beginner Guide step by step
 
40:07
Install SQL Server 2008 R2 How to choose various options during installation SQL Server client --Server connectivity overview SQL Server features overview Instance/Collation/ Security(Service Account) setup Default Data and log file location SQL Server configuration management Using sample databases
Views: 1864 SQL JUNKIESHARE
Execute PowerShell Scripts in Service Now
 
05:29
We will look at using ECC queue and Custom PowerShell activity to execute PowerShell commands on MID server
Views: 820 SQL JUNKIESHARE
User defined functions SQL server 2008, R2, 2012
 
01:00:26
What is a user defined function (UDF) Different types of UDF's Scalar Functions Table valued Functions Inline Table Valued Functions Multi statement Table Valued Functions Properties of UDF's How develop and execute UDF's Advantages Limitations How to use Scalar Udf's in computed columns What are Deterministic functions and Non Deterministic functions how do they effect UDF's How do they effect performance of the UDF's Creating indexes on the Computed columns
Views: 12897 SQL JUNKIESHARE
SQL Server 2016:: Temporal Table Implementation Part - 2
 
13:17
This second part of of Temporal tables in SQL Server 2016
Views: 1430 SQL JUNKIESHARE
Oracle Key Vault endpoint enrollment process - Part 2
 
11:23
How to enroll an endpoint using OKVUTIL client and Oracle Key Vault
Views: 167 SQL JUNKIESHARE
How SQL Server Resource Governor Works Visualized
 
02:10
Resource Governor Visualized
Views: 1068 SQL JUNKIESHARE
SSIS 2008, 2012 Import and Export column transformation, For each loop container.avi
 
26:55
In this video you will learn how to use ssis import and export column transformations and also for each loop container with file enumerator , and a simple example package
Views: 6178 SQL JUNKIESHARE
SQL Server 2016::Querying Temporal tables Part-3
 
29:27
This is the third video for Temporal tables in SQL 2016 .. we discuss how to query Temporal tables using new TSQL clause (for system_time ) "asof, from,between,containedin"
Views: 993 SQL JUNKIESHARE
How to Query JSON in SQL 2016 Part 2 -1
 
12:30
In this video we will discuss how to transforom relational data to JSON data using JSON Path and JSON Auto and we will also get introduced to concepts of JSON Objects, Arrays, Embedded and Nested JSON object. To continue part 2 please click this video https://www.youtube.com/watch?v=j2Uxo9sMw0A
Views: 5687 SQL JUNKIESHARE
Deploy your first Serverless Service to AWS in 10 mins
 
14:23
Tools: NodeJS and npm, serverless module npm install -g serverless serverless config credentials --provider aws --key AKIAIEIRAUYFCKTFRRNA --secret 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 serverless create --template aws-nodejs --path testService serverless deploy -v
Views: 147 SQL JUNKIESHARE
Intro to SSIS Script Task and Script Component - 1
 
17:20
In this video we will introduce you to script task and script component on how to use C# to create your own Script task and components
Views: 3008 SQL JUNKIESHARE
SQL2016 :: Dynamic Data Masking
 
09:38
In this video we will implement dynamic data masking in Adventure works database using default,email,partial masking functions https://github.com/akhil393/SQL2016Features/blob/master/Dynamic%20Data%20masking.sql
Views: 153 SQL JUNKIESHARE
Impact of Row Goals on Query Performance
 
09:21
How to find if query optimizer used Row Goals How Row Goals change query plan, performance and IO.
Views: 29 SQL JUNKIESHARE
SQL 2016: RowLevelSecurity
 
15:29
SQL Server 2016 New feature Row level security Source code: https://github.com/akhil393/SQL2016Features/blob/master/Row%20Level%20Security.sql
Views: 197 SQL JUNKIESHARE
SQL 2016 :: How StrechDB Works and Implementing StrechDB using AdventureWorks DB
 
28:25
New feature in SQL 2016 Strech DB Source Code : https://github.com/akhil393/SQL2016Features/blob/master/Strech%20Db/Strech%20Db%20Walkthrough.sql
Views: 723 SQL JUNKIESHARE