Home
Search results “Creating guid in oracle”
Working with Orchestrated Integrations in Oracle Integration Cloud Service
 
04:38
When should you use an Orchestration integration? How do you create an Orchestration integration? This video shows you how. Learn more about Orchestration: https://docs.oracle.com/cloud/latest/intcs_gs/ICSUG/GUID-F66ABE41-0A69-4A73-BC3D-0CE36FA78C4D.htm#ICSUG-GUID-36A90FF0-F0D4-4F81-9028-41971C7D100B ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle DV: How to build viz plugins using SDK
 
05:05
Oracle Data Visualization SDK Reference https://docs.oracle.com/middleware/bidv1221/desktop/BIDVD/GUID-6CCA6D3D-1877-4F7E-B337-73DC68D84797.htm Oracle Data Visualization SDK JavaScript Reference https://docs.oracle.com/middleware/bidv1221/desktop/DVDJS/index.html
Views: 1376 ORACLE ANALYTICS
NIH Global Unique Identifier (GUID)
 
03:36
Overview of the GUID tool and the GUID creation process, including elements required to generate a GUID.
Views: 1059 NCATS NIH
Oracle Enterprise Manager: Integration with 3rd Party Systems
 
18:26
Enterprise Manager has a number of management connectors to integrate with popular 3rd party management systems. The management connectors leverage EM’s connector framework in order to forward event and incident details to 3rd party systems. Besides the management connectors, Enterprise Manager also has a number of Advanced Notification Methods when the use case is more complicated or when there is no management connector available. Enterprise Manager is highly extensible and provides a Connector Framework API which leverages web service calls to create and update events or tickets in 3rd party systems. We provide a Connectors Integration Guide with instructions and examples to build your own connector. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/nav/connectors.htm http://docs.oracle.com/cd/E73210_01/EMADM/GUID-B48F6A84-EE89-498D-94E0-5DE1E7A0CFBC.htm#EMADM9066 http://docs.oracle.com/cd/E73210_01/EMCIG/GUID-FBA700A1-B2F0-4A7B-980C-E4816A21FAD4.htm#EMCIG169 Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
How to generate UUIDs as primary keys with Hibernate
 
05:59
Most developers prefer numerical primary keys because they are efficient to use and easy to generate. But that doesn’t mean that a primary key has to be a number. UUIDs, for example, have gained some popularity over the recent years If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Join the free Member Library: https://goo.gl/dtyIIC Read the accompanying post: https://www.thoughts-on-java.org/generate-uuids-primary-keys-hibernate/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 2714 Thoughts On Java
How to Use VirtualBox (Beginners Guide)
 
13:52
In a recent video in the “Free Software” series, I showed you VirtualBox, which is a free and open source solution to be able to run other operating systems virtually on your PC. In this beginner’s guide, I will show you how to set-up and use VirtualBox. In addition, I’ll also show you how to install and run Ubuntu, which is one of the most popular of the Linux distributions. If you're new, Subscribe! ▶ https://www.youtube.com/techgumbo Share This Video ▶ https://youtu.be/sB_5fqiysi4 0:30 What is VirtualBox. 1:16 Download. 1:46 Install. 2:29 Launch VirtualBox. 2:42 Download ISO for Ubuntu. 3:35 Create Guest OS. 6:41 Settings to complete the Guest OS process. 8:54 Install Ubuntu. 11:07 Tips for using Ubuntu. 13:15 Shut down Ubuntu. “Free Software” Playlist https://www.youtube.com/watch?v=gM8plsUfkTA&list=PLunpbmfrhFAWJA4lSDmRYJdcsEpjAuRdz VirtualBox https://www.virtualbox.org/wiki/Downloads Ubuntu https://www.ubuntu.com/desktop TechGumbo is a leading source for the technology that we use each day. Whether it’s discussing computer operating system tricks, the latest tips for your mobile phone, finding out about the newest gadgets, or beginners guides that show you how to use popular software, TechGumbo has boundless topics on technology for the astute YouTube viewer.
Views: 255748 TechGumbo
How Generate Custom ID in SQL
 
08:17
This tutorial will teach how to generate custom unique id's in Sql Server. Also please file links to download scripts below. https://github.com/vetrivelandyou/RecordedProject/blob/master/How-to-generate-custom-id-in-sql/SQLQuery.sql
Views: 3886 Vetrivel D
Oracle Enterprise Manager: Metric Extensions
 
19:49
ic extensions provide you with the ability to extend Oracle's monitoring capabilities to monitor conditions specific to your IT environment. This provides you with a comprehensive view of your environment. Furthermore, metric extensions allow you to simplify your IT organization's operational processes by leveraging Enterprise Manager as the single central monitoring tool for your entire datacenter instead of relying on other monitoring tools to provide this supplementary monitoring. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-4FCB90EC-5335-4F92-BFA7-CB1442000353.htm#EMADM10032 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Select and Where: Databases for Developers #4
 
05:03
You query a database table with a select statement. But unless you provide a where clause, this will return you all the rows! That's a lot for you to sift through if your table has millions, billions or trillions of rows. In this episode Chris discusses common conditions for filtering rows so the database only returns what you need. Further reading: Oracle Database 12.2 select syntax: http://docs.oracle.com/database/122/SQLRF/SELECT.htm#SQLRF01702 Oracle Database Concepts Guide on Select: http://docs.oracle.com/database/122/CNCPT/sql.htm#GUID-702909E1-B214-4D30-A0F9-5A4335C2BA4A Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/devgym/database-for-developers.html Daily SQL tips on Twitter: https://twitter.com/SQLDaily Chris on Twitter: https://twitter.com/ChrisRSaxon All Things SQL Blog: https://blogs.oracle.com/sql ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 5479 The Magic of SQL
Set Up and Log In to Your First Oracle Container Cloud Service Instance
 
02:52
Find out how to get from your Oracle Cloud welcome mail to a working instance of Oracle Container Cloud Service, where you can manage your Docker environment. For more information, see the documentation at http://www.oracle.com/pls/topic/lookup?ctx=cloud&id=CONTU-GUID-CA18910C-AFC9-432E-AB1D-ADE87EAB5E63 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
DataGrip Introduction
 
11:01
IMPORTANT! If you're looking for DataGrip Quick Start Guide, please, read: https://www.jetbrains.com/datagrip/quick-start/ DataGrip is an IDE from JetBrains built for database developers. It allows you to quickly migrate and refactor relational databases, construct efficient, statically checked SQL queries and much more. In this video, we highlight some of DataGrip's most powerful features. It is also relevant to the database plugin of IntelliJ IDEA, PhpStorm, PyCharm and RubyMine. For more details visit https://www.jetbrains.com/datagrip.
Views: 38336 JetBrainsTV
Hierarchical Queries: Databases for Developers #16
 
09:38
Often data contains a parent-child relationship between rows in the same table. For example, company org charts and family trees. You can use the power of SQL to traverse these hierarchical relationships. There are two ways to do this in Oracle Database: - Connect By - Recursive With Watch this video to learn about data trees and find out how these work! Further reading: Hierarchical queries in the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Hierarchical-Queries.html#GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E Recursive subquery factoring in 11.2: https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2 Take the course! https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1606 The Magic of SQL
Oracle Enterprise Manager: Always-On Monitoring
 
25:23
The Enterprise Manager Always-On Monitoring application provides the ability to monitor critical target status and metric alerts when the Oracle Management Service is unavailable. The service continuously monitors critical targets through the Enterprise Manager Agent and can be easily configured to send email notifications for these events to administrators. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-3152AD33-8118-4478-B888-A332CFAB3453.htm#EMADM15489 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
The Complete Linux Course: Beginner to Power User!
 
07:23:53
Get The Complete Linux Administration Course Bundle! https://josephdelgadillo.com/product/linux-course-bundle/ Preview the courses! A Beginner’s Guide to Linux System Administration! https://bit.ly/2LZ7cfN CentOS and Red Hat Linux to Certified System Administrator! https://bit.ly/2OJtZLp BASH Programming Course: Master the Linux Command Line! https://bit.ly/2ACzXuv The Complete Wireshark Course: Go from Beginner to Advanced! https://bit.ly/2MinlKr If you want to get started using Linux, you will LOVE this course! This 7+ hour Ubuntu Linux tutorial will take you from beginner to power user. We will cover installation, command line, administrative privileges, app development, server hosting, GitHub, and much more! Time-stamps 01:01 Introduction to Linux 08:44 Linux distributions explained 15:56 Installing VirtualBox and setting up our virtual machine 23:47 Ubuntu Linux installation on a virtual machine 36:26 Disabling the ISO and first boot up 38:40 VirtualBox guest additions for a better user experience 46:14 Customizing our Ubuntu desktop 54:41 Unity Tweak Tool for Ubuntu 1:06:48 Installing Ubuntu alongside Windows (dual boot) 1:23:09 Linux command line essentials 1:36:17 Administrative privileges in terminal 1:42:14 Using the package manager (apt-get) to install new applications 1:46:17 Searching through the repositories to find new apps 1:48:23 Installing packages that are not in the repository 1:53:09 Keeping programs updated in Linux 1:57:48 File permissions and ownership explained 2:10:26 How to create files using the command line interface (CLI) 2:15:24 Creating new directories and moving files 2:19:59 Copying, renaming, and removing files 2:24:43 The FIND command and it’s practical uses 2:36:10 GREP command explained 2:39:10 Using GREP in conjunction with FIND 2:42:26 Redirecting the output of a command 2:45:42 The TOP command and its uses 2:47:01 How to view the entire list of processes and closing applications 2:52:36 Services explained 2:54:44 Configuring services using the command line 2:59:20 Using CRONTABS to schedule tasks 3:04:56 Choosing an integrated development environment (IDE) 3:08:29 Eclipse installation and setup 3:12:26 PyCharm installation and setup 3:18:51 Introduction to GitHub, installation, and repository setup 3:23:06 How to push/pull information from a repository 3:29:13 How to remove/ignore directories in our repository 3:34:25 Resolving merge conflicts through terminal 3:41:42 How to setup and manage branches 3:49:37 Meteor installation & setup 3:55:32 Meteor project setup 4:01:06 Router setup with React components 4:13:31 Getting into the programming 4:26:46 Rendering our blog posts 4:42:06 Apache 2, PHP 5, and MySQL setup 4:45:36 Server configuration 4:51:14 Linux hosts file explained 4:54:40 Deploying our Meteor app to an Apache 2 server 5:00:03 MongoDB NoSQL database 5:05:21 Virtual host setup 5:16:46 phpMyAdmin setup 5:24:50 Creating a basic virtual host 5:33:00 Wordpress installation on top of our Apache 2 environment 5:40:25 Database setup 5:46:48 Python installation and CLI 5:57:35 Adding/removing users through GUI 6:01:09 Adding/removing users through CLI 6:06:55 Adding users to a group 6:10:51 Introduction to networking 6:17:41 Local area network (LAN) explained 6:25:08 Networking commands 6:35:40 NETSTAT command 6:40:39 Linux host file 6:49:59 TRACEROUTE commands 6:53:57 Network mapping explained 7:08:29 Using SSH to access the command line of a remote host 7:11:06 Using SFTP to transfer files between machines 7:14:43 Setting up SSH on our local machine 7:20:10 MAN command explained
Views: 958588 Joseph Delgadillo
Oracle Enterprise Manager: Advanced Threshold Management
 
16:34
Advanced Thresholds allow you to define and manage alert thresholds that are either adaptive (self-adjusting) or time-based (static). There are monitoring situations in which different workloads for a target occur at regular (expected) intervals. Under these conditions, a static alert threshold would prove to be inaccurate. For example, the accurate alert thresholds for a database performing Online Transaction Process (OLTP) during the day and batch processing at night would be different. Similarly, database workloads can change based purely on different time periods, such as weekday versus weekend. In both these situations, fixed, static values for thresholds might result in false alert reporting. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-02356AB5-4B03-46AE-8354-2E9517A8F439.htm#EMADM15123 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Virtual Box - How to set a new UUID to a Virtual Machine
 
02:47
How to set a new UUID on a VM in Oracle VM Virtual Box, this error can happen if circumstances surrounding the VDI file change such as name, location etc. This is done using the vboxmanage command line tool Steps: 1 - Right click "Command Prompt" and then click "Run as Administrator" 2 - Then use CD and DIR to browse to: C:\Program files\Oracle\Virtual Box 3 - Then type: vboxmanage internalcommands sethduuid "VDI filepath and filename" For example: vboxmanage internalcommands sethduuid "D:\vm\Windows7virtualmachine.vdi" Song name: DM Galaxy - Etiquette - Free Background Music Link to song: https://youtu.be/ZD_Urg9fOs0 Song created by: DM Galaxy: YouTube - http://goo.gl/5Tezt7 Facebook - https://www.facebook.com/DmGalaxy SoundCloud - https://soundcloud.com/dmgalaxy
Views: 3250 WitherTech
How To Integrate Oracle Weblogic Server With Oracle Enterprise Manager (OEM) Cloud Control
 
19:02
In this video demo I will show you how to integrate Oracle Weblogic Server with Oracle Enterprise Manager Cloud Control (OEM) Have a look at my blog for step by step instructions and screenshots I used in this video. Blog Link : http://prasaddomala.com/how-to-integrate-oracle-weblogic-server-with-oracle-enterprise-manager-cloud-control-oem Oracle Enterprise Manager Cloud Control (OEM) Installation & Configuration https://www.youtube.com/watch?v=EKd_Mr_c1XU http://prasaddomala.com/oracle-enterprise-manager-cloud-control-13c-installation-configuration/ Weblogic Server OEM Metric Reference Guide http://docs.oracle.com/cd/E73210_01/EMASM/GUID-3E63D9C6-65B4-4B46-8BEB-E855D009CF8D.htm#EMASM3202
Views: 3294 Prasad Domala
CS50 2018 - Lecture 8 - SQL
 
01:54:22
00:00:00 - Introduction 00:00:50 - Hackathon Teaser 00:02:23 - Week 7 Recap 00:05:35 - C$50 Finance 00:07:47 - Cookies 00:15:46 - store 00:22:22 - Databases 00:27:15 - Mock Database 00:29:07 - SQL 00:39:32 - SQLite 00:51:52 - phpLiteAdmin 01:12:54 - lecture 01:38:39 - Race Conditions 01:45:57 - SQL Injection Attacks
Views: 4866 CS50
custom partitioning during RHEL7 installation
 
07:26
This video teaches how to specify a custom disk layout which installing RHEL 7. This video is provided as an update to my RHCSA complete video course.
Views: 10034 sander van Vugt
How To Create A Customer in Oracle ERP Cloud Accounts Receivable
 
03:07
How To Create A Customer in Oracle ERP Cloud Accounts Receivable
Views: 4272 Inoapps Limited
Monitoring  Oracle Java Cloud Service -  SaaS Extension
 
04:54
(This video is describes how to use JCS-SaaS Extension Control, the Java console for JCS-SaaS Extension, to monitor activity running on that application. For additional information, see "Using Oracle Java Cloud Service - SaaS Extension Control" at https://docs.oracle.com/cloud/latest/javacs_gs/CSJSU/GUID-DB8FC210-671F-470C-94A9-C472814C8E66.htm#CSJSU7074 NOTE: To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Titan Quest Anniversary The Oracle of Zeus build guide
 
17:11
Follow me on Twitter https://twitter.com/TheLineOfHeroes This is a build guide about a build i am creating. It is a build in progress but the main set up of the skills and most of the equipment is done. If you have any questions, please write a comment and i will reply as soon as possible. Thanks for watching, share like and subscribe if you like what you see. More builds will come in the future. The next build guide will be about a build i call "Alexander the Great" build!
CTE in sql server   Part 49
 
12:57
In this video we will learn about creating and referencing CTE's in SQL server. We will also learn how to create multiple CTE's using a single WITH clause. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/common-table-expressions-part-49.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-49-cte.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 172072 kudvenkat
How To Use VirtualBox - Complete Step by Step Tutorial
 
17:29
www.techzaada.com A step by step video of Virtualbox. this video is about how to use Virtual box with complete step by step guide. virtualbox is a software in wich you can install multiple windows operating systems. such as windows 7, windows 8, windows vista, windows xp, linux, even you can install MAC OS, inside your computer or virtualbox, download the virtualbox from the link below. . https://www.virtualbox.org/wiki/Downloads VISIT MY WEBSITE FOR MORE LATEST TIPS AND TRICKS. WWW.TECHZAADA.COM SUGGESTED VIDEOS..... 1. 5 Ways to Repair a Corrupted SD Card/USB Flash or External Hard Disk. https://www.youtube.com/watch?v=oBkC8EhbZ7U&t=160s 2. How to Transfer Files From USB Flash to iPhone/iPad/iPod (No Computer Needed) https://www.youtube.com/watch?v=o-T3V9WgoSg&t=114s - 3. How to Remove Pattern or Password from Android Phone without Factory Reset/Without Loosing data. https://www.youtube.com/watch?v=mbMBqBLPGLQ&t=1s - 4. How to Hide your WiFi Signal from others. https://www.youtube.com/watch?v=Z4jG1Dw-9iU&t=12s - 5. How to Backup or Recover Data from a Broken Android Phone/Tablet https://www.youtube.com/watch?v=noCGBSryzIc&t=25s - 6. How to install Mac OS on any Windows Computer https://www.youtube.com/watch?v=Dd7z-lQ1FB0&t=52s - 7. How to Recover deleted files from Android. https://www.youtube.com/watch?v=EvesbfSC6hU - 8. How to Backup data from a Broken iPhone or iPad. https://www.youtube.com/watch?v=gmfCDvt-vrI&t=163s - 7. How to get PAID Udemy courses for free. https://www.youtube.com/watch?v=HX2gtSQPU8U&t=3s . -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow me on Twitter https://twitter.com/TechZaada Follow me on Facebook https://www.facebook.com/techzaada Follow me on Google Plus https://plus.google.com/u/0/communities/102161270264068173502 -~-~~-~~~-~~-~- Please watch: "How to Unlock Android Pattern or Pin Lock without losing data | Without USB Debugging" https://www.youtube.com/watch?v=mbMBqBLPGLQ -~-~~-~~~-~~-~-
Views: 739160 Tech Zaada
ASP.NET Tutorial 6- Create a Login website - Login page & Validating User and Password in database
 
22:58
asp.net login validation with database c# - Validating username and password in a database in asp.net Validating User Input in ASP.NET Web Pages Sites Asp.Net Examples: Simple login form example in asp.net How to create Login page/form and check username,password in database Simple login form example in asp.net Check Username How to implement form validation using ASP.Net 2.0 How to Validate User Login in asp.net using DataSet ASP.NET Form to Database with Form Validation ASP.NET Database Login ASP.NET FormDecorator Demo - Validation and Login Controls
Views: 446381 ProgrammingKnowledge
GPT - GUID Partition Table
 
08:11
This video covers GPT (GUID partition table) partitioning scheme: what is GPT, how it is organized. GPT main components - header and entries – are discussed with the respect to the partition recovery. Additionally, the location of GPT header and table of entries are considered along with overall GPT on-disk layout.
asp net oracle
 
14:41
Views: 119 Nguyennhat Son
ASP.NET Tutorial 3- How to Create a Login website - Creating Database For website
 
13:42
Setting up the Database ASP.NET Site Building ASP.NET Web Applications with ASP.NET Web Pages Databases ASP.NET Web Forms Tutorial After creating Website using ASP.NET (c#), sqlserver(Database SQL server DAtabase Creating a Database ASP.NET Web Pages Tutorial Create a Database Application in 15 Minutes with ASP.NET Create a website with ASP.Net Create an ASP.NET website ASP.NET Web Pages Databases ASP.NET Web Forms Database
Views: 465210 ProgrammingKnowledge
SharePoint 2013 Tutorial - Rename SharePoint_AdminContent Database
 
06:21
Visit SharePoint Training Online at http://www.sharepointtrainingonline.com View this videos webpage for more information at http://www.sharepointtrainingonline.com/rename-sharepoint_admincontent-database/ Series of Renaming SharePoint 2013 Databases This is the first of a series where we are renaming the SharePoint 2013 Databases. Here, we start with renaming SharePoint_AdminContent_[GUID] database. These steps can be used with SharePoint 2010 as well. Create a new Central Administration Content Database: New-SPContentDatabase -Name SharePoint_AdminContent -WebApplication http://[central admin url:port] Get a list of Central Administration Content Databases: Get-SPWebApplication -Identity http://[central admin url:port] | Get-SPContentDatabase | Select Id, Name, WebApplication | Format-List Copy database content: Get-SPSite -ContentDatabase [old database Id GUID] | Move-SPSite -DestinationDatabase [new database Id GUID] Execute command IISRESET. Delete the old database: Remove-SPContentDatabase [old database Id GUID] Confirm the old database has been removed from SharePoint: Get-SPWebApplication -Identity http://[central admin url:port] | Get-SPContentDatabase | Select Id, Name, WebApplication | Format-List References: Good blog walk-through: http://www.mssqltips.com/sqlservertip/2706/renaming-the-sharepoint-admin-content-database-to-follow-sql-server-naming-conventions/ New-SPContentDatabase: http://technet.microsoft.com/en-us/library/ff607572.aspx Get-SPWebApplication: http://technet.microsoft.com/en-us/library/ff607562.aspx Get-SPContentDatabase: http://technet.microsoft.com/en-us/library/ff607828.aspx Get-SPSite: http://technet.microsoft.com/en-us/library/ff607950.aspx Move-SPSite: http://technet.microsoft.com/en-us/library/ff607915.aspx Remove-SPContentDatabase: http://technet.microsoft.com/en-us/library/ff607920.aspx
Views: 6375 Jeff Willener
Centos 7 With Software RAID 1 and LVM For ROOT And Swap
 
18:44
This tutorial guides the user through Centos 7 installation. Tells user how to change screen resolution of the installer. Creation of RAID 1 software array and installing /boot partition on the same. Creation of LVM root and swap partitions over RAID 1 software array right from the installer of Centos 7. Post OS boot information shows how it looks like. Presented to you by Hypertech Solutions.
Views: 45841 shamoorthytube
Sequence object in SQL Server 2012
 
12:22
create sequence in sql server In this video we will discuss sequence object in SQL Server. Sequence object Introduced in SQL Server 2012 Generates sequence of numeric values in an ascending or descending order Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012_26.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Creating the Incrementing Sequence : The following code create a Sequence object that starts with 1 and increments by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 Generating the Next Sequence Value : Now we have a sequence object created. To generate the sequence value use NEXT VALUE FOR clause SELECT NEXT VALUE FOR [dbo].[SequenceObject] Output : 1 Every time you execute the above query the sequence value will be incremented by 1. I executed the above query 5 times, so the current sequence value is 5. Retrieving the current sequence value : If you want to see what the current Sequence value before generating the next, use sys.sequences SELECT * FROM sys.sequences WHERE name = 'SequenceObject' Alter the Sequence object to reset the sequence value : ALTER SEQUENCE [SequenceObject] RESTART WITH 1 Select the next sequence value to make sure the value starts from 1 SELECT NEXT VALUE FOR [dbo].[SequenceObject] Using sequence value in an INSERT query : CREATE TABLE Employees ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) -- Generate and insert Sequence values INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') -- Select the data from the table SELECT * FROM Employees Creating the decrementing Sequence : The following code create a Sequence object that starts with 100 and decrements by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 100 INCREMENT BY -1 Specifying MIN and MAX values for the sequence : Use the MINVALUE and MAXVALUE arguments to specify the MIN and MAX values respectively. Step 1 : Create the Sequence object CREATE SEQUENCE [dbo].[SequenceObject] START WITH 100 INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 Step 2 : Retrieve the next sequence value. The sequence value starts at 100. Every time we call NEXT VALUE, the value will be incremented by 10. SELECT NEXT VALUE FOR [dbo].[SequenceObject] If you call NEXT VALUE, when the value reaches 150 (MAXVALUE), you will get the following error The sequence object 'SequenceObject' has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated. Recycling Sequence values : When the sequence object has reached it's maximum value, and if you want to restart from the minimum value, set CYCLE option ALTER SEQUENCE [dbo].[SequenceObject] INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 CYCLE At this point, whe the sequence object has reached it's maximum value, and if you ask for the NEXT VALUE, sequence object starts from the minimum value again which in this case is 100. To improve performance, the Sequence object values can be cached using the CACHE option. When the values are cached they are read from the memory instead of from the disk, which improves the performance. When the cache option is specified you can also specify the size of th cache , that is the number of values to cache. The following example, creates the sequence object with 10 values cached. When the 11th value is requested, the next 10 values will be cached again. CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 CACHE 10 Using SQL Server Graphical User Interface (GUI) to create the sequence object : 1. Expand the database folder 2. Expand Programmability folder 3. Right click on Sequences folder 4. Select New Sequence Next video : Difference between SEQUENCE and IDENTITY in SQL Server
Views: 33176 kudvenkat
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 27825 kudvenkat
Difference between sequence and identity in SQL Server
 
05:29
sql server identity vs sequence In this video we will discuss the difference between SEQUENCE and IDENTITY in SQL Server This is continuation to Part 134. Please watch Part 134 from SQL Server tutorial before proceeding. Sequence object is similar to the Identity property, in the sense that it generates sequence of numeric values in an ascending order just like the identity property. However there are several differences between the 2 which we will discuss in this video. Identity property is a table column property meaning it is tied to the table, where as the sequence is a user-defined database object and is not tied to any specific table meaning it's value can be shared by multiple tables. Example : Identity property tied to the Id column of the Employees table. CREATE TABLE Employees ( Id INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(50), Gender NVARCHAR(10) ) Example : Sequence object not tied to any specific table CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 This means the above sequence object can be used with any table. Example : Sharing sequence object value with multiple tables. Step 1 : Create Customers and Users tables CREATE TABLE Customers ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO CREATE TABLE Users ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO Step 2 : Insert 2 rows into Customers table and 3 rows into Users table. Notice the same sequence object is generating the ID values for both the tables. INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Tom', 'Male') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Pam', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'David', 'Male') GO Step 3 : Query the tables SELECT * FROM Customers SELECT * FROM Users GO Output : Notice the same sequence object has generated the values for ID columns in both the tables To generate the next identity value, a row has to be inserted into the table, where as with sequence object there is no need to insert a row into the table to generate the next sequence value. You can use NEXT VALUE FOR clause to generate the next sequence value. Example : Generating Identity value by inserting a row into the table INSERT INTO Employees VALUES ('Todd', 'Male') Example : Generating the next sequence value using NEXT VALUE FOR clause. SELECT NEXT VALUE FOR [dbo].[SequenceObject] Maximum value for the identity property cannot be specified. The maximum value will be the maximum value of the correspoding column data type. With the sequence object you can use the MAXVALUE option to specify the maximum value. If the MAXVALUE option is not specified for the sequence object, then the maximum value will be the maximum value of it's data type. Example : Specifying maximum value for the sequence object using the MAXVALUE option CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MAXVALUE 5 CYCLE option of the Sequence object can be used to specify whether the sequence should restart automatically when the max value (for incrementing sequence object) or min value (for decrementing sequence object) is reached, where as with the Identity property we don't have any such option to automatically restart the identity values. Example : Specifying the CYCLE option of the Sequence object, so the sequence will restart automatically when the max value is exceeded CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 5 CYCLE Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 32824 kudvenkat
Prevent sql injection with dynamic sql
 
10:28
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/prevent-sql-injection-with-dynamic-sql.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/prevent-sql-injection-with-dynamic-sql_5.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, how to prevent SQL injection when using dynamic SQL. In Part 140, we have implemented "Search Page" using dynamic SQL. Since we have used parameters to build our dynamic SQL statements, it is not prone to SQL Injection attack. This is an example of good dynamic SQL implementation. I have seen lot of software developers, not just the beginners but even experienced developers, buidling their dynamic sql queries by concatenating strings instead of using parameters without realizing that they are opening the doors for SQL Injection. Please check my blog at the following link for code used in the demo. http://csharp-video-tutorials.blogspot.com/2017/04/prevent-sql-injection-with-dynamic-sql.html Since we are concatenating the user input values to build the dynamic sql statement, the end user can very easily inject sql. Imagine, what happens for example, if the user enters the following in the "Firstname" textbox. ' Drop database SalesDB -- With the above SQL injected into the "Firstname" textbox, if you click the "Search" button, the following is the query which is sent to SQL server. This will drop the SalesDB. Select * from Employees where 1 = 1 AND FirstName = '' Drop database SalesDB --' On the other hand, if you use parameters to build your dynamic SQL statements, SQL Injection is not an issue. The following input in the "Firstname" textbox, would not drop the SalesDB database. ' Drop database SalesDB -- The text the user has provided in the "Firstname" textbox is treated as the value for @Firstname parameter. The following is the query that is generated and executed. exec sp_executesql N'Select * from Employees where 1 = 1 AND [email protected]',N'@FirstName nvarchar(26)',@FirstName=N''' Drop database SalesDB --' We don't have this problem of sql injection if we are using stored procedures. "SearchPageWithoutDynamicSQL.aspx" is using the stored procedure "spSearchEmployees" instead of dynamic SQL. The same input in the "Firstname" texbox on this page, would generate the following. Notice, whatever text we typed in the "Firstname" textbox is treated as the value for @FirstName parameter. exec spSearchEmployees @FirstName=N''' Drop database SalesDB --' An important point to keep in mind here is that if you have dynamic SQL in your stored procedure, and you are concatenating strings in that stored procedure to build your dynamic sql statements instead of using parameters, it is still prone to SQL injection. If this is not clear at the moment don't worry, we will discuss an example of this in out next video. So in summary, while dynamic sql provides great flexibility when implementing complicated logic with lot of permutations and combinations, if not properly implemented it may open doors for sql injection. Always use parameters to build dynamic sql statements, instead of concatenating user input values. Another benefit of using parameters to build dynamic sql statements is that it allows cached query plans to be reused, which greatly increases the performance. We will discuss an example of this in our upcoming videos.
Views: 17364 kudvenkat
Installing W10 on a GPT partition
 
04:09
Creating a bootable system using UEFI. How to install Windows 10 onto a large disk (over 2 TB) using a GPT (GUID Partition Table). You need a GPT partition to create a partition larger than 2T.
Views: 151 Frank Vella
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 98781 kudvenkat
How Many Uuids Are There?
 
00:45
Postgresql documentation 9. How to generate uuids as primary keys with hibernate. Googleusercontent search. Uuid tossed about (universally unique identifier), there are so many guids that you can use them to number everything and not run online guid generatorjava practices generating ids. Proper rfc 4122 uuids as guids in wordpress bjrn johansen. Or if every human on earth generated 600,000,000 guids there would only be a 50. When identifiers are used solely within a database, their generation should be left starting with java 5, the uuid class provides simple means for generating uuids have many applications. 20 jul 2009 in other words, only after generating 1 billion uuids every second for the next 100 years, the probability of creating just one duplicate would be about 50. Uuids and linux everything you ever need to know [update uuid (java platform se 7 ) oracle help center. Rfc 4122 a universally unique identifier (uuid) urn namespaceuniversally identifiers (uuids) itu. Another is the data type uuid stores universally unique identifiers (uuid) as defined by rfc 4122, iso iec 9834 8 2005, and related standards. Object identifier components' 13 mar 2013 and about the question, how many uuids there are big chance is that you will generate a number already own, here version field holds value describes type of this uuid. Since the time and clock sequence total 74 bits, 2 (1. Uuid uuid4() collisions issue #80 ramsey uuid githubapple developer documentation. Some systems refer to 5 oct 2016 each component can generate a uuid and there will not be any conflicts. Uuids generally do not meet security requirements. Uuid? Stack overflow. Random uuid collisions software engineering stack exchange. An attractive feature of uuids when compared to alternatives is their relative small size, 128 bits, or 16 bytes. X10 22 or 18 sextillion) version 1 uuids can be generated per node id, at a maximum average rate of 163 billion second id i. As always, you don't have to do much get the default behaviour 27 aug 2015 at this moment i think there is an issue in ramsey uuid, but still maybe that explains why he was seeing so collisions with uuids created by nsuuid conform rfc 4122 version 4 and are because a uuid expressed simply as array of bytes, no 10 jun 2017 adoption guids widespread, many computing platforms providing support for generating them, parsing their 26 nov problem highlighted here not uuids, instead use from title, would thought something about Guid how unique uuid? Stack overflowhas ever been collision? Quora. Uuid? Stack overflow guid how unique is uuid? overflow stackoverflow questions 1155008 uuid url? Q webcache. Of osi registration authorities generation and of universally unique identifiers (uuids) their use as asn. Two different records had the same uuid yes, see this account of frequent uuid4 collisions we are generating about 1m a day, and getting pretty much allows anything from xkcd random generator very fact that there multiple approach
Views: 32 Lanora Hurn Tipz
Oracle Eloqua Developer - Creating an App Provider
 
02:20
What is an App Provider in Oracle Eloqua? Watch this video to find out why you want one, and how to create one. For more information, see https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAB/index.html#CSHID=AppCloud.
Omnichannel Services - Use UUID Keys to Your Data
 
03:46
Today I'm going to talk to you about why it's important to use universally unique identifiers (UUID) as keys to your data, and I will show you some of the problems that they can solve. In the distributed computing world of mobile devices and an internet of things it becomes almost impossible to have one source for key generation, so each device need to be able to create their own keys, while still making sure that those keys are unique. The answer is to use UUIDs, which is a standard by the Open Software Foundation, and there's an industry wide support for them (http://en.wikipedia.org/wiki/Universally_unique_identifier). For example, PHP, Java, .NET, Oracle, and MySQL all have ways to generate them, and SQL Server and ProgresSQL even has native UUID data types. Let talk about the benefits of using UUIDs, and I will start by pointing out some of the problems they can solve. When doing our data models, we have been taught to normalize our databases so that we find primary keys as one of the columns or a combination of columns. If not found, we usually add a generated id, such as an automatically incremented integer. One problem with using a multi-column key is that the queries become more complex as each column needs to be included in each join, and more complex means a lower performance and also larger indices. Another problem is that it's harder for the consumer of the data to know which columns are included in the key. With auto-generated keys, we get a simpler join, but a problem is that each consumer need to ask the generator for a valid key, and another problem is that there will be "holes" in the sequence when rows are deleted. Yet another problem is that any data type used has a fixed limit (even if huge), so it will eventually run out. Also, it becomes tricky for a client to find out which id was generated during an insert. With UUIDs, we get the same benefit of the simpler join as we got with the auto-generated keys, but now each user of the data can generate new keys and rows, without access to any central key generator -- it can even happen while disconnected. So any device or thing can generate a key and the maximum 3.4 x 10^38 combinations both ensure that each key is unique and that there's no practical limit of keys. But even UUIDs have drawbacks, and the most obvious is that they are hard to remember. Therefore, it's a good practice to provide ways of accessing data using attributes that are easier to remember. For example, provide a service that can get an order by providing an order number in addition to getting it using the primary key, the UUID. So make sure that you use UUIDs as keys to your data to allow distributed key generation, simplified joins, and get better performance. Follow me on Twitter https://twitter.com/chrisforsberg Visit my site http://cforsberg.com
Views: 4903 Chris Forsberg
Solution - Unable to Create Machine ID Error
 
02:33
Fix "Unable to Create Machine ID, error retrieving information." error in minutes. If any problem, mention in comments. This error usually arrives when you are trying to Generate Machine ID after installing Intergraph Smart Plant License Manager (SPLM). Give Thumbs Up. Subscribe for more Updates. Follow us on:- Facebook :- https://goo.gl/jBZXqP Twitter :- https://twitter.com/TvTwinkle Google+ :- https://plus.google.com/+TwinkleTVi YouTube :- http://www.youtube.com/c/TwinkleTVi
Views: 10489 TwinkleTV
[C# Programming Tutorial] C# Tutorial 53:  Generate Globally Unique Identifiers (GUIDs) in C#
 
10:07
[C# Programming Tutorial] C# Tutorial 53: Generate Globally Unique Identifiers (GUIDs) in C#. Is GUID (globally unique identifier) really unique C# how to declare globally unique identifier (GUID) - Visual C# Generating GUIDs C# What is GUID Creating a Globally Unique ID. C#. SUBSCRIBE for more videos!
Views: 79 Diep Nguyen Dang
Dynamic SQL in SQL Server
 
12:12
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What is Dynamic SQL 2. Simple example of using Dynamic SQL What is Dynamic SQL Dynamic SQL is a SQL built from strings at runtime. Simple example of using Dynamic SQL Here is the SQL Script to create Employees table and populate it with data Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) Go Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) Go One way to achieve this is by implementing a stored procedure as shown below that this page would call. Create Procedure spSearchEmployees @FirstName nvarchar(100), @LastName nvarchar(100), @Gender nvarchar(50), @Salary int As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go The stored procedure in this case is not very complicated as we have only 4 search filters. What if there are 20 or more such filters. This stored procedure can get complex. To make things worse what if we want to specify conditions like AND, OR etc between these search filters. The stored procedure can get extremely large, complicated and difficult to maintain. One way to reduce the complexity is by using dynamic SQL as show below. Depending on for which search filters the user has provided the values on the "Search Page", we build the WHERE clause dynamically at runtime, which can reduce complexity. However, you might hear arguments that dynamic sql is bad both in-terms of security and performance. This is true if the dynamic sql is not properly implemented. From a security standpoint, it may open doors for SQL injection attack and from a performance standpoint, the cached query plans may not be reused. If properly implemented, we will not have these problems with dynamic sql. In our upcoming videos, we will discuss good and bad dynamic sql implementations. For now let's implement a simple example that makes use of dynamic sql. In the example below we are assuming the user has supplied values only for FirstName and LastName search fields. To execute the dynamicl sql we are using system stored procedure sp_executesql. sp_executesql takes two pre-defined parameters and any number of user-defined parameters. @statement - The is the first parameter which is mandatory, and contains the SQL statements to execute @params - This is the second parameter and is optional. This is used to declare parameters specified in @statement The rest of the parameters are the parameters that you declared in @params, and you pass them as you pass parameters to a stored procedure Declare @sql nvarchar(1000) Declare @params nvarchar(1000) Set @sql = 'Select * from Employees where [email protected] and [email protected]' Set @params = '@FirstName nvarchar(100), @LastName nvarchar(100)' Execute sp_executesql @sql, @params, @FirstName='Ben',@LastName='Hoskins' This is just the introduction to dynamic SQL. If a few things are unclear at the moment, don't worry. In our upcoming videos we will discuss the following 1. Implementing a real world "Search Web Page" with and without dynamic SQL 2. Performance and Security implications of dynamic sql. Along the way we will also discuss good and bad dynamic sql implementations. 3. Different options available for executing dynamic sql and their implications 4. Using dynamic sql in stored procedures and it's implications Once we discuss all the above, you will understand 1. The flexibility dynamic sql provides 2. Advantages and disadvantages of dynamic sql 3. When and when not to use dynamic sql
Views: 35485 kudvenkat
How To Install CentOS 6 Software RAID & LVM
 
05:46
How to install CentOS 6 with software RAID & LVM configured, the guid is for RAID1 but this guide can easily be followed for RAID 0 as well.
Views: 40473 linuxmoz
Sql server query plan cache
 
14:20
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/sql-server-query-plan-cache.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/sql-server-query-plan-cache_12.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What happens when a query is issued to SQL Server 2. How to check what is in SQL Server plan cache 3. Things to consider to promote query plan reusability What happens when a query is issued to SQL Server In SQl Server, every query requires a query plan before it is executed. When you run a query the first time, the query gets compiled and a query plan is generated. This query plan is then saved in sql server query plan cache. Next time when we run the same query, the cached query plan is reused. This means sql server does not have to create the plan again for that same query. So reusing a query plan can increase the performance. How long the query plan stays in the plan cache depends on how often the plan is reused besides other factors. The more often the plan is reused the longer it stays in the plan cache. How to check what is in SQL Server plan cache SELECT cp.usecounts, cp.cacheobjtype, cp.objtype, st.text, qp.query_plan FROM sys.dm_exec_cached_plans AS cp CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st CROSS APPLY sys.dm_exec_query_plan(plan_handle) AS qp ORDER BY cp.usecounts DESC As you can see we have sorted the result set by usecounts column in descending order, so we can see the most frequently reused query plans on the top. usecounts - Number of times the plan is reused objtype - Specifies the type of object text - Text of the SQL query query_plan - Query execution plan in XML format To remove all elements from the plan cache use the following command DBCC FREEPROCCACHE In older versions of SQL Server up to SQL Server 6.5 only stored procedure plans are cached. The query plans for Adhoc sql statements or dynamic sql statements are not cached, so they get compiled every time. With SQL Server 7, and later versions the query plans for Adhoc sql statements and dynamic sql statements are also cached. Things to consider to promote query plan reusability For example, when we execute the following query the first time. The query is compiled, a plan is created and put in the cache. Select * From Employees Where FirstName = 'Mark' When we execute the same query again, it looks up the plan cache, and if a plan is available, it reuses the existing plan instead of creating the plan again which can improve the performance of the query. However, one important thing to keep in mind is that, the cache lookup is by a hash value computed from the query text. If the query text changes even slightly, sql server will not be able to reuse the existing plan. For example, even if you include an extra space somewhere in the query or you change the case, the query text hash will not match, and sql server will not be able find the plan in cache and ends up compiling the query again and creating a new plan. Another example : If you want the same query to find an employee whose FirstName is Steve instead of Mark. You would issue the following query Select * From Employees Where FirstName = 'Steve' Even in this case, since the query text has changed the hash will not match, and sql server will not be able find the plan in cache and ends up compiling the query again and creating a new plan. This is why, it is very important to use parameterised queries for sql server to be able to reuse cached query plans. With parameterised queries, sql server will not treat parameter values as part of the query text. So when you change the parameters values, sql server can still reuse the cached query plan. The following query uses parameters. So even if you change parameter values, the same query plan is reused. Declare @FirstName nvarchar(50) Set @FirstName = 'Steve' Execute sp_executesql N'Select * from Employees where [email protected]', N'@FN nvarchar(50)', @FirstName One important thing to keep in mind is that, when you have dynamic sql in a stored procedure, the query plan for the stored procedure does not include the dynamic SQL. The block of dynamic SQL has a query plan of its own. Summary: Never ever concatenate user input values with strings to build dynamic sql statements. Always use parameterised queries which not only promotes cached query plans reuse but also prevent sql injection attacks.
Views: 21724 kudvenkat
Creating and Formatting Partitions with FDISK and mkfs - BASH - Linux
 
08:21
http://filmsbykris.com/wordpress/?p=318 Got Questions? visit http://FilmsByKris.com/forum Chat with us and learn more http://FilmsByKris.com/irc
Views: 99557 Kris Occhipinti
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 1378547 Manish Sharma
How to create a LUKS Encrypted Volume in Red Hat Enterprise Linux 6
 
12:44
Learn how to create a LUKS Encrypted Volume in RHEL 6. Do you wish to learn more? Buy one of my video courses on pearsonitcertification. 60% OFF WITH PROMO CODE: SANDER60 using the links below: RED HAT - RHCSA in Red Hat OpenStack LiveSessons http://www.rhatcert.com/RHCSA-in-Red-Hat-OpenStack - OpenStack Certification Complete Video Course http://www.rhatcert.com/openstack-certification - RHCSA Complete Video Course http://www.rhatcert.com/RHCSA-Complete-Video-Course- - RHCSA Exam Prep Video Workshop (download) http://www.rhatcert.com/RHCSA-Exam-Prep-Video-Workshop-download - RHCSA Exam Prep Video Workshop (streaming) http://www.rhatcert.com/RHCSA-Exam-Prep-Video-Workshop-stream - RHCE Complete Video Course http://www.rhatcert.com/RHCE-Complete-Video-Course- - RHCE Exam Prep Video Workshop (download) http://www.rhatcert.com/RHCE-Exam-Prep-Video-Workshop-dwnld - RHCE Exam Prep Video Workshop (streaming) http://www.rhatcert.com/RHCE-Exam-Prep-Video-Workshop-stream - RHCSA and RHCE Complete Video Course Library http://www.rhatcert.com/RHCSA-and-RHCE-Complete-Video-Course-Library - RHCSA/RHCE 7 Cert Guide (book) http://www.rhatcert.com/RHCSA-RHCE-7-Cert-Guide - RHCSA/RHCE 7 Cert Guide (ebook) http://www.rhatcert.com/Red-Hat-RHCSA-RHCE-7-Cert-Guide-ebook - RHCSA/RHCE 7 Cert Guide PREMIUM http://www.rhatcert.com/Red-Hat-RHCSA-RHCE-7-Cert-Guide-Premium-Edition - RHEL 7 New Features LiveLessons http://www.rhatcert.com/RHEL-7-New-Features- - Linux High Availability Clustering Complete Video Course https://www.rhatcert.com/linux-high-availability LINUX FOUNDATION - Linux Foundation System Administrator (LFCS) - http://www.rhatcert.com/LFCS - Linux Foundation Engineer (LFCE) - http://www.rhatcert.com/LFCE MICROSOFT LINUX - Linux on Azure https://www.rhatcert.com/linux-azure GENERIC LINUX - Ansible Fundamentals - https://www.rhatcert.com/ansible-fundamentals - Linux Under the Hood - http://www.rhatcert.com/linux-under-the-hood - Bash Scripting Fundamentals http://www.rhatcert.com/Bash-Scripting-Fundamentals - Advanced Bash Scripting http://www.rhatcert.com/Advanced-Bash-Scripting - Ubuntu Server Essentials LiveLessons http://www.rhatcert.com/Ubuntu-Server-Essentials - Novell Cluster Services for Linux and NetWare http://www.rhatcert.com/Novell-Cluster-Services-for-Linux-and-NetWare VMWARE - vSphere 6 Foundations (Exam #2V0-620) Complete Video Course http://www.rhatcert.com/vSphere-6-Foundations-Exam-2V0-620 LINUX LEARNING PATHS Need help to find the right video course? Check http://www.sandervanvugt.com/linux-video-courses Or see these learning paths: RHCSA Learning path https://www.sandervanvugt.com/learning-rhcsa RHCE Learning path https://www.sandervanvugt.com/learning-rhce RHCA Learning path https://www.sandervanvugt.com/learning-rhca Linux+ LPIC-1 Learning path https://www.sandervanvugt.com/learning-linux-lpic-1 LFCE Learning path https://www.sandervanvugt.com/learning-lfce LFCS Learning path https://www.sandervanvugt.com/learning-lfcs Questions? Contact me via http://www.sandervanvugt.com/contact Stay informed about new (free) courses and promotions by subscribing to my updates via http://www.sandervanvugt.com https://www.youtube.com/watch?v=Kv7GrKCqHUo
Change SID on Windows 7
 
03:30
Change SID on Windows 7 join domain.
Views: 10067 Happy Ghost

Mac cosmetics cover letter
Writing community service
Sample cover letter for student radiologic technologist
Frimley park run newsletter formats
Zheng yuan thesis examples