Home
Search results “Sql user options”
SQL Server 2012 tutorial: Permissions applied to securables | lynda.com
 
05:51
SQL Server permits the assignment of permissions to securables, for the purpose of controlling user actions. This tutorial takes a look at the different permissions that can be applied to securables, both at the server and the database level. Watch more at http://www.lynda.com/SQL-Server-tutorials/Securing-SQL-Server-2012/137884-2.html?utm_campaign=sH6eFJ6SyEg&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Securing SQL Server 2012 course presented by lynda.com author Gerry O'Brien. The complete course is 1 hour and 36 minutes and shows how to make sure your network's SQL Servers are secure, using best practices for physical, instance, network, and file system security. Introduction 1. Security Best Practices for SQL Server 2. SQL Server Security Basics 3. Understanding and Using SQL Server Permissions 4. Creating and Assigning Logins and Roles 5. Securing SQL on the Network Conclusion
Views: 35376 LinkedIn Learning
Grant/Deny Access to a Database for a user in SQL server
 
02:08
For more Details visit http://techchoco.com/grant-or-deny-access-database-for-a-user-sql-server/ Grant/Deny access to a Database for a particular user in SQL server 2008 R2, we can do this by using User Mapping option in SQL.
Views: 73378 Tech Choco
SQL Server DBA Tutorial 50- How to create Windows Authentication Login in SQL Server
 
08:08
In this video you will learn how to create SQL Server Login using Windows Authentication. It also demonstrates step by step process of creating Windows Authentication Login using SQL Server Management studio as well as T-SQL Script. It also explains how to retrieve Active directory user, options while creating Windows Authentication user such as selecting right object type, selecting right domain controller as well as selecting entire directory to create SQL Server Login using Windows Authentication. link to blog post: http://sqlage.blogspot.com/2015/03/how-to-create-windows-authentication.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 24668 TechBrothersIT
How to Create User Account in SQL Server Tutorial
 
04:15
Today I'm going to show You Can Create Tutorial. It is one best way to secure your database. If you have installed SQL Server You are using Windows Authentication User Account in SQL Server Mode to Connect SQL Server, that's not good work. Because many friends or any other person they are using your system. They easily delete or change your database from your computer. Basically, more than users using Windows Authentication Mode, I recommend you use Server Authentication Mode to Connect the SQL Server. You just need to create a username, password and authorize role of the database as you like. In this video tutorial, I will teach you How You can make a User to Connect SQL. These few simple steps to create an Account. First of All, you need to Open SQL Server and Connect the SQL Windows Authentication Mode. After that Go to Left Side Right Click to DB Yellow and Green Icon in the Front. After that Select property then select Security Tab and Change the Radio Button Windows Authentication Mode to SQL Server Mode. Then you need to restart the SQL Server and go to right side folder namely Security Right Click it. Then Hover the Mouse New and Login then enter the User Name as you want to use and Select Second Radio Button and enter the password, then you need to uncheck Enforce password expiration. Then Go to Next Tab Server Role and Check Last Option namely sysadmin. Then go to User Map Tab and Select Database as you assign, after that below you can database roles, assign the role as you like. That’s it, However, Kindly Watch the Complete video tutorial for getting more ideas. If you have any question/suggestion kindly comment me. Please Subscriber My YouTube Channel and Share my Video. Thanks, A Lot
SQL database to multi user mode from single user mode
 
02:44
This video is to show you how to troubleshoot the issue when you are not able to put a database back to multi user mode from single user mode. You can visit my blog as well http://sqlgeekspro.com/ for more tips.
Views: 4285 SQLGeeksPro
SQL tutorial 47: How to Grant Object Privileges With Grant Option in Oracle Database
 
07:13
In this SQL Tutorial you will learn How To Grant Object Privilege using Grant Data Control Language (DCL) statement along with GRANT OPTION flag. Third SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:06- Query 1- How To grant Basic Object Privilege (i.e.SELECT Object privilege) to a user 3:31- Query 2 - How to Grant Multiple Object Privilege To a user in 4:26- Query 3 - How To grant Object Privilege on Column Level 5:30- Query 4- How To Grant System Privilege WITH GRANT OPTION flag 6:06- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ List of Object Privilege http://bit.ly/list_of_object_privileges Object Privileges Blog http://bit.ly/object_privileges-in-oracle-database Previous Tutorial System Privilege: http://youtu.be/EQzdtKPiErU Introduction to user privilege: http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 25028 Manish Sharma
SQL tutorial 45: Introduction to user Privileges in Oracle Database By Manish Sharma RebellionRider
 
04:30
First SQL Tutorial in the series of user privileges in oracle database an introduction to user privileges. In this tutorial you will learn ● What is user privileges ● Different types of user Privileges ● Data Control Language (DCL) Grant and Revoke ● Who Can Grant or Revoke System Privileges? ● Oracle grant flags such as "With Admin option, With Grant option and with hierarchy option " This is a quick video on Introduction of user privileges expaining the theoretical concepts for the better understanding of the concept and up coming videos in USER PRIVILEGE series. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/introduction-to-user-privileges ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 29853 Manish Sharma
SQL Server - How to fix error in SQL Server Saving changes is not permitted
 
02:36
Internet World This Example shows that how to fix the following error in SQL Server Error - Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option Prevent saving changes that require the table to be re-created. To change the Prevent saving changes that require the table re-creation option, follow these steps: 1) Open SQL Server Management Studio (SSMS). 2) On the Tools menu, click Options. 3)In the navigation pane of the Options window, click Designers. 4) Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK. Note : If you disable this option, you are not warned when you save the table that the changes that you made have changed the metadata structure of the table. In this case, data loss may occur when you save the table. You can used this method in following SQl Server versions 10.0 for SQL Server 2008 10.5 for SQL Server 2008 R2. 11.0 for SQL Server 2012. 12.0 for SQL Server 2014.
Views: 4562 Internet World
SQL Views, WITH CHECK OPTION
 
03:43
Jamie King of Neumont University shows how WITH CHECK OPTION prevents data inserted into a view that will be lost.
Views: 12342 Jamie King
SOLIDWORKS Quick Tip - Recommended SQL Install Settings
 
07:58
See more at: http://www.goengineer.com/products/solidworks/ Learn the entire Microsoft SQL 2014 installation process paying special attention to settings that are recommended for SOLIDWORKS Enterprise PDM. SOLIDWORKS Quick Tip presented by Joseph Cutrona of GoEngineer. About GoEngineer: GoEnginneer delivers software, technology and expertise that enable companies to unlock innovation and deliver better products faster. With more than 30 years experience and thousands of customers in high-tech, medical, machine design, energy and other industries, GoEngineer provides best-in-class design solutions from SOLIDWORKS, Stratasys, CAMWorks and Agile PLM. http://www.goengineer.com http://www.facebook.com/goengineer http://www.twitter.com/goengineer http://www.linkedin.com/goengineer https://plus.google.com/101084524922750716243
Views: 15626 GoEngineer
How to Configure ODBC to Access a Microsoft SQL Server
 
05:47
This video tutorial covers how to configure ODBC to access a Microsoft SQL Server database. More guides and tutorials: http://www.itgeared.com/.
Views: 309412 itgeared
1. Restricted User - Part 1 - SQL Administration
 
02:14
Part 1 of Access restriction options available in SQL.
Views: 38 SQl Xmen
SQL tutorial 46: What are System Privileges & How To Grant them using Data Control Language
 
06:26
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag. First SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user 2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement 3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement 4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag 5:26- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option Link for How To create user ●SQL Tutorial 37 - Using Create User Statement http://youtu.be/4QbK2Y-1LZw ●SQL Tutorial 38- Using SQL Developer http://youtu.be/GS4udgR44Ls ●SQL Tutorial 39- Using Oracle Enterprise Manager http://youtu.be/zGjh-Bb3HrI List of few System Privileges Available in Oracle Database http://wp.me/p3r6sw-7M Previous Tutorial: Introduction To User Privileges http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 26179 Manish Sharma
How to Create User In SQL Server | Login and User Security
 
06:30
How to Create User In SQL Server | Login and User Security today we will learn How to Create User In SQL Server | Login and User Security. If you want to SQL Server Connect with Your Own User Name and User Security. You need to Make Your Own User Name and Password. How can You do that? First of All, you need to Connect SQL Server with Windows Authentication Mode, then you need to Right Click On Your SQL Server Name, Properties, and You need to Select the Second Radio Button Namely SQL Server and Windows Authentication Mode. Then you need to Restart the SQL Server, Then you need to Right Click Security Folder and Then Login, it has appeared on the right side under Object Explorer Panel, then New Login. In this Page you need to Enter the User Name as you want to use in SQL Server to Connect, and Select Second Radio Button, then enter the password, then uncheck Enforce Password Expiration. Then you need to Click Server Role Link, in this page, you need to Select sysadmin. Then, you need to click User Role and Assign the Database as you want to assign with New User. Select the Database and Assign the Role as you like. Then, you need to Click Securable Link, in this page, you need to Search the SQL Server Name, after searching the SQL Server Name than you need to Select the Third Option. and Click OK, that's it. The Largest Hub of Tutorials In this Channel, you will a lot of Programming, Blogging, Digital Marketing, Web Development, Web Designing, WordPress, Google AdSense and Tips & Tricks. Basically, I will share helpful and beneficial videos tutorial. I humbly request to you please Subscribe My YouTube Channel for getting updates. Thanks Follow us On Facebook www.Facebook.com/MyAktion Twitter www.Twitter.com/MyAktion Pinterest www.Pinterest.com/MyAktion Watch more video Trigger Tutorial In SQL Server For Beginners https://goo.gl/tnirVT Stored Procedure in Sql Server Tutorial For Beginners https://goo.gl/5onvH5 How to Create Login Form in C# With Database https://goo.gl/28TVT3 Student Registration System in C Sharp Windows Form Application https://goo.gl/sQngHX How to insert Update Delete in C# Windows Application https://goo.gl/LuCpvg
Views: 960 Myaktion Technology
SQL Server DBA Tutorial 52- How to create Windows Group Authentication Login in SQL Server
 
08:56
In this video you will learn how to add Active directory group to SQL Server, how to create login using Windows Authentication while selecting the active directory group. How SQL Server communicates with Active directory for Authentication and Authorization. What option to select when adding Active directory (AD) group to SQL Server Login. Video shows both ways of creating Group login, using SQL Server Management studio as well as T-SQL script. Blog post link for the video for scripts used in the video http://sqlage.blogspot.com/2015/03/how-to-create-windows-group.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 18877 TechBrothersIT
Business Rules & User Options in the Raiser's Edge 7.95
 
01:46
In this video, you will learn about business roles and user options in the Raiser's Edge 7.95.
Views: 2363 BlackbaudSupport
How to Reset Forgotten SQL Server User/SA Password Quickly
 
05:33
#RecoverSQLPassword #SysTools #SQLServer Have you forgot your SQL Server sa Password? Are you not able to access your SQL Server database due to lost password? Relax! Try SysTools SQL Password Recovery Tool https://bit.ly/2wxWljk to reset sa password in SQL Server Database. Inorder to see how the tool works, Download the Free Demo version of SQL Password Recovery software to reset SQL Server sa & User password from master.mdf file. The software supports to reset SQL password of any length and of any type. You can reset password of any special character or password having multilingual type. The software loads all the username of user account and select the username you want to reset. The best part is, you don't need to have mandatory installation of SQL Server. If you have master.mdf file. The software provides you an option to set new SQL Server password. Just select the particular user you want to reset sa password and confirm the new password. SQL Password Reset Tool is compatible with all Windows version. User can install this utility to any Windows version like Windows 10/ 8.1/ 8/ 7/ Vista etc. It supports to load master.mdf file of all SQL Server version like 2017, 2016, 2014 & all below its version. The software requires 2GB RAM in your system and 50MB free hard disk space. Steps to reset SQL Server sa Password in just 4 simple steps: Step 1: Browse the master.mdf file to reset SQL SA/User Password Step 2: Select the username you want to reset Step 3: Set new password and Confirm it Step 4: Login to the SQL Server with new password. E-mail: [email protected] For Help: [email protected] Visit our popular social media platforms to know more about us & our products: Facebook: https://www.facebook.com/systools Twitter: https://www.twitter.com/systools Instagram: https://www.instagram.com/systools LinkedIn: https://www.linkedin.com/company/systools Vector Images Sourced From : https://bit.ly/2ycdl2h
Views: 415 SysTools Software
Allow remote connections to SQL Server Express : How to Video
 
07:36
Enable remote connection on SQL Server 2014 express. By default, when SQL Server Express is installed it generates a random port to listen on. In this video you will learn how to configure SQL Server 2014 Express to accept remote connections over TCP/IP using SQL Server Configuration Manager and how to open the port on firewall for incoming connection.
Views: 265027 Sachin Samy
SQL Server -  Grant and Revoke in Sql | Create New User in Sql | DCL Commands in Hindi/Urdu Part-5
 
10:31
In this video you can learn (DCL) Data Control Languag Commands in Microsoft SQL Server in Hindi/Urdu. How to Create New User in SQL Server Using Grant or Revoke Statements For more updates visit our website: http://www.safcode.com/ Here we explain Sql Commands Like Data Definition Language (DDl), Data Manipulation Language (DML), Data Control Language (DCL), Triggers, Store Procedure, Virtual Tables (Views), Joins, Inner Join, Left Joins, right Joins, Sql Function, Queries, Primary Key, Foreign Key and more .....! See our Related Videos Like: SQL Server Tutorials for beginner in hindi/urdu https://www.youtube.com/watch?v=khkix1I6XSc&feature=youtu.be SQL Server - Insert in sql | Data Manipulation Language (DML) in hindi/urdu https://www.youtube.com/watch?v=6sdYjIIp8uA&feature=youtu.be Windows Form c# Tutorials for Beginnners in Hindi/Urdu https://www.youtube.com/watch?v=jL8RGGCXN-I you are also like our facebook page for more updates Facebook: https://www.facebook.com/safcode3 For more details visit our website: http://safcode.com/ #DataControlLanguage #DCLinSqlServer #GrantandRevokeinSql
Views: 2600 Safcode
How to Create Multi User Login Form in VB.NET using SQL Server Database?[With Source Code]
 
20:31
This video will show you how you can Create Multi-user Login From in VB.NET using SQL Server Database! NOTE: i forget to show you that when you enter wrong username or password then you will get error message! Send SMS using VB.NET: https://youtu.be/o8Hw-2Szxzg Source Code: https://techsupportnep.com/programming/vbnet/how-to-create-multi-user-login-form-in-vb-net-using-sql-server-database.html This video is created by Ran and TechSupportNep own this video. Using of this video on other channels without prior permission will be strictly prohibited. (Embedding to the websites is allowed).. So stop copying and be a responsible people. #MultiUserVB #VBMultiuserLogin #MultiUserLogin #MultiUserLoginInVB
Views: 6047 TechSupportNep
SQL Server DBA Tutorial 51- How to Create SQL Server Authenticated Login in SQL Server
 
10:16
In this video you will learn step by step how to create SQL server Login using SQL Server Authentication. It shows step by step process using SQL Server management studio as well as creating SQL Server Authentication login using T-SQL Script. It talks about different options such as password Policy management of SQL Server and default database best practices. blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-create-sql-server-authenticated.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 44292 TechBrothersIT
Login and User security in SQL Server 2008
 
10:01
For more videos on technology, visit http://www.Techytube.com By Jayanth Kurup / Techytube.com This video introduces the principle of least privileges and how to implement it within a database schema. Security is a prime concern for every organization therefore everybody has a stake in helping the company achieve compliance. Sometimes it is self-enforced other times it is mandatory. Regardless of why your implementing it the DBA is a key member in helping you achieve these goals and one of the first and most basic steps include mapping logins to users in the database. These users in turn map to roles or schema within the database and the schema in turn own objects like tables and procedure. These layers help control and restrict access in terms of which login or user has access to what objects. The video covers how to create a login that is bound to a windows account. This is followed by how to map the login to a user within a database and lastly how to grant the user specific permissions on a procedure in order to execute it. This simple video help you get started in implementing what will be a robust security model within your database server and in most cases is sufficient in order to make sure your database is secure. We will cover many more advances security principles such as auditing and DDL triggers etc. in future videos.
Views: 99596 techytube
SQL Server Error 18456
 
05:10
Explains the common sql server error 18456 and possible solutions. http://www.helpdesk-blog.com http://www.helpdesksoftware.biz The "Login Failed" error 18456 can occur due to a variety of reasons. The 18456 error is displayed when the server name you entered was correct, but the connection cannot be granted due to one of a number of reasons. The 18456 error message does not provide much information on the cause login failure. This is because it is intended to hide details from unauthorized users, in case someone tries to enter the SQL server by guessing information. What are the Main Causes of SQL Server Error 18456? (1) Error 18456 commonly occurs when mixed mode authentication is enabled. You may be trying to log in using Windows authentication with a user that the SQL server does not recognize as a SQL user login. (2) Error 18456 will occur If you are using SQL server authentication and the login or password is incorrect. (3) This error can also occur in the event of disabling or locking the username in the server, and also in the case of password expiration. How can a SQL Server Error 18456 be Resolved? Before proceeding with troubleshooting, take the time to verify that your credentials are correct. If you are using Windows 7 or Windows Vista, you should try opening the SQL Server using the "Run as Admin" option and see whether that resolves the problem. If you are trying to log in using Windows Authentication and you receive Error 18456, you should login using SQL SA credentials and go to Security and verify that your Active Directory Windows account is associated with your SQL login If you try to log in using SQL server authentication, you should log in using SQL SA credentials, go to Security and check to ensure that the user name passwords are not expired or locked. Go to Logins, select the user you want to check, and go to properties. You can check whether password expiration is enabled by navigating to the "General" tab. Next, go to the Status tab and check whether your account is locked or not. Here in this illustration, the "Login is locked out" option is not activated and it is grayed out which means the account is not locked. The other possible reason for Error 18456 is that Windows Authentication or Mix Mode Authentication is not enabled on the database itself. You can check this by navigating to the properties of the database. Select the database instance and go to Properties. Click on the Security tab and go to the server authentication area to check this. If you change Server authentication to "SQL Server and Windows Authentication" mode or vice versa, you must restart the SQL Server service. You can use the Microsoft Service console to restart the SQL Server if needed - just right-click and choose the Restart option. Usually, if Error 18456 occurs, it will have an error state number that can help determine the cause. Obtaining information on the error state can make troubleshooting significantly easier. Windows Event Viewer holds details of the error. In the Event Viewer, this error is associated with the event ID 18456. The Error state descriptions are as follows: 2 and 5 indicate that an Invalid USERID was used to log in. 6 indicates that user has attempted to use a Windows login name with SQL Authentication. 7 indicates that login is disabled and password could be mismatched. 8 indicates that password mismatch has occurred. 9 indicates an invalid password. 11 and 12 indicate that a valid login was used but server access failure has occurred. 13 indicates that the SQL Server service is paused. 18 indicates that a change of password is required.
Views: 72711 Help Desk Premier
Database Mirroring In MS SQL Server - I
 
09:26
https://www.youtube.com/user/masterkeshav With this video session I have tried to explain briefly how mirroring can be configured and used as one of the best fail over options for critical databases. This is the Part I of the complete session.
Views: 34774 Keshav Singh
PHP Dynamic Select/Option From MySQL Table
 
07:05
In this video I will illustrate how to create a dynamic Select/Option structure from a MySQL table using PHP.
Views: 47139 Ken Swartwout
How to enable SQL Authentication in SQL Server 2014 Express
 
03:36
SQL Server Authentication is the typical authentication used for various database systems, SQL authentication composed of a username and a password. In this video tutorial you are going to learn how to enable SQL Server Authentication on SQL Server 2014 Express
Views: 32623 Sachin Samy
User Registration Form With V.B .Net And sql database
 
15:25
register/insert user data with v.b .net and sql database as back end if you need any help on your system, email you query to [email protected]
Views: 20778 System Platforms
SQL Server 2016 - How to use Query Store Feature in SQL Server 2016
 
07:52
In this video you will learn How to use Query Store database feature of SQL Server 2016, this video illustrates following reports and options of Query Store database features - Regressed Queries - Overall Resources Consumption - Top Resources Consumption Queries - Tracked Queries Step by Step DBA Tutorial by TechBrothersIT http://www.techbrothersit.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 9286 TechBrothersIT
SQL tutorial 43: How to create an EXTERNAL USER in oracle database By Manish Sharma RebellionRider
 
05:08
Learn another DBA trick. In this tutorial you will learn how to create an user actually an External user / schema. Being an Oracle DBA you must know how to create an external user/ schema Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Website: http://bit.ly/how-to-create-external_user-oracle Previous Tutorial: How to unlock user using SQL Developer http://youtu.be/xRBfeTO1Pc8 Tutorial 38: http://youtu.be/GS4udgR44Ls Links of how to create user tutorial Create user using SQL Developer http://youtu.be/GS4udgR44Ls Create user using Create user command http://youtu.be/4QbK2Y-1LZw Create user using EM http://youtu.be/zGjh-Bb3HrI ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] -------------------------------------------------------------------------- ►Connect with me on my LinkedIn and please endorse my skills Thanks in Advance http://in.linkedin.com/in/mannbhardwaj/ -------------------------------------------------------------------------- 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: 19867 Manish Sharma
SQL Server DBA Tutorial 45-Do you recommend default settings auto growth for Database files
 
04:30
In this video you will learn the answer of SQL Server DBA interview Question " Do you recommend default settings auto growth for Database files If not why " Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 11553 TechBrothersIT
SQL Server DBA Tutorial 125-How to Get the Detail of a Job Failure in SQL Server
 
11:22
In this video you will learn how to find Job failure cause using SQL Server management studio as well as T-SQL Script. The video shows various options for storing Job history such as storing history in a file, Table or directing the output in Application Log. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-tet-detail-of-job-failure-in-sql.html Complete Step by Step List for DBA Tutorial Videos: http://sqlage.blogspot.com/search/label/SQL%20Sever%202014%20DBA%20Video%20Tutorial
Views: 11923 TechBrothersIT
Creating Computed Columns with User Defined Functions - SQL Server
 
04:35
-- IN THIS VIDEO WE ARE GOING TO LEARN ABOUT ADDING A COMPUTED COLUMN BY USING A USER DEFINED FUNCTION WHICH IS ALSO KNOWN AS CUSTOM FUNCTION --Create a function (NON DETERMINISTIC) CREATE FUNCTION [dbo].[MyFunc] (@val int) RETURNS int AS BEGIN RETURN @val*2; END --Test the function select dbo.myFunc (200); -- should give output: 400 -- Add a computed column using ALTER TABLE query ALTER TABLE jobs ADD double_salary AS dbo.myFunc(salary) Go --Get data from table SELECT * FROM jobs --Find if User Defined function is Deterministric SELECT id, Name, OBJECTPROPERTY(id, 'IsDeterministic') AS isDeterministic FROM dbo.SysObjects WHERE XType = 'FN' ORDER BY OBJECTPROPERTY(id, 'IsDeterministic') DESC, Name --Create a deterministic function WITH SCHEMABINDING CREATE FUNCTION [dbo].[MyDetFunc] (@val int) RETURNS int WITH SCHEMABINDING AS BEGIN RETURN @val*2; END -- Add a computed column with PERSISTED option ALTER TABLE jobs ADD double_salary2 AS dbo.myDetFunc(salary) persisted Go -- Again Get data from table SELECT * FROM jobs
Views: 370 Zia Ahmed Shaikh
Automation Anywhere 11.X - SQL Query ( Database )  | Robotics | AI | ML | ChatBots
 
21:07
Contact Us for RPA Tool Project Support Email : [email protected] can be used and re-used in a wide variety of automated tasks. These bots allow automation at all levels, including API, front-end, back-end, and image recognition. Tags : automation anywhere, automation anywhere 10.2, automation anywhere analytics, automation anywhere ankur kothari, automation anywhere architecture, automation anywhere artificial intelligence, automation anywhere banking, automation anywhere blue prism, automation anywhere bots, automation anywhere case study, automation anywhere ceo, automation anywhere certification, automation anywhere citrix, automation anywhere coding, automation anywhere cognitive, automation anywhere control room, automation anywhere controls, automation anywhere course, automation anywhere create exe, automation anywhere dashboard, automation anywhere data extraction, automation anywhere database, automation anywhere deloitte, automation anywhere demo, automation anywhere demo videos, automation anywhere deployment, automation anywhere development, automation anywhere download, automation anywhere email, automation anywhere enterprise, automation anywhere enterprise manual, automation anywhere error handling, automation anywhere example, automation anywhere excel, automation anywhere exception handling, automation anywhere exe, automation anywhere extract data, automation anywhere extract table, automation anywhere for beginners, automation anywhere founder, automation anywhere framework, automation anywhere getting started, automation anywhere global variables, automation anywhere help, automation anywhere image recognition, automation anywhere installation, automation anywhere integration, automation anywhere interface, automation anywhere interview questions, automation anywhere introduction, automation anywhere ipo, automation anywhere iq bot, automation anywhere keystrokes, automation anywhere learn, automation anywhere list variable, automation anywhere mainframe, automation anywhere medabot, automation anywhere meta bot, automation anywhere object cloning, automation anywhere ocr, automation anywhere online training, automation anywhere overview, automation anywhere pdf, automation anywhere pdf download, automation anywhere pdf integration, automation anywhere quora, automation anywhere robotics, automation anywhere rpa, automation anywhere rpa training, automation anywhere samples, automation anywhere sap, automation anywhere screen scraping, automation anywhere scripting language, automation anywhere server, automation anywhere software, automation anywhere step by step, automation anywhere stock, automation anywhere string operation, automation anywhere studio, automation anywhere task editor, automation anywhere terminal emulator, automation anywhere tool, automation anywhere training material, automation anywhere training online, automation anywhere trigger, automation anywhere tutorial, automation anywhere tutorial pdf, automation anywhere tutorial videos, automation anywhere tutorials, automation anywhere tutorials youtube, automation anywhere use case, automation anywhere user guide, automation anywhere variable operation, automation anywhere variables, automation anywhere vbscript, automation anywhere video, automation anywhere video tutorial, automation anywhere vs blue prism, automation anywhere vs openspan, automation anywhere web data extraction, automation anywhere web recorder, automation anywhere web scraping, automation anywhere webinar, automation anywhere workflow designer, automation anywhere xml, automation anywhere youtube, robotic process automation accenture, robotic process automation accounting, robotic process automation analytics, robotic process automation anz, robotic process automation architecture, robotic process automation automation anywhere, robotic process automation blue prism, robotic process automation blue prism training, robotic process automation blue prism tutorial, robotic process automation deloitte, robotic process automation demo, robotic process automation developer, robotic process automation examples, robotic process automation excel, robotic process automation explained, robotic process automation ey, robotic process automation human resources, robotic process automation ibm, robotic process automation in accounting, robotic process automation in banking, robotic process automation in financial services, robotic process automation in healthcare, robotic process automation in sap, robotic process automation pros and cons, robotic process automation pwc, robotic process automation recruitment, robotic process automation roadmap, robotic process automation rpa, robotic process automation software, robotic process automation tools, robotic process automation tutorial, robotic process automation uipath, robotic process automation use cases, robotic process automation videos,
SQL tutorial 48: How to create Roles in Oracle Database
 
07:16
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 25681 Manish Sharma
User defined functions in sql server 2008 R2
 
14:13
In this video I demonstrate how to create user defined functions in sql server 2008. For more videos subscribe our channel.this is knowledge sharing channel. http://schoolautomation.net for more tutorials , source code ,notes, please visit my other website : http://www.yogeshdotnet.com For more videos and free tutorial and notes please visit https://yogeshdotnet.com/ My Youtube gears: Headphone with Mic : http://amzn.to/2kUXHSq Best USB Micro phone : http://amzn.to/2gogjsR Another option(cheap) asUSB microphone : http://amzn.to/2yrOsME Microphone with mic under 500: http://amzn.to/2gogV1D Antivirus under 500 : http://amzn.to/2ieKPFV Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN What's app group: https://chat.whatsapp.com/AtlkVqbxOrp1vyewFDOg4x What's app group for latest technologies and trends : https://chat.whatsapp.com/AtlkVqbxOrp1vyewFDOg4x Facebook Page Url : https://www.facebook.com/yogeshdotnetblogs/
Views: 10428 john mass
Microsoft SQL Server 70-462 Tutorial | Memory Settings
 
05:41
Want all of our free Microsoft SQL Server 2012 Exam 70-462 training videos? Visit our Learning Library, which features all of our training courses and tutorials at http://learn.infiniteskills.com?utm_source=youtube&utm_medium=microsoft_sql_70-462&utm_campaign=01839_0319 More details on this Microsoft SQL Server 2012 Exam 70-462 training can be seen at http://www.infiniteskills.com/microsoft/. This clip is one example from the complete course. For more free Microsoft tutorials please visit our main website. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
06 -Administering Microsoft SQL Server 2012- High Availability Options
 
01:05:10
6-Some of the planet's heaviest database workloads sit on SQL Server, and the loss of availability could be catastrophic. SQL Server offers a number of high availability technologies that can be used alone, or in some cases, together. The high availability technologies of failover clustering, replication, log shipping, database mirroring, and AlwaysOn are examined and compared.
Views: 2090 RG Edu
SQL Server Disaster Recovery and High Availability
 
01:49:29
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA's) lump disaster recovery (DR) & high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and what criteria do you use to make the choice? It's incredibly important that you understand the decision tree that helps you pick the right options(s) for your business and that you can explain the choices clearly to the stakeholders. It's not as complicated as it sounds, but it is complicated. This presentation will give you a high level understanding of the options, the costs, complexities, & reasons for using each of them.
SQL Server 17 - ON DELETE and ON UPDATE
 
08:14
Now, what happens when you have successfully created a reference, and now you try deleting the parent? This is where the ON DELETE clause comes in. This is essentially how we configure how strict a foreign key is. There are 4 options you can give for an ON DELETE: Standard SQL Server NO ACTION Yes (Default) CASCADE Yes SET NULL Yes SET DEFAULT Yes Now the default is NO ACTION. This means that when you try to delete a parent row, SQL Server is going to throw an error and not let you. Cascade means that if you delete the parent row, any rows that reference that parent will also be deleted. This is pretty dangerous and not often recommended. SET NULL will set the foreign key to be NULL. Now obviously, this is going to require that the foreign key is not labelled NOT NULL. Finally, set DEFAULT will change the reference to the child row to some default value. We have not discussed defaults, but a column can have a default value. For example, we could make a deleted user in our Users table, and set the default for the foreign key to be the deleted user, and when any other users are deleted it will default to the deleted user UserId. In addition to the ON DELETE clause, there is the ON UPDATE clause. This one is a little less common because it configures what happens when a parent value changes. Obviously, when you are referencing a primary key, the ON UPDATE clause is nearly useless. That's because the primary key value is never supposed to change. If, on the other hand, we have a foreign key referencing a UNIQUE column that is not a primary key, it may change occasionally. So the only times you have to worry about the ON UPDATE clause is with foreign keys referencing UNIQUE columns that are not a primary key, and when you have natural keys that break the rules and actually do change at some point in time. The ON UPDATE clause has the same options as the ON DELETE clause and they all work the same way. Now, the last thing you need to know about foreign keys is that they must match the data type of the column you are referencing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 6930 Caleb Curry
Oracle SQL Tutorial 19 - ON DELETE (SET NULL and CASCADE)
 
05:59
Welcome everyone! Something you need to consider when you are creating foreign keys is what happens if you delete the parent? As a reminder, the parent is the row that has the value you are referencing in the row that has a foreign key. Why is this something important to consider? It's important because foreign keys need to protect us from two primary things, unacceptable INSERT statements, and unacceptable DELETE statements. Let's see what happens when we try to insert incorrect data into the table with the foreign key: INSERT INTO projects VALUES (1, 'Update website homepage', 'CalebCurry') The response tells us plainly that there is no such user in the users table. So this works correctly. Deleting data on the other hand works a bit differently because the database does not know what you want to do with the child row when you delete the parent from the parent table. By default, we will get an error message that prevents the parent from being deleted, but there are some other options. How do we configure this? This is where the ON DELETE statement comes in. We add the keywords ON DELETE right after the foreign key and then we can give it the option of CASCADE or SET NULL. CASCADE means that if we delete the parent, we are also going to delete the child. In our situation what that means is that if somebody creates a project in our project table and then that persons account gets deleted, all of the projects he owns will also be deleted. CASCADE: CREATE TABLE projects( project_id NUMBER, Project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ON DELETE CASCADE ) SET NULL will take the value in the child table and get rid of it. What you are left with is NULL. This means that we have an orphaned child. The first thought you might have is that it is a bad thing to have an orphaned child, but in databases that is not always so. In our application if we had it set to SET NULL, when a user account gets deleted the projects would remain in existence they would just lack a creator. This might be a good thing if you are concerned about the long term survival of a project, this might be the route you want to go. It ultimately depends on the application purpose. If you don't like CASCADE or SET NULL, you can leave the entire ON DELETE statement and just have Oracle throw an error when a parent is deleted. As for us, we are going to use ON DELETE CASCADE. We need to use this with extreme caution. If you are not careful, someday you will run a delete a row and that will cascade through you database deleting a bunch of stuff you didn't want to delete. Stuff happens, so make sure you back up your database every once in eternity. Now, in the last video we started with a database design that had three tables. We've only created two in this video. In the next video we are going to create the next one, which is a little special. Then we'll finish things up by adding some indexes. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me on Patreon! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 19860 Caleb Curry
Administering Microsoft SQL Server 2012, 06, High Availability Options
 
01:05:10
www.epcgroup.net | [email protected] | Phone: (888) 381-9725 * SharePoint Server 2013, SharePoint Server 2010, and SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, and Post Go-live Support with Extensive Knowledge Transfer * Health Check and Assessments (Roadmap Preparation to Upgrade to 2013 or 2010) - Including Custom Code & Solution Review * Enterprise Content Management Systems based on Microsoft SharePoint * Enterprise Metadata Design, Taxonomy | Retention Schedule Development | Disposition Workflow, and Records Management Implementations * Roadmap, Requirements Gathering, Planning, Designing, and Performing the Actual Implementation * Best Practices Consulting on SharePoint 2013, 2010, 2007 | EPC Group has completed over 725+ initiatives * Intranet, Knowledge Management, Internet and Extranet-Facing as Well as Mobility (BYOD Roadmap), Cloud, Hybrid, and Cross-Browser | Cross-Platform Solutions for SharePoint 2013 / 2010 with Proven Past-performance *Upgrades or Migrations of Existing Deployments or Other LOB Systems (Documentum, LiveLink, FileNet, SAP, etc.) using EPC Group's Proven Methodologies (On-Premises, Hybrid, Virtualized, or Cloud-Based Infrastructure Design) * Custom Application, Feature, Master Pages, Web Parts, Security Model, Usability (UI), and Workflow Development (i.e. Visual Studio 2012) * Migration Initiatives to SharePoint 2013 / SharePoint 2010 * Key Performance Indicators, Dashboard & Business Intelligence Reporting Solutions (PerformancePoint 2013, SQL Server 2012, BI, KPIs, PowerPivot, Scorecards, Big Data Experts) * Experts in Global \ Enterprise Infrastructure, Security, Hardware Configuration & Disaster Recovery (Global performance considerations, multilingual, 1mm+ user environment experience) * Tailored SharePoint "in the trenches" Training on SharePoint 2013, 2010, 2007 as well as Project Server and Custom Development Best Practices * Support Contracts (Ongoing Support your Organization's 2013, 2010, or 2007 Implementations) * .NET Development, Custom applications, BizTalk Server experts * Project Server 2013, 2010, and 2007 Implementations and Consulting * SharePoint Roadmap & Governance Development: 6, 12, 18, 24 and 36 months (Steering Committee & Code Review Board Development) * Corporate Change Management & End User Empowerment Strategies * EPC Group's WebpartGallery.com - Customized Web Parts Based off of "in the trenches" Client Needs With over 14 years of experience, EPC Group delivers time tested SharePoint methodologies that ensure success within your organization. Engagement with EPC Group carries unique offerings and knowledge. Currently having implemented over 725+ SharePoint engagements and 75+ Microsoft Project Server implementations, we are the nation's leading SharePoint and Microsoft platform related consulting firm. EPC Group will be releasing our 3rd SharePoint book in August of 2013 by Sams Publishing titled, "SharePoint 2013 Field Guide: Advice from the Consulting Trenches" which will be like having a team of Senior SharePoint 2013 consultants by your side at each turn as you implement this new powerful and game changing software platform within your organization. SharePoint 2013 Field Guide: Advice from the Consulting Trenches will guide you through all areas of a SharePoint initiative from the initial whiteboarding of the overall solutions to accounting for what your organization currently has deployed. It will assist you in developing a roadmap and detailed step-by-step implementation plan and will also cover implementation best practices, content management and records management methodologies, initial SharePoint 2013 development best practices, as well as mobility planning. SharePoint 2013, Microsoft SharePoint 2013, SharePoint Consulting, Microsoft SharePoint consulting, SharePoint Consulting Firm, Top SharePoint Firm, SharePoint 2013 Consulting,SharePoint 2010 Consulting, SharePoint ECM Consulting, SharePoint branding firm, SharePoint, SharePoint branding experts, ECM experts SharePoint, Errin O'Connor, EPC Group, EPC Group.net, BizTalk Consulting, Project Server Consulting, BYOD, SharePoint 2013 book, SharePoint 2013 advice from the trenches
Views: 4295 EPC Group.net
Creating a PHP Search
 
14:44
This is a tutorial which goes over how to create a PHP search which filters out results from a database table. Sorry for the mistakes made in this video, the video following this goes over how to take this and make it instant with jQuery Tutor Facebook: http://www.facebook.com/JoeTheTutor Dibbble: www.dribbble.com/sleekode www.helpingdevelop.com
Views: 484650 Joseph Smith
SQL Server 2012 Querying - How To Create A View
 
05:16
http://www.trainsignal.com/SQL-Server-2012-Querying-Training.aspx?utm_source=YouTube&utm_medium=Social%20Media&utm_campaign=SQL%20Querying%20Demo In this free video from our SQL Server 2012 Querying Training, Christopher Harrison demonstrates how to create and use a view. -~-~~-~~~-~~-~- This channel is an archive! Subscribe to Pluralsight for new IT Pro training ➨ https://www.youtube.com/user/Pluralsight?sub_confirmation=1 -~-~~-~~~-~~-~-
SysTools SQL Decryptor Tool | Decrypt SQL Server Database Objects
 
06:24
#SQLDecryptor #SQLDatabase #SysTools SysTools SQL Decryptor removes Encryption from SQL Server Database Objects like Stored Procedures, Views, Functions & Triggers without impact on original database. It supports decrypting SQL Server database objects of SQL Server 2019, 2017, 2016 & all previous SQL Server database objects that are encrypted using With Encryption option. The Software is capable to Decrypt encrypted stored procedures and other database objects in live SQL Server environment. Software has two different options to save Decrypted Objects of SQL Server i.e. SQL Server and SQL Server Compatible SQL Scripts. If you want to save Decrypted Objects Directly to SQL Server then you can choose SQL Server as an export option or if the Database objects are required in .sql scripts then choose SQL Server Compatible SQL Scripts option. Moreover, this SQL decryptor tool allows you to save database objects Without Encryption or With Encryption. the software enables SQL Server authentication option, if you are exporting the decrypted objects of a user account. This requires Server details like Server Name, Username and Password of that user. Steps to removes encryption from SQL Server database objects: Make sure you have successfully enabled the DAC connection or take help from here: https://www.systoolsgroup.com/sql-decryptor/enable-dac-connection.html Step 1: Open SysTools SQL Decryptor Tool Step 2: Click on Start button and Select the Server Name from the drop down list Step 3: Choose the Login Mode and select the Database Name then click on Next Step 4: Preview all the encrypted database objects and click on Next to Export Step 5: Select the Objects you want to Export and choose the Export option Step 6: Select the Output Mode and provide the Server details of Destination Server Step 7: Select the database on which you want to save the decrypted objects of SQL Server then Click on Export. E-mail: [email protected] For Help: [email protected] Visit our popular social media platforms to know more about us & our products: Facebook: https://www.facebook.com/systools Twitter: https://www.twitter.com/systools Instagram: https://www.instagram.com/systools LinkedIn: https://www.linkedin.com/company/systools Vector Images Sourced From : https://bit.ly/2ycdl2h
Views: 70 SysTools Software
SQL Decryptor
 
04:17
Decrypt the Encrypted SQL Database Script -- http://www.sqlrecoverysoftware.net/sql-server-database-decrypt/ SQL Decryptor -- A Matchless Solution For SQL Users! SQL Decryptor is capable of extracting data from data files of SQL Server even if they are encrypted. Users who demand SQL database exported in decrypted manner can avail this tool and easily fetch the SQL database even if they lack the Dedicated Admin Connections. Tool incorporates foundation of complex algorithms and yet has a simple interface giving users a much friendly environment to exhibit necessary operations. What Is Data Encryption? Encryption is provided for security so that this data is saved with more security. This can be done either by providing a code inside the data or a key which manipulates data in such a way that it cannot be processed without decoding or decrypting. And for decoding, key is required. This is meant for security purpose, but sometimes users face issues when that particular key is misplaced or user wants to access this encrypted data urgently and do not have necessary Dedicated Admin Connections. In that situation our SQL Decryptor can be a great help as it provides a platform where user can access this encrypted SQL data also. Key Features of Software Tool: Login Modes: Tool provides two log-in modes, one is "Windows Authenticated" and other is "SQL Server Authenticated". When user is choosing second option he has to give necessary credentials i.e. username and password associated with SQL Server. Preview SQL Database: Once your SQL database to get decrypted is loaded, tool shows all the details within script of stored procedures, functions, views, triggers which were initially encrypted and now have been decrypted. Dual Export Options: User has two options of exporting SQL encrypted data. One is to export data without decrypting it i.e. "With Encryption", and other is to export SQL data after decrypting it "Without Encryption". SQL Decryptor provides both options and user can choose amongst these as per his requirements.
Views: 3680 Ellis White
Automate Report Delivery in SQL Server Reporting Services
 
07:15
This demo shows how to: Configure a shared data source to store credentials (required for subscriptions) Configure SSRS for SMTP email delivery Create a subscription that delivers reports to a file share Create a subscription that delivers reports via email
Views: 88545 DeveloperVideos
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: 119289 kudvenkat
How To Connect Sql Database With ESSL ETimeTrackLite
 
05:01
This Video shows how to Connect Sql Database With ESSL ETimeTrackLite. For More: http://www.techmax.co.in
Views: 68225 TechMax
SQL Server Reporting Services
 
07:45
This video shows how configure a SSRS report portal from scratch. This demo shows how to: Setup a Report URL Define an execution account Create a Reports Server database Configure SMTP and more...
Views: 119687 ITProVideos
SQL Server 2017 – Everything you need to know
 
14:22
Microsoft Ignite Session: THR2116 We take a look at SQL Server 2017, and how the SQL Server that you know now runs on Linux with the new platform abstraction layer. We'll look at and how well it performs as well Active Directory Authentication on working on Linux; high availability options as well as failover between Windows and Linux Platforms. We'll also show you support for Graph analysis to identify new relationships in your data and more
Views: 75794 Microsoft Mechanics