Home
Videos uploaded by user “CodeCowboyOrg”
SFTP - Windows Script to Automate Synchronize Remote to Local Directory using WinSCP
 
02:31
WinSCP Script - https://goo.gl/XyYXTp WinSCP - Batch File - https://goo.gl/PBcNz6 WinSCP Download (download Portable) - https://winscp.net/eng/download.php WinSCP Scripting Resource - https://winscp.net/eng/docs/scripting Demo of using WinSCP to script the automation of synchronizing Remote SFTP directory with a Local Directory
Views: 66054 CodeCowboyOrg
Tableau Server | How to Create a Schedule and Change an Extract Schedule
 
02:44
How to Create a Schedule and Change an Extract Schedule on Tableau Server
Views: 13682 CodeCowboyOrg
SFTP - Windows Automate Script to Synchronize Uploading Files to Remote Directory using WinSCP
 
02:53
WinSCP Script - https://goo.gl/dbWZh3 WinSCP - Batch File - https://goo.gl/6ssTm6 WinSCP Download (download Portable) - https://winscp.net/eng/download.php WinSCP Scripting Resource - https://winscp.net/eng/docs/scripting Demo of using WinSCP to script the automation of synchronizing Remote SFTP directory with a Local Directory by Uploading files, One Way Sync
Views: 50794 CodeCowboyOrg
IIS - How to Create Self Signed SSL Certificate for HTTPS
 
02:05
How to setup self signed SSL in IIS and edit HTTPS binding
Views: 23152 CodeCowboyOrg
Windows Server 2016 - Install IIS 10.0 (How to Step by Step)
 
05:50
IIS 10.0 is only available in Windows Server 2016 and Windows 10
Views: 60056 CodeCowboyOrg
Windows Server 2016 - Install FTP on IIS 10.0 (How to Step by Step)
 
04:34
In the Video Tutorial you will learn to install and configure FTP on IIS 10 in Windows Server 2016. After watch tutorial on IIS 10.0 FTP configuring users for the ftp server. Download Free FTP Client software: https://filezilla-project.org/download.php
Views: 46839 CodeCowboyOrg
Tableau Server | Creating Sites and Site Administrators Tutorial
 
05:32
Quick tutorial on creating Sites and Site Administrators within Tableau Server
Views: 9139 CodeCowboyOrg
MSSQL - Understanding Isolation Level by Example (Read Uncommitted)
 
06:27
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Serializable, Read Committed, Read Uncommitted, Repeatable Read --===================================== -- Windows/Session #1 --===================================== IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 1 WAITFOR DELAY '00:02:00' ROLLBACK --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT * FROM SampleTable SELECT * FROM SampleTable WITH (NOLOCK) SELECT * FROM SampleTable WHERE ID = 3 SELECT * FROM SampleTable WHERE Name = 'Name2' SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is default READ UNCOMMITTED -- ----------------------------------------------------- SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT * FROM SampleTable SELECT * FROM SampleTable SELECT * FROM SampleTable WHERE ID = 2 SELECT * FROM SampleTable WHERE Name = 'Name2' SELECT * FROM SampleTable WITH (NOLOCK)
Views: 9395 CodeCowboyOrg
MSSQL - Understanding Isolation Level By Example (Serializable)
 
08:46
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Serializable, Read Committed, Read Uncommitted, Repeatable Read --===================================== -- Windows/Session #1 --===================================== SELECT @@SPID IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] DEFAULT(GETDATE()) NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 2 DELETE FROM SampleTable WHERE ID = 4 WAITFOR DELAY '00:0:10' COMMIT TRAN --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT @@SPID BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable ROLLBACK SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is REPEATABLE READ -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN --===================================== -- Windows/Session #4 --===================================== ----------------------------------------------------- -- This window/session is SERIALIZABLE -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN
Views: 13858 CodeCowboyOrg
Tableau | Live vs Extract Data Source Demo
 
06:28
A Demonstration of the Difference between a Live and Extract Data Source in Tableau Server and Tableau Desktop
Views: 23687 CodeCowboyOrg
Azure (RM) -  What Are Availability Sets and Groups
 
04:53
Quick Explanation of What are Availability Sets and Groups in the NEw Azure Resource Manager
Views: 8564 CodeCowboyOrg
PHP - How To Manually Install PHP on IIS 10.0 for Windows Server 2016
 
15:49
PHP Demo File Download - http://goo.gl/2gligS 1) Install CGI for IIS 2) Get PHP non thread safe zip package a. http://windows.php.net/download#php-7.0 b. Unzip PHP put in "C:\PHP7" c. Give IIS "IUSR_" permissions to folder 3) Edit "php.ini" a. fastcgi.impersonate = 1 b. cgi.fix_pathinfo=0 c. cgi.force_redirect = 0 d. extension_dir= "ext" e. error_log=”C:\PHP7\php_errors.log” f. date.timezone = "UTC" g. Uncomment extensions required 4) Set PATH variable 5) IIS Settings a. Add IIS Handler Mappings b. Add "index.php" to default docs 6) Test command line a. Possible need to download Visual C++ Redistributable 20xx Links here http://stackoverflow.com/questions/30811668/php7-missing-vcruntime140-dll https://www.microsoft.com/en-us/download/details.aspx?id=48145 7) Test a php web page
Views: 49563 CodeCowboyOrg
Visual Studio - How to Debug a Remote Web Application  (Part 3)
 
07:28
Link below to the Remote Debugging Tool, How to Attach Debugger to a Remote Server, step by step in Visual Studio 2005, 2008, 2010, 2012, 2013 http://msdn.microsoft.com/en-us/library/bt727f1t(v=vs.110).aspx#BKMK_Installing_the_Remote_Debugger Part 1 https://www.youtube.com/watch?v=juPCqN-Rb1E Part 2 https://www.youtube.com/watch?v=S7Jcur8YAsw Part 3 https://www.youtube.com/watch?v=aAwOoNiojoA
Views: 32236 CodeCowboyOrg
MSSQL - How to, Step by Step Change Data Capture (CDC) Tutorial
 
10:46
Download example from my Google Drive - https://goo.gl/3HYQcH REFERENCES http://technet.microsoft.com/en-us/library/cc645937.aspx http://technet.microsoft.com/en-us/library/dd266396(v=sql.100).aspx Change data capture cannot function properly when the Database Engine service or the SQL Server Agent service is running under the NETWORK SERVICE account. This can result in error 22832. 0) CDC Can not be enabled when Transactional Replication is on, must turn off, enable CDC then reapply Transactional Replication 1) Source is the SQL Server Transaction Log 2) Log file serves as the Input to the Capture Process 3) Commands a. EXEC sp_changedbowner 'dbo' or 'sa' b. EXEC sys.sp_cdc_enable_db / EXEC sys.sp_cdc_disable_db c. EXEC sys.sp_cdc_enable_table / d. EXEC sys.sp_cdc_help_change_data_capture -- view the cdc tables e. SELECT name, is_cdc_enabled FROM sys.databases 4) To SELECT a table you must use the cdc schema such as cdc.SCHEMANAME_TABLENAME_CT iand its suffixed with CT 5) Columns a. _$start_lsn -- commit log sequence number (LSN) within the same Transaction b. _$end_lsn - c. _$seqval -- order changes within a transaction d. _$operation -- 1=delete, 2=insert,3=updatebefore,4=updateafter e. _$update_mask -- for insert,delete all bits are set, for update bits set correspond to columns changed 6) Note CDC creates SQL Agent Jobs to move log entries to the CDC tables, there is a latency 7) There is a moving window of data kept, I believe the default is 3 days. 8) At most 2 capture instances per table USE AdventureWorks2008R2 GO EXEC sp_changedbowner 'sa' EXEC sys.sp_cdc_help_change_data_capture EXEC sys.sp_cdc_enable_db EXEC sys.sp_cdc_disable_db SELECT * FROM cdc.change_tables SELECT * FROM cdc.Address_CT SELECT * FROM cdc.Person_Address_CT ORDER BY __$start_lsn DESC EXEC sys.sp_cdc_disable_table @source_schema = N'Person' , @source_name = N'Address' , @capture_instance = N'Address' EXEC sys.sp_cdc_enable_table @source_schema = N'Person' , @source_name = N'Address' , @role_name = NULL -- , @capture_instance = N'Address' , @capture_instance = NULL , @supports_net_changes = 1 , @captured_column_list = N'AddressID, AddressLine1, City' , @filegroup_name = N'PRIMARY'; GO INSERT INTO AdventureWorks2008R2.Person.Address (AddressLine1,AddressLine2,City,StateProvinceID,PostalCode,SpatialLocation,rowguid,ModifiedDate) VALUES ('188 Football Avenue', 'Suite 188', 'Seattle', 10, '80230', NULL, NEWID(), GETDATE()); SELECT TOP 1 * FROM Person.Address ORDER BY AddressID DESC UPDATE Person.Address SET AddressLine1 = '199 Football Ave' WHERE AddressID = 32524 DELETE FROM Person.Address WHERE AddressID = 32524 GO
Views: 41540 CodeCowboyOrg
OpenSSH - Using RSA Public Keys for SSH Connection (ssh-keygen, ssh-copy-id, ssh- keyscan)
 
06:12
Demo of connection via SSH using the RSA Public Keys without password using the commands 1) ssh-keygen - creates the public and private keys for connection 2) ssh-keyscan - putting the host into the trusted known_hosts files 3) ssh-copy-id - command to put public key in the authorized_keys file
Views: 27566 CodeCowboyOrg
SFTP - Linux Shell Script to Automate Synchronize Remote to Local Directory using LFTP command
 
02:41
Linux Bash Script - https://goo.gl/5r60iE Demo of using LFTP to script the automation of synchronizing Remote SFTP directory with a Local Directory
Views: 9784 CodeCowboyOrg
MSSQL - Understanding Isolation Level By Example (Repeatable Read)
 
08:26
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Serializable, Read Committed, Read Uncommitted, Repeatable Read --===================================== -- Windows/Session #1 --===================================== SELECT @@SPID IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] DEFAULT(GETDATE()) NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 2 DELETE FROM SampleTable WHERE ID = 4 WAITFOR DELAY '00:0:10' COMMIT TRAN --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT @@SPID BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable ROLLBACK SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is default REPEATABLE READ -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN
Views: 6892 CodeCowboyOrg
Tableau Server | How to Backup Server
 
04:01
Demo how to Backup the Tableau Server BACKUP ================== SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\bin; tabadmin backup tabserver -d -v RESTORE ================== SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\bin; tabadmin stop tabadmin restore "tabserver-restore.tsbak" REM tabadmin restore --no-config "tabserver-restore.tsbak" tabadmin start
Views: 5455 CodeCowboyOrg
Azure - How to Remote Desktop to Ubuntu VM using RDP
 
10:16
Download Instruction Here - https://goo.gl/BLHsYf How to Remote Desktop to Ubuntu VM using RDP
Views: 28749 CodeCowboyOrg
MSSQL - How to schedule SSIS Package in SQL Agent
 
07:17
Microsoft SQL Server 2012 Visual Studio Business Intelligence Data Tools http://www.microsoft.com/en-us/download/details.aspx?id=36843 Github https://github.com/CodeCowboyOrg/SSISConcepts
Views: 50706 CodeCowboyOrg
.NET Obfuscator - How to use ConfuserEx Tutorial
 
05:43
ConfuserEx Link - https://github.com/yck1509/ConfuserEx/releases Telerik Decompiler - http://www.telerik.com/products/decompiler.aspx ConfuserEx Anti-Decompiler Demo and Review .NET obfuscator antidecompiler
Views: 20656 CodeCowboyOrg
USB UEFI Boot - How to Create a Win7 UEFI USB Boot Disk
 
07:41
Demonstrate how to create a UEFI Boot Disk for Windows 7 on a USB Thumb Drive or USB External Hard Drive. Below are the step by step instructions. HOW TO CREATE A UEFI WINDOWS 7 USB BOOT DISK 1) Download and install 7-Zip (get it here http://www.7-zip.org/download.html) 2) Extract the files from DVD or ISO file 3) Partition your USB Drive (optional) a. Open Command Window (CMD) as administrator b. diskpart c. list disk d. select disk NUMBER e. clean f. create Partition Primary g. select Partition 1 h. active i. format quick fs=FAT32 j. assign j. exit 4) Copy files from DVD or ISO to USB Drive 5) Make a directory “/efi/boot” on the USB Drive 6) Go to “/source/install.wim” open archive with 7-zip a. In the archive go to “/1/Windows/boot/efi” b. Copy file bootmgfw.efi to “/efi/boot” on USB Drive 7) Rename bootmgfw.efi to bootx64.efi in “/efi/boot” 8) Copy Files from “/efi/microsoft/boot” TO “/efi/boot”
Views: 193403 CodeCowboyOrg
IIS FTP - User Isolation Setup with Admin Access
 
16:32
WHAT ARE WE TRYING TO DO 1) Set up FTP in IIS such that a) FTP Users are isolated to their home directory b) But FTP Admin can access all directories STEPS 1) Create IIS FTP Site a) Enable Basic Authentication b) Set FTP User Isolation to "User name directory" 2) Create NT Security Groups (FTP Users, FTP Admins) 3) Create Users (ftpadmin01, ftpuser01, ftpuser02, ftpuser03) 4) Create a Folder FtpRoot a) Set NT File Permissions for "FTP Admins" on FtpRoot 5) Create User folders of the Same Name (ftpuser01, ftpuser02, ftpuser03) 6) Create Virtual Directory LocalUser a) Set FTP Authorization to FTP Users "Read" b) Set FTP Authorization to FTP Admins "Read,Write" 7) Create Virtual Directory ftpadmin01 8) Set Authorization for User Home Folders to Read,Write"
Views: 45863 CodeCowboyOrg
Tableau Desktop | Publishing Live Data Source
 
02:54
A Tableau Desktop Demonstration Publishing a Live Data Source to Tableau Server from Tableau Desktop
Views: 3240 CodeCowboyOrg
Azure (RM) -  How To Configure Sticky Sessions for Load Balancer
 
03:40
Azure Resource Manager - How to configure sticky sessions for load balancer
Views: 3646 CodeCowboyOrg
SFTP - Use WinSCP to Login to SFTP without Password using Public Key Private Key Pair
 
06:06
WinSCP Download - https://winscp.net/eng/download.php Demo how to import an OpenSSH formatted Private and Public Key Pair into WinSCP for use with SSH and SFTP
Views: 55615 CodeCowboyOrg
Windows Server - How to Enable TLS 1.2 Registry Script (Disable TLS 1.0, 1.1, RC4, SSL 2.0, 3.0, DH)
 
04:22
Registry Script - http://bit.ly/TLS-Security-Fix (rename to .reg) SSL Labs - https://entrust.ssllabs.com/ Microsoft SQLServer TLS Support - https://blogs.msdn.microsoft.com/psssql/2016/01/31/tls-1-2-support-for-sql-server-2008-2008-r2-2012-and-2014/ Microsoft TLS Poodle Fix - https://www.microsoft.com/en-us/download/details.aspx?id=30253 Security Standards Council - https://blog.pcisecuritystandards.org/are-you-ready-for-30-june-2018-sayin-goodbye-to-ssl-early-tls Windows Server - How to Enable TLS 1.2 Registry Script
Views: 15149 CodeCowboyOrg
Azure (RM) | VPN Point to Site | Step By Step Tutorial
 
31:29
Download Artifacts - https://goo.gl/sMyFrb Short Video - https://youtu.be/2IH3SrqXUEk Long Video - https://youtu.be/-GEEv_7xrEo How to Create a Point to Site VPN to Azure Virtual Network Step by Step Tutorial 1) Create a Virtual Network 0) Named - VNET-01 1) Address Space - 10.10.0.0/16 2) Subnet - 10.10.10.0/24 2) Create a GatewaySubnet within the Virtual Network 1) GatewaySubnet - 10.10.1.0/24 3) Create a Virtual Network Gateway 1) Associate to Virtual Network VNET-01 2) This takes Azure 45 minutes to complete 4) Create a VM within the Virtual Network VNET-01 5) Create the Root VPN Certificate 1) Download Windows SDK if neccessary - https://developer.microsoft.com/en-us/windows/downloads/windows-10-sdk 2) Go to Directory - C:\Program Files (x86)\Windows Kits\10\bin\x86 3) Run Command - makecert -sky exchange -r -n "CN=AzureVpnRootCert" -pe -a sha1 -len 2048 -ss My "AzureVpnRootCert.cer" 4) Run CertMgr to Convert to BASE64 - certmgr.msc 5) Find Cert in Personal\Certificates and Export to BASE64 without Password 6) Open Base64 Cert in Text Editor, put in one line and paste into Azure Root Cert Settings 6) Create the Client Certificate 1) Command - makecert.exe -n "CN=AzureVpnClientCert" -pe -sky exchange -m 96 -ss My -in "AzureVpnRootCert" -is my -a sha1 2) Run CertMgr to Convert to PFX file - certmgr.msc 3) Find Cert in Personal\Certificates and Export to BASE64 with Password 4) This pfx file must be installed and distributed to users with VPN Software 7) Get up Gateway Point to Site Setting 1) Address Space - 172.20.20.0/24 2) Set up Root Certificate a) Name - AzureVPN b) Cert - MIIDCDCCAfSgAwIBAgIQaJWEScsSKplBONYqfhQDZjAJBgUrDgMCHQUAMBsxGTAXBgNVBAMTEEF6dXJlVnBuUm9vdENlcnQwHhcNMTYxMjE5MDg0MjM5WhcNMzkxMjMxMjM1OTU5WjAbMRkwFwYDVQQDExBBenVyZVZwblJvb3RDZXJ0MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1J2+mypZtKY/XHrPl3NE2a0I+YacSgoji4smnrciF5M621hrJMLXLTwTLP0Y/zVgxqXnbB/xEfJrccYqZgBwzrvKHH609RARiIpJYpdyomBFCvsviZRJK+FRZn9es3BUnhlGYlEG1lidZbeUHVEf2MSc8QSZOm6OWvE/DYYjQ3gyUHl2wndsU8AppaHqRFiLuKA108IlDrPGMpaS/u+zFsfn9vTWE0m2aJgp6JBhB8OEiggx93Nn8KaYtb1Y5Pp5kTFAzGHC35Yt0W639xJn56/cEjrItqfbQ2jgOAPYk9mr0VF3v54Tq8qZAmTOrD/SxLzCJTI9yFz05Pg/lwNWaQIDAQABo1AwTjBMBgNVHQEERTBDgBAYnN+hUpyAO1rkJ0aH9zTmoR0wGzEZMBcGA1UEAxMQQXp1cmVWcG5Sb290Q2VydIIQaJWEScsSKplBONYqfhQDZjAJBgUrDgMCHQUAA4IBAQA4KHuby1KLyEtGVOxIgxk+eJDf76wbtCrbYEVyiULV+NcHgy+zb7PXHXFT6Rn24aqF3tmzqvrw3GSqUWaXOb3B5a4OSTa+kG0flXl1bLwJLUyizA5wmL2aDM5JlliTiuYviYDYCoO43f3+kINvQ0iVclHwPPZWk9gkZ0XYBBzDu5lJtNazG8RBvR9Kxs84rWBt8rGOa/0/qLewIIN60pzaFGJ83BSqzR9XTt+AxE9fiGhrPgn11yZsnT2RUeP/N5R3t4iTMnZQ2yriTI1sjS5hSnhjkPhiyC3SFpcRUtB6CXWB8mx2L2JqXZeZbUzGR+uK0GppTFsqm8Q7IDpFyaJJ 8) Download VPN Software 9) Install Client Cert 1) Right Click On Client Certificate, Click Install 2) Install VPN Software 10) Connect VPN via Network Connections
Views: 62086 CodeCowboyOrg
MSSQL - How To Create a SSIS Configuration File for Deployment
 
07:14
Microsoft SQL Server 2012 Visual Studio Business Intelligence Data Tools http://www.microsoft.com/en-us/download/details.aspx?id=36843 Github https://github.com/CodeCowboyOrg/SSISConcepts
Views: 21838 CodeCowboyOrg
Azure  (RM) - How to Setup RDP for Remote Access
 
02:48
Set up and Configure a new Azure Resource Manager VM to RDP via port 3389 to the Remote Desktop Access
Views: 32133 CodeCowboyOrg
MSSQL - How to Setup Database Mail Step by Step
 
06:55
How to set up database mail for SQL Server.
Views: 23619 CodeCowboyOrg
Windows Server 2016 - Install Hyper-V Server, Virtual Switch, VMs  (How to Step by Step Tutorial)
 
19:49
Installing HyperV from nothing to Virtual Switch to VMs step by step tutorial on Windows Server 2016 or Windows 10
Views: 173415 CodeCowboyOrg
MSSQL - How to Trace Deadlock Using Extended Events
 
04:52
Download below Code from the Video for Tracing Deadlock with SQL Server Extended Events, works for 2008R2, 2012, 2014 https://drive.google.com/file/d/0B-fhB8yhjD8AQ3o1NWZvQTBYMmM/view?usp=sharing
Views: 7339 CodeCowboyOrg
MSSQL - How to Upgrade SQL Server Standard Edition to Enterprise Edition
 
02:39
Quick demo on how to upgrade and Standard Edition to and Enterprise Edition for SQL Server 2014 or any other Version
Views: 7931 CodeCowboyOrg
Azure (RM) - Create Network File Share without a VM
 
04:54
Tutorial on how to create a network file share without a VM, which can be shared across VMs for both Linux and Windows and can be accessed Remotely outside of Azure infrastructure. This uses SMB 3.0 thus it is only supported by Windows 8 or above and Windows 2012 or above.
Views: 8353 CodeCowboyOrg
Tableau Server | How to Change Logo for Branding
 
05:23
Sample Artifacts - https://goo.gl/jK79U3 How to Change Logo - https://youtu.be/yKbQ9aXj9-c How to Restore Logo - https://youtu.be/hqGLLjPrsd4 REM ================================ Reference =================================== REM https://onlinehelp.tableau.com/current/server/en-us/customize_namelogo.htm REM ============================ RESTORE DEFAULT LOGOS ============================= REM SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\bin; REM tabadmin customize parameter -d REM For parameter, specify name, logo, header_logo, sign_in_logo, or smalllogo. REM tabadmin restart REM tabadmin customize name -d REM tabadmin customize header_logo -d REM tabadmin customize sign_in_logo -d REM tabadmin customize smalllogo -d REM ============================ Customize Site Name ============================= REM Replace new_name with your custom name, as in the following example REM Note: To change to a name that includes Unicode characters, identify REM the hex encoding for each Unicode character and add \u before each REM hex value. For example, for the two-character Chinese, type the REM command tabadmin customize name "\u6D4B\u8BD5". REM tabadmin customize name "My Company Name" REM tabadmin restart SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\bin; tabadmin customize name "CodeCowBoy" REM You can customize the logo that appears on the Tableau Server sign-in page, REM the header logo in server pages, and the small logo that appears in the upper REM left when a view is being edited in web authoring. The name "Tableau" is REM part of this logo. It cannot be changed independently of the logo. REM The image files you use should be in GIF, JPEG, or PNG format. REM The header_logo image can be up to 160 by 160 pixels, but not smaller than REM 32 by 32 pixels. For best results use an image that is 125 by 35 pixels. REM If the image is larger than 160 by 160 pixels, it is clipped. REM The sign_in_logo image can be a maximum of 3000 by 3000 pixels. REM The smalllogo image can be up to 32 by 32 pixels. For best results use an REM image that is 32 by 32 pixels. REM =========================== Customize Header Logo =========================== REM tabadmin customize header_logo "C:\My Pictures\logo.png" REM tabadmin restart tabadmin customize header_logo "C:\Temp\CodeCowBoy-HeaderLogo.png" REM =========================== Customize Login Logo ============================ REM tabadmin customize sign_in_logo "C:\My Pictures\logo.png" REM tabadmin restart tabadmin customize sign_in_logo "C:\Temp\CodeCowBoy-LogonLogo.png" REM ======================== Customize Small Icon Logo ========================== REM tabadmin customize smalllogo "C:\My Pictures\logo.png" REM tabadmin restart tabadmin customize smalllogo "C:\Temp\CodeCowBoy-SmallLogo.png" tabadmin restart REM ======================== Restore Default Logo ==========================\ REM SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\bin; REM tabadmin customize name -d REM tabadmin customize header_logo -d REM tabadmin customize sign_in_logo -d REM tabadmin customize smalllogo -d REM tabadmin restart
Views: 4447 CodeCowboyOrg
Windows 2016 Hyper-V - Relationship Between VM IP Address, Virtual Switch and Network Cards
 
03:27
Relationship Between VM IP Address, Virtual Switch and Network Cards for Windows 2016 Hyper-V
Views: 4605 CodeCowboyOrg
WordPress - How to Manually Install on IIS Windows Server
 
27:10
Step on how to Install WordPress Manually on a Windows Server for 2003, 2008, 2012, 2014 1) Software Needed a. IIS Web Platform installer http://www.microsoft.com/web/downloads/platform.aspx b. MySQL Database http://www.mysql.com/downloads/ c. WordPress Website Software / Binaries http://wordpress.org/download/ d. PHP plugin for IIS http://php.iis.net/ 2) Install the sofware Above 3) Create a Database and DB User in MySQL For WordPress 4) Configure the WordPress Config File 5) Setup and Install WordPress
Views: 57194 CodeCowboyOrg
MSSQL - Step by Step Change Tracking (CT) Tutorial and Demo
 
16:32
Download examples here - https://goo.gl/wuLUIw REFERENCES https://msdn.microsoft.com/en-us/library/cc305322(v=sql.110).aspx https://msdn.microsoft.com/en-us/library/bb934145.aspx https://msdn.microsoft.com/en-us/library/bb895238.aspx https://msdn.microsoft.com/en-us/sync/bb887608 http://www.brentozar.com/archive/2014/06/performance-tuning-sql-server-change-tracking/
Views: 9013 CodeCowboyOrg
Windows Server 2016 - Install SMTP and Configure, Test (How To Step by Step)
 
12:23
SMTP Test Client https://github.com/CodeCowboyOrg/SimpleSMTPClient/releases How to Install, Configure and Test SMTP Relay Server on Windows 2016
Views: 125837 CodeCowboyOrg
Tableau Desktop | Publishing Extract Data Source
 
05:32
A Tableau Desktop Demonstration Publishing an Extract Data Source to Tableau Server from Tableau Desktop
Views: 12243 CodeCowboyOrg
SFTP - Windows Automation Script Bi-Directional Synchronization using WinSCP
 
02:24
WinSCP Script - https://goo.gl/alsVKn WinSCP - Batch File - https://goo.gl/HTV6M3 WinSCP Download (download Portable) - https://winscp.net/eng/download.php WinSCP Scripting Resource - https://winscp.net/eng/docs/scripting Demo of using WinSCP to script the automation of synchronizing Remote SFTP directory with a Local Directory in a Bi-Directional upload and download
Views: 4898 CodeCowboyOrg
Windows 7 - How to Create an OEM Boot DVD Disk
 
03:11
Demonstrates how to create an OEM Windows 7 Boot DVD from a Retail version, so you can use your original OEM License and Serial Number that came with the Original Computer
Views: 6062 CodeCowboyOrg
MSSQL - Understanding and Deciphering a Deadlock Graph XML
 
16:21
Best Most Useful Links for Understand a Deadlock (XML) in SQL Server 1) Compatible Locks Table - http://technet.microsoft.com/en-us/library/ms186396(v=sql.105).aspx 2) Understanding Deadlocks - https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/ In your example waitresource="KEY: 6:72057594090487808 (d900ed5a6cc6) 1) Database - retrieve the database involved in the deadlock with SELECT * FROM sys.databases WHERE database_id IN (6) 2) Table or Index - retrieve the table or index involved in the deadlock SELECT b.name AS TableName, c.name AS IndexName, c.type_desc AS IndexType, * FROM sys.partitions a INNER JOIN sys.objects b ON a.object_id = b.object_id INNER JOIN sys.indexes c ON a.object_id = c.object_id AND a.index_id = c.index_id WHERE partition_id IN ('72057594090487808') 3) Exact Row - retrieve the exact row or page, in your specific case the wait resource was a KEY, so you search the "column" %%lockres%% (yes the column name is actually %%lockres%%). If your table is not too out of date or if it is not a DELETE operation, then you will find the exact row from that hash, after you have determined which table that "partition id" or "hobt_id" is from then alter and run the below code (disclaimer - the hashes and page locations may have changed by the time you are doing the debugging, though unlikely with the key hashes) SELECT sys.fn_PhysLocFormatter(%%physloc%%) AS PageResource, %%lockres%% AS LockResource, * FROM InsertTableNameFromStep2Here WHERE %%lockres%% IN ('(d900ed5a6cc6)') Keep in mind that usually 2 resources are conflicting which caused the deadlock. However, it doesn't necessarily have to be both of the statements provided in the deadlock graph which is doing both of the locking. It is also possible that a statement prior, but within the same transaction (but not identified in the deadlock graph) locked 1 of the 2 resources. But 1 of the 2 statements in the deadlock is definitely involved in locking 1 of the 2 resources causing the deadlock at the time the deadlock was logged.
Views: 8120 CodeCowboyOrg
SFTP - Windows Server 2016 install of Cygwin OpenSSH with User Restricted to Home Directory
 
25:19
Link to Cygwin Install Notes - https://goo.gl/mnbYB7 Updated to include better user Restriction Instructions locking user into their Home Directory in SFTP Updated video on how to install SFTP on a Windows Server using Cygwin OpenSSH for Windows Server 2003, 2008, 2008R2, 2012, 2014, 2016 STEP #0 = Install Cygwin and OpenSSH Files 1) Install files as instructed in this video 2) Note always run all terminals as Administrator when doing the instructions below STEP #1 = Create a Windows Users, Groups and User Directories 1) For Example, create windows users sftpuser01, sftpuser02, sftpuser03 2) For Example, create windows group sftp_group 3) Place users in the sftp_group 4) Under windows create the Folder C:\SFTP_ROOT 5) Create a folder for each user, in my case its a) C:\SFTP_ROOT\sftpuser01 b) C:\SFTP_ROOT\sftpuser02 c) C:\SFTP_ROOT\sftpuser03 STEP #2 = Open Cygwin Terminal Shell install SSH 1) In the Cygwin Terminal Shell type export CYGWIN='ntsec tty' chmod 0755 /var ssh-host-config Answers to the questions when prompted for from ssh-host-config =================================================================== a) should strictmodes be used? no b) Should privilege separation be used? yes c) New local account 'sshd'? yes d) do you want to install sshd as a service? yes e) Enter the value of CYGWIN daemon? sshd f) do you want to use a different name? no g) Create a new privileged user account 'cyg_server'? yes STEP #3 = Create password and Group file 1) Create the Password File and Group File, in the CygWin Termina type mkgroup [redirect output to] /etc/group #for local users mkpasswd -cl [redirect] /etc/passwd #for domain users #mkpasswd -d [redirect] /etc/passwd chmod +rw /etc/group chmod +rw /etc/passwd STEP #4 = Edit the FSTAB File system table 1) Some FSTAB Entries for Your Reference http://cygwin.com/cygwin-ug-net/using.html#mount-table 2) Use these entries C:/cygwin64 / ntfs override,binary,noacl 0 0 C:/SFTP_ROOT /home ntfs override,binary,noacl 0 0 C:/cygwin64/bin /usr/bin ntfs override,binary,noacl 0 0 C:/cygwin64/lib /usr/lib ntfs override,binary,noacl 0 0 C:/cygwin64/etc/terminfo /usr/share/terminfo ntfs override,binary,noacl 0 0 STEP #5 = Change the nsswitch.conf file 1) This allows only users in the passwd file to login, otherwise if you specify "db" it allows users in the Active Directory to log in also If you want User Login Access to be soley Controlled by PASSWD file not Active Directory edit the /etc/nsswitch.conf /etc/nsswitch.conf # Defaults: # passwd: files db # group: files db # db_enum: cache builtin # db_home: /home/%U # db_shell: /bin/bash passwd: files group: files STEP #6 = Now Start the Service 1) Start the Service net stop sshd net start sshd netstat -a 2) Make sure to change the Firewall to allow for port 22 STEP #7 = Restrict users to home dir 0) Allow edit to sshd_config in cygwin terminal chmod 777 /etc/sshd_config 1) Restrict users to home direct, edit the /etc/sshd_config add the lines below a) comment out #Subsystem sftp /usr/sbin/sftp-server b) paste below the subsystem and match group Subsystem sftp internal-sftp Match group sftp_group ChrootDirectory /home/%u X11Forwarding no AllowTcpForwarding no ForceCommand internal-sftp 2) Edit the /etc/passwd file for the user "cyg_server" give it the root id of 0 this is necessary for restricting the user to their own home directory cyg_server:*:0 3) Append these to /etc/fstab file, this will hid the /cygdrive and /dev folder after you have restricted the user to the /home directory /dev /null none bind none / cygdrive user 0 0 4) Go into Cygwin Terminal assign cyg_server /home this is required for the restricting of the user to the home directory chown cyg_server /home chmod 0755 /home 5) Start the Service net stop sshd net start sshd
Views: 44663 CodeCowboyOrg
Tableau Server | How to Connect to the System PostGreSQL Tableau Database
 
06:50
How to Connect to the System PostGreSQL Tableau Database Data Dictionary ================================ https://onlinehelp.tableau.com/current/server/en-us/data_dictionary.html Tableau Server Instructions ================================ https://onlinehelp.tableau.com/current/server/en-us/perf_collect_server_repo.htm
Views: 5726 CodeCowboyOrg
MSSQL - Understanding Isolation Level By Example (Snapshot)
 
05:04
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Snapshot --===================================== -- Windows/Session #1 --===================================== SELECT @@SPID IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] DEFAULT(GETDATE()) NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 2 DELETE FROM SampleTable WHERE ID = 4 WAITFOR DELAY '00:0:10' COMMIT TRAN --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT @@SPID BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable ROLLBACK SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is REPEATABLE READ -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN --===================================== -- Windows/Session #4 --===================================== ----------------------------------------------------- -- This window/session is SERIALIZABLE -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN --===================================== -- Windows/Session #5 --===================================== ----------------------------------------------------- -- This window/session is SNAPSHOT -- ----------------------------------------------------- SELECT @@SPID ALTER DATABASE SandBox SET ALLOW_SNAPSHOT_ISOLATION ON SET TRANSACTION ISOLATION LEVEL SNAPSHOT BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN
Views: 2967 CodeCowboyOrg
Tableau Server | SSL Self Signed Certificate Install
 
13:24
How to install a Self-Signed SSL Certificate for Tableau Server REM ========================================================================================= REM == NOTE: The First Time you Restart Tableau the First Page may take 5 minutes to appear REM == Wait the 5 minutes, there will be a BLANK web page as the page is initially loading after a RESTART REM ========================================================================================== REM SetUp the OpenSSL Config SET OPENSSL_CONF=c:\Program Files\Tableau\Tableau Server\10.1\apache\conf\openssl.cnf SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\apache\bin; SET PATH=%PATH%;C:\Program Files\Tableau\Tableau Server\10.1\bin; REM Generate a Private Key openssl.exe genrsa -out tabby.demo.key 4096 REM Generate a Cert Signing Request openssl.exe req -new -key tabby.demo.key -out tabby.demo.csr REM Generate Self Signed Cert openssl.exe x509 -in tabby.demo.csr -out tabby.demo.crt -req -signkey tabby.demo.key -days 365 REM Start/Stop Tableau REM tabadmin stop REM tabadmin start REM services.msc REM certmgr.msc
Views: 5951 CodeCowboyOrg

Here!
Blumenkranz braut online dating
Here!
Paraules emmetzinades llegir online dating
Shrek para sempre online dating