Home
Search results “Sql server text mining examples”
SAP HANA Academy - Text Mining: Using SQL to access Text Mining Functions [SPS 10]
 
13:40
Text Mining existed in SAP HANA SPS09, but it is easier to use in SPS10. In this video, Tahir Hussain Babar (Bob) shows how easy it is to use some of the Text Mining functions in SAP HANA SPS10. These are accessed via SQL, and in the video, Bob gives some examples of the possibilities of Text Mining in SAP HANA SPS10. Scripts ; https://github.com/saphanaacademy/TextAnalysis_Search_Mining/blob/master/TextMining_SPS10.txt Thank you for watching. Video by the SAP HANA Academy. SOCIAL MEDIA Feel free to connect with us at the links below: LinkedIn: https://linkedin.com/saphanaacademy Twitter: https://twitter.com/saphanaacademy Facebook: https://www.facebook.com/saphanaacademy/ Google+: https://plus.google.com/u/0/111935864030551244982 Github: https://github.com/saphanaacademy
Views: 3813 SAP HANA Academy
Applying Data Mining Models with  SQL Server Integration Services (SSIS)
 
09:42
SQL Server Integration Services (SSIS) can be used to apply Data Mining predictions. This tutorial demonstrates how to use the SSIS "Data Mining Query" to predictive the risk of having a vehicle using profile information stored in a SQL Server table. I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 7908 Steve Fox
Data Mining in SQL Server Analysis Services
 
01:29:25
Presenter: Brian Knight
Views: 98790 PASStv
SQL Server 2017: Advanced Analytics with Python
 
21:29
In this session you will learn how SQL Server 2017 takes in-database analytics to the next level with support for both Python and R; delivering unparalleled scalability and speed with new deep learning algorithms built in. Download SQL Server 2017: https://aka.ms/sqlserver17linuxyt
Views: 13810 Microsoft Cloud
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: 28785 kudvenkat
SQL Server deadlock example
 
05:14
Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-deadlock-example.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-deadlock-example_25.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 When can a deadlock occur In a database, a deadlock occurs when two or more processes have a resource locked, and each process requests a lock on the resource that another process has already locked. Neither of the transactions here can move forward, as each one is waiting for the other to release the lock. When deadlocks occur, SQL Server will choose one of processes as the deadlock victim and rollback that process, so the other process can move forward. The transaction that is chosen as the deadlock victim will produce the following error. Msg 1205, Level 13, State 51, Line 1 Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. SQL script to create the tables and populate them with test data Create table TableA ( Id int identity primary key, Name nvarchar(50) ) Go Insert into TableA values ('Mark') Go Create table TableB ( Id int identity primary key, Name nvarchar(50) ) Go Insert into TableB values ('Mary') Go The following 2 transactions will result in a dead lock. Open 2 instances of SQL Server Management studio. From the first window execute Transaction 1 code and from the second window execute Transaction 2 code. -- Transaction 1 Begin Tran Update TableA Set Name = 'Mark Transaction 1' where Id = 1 -- From Transaction 2 window execute the first update statement Update TableB Set Name = 'Mary Transaction 1' where Id = 1 -- From Transaction 2 window execute the second update statement Commit Transaction -- Transaction 2 Begin Tran Update TableB Set Name = 'Mark Transaction 2' where Id = 1 -- From Transaction 1 window execute the second update statement Update TableA Set Name = 'Mary Transaction 2' where Id = 1 -- After a few seconds notice that one of the transactions complete -- successfully while the other transaction is made the deadlock victim Commit Transaction Next Video : We will discuss the criteria SQL Server uses to choose a deadlock victim
Views: 65653 kudvenkat
How to Search SQL Query Text in Stored Procedures and Ad-Hoc Queries
 
04:44
Have you ever wanted to search across all queries on your SQL Server? In today's video, we take a look at how to search the SQL query body/text of ad-hoc queries, stored procedures, functions, and views. Blog post containing code templates for easy copy/pasting: https://bertwagner.com/2017/11/14/how-to-search-stored-procedures-and-ad-hoc-queries/ Previous video that talks about searching for implicit conversions: https://youtu.be/mLcDzxCTfHY Follow me on Twitter: https://twitter.com/bertwagner Want to receive my latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/
Views: 697 Bert Wagner
How to find blocking queries in sql server
 
07:35
sql server find blocking processes sql server list blocking processes dbcc opentran example sql server kill spid sql server kill connections sql server kill query sql server kill transaction In this video we will discuss, how to find blocking queries in sql server. Blocking occurs if there are open transactions. Let us understand this with an example. Execute the following 2 sql statements Begin Tran Update TableA set Name='Mark Transaction 1' where Id = 1 Now from a different window, execute any of the following commands. Notice that all the queries are blocked. Select Count(*) from TableA Delete from TableA where Id = 1 Truncate table TableA Drop table TableA This is because there is an open transaction. Once the open transaction completes, you will be able to execute the above queries. So the obvious next question is - How to identify all the active transactions. One way to do this is by using DBCC OpenTran. DBCC OpenTran will display only the oldest active transaction. It is not going to show you all the open transactions. DBCC OpenTran The following link has the SQL script that you can use to identify all the active transactions. http://www.sqlskills.com/blogs/paul/script-open-transactions-with-text-and-plans The beauty about this script is that it has a lot more useful information about the open transactions Session Id Login Name Database Name Transaction Begin Time The actual query that is executed You can now use this information and ask the respective developer to either commit or rollback the transactions that they have left open unintentionally. For some reason if the person who initiated the transaction is not available, you also have the option to KILL the associated process. However, this may have unintended consequences, so use it with extremen caution. There are 2 ways to kill the process are described below Killing the process using SQL Server Activity Monitor : 1. Right Click on the Server Name in Object explorer and select "Activity Monitor" 2. In the "Activity Monitor" window expand Processes section 3. Right click on the associated "Session ID" and select "Kill Process" from the context menu Killing the process using SQL command : KILL Process_ID What happens when you kill a session All the work that the transaction has done will be rolled back. The database must be put back in the state it was in, before the transaction started. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/how-to-find-blocking-queries-in-sql_3.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/how-to-find-blocking-queries-in-sql_3.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: 55633 kudvenkat
Full-Text Search in SQL Server 2012 - practical introduction
 
26:00
It is an introduction to Full-Text Search in SQL Server 2012. It walks through installation, configuration and usage of a powerful database engine component for searching in texts. The video contains examples of SQL queries using contains, freetext, freetexttable functions.
Views: 44086 DBA presents
Microsoft Data Mining Demo -- Analyze Key Influencers
 
03:10
Microsoft Data Mining Demo -- Analyze Key Influencers with SQL Server 2008 and Excel 2007
Views: 5331 MarkTabNet
Cube in SQL Server
 
07:42
group by cube in sql server 2008 cube group by sql sql server group by cube example sql server cube group by Cube() in SQL Server produces the result set by generating all combinations of columns specified in GROUP BY CUBE(). Let us understand Cube() in SQL Server with examples. Write a query to retrieve Sum of Salary grouped by all combinations of the following 2 columns as well as Grand Total. Country, Gender Using Cube with Group By SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Cube(Country, Gender) --OR SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country, Gender with Cube The above query is equivalent to the following Grouping Sets query. SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY GROUPING SETS ( (Country, Gender), (Country), (Gender), () ) The above query is equivalent to the following UNION ALL query. While the data in the result set is the same, the ordering is not. Use ORDER BY to control the ordering of rows in the result set. SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country, Gender UNION ALL SELECT Country, NULL, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country UNION ALL SELECT NULL, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Gender UNION ALL SELECT NULL, NULL, SUM(Salary) AS TotalSalary FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/cube-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/cube-in-sql-server_22.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: 64485 kudvenkat
Predictive Analytics with R Server and SQL Server 2016
 
01:01:44
They key to optimizing any business is to match demand with supply. Using Microsoft R Server and SQL Server 2016 we can forecast NYC taxi demand using the freely available NYC taxi data for the year 2013. Watch as we use the power of the R programming language in conjunction with Microsoft SQL Server 2016 to transform and prepare large amounts of data into a format that is ideal for building and deploying a predictive forecasting model.
Views: 23353 Pragmatic Works
Phantom reads example in sql server
 
06:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/phantom-reads-example-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/phantom-reads-example-in-sql-server_18.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 In this video we will discuss phantom read concurrency problem with examples. Phantom read happens when one transaction executes a query twice and it gets a different number of rows in the result set each time. This happens when a second transaction inserts a new row that matches the WHERE clause of the query executed by the first transaction. We will use the following table tblEmployees in this demo Scrip to create the table tblEmployees Create table tblEmployees ( Id int primary key, Name nvarchar(50) ) Go Insert into tblEmployees values(1,'Mark') Insert into tblEmployees values(3, 'Sara') Insert into tblEmployees values(100, 'Mary') Transaction 1 starts first. Reads from Emp table where Id between 1 and 3. 2 rows retrieved for first read. Transaction 1 is doing some work and at this point Transaction 2 starts and inserts a new employee with Id = 2. Transaction 1 then makes a second read. 3 rows retrieved for second read, resulting in phantom read problem. Phantom read example : Open 2 instances of SQL Server Management studio. From the first window execute Transaction 1 code and from the second window, execute Transaction 2 code. Notice that when Transaction 1 completes, it gets different number of rows for read 1 and read 2, resulting in phantom read. -- Transaction 1 Begin Transaction Select * from tblEmployees where Id between 1 and 3 -- Do Some work waitfor delay '00:00:10' Select * from tblEmployees where Id between 1 and 3 Commit Transaction -- Transaction 2 Insert into tblEmployees values(2, 'Marcus') Serializable or any other higher isolation level should solve the phantom read problem. Fixing phantom read concurrency problem : To fix the phantom read problem, set transaction isolation level of Transaction 1 to serializable. This will place a range lock on the rows between 1 and 3, which prevents any other transaction from inserting new rows with in that range. This solves the phantom read problem. When you execute Transaction 1 and 2 from 2 different instances of SQL Server management studio, Transaction 2 is blocked until Transaction 1 completes and at the end of Transaction 1, both the reads get the same number of rows. -- Transaction 1 Set transaction isolation level serializable Begin Transaction Select * from tblEmployees where Id between 1 and 3 -- Do Some work waitfor delay '00:00:10' Select * from tblEmployees where Id between 1 and 3 Commit Transaction -- Transaction 2 Insert into tblEmployees values(2, 'Marcus') Difference between repeatable read and serializable Repeatable read prevents only non-repeatable read. Repeatable read isolation level ensures that the data that one transaction has read, will be prevented from being updated or deleted by any other transaction, but it doe not prevent new rows from being inserted by other transactions resulting in phantom read concurrency problem. Serializable prevents both non-repeatable read and phantom read problems. Serializable isolation level ensures that the data that one transaction has read, will be prevented from being updated or deleted by any other transaction. It also prevents new rows from being inserted by other transactions, so this isolation level prevents both non-repeatable read and phantom read problems.
Views: 53463 kudvenkat
Import Data and Analyze with MATLAB
 
09:19
Data are frequently available in text file format. This tutorial reviews how to import data, create trends and custom calculations, and then export the data in text file format from MATLAB. Source code is available from http://apmonitor.com/che263/uploads/Main/matlab_data_analysis.zip
Views: 397668 APMonitor.com
Non repeatable read example in sql server
 
05:45
Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/non-repeatable-read-example-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/non-repeatable-read-example-in-sql_17.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 In this video we will discuss non repeatable read concurrency problem with an example. Non repeatable read problem happens when one transaction reads the same data twice and another transaction updates that data in between the first and second read of transaction one. Transaction 1 starts first. Reads ItemsInStock. Gets a value of 10 for first read. Transaction 1 is doing some work and at this point Transaction 2 starts and UpdatesItemsInStock to 5. Transaction 1 then makes a second read. At this point Transaction 1 gets a value of 5, reulting in non-repeatable read problem. Non-repeatable read example : Open 2 instances of SQL Server Management studio. From the first window execute Transaction 1 code and from the second window, execute Transaction 2 code. Notice that when Transaction 1 completes, it gets different values for read 1 and read 2, resulting in non-repeatable read. -- Transaction 1 Begin Transaction Select ItemsInStock from tblInventory where Id = 1 -- Do Some work waitfor delay '00:00:10' Select ItemsInStock from tblInventory where Id = 1 Commit Transaction -- Transaction 2 Update tblInventory set ItemsInStock = 5 where Id = 1 Repeatable read or any other higher isolation level should solve the non-repeatable read problem. Fixing non repeatable read concurrency problem : To fix the non-repeatable read problem, set transaction isolation level of Transaction 1 to repeatable read. This will ensure that the data that Transaction 1 has read, will be prevented from being updated or deleted elsewhere. This solves the non-repeatable read problem. When you execute Transaction 1 and 2 from 2 different instances of SQL Server management studio, Transaction 2 is blocked until Transaction 1 completes and at the end of Transaction 1, both the reads get the same value for ItemsInStock. -- Transaction 1 Set transaction isolation level repeatable read Begin Transaction Select ItemsInStock from tblInventory where Id = 1 -- Do Some work waitfor delay '00:00:10' Select ItemsInStock from tblInventory where Id = 1 Commit Transaction -- Transaction 2 Update tblInventory set ItemsInStock = 5 where Id = 1
Views: 54185 kudvenkat
SQL Server Programming Part 6 - WHILE Loops
 
14:48
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - In SQL Server there is only one type of loop: a WHILE loop. This video teaches you how to use them, from the basic syntax of the WHILE statement, through how to use a SELECT statement within a loop. We'll also cover how to use the BREAK command to exit from a loop, what to do when you inevitably find yourself in an endless loop and, finally, a quick introduction to using loops with cursors. You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 77563 WiseOwlTutorials
SQL Server deadlock analysis and prevention
 
08:58
sql server deadlock analysis read sql server deadlock log Read and analyze sql server deadlock log Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-deadlock-analysis-and.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-deadlock-analysis-and_28.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 In this video we will discuss how to read and analyze sql server deadlock information captured in the error log, so we can understand what's causing the deadlocks and take appropriate actions to prevent or minimize the occurrence of deadlocks. This is continuation to Part 80. Please watch Part 80 from SQL Server tutorial before proceeding. The deadlock information in the error log has three sections 1. Deadlock Victim - Contains the ID of the process that was selected as the deadlock victim and killed by SQL Server. 2. Process List - Contains the list of the processes that participated in the deadlock. 3. Resource List - Contains the list of the resources (database objects) owned by the processes involved in the deadlock. Process List : The process list has lot of items. Here are some of them that are particularly useful in understanding what caused the deadlock. loginname : The loginname associated with the process isolationlevel : What isolation level is used procname: The stored procedure name Inputbuf: The code the process is executing when the deadlock occured Resource List : Some of the items in the resource list that are particularly useful in understanding what caused the deadlock. objectname : Fully qualified name of the resource involved in the deadlock owner-list : Contains (owner id) the id of the owning process and the lock mode it has acquired on the resource. lock mode determines how the resource can be accessed by concurrent transactions. S for Shared lock, U for Update lock, X for Exclusive lock etc. waiter-list : Contains (waiter id) the id of the process that wants to acquire a lock on the resource and the lock mode it is requesting. To prevent the deadlock that we have in our case, we need to ensure that database objects (Table A & Table B) are accessed in the same order every time.
Views: 49484 kudvenkat
SQL Server 2016 Part 5 - Basic Table Design, Data Types and Constraints
 
46:46
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Designing basic tables in SQL Server involves deciding which columns the table should include, what the data type of those columns should be (not always an easy choice!) and a few additional properties such as whether the column can be left empty (or NULL) and whether there should be any constraints on the values entered into the column. This video takes you through that process to design and create a simple table to store information about people. The video contains a discussion of the main text, number and date data types in SQL Server - you'll learn the difference between char, varchar, nchar and nvarchar data types, as well as the difference between exact and approximate numerics. The video also covers the basics of inserting and editing data before the final part shows how to automatically generate scripts that will recreate the table and its precious data in the event that you delete it. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
Views: 23590 WiseOwlTutorials
How to Build a Text Mining, Machine Learning Document Classification System in R!
 
26:02
We show how to build a machine learning document classification system from scratch in less than 30 minutes using R. We use a text mining approach to identify the speaker of unmarked presidential campaign speeches. Applications in brand management, auditing, fraud detection, electronic medical records, and more.
Views: 167186 Timothy DAuria
Capturing deadlocks in sql profiler
 
10:21
deadlock graph sql server 2008 how can you get a deadlock graph from sql server sql server profiler deadlock graphs sql server deadlock graph xml how to read deadlock graph deadlock graph analysis deadlock graph analyze analyze deadlock graph sql server Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/capturing-deadlocks-in-sql-profiler.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/capturing-deadlocks-in-sql-profiler_29.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 In this video we will discuss how to capture deadlock graph using SQL profiler. To capture deadlock graph, all you need to do is add Deadlock graph event to the trace in SQL profiler. Here are the steps : 1. Open SQL Profiler 2. Click File - New Trace. Provide the credentials and connect to the server 3. On the general tab, select "Blank" template from "Use the template" dropdownlist 4. On the "Events Selection" tab, expand "Locks" section and select "Deadlock graph" event 5. Finally click the Run button to start the trace 6. At this point execute the code that causes deadlock 7. The deadlock graph should be captured in the profiler The deadlock graph data is captured in XML format. If you want to extract this XML data to a physical file for later analysis, you can do so by following the steps below. 1. In SQL profiler, click on "File - Export - Extract SQL Server Events - Extract Deadlock Events" 2. Provide a name for the file 3. The extension for the deadlock xml file is .xdl 4. Finally choose if you want to export all events in a single file or each event in a separate file The deadlock information in the XML file is similar to what we have captured using the trace flag 1222. Analyzing the deadlock graph 1. The oval on the graph, with the blue cross, represents the transaction that was chosen as the deadlock victim by SQL Server. 2. The oval on the graph represents the transaction that completed successfully. 3. When you move the mouse pointer over the oval, you can see the SQL code that was running that caused the deadlock. 4. The oval symbols represent the process nodes a) Server Process Id : If you are using SQL Server Management Studio you can see the server process id on information bar at the bottom. b) Deadlock Priority : If you have not set DEADLOCK PRIORITY explicitly using SET DEADLOCK PRIORITY statement, then both the processes should have the same default deadlock priority NORMAL (0). c) Log Used : The transaction log space used. If a transaction has used a lot of log space then the cost to roll it back is also more. So the transaction that has used the least log space is killed and rolled back. 5. The rectangles represent the resource nodes. a) HoBt ID : Heap Or Binary Tree ID. Using this ID query sys.partitions view to find the database objects involved in the deadlock. SELECT object_name([object_id]) FROM sys.partitions WHERE hobt_id = 72057594041663488 6. The arrows represent types of locks each process has on each resource node.
Views: 47449 kudvenkat
IIF function in SQL Server
 
04:00
iif function in sql server 2012 iif function in sql server example sql server iif function example In this video we will discuss IIF function in SQL Server. IIF function Introduced in SQL Server 2012 Returns one of two the values, depending on whether the Boolean expression evaluates to true or false IIF is a shorthand way for writing a CASE expression Syntax : IIF ( boolean_expression, true_value, false_value ) Example : Returns Male as the boolean expression evaluates to TRUE DECLARE @Gender INT SET @Gender = 1 SELECT IIF( @Gender = 1, 'Male', 'Femlae') AS Gender Example : Using IIF() function with table data. We will use the following Employees table for this example. SQL Script to create Employees table Create table Employees ( Id int primary key identity, Name nvarchar(10), GenderId int ) Go Insert into Employees values ('Mark', 1) Insert into Employees values ('John', 1) Insert into Employees values ('Amy', 2) Insert into Employees values ('Ben', 1) Insert into Employees values ('Sara', 2) Insert into Employees values ('David', 1) Go Write a query to display Gender along with employee Name and GenderId. We can achieve this either by using CASE or IIF. Using CASE statement SELECT Name, GenderId, CASE WHEN GenderId = 1 THEN 'Male' ELSE 'Female' END AS Gender FROM Employees Using IIF function SELECT Name, GenderId, IIF(GenderId = 1, 'Male', 'Female') AS Gender FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/iif-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/iif-function-in-sql-server_14.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: 36352 kudvenkat
Window functions in SQL Server
 
11:00
sql server window function example window function sql server example sql server rows range clause sql server rows between 1 preceding and 1 following In this video we will discuss window functions in SQL Server In SQL Server we have different categories of window functions Aggregate functions - AVG, SUM, COUNT, MIN, MAX etc.. Ranking functions - RANK, DENSE_RANK, ROW_NUMBER etc.. Analytic functions - LEAD, LAG, FIRST_VALUE, LAST_VALUE etc... OVER Clause defines the partitioning and ordering of a rows (i.e a window) for the above functions to operate on. Hence these functions are called window functions. The OVER clause accepts the following three arguments to define a window for these functions to operate on. ORDER BY : Defines the logical order of the rows PARTITION BY : Divides the query result set into partitions. The window function is applied to each partition separately. ROWSor RANGE clause : Further limits the rows within the partition by specifying start and end points within the partition. The default for ROWS or RANGE clause is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW Let us understand the use of ROWS or RANGE clause with an example. Compute average salary and display it against every employee We might think the following query would do the job. SELECT Name, Gender, Salary, AVG(Salary) OVER(ORDER BY Salary) AS Average FROM Employees As you can see from the result, the above query does not produce the overall salary average. It produces the average of the current row and the rows preceeding the current row. This is because, the default value of ROWS or RANGE clause (RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) is applied. To fix this, provide an explicit value for ROWS or RANGE clause as shown below. ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING tells the window function to operate on the set of rows starting from the first row in the partition to the last row in the partition. SELECT Name, Gender, Salary, AVG(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Average FROM Employees The same result can also be achieved by using RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING Well, what is the difference between ROWS and RANGE We will discuss this in a later video The following query can be used if you want to compute the average salary of 1. The current row 2. One row PRECEDING the current row and 3. One row FOLLOWING the current row SELECT Name, Gender, Salary, AVG(Salary) OVER(ORDER BY Salary ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS Average FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/window-functions-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/window-functions-in-sql-server_7.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: 65544 kudvenkat
How to Connect to SQL Server with Python Via ODBC
 
01:46
How to Connect to SQL Server with Python Via ODBC
Views: 16764 Edward Lara
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA
 
11:34
Create Report in Seconds by Fetching Data from SQL Server using Excel VBA If your manager needs the report very frequently then you need to do the same task again and again. Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager. Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel. You can read our blog to go through instructions as well as download working and code files, Click here: http://yodalearning.com/tutorials/export-data-from-sql-to-excel-spreadsheet-using-vba/ You can enroll in our Excel VBA course: http://courses.yodalearning.com/p/excel-vba-tutorials CHECK SOME OF THE FREE COURSES WE OFFER http://courses.yodalearning.com/p/free-office-2016-tips Keep yourself updated. Follow us now! http://www.facebook.com/yodalearning http://www.twitter.com/yodalearning
Views: 101599 Yoda Learning Official
SQL Server Queries Part 1 - Writing Basic Queries
 
16:36
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Learn how to write basic queries in Microsoft SQL Server. This video teaches you the absolute basics of the SELECT and FROM statements using SQL Server Management Studio, including how to use aliases to refer to fields. You can view a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s289/getting_started_with_sql_queries.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 611428 WiseOwlTutorials
Rollup in SQL Server
 
09:01
sql server group by rollup sql server 2008 group by rollup group by with rollup example sql rollup example sql server rollup example sql server 2008 rollup examples rollup clause in sql server rollup function in sql server ROLLUP in SQL Server is used to do aggregate operation on multiple levels in hierarchy. Let us understand Rollup in SQL Server with examples. We will use the following Employees table for the examples in this video. Retrieve Salary by country along with grand total There are several ways to achieve this. The easiest way is by using Rollup with GroupBy. SELECT Country, SUM(Salary) AS TotalSalary FROM Employees GROUP BY ROLLUP(Country) The above query can also be rewritten as shown below SELECT Country, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country WITH ROLLUP We can also use UNION ALL operator along with GROUP BY SELECT Country, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country UNION ALL SELECT NULL, SUM(Salary) AS TotalSalary FROM Employees We can also use Grouping Sets to achieve the same result SELECT Country, SUM(Salary) AS TotalSalary FROM Employees GROUP BY GROUPING SETS ( (Country), () ) Let's look at another example. Group Salary by Country and Gender. Also compute the Subtotal for Country level and Grand Total as shown below. Using ROLLUP with GROUP BY SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY ROLLUP(Country, Gender) OR SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country, Gender WITH ROLLUP Using UNION ALL with GROUP BY SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country, Gender UNION ALL SELECT Country, NULL, SUM(Salary) AS TotalSalary FROM Employees GROUP BY Country UNION ALL SELECT NULL, NULL, SUM(Salary) AS TotalSalary FROM Employees Using GROUPING SETS SELECT Country, Gender, SUM(Salary) AS TotalSalary FROM Employees GROUP BY GROUPING SETS ( (Country, Gender), (Country), () ) Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/rollup-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/rollup-in-sql-server_20.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: 60017 kudvenkat
sql server trigger execution order
 
06:43
sql server set trigger order sp_settriggerorder in sql server sp_settriggerorder example exec sp_settriggerorder In this video we will discuss how to set the execution order of triggers using sp_settriggerorder stored procedure. Server scoped triggers will always fire before any of the database scoped triggers. This execution order cannot be changed. In the example below, we have a database-scoped and a server-scoped trigger handling the same event (CREATE_TABLE). When you create a table, notice that server-scoped trigger is always fired before the database-scoped trigger. CREATE TRIGGER tr_DatabaseScopeTrigger ON DATABASE FOR CREATE_TABLE AS BEGIN Print 'Database Scope Trigger' END GO CREATE TRIGGER tr_ServerScopeTrigger ON ALL SERVER FOR CREATE_TABLE AS BEGIN Print 'Server Scope Trigger' END GO Using the sp_settriggerorder stored procedure, you can set the execution order of server-scoped or database-scoped triggers. sp_settriggerorder stored procedure has 4 parameters @triggername - Name of the trigger @order - value can be First, Last or None. When set to None, trigger is fired in random order @stmttype - SQL statement that fires the trigger. Can be INSERT, UPDATE, DELETE or any DDL event @namespace - Scope of the trigger. Value can be DATABASE, SERVER, or NULL EXEC sp_settriggerorder @triggername = 'tr_DatabaseScopeTrigger1', @order = 'none', @stmttype = 'CREATE_TABLE', @namespace = 'DATABASE' GO If you have a database-scoped and a server-scoped trigger handling the same event, and if you have set the execution order at both the levels. Here is the execution order of the triggers. 1. The server-scope trigger marked First 2. Other server-scope triggers 3. The server-scope trigger marked Last 4. The database-scope trigger marked First 5. Other database-scope triggers 6. The database-scope trigger marked Last Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/sql-server-trigger-execution-order.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/sql-server-trigger-execution-order_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 Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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: 30151 kudvenkat
Introduction to  spatial queries  in SQL Server 2012
 
30:01
The amount of spatial data captured in databases is increasing exponentially. This includes data from mobile phones, GPS units through to home detention bracelets. Typically these devices capture location information in the form of latitudes and longitudes. The spatial capabilities of SQL Server has been significantly enhanced with the release of Microsoft SQL Server 2012. SQL now has some of the best spatial functionality of all the mainstream databases. Spatial queries use different syntax to the T-SQL that traditional queries use. This tutorial will provide an introduction to creating spatial queries that perform tasks such as - Viewing shapes within SQL Server. - Calculating the length of direct and indirect routes. - Area of shapes such as polygons or buffered points - Whether coordinates fall within a a predefined area such as a polygon, circle or buffered line string. Demonstration files are available from my website (link provided in video). I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF
Views: 33156 Steve Fox
How to Import a Flat Text File Using SSIS 2012
 
14:54
This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here: http://www.learnitfirst.com/Course170 In this video, Instructor Scott Whigham will explain what a Flat Text File is, why it is important for sharing data between programs, and show you step by step of how to import a Flat Text File using the SQL Server Import and Export Wizard in SQL Server Management Studio. Highlights from this video: - Step by step importing a Flat File into SSMS with the Import and Export Wizard - What is a "Flat File," and what is the benefit of using one? - Setting the row and column delimiters - Will the Import and Export Wizard infer a primary key in a Flat Text File or Excel File? - What is a text qualifier? and much more...
Views: 57865 LearnItFirst.com
sql server lost update problem
 
08:29
Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-lost-update-problem.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-lost-update-problem_16.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 In this video we will discuss, lost update problem in sql server with an example. Lost update problem happens when 2 transactions read and update the same data. Let's understand this with an example. Consider the following 2 transactions - Transaction 1 and Transaction 2. Transaction 1 starts first, and it is processing an order for 1 iPhone. It sees ItemsInStock as 10. At this time Transaction 2 is processing another order for 2 iPhones. It also sees ItemsInStock as 10. Transaction 2 makes the sale first and updates ItemsInStock with a value of 8. At this point Transaction 1 completes the sale and silently overwrites the update of Transaction 2. As Transaction 1 sold 1 iPhone it has updated ItemsInStock to 9, while it actually should have updated it to 7. Example : The lost update problem example. Open 2 instances of SQL Server Management studio. From the first window execute Transaction 1 code and from the second window, execute Transaction 2 code. Transaction 1 is processing an order for 1 iPhone, while Transaction 2 is processing an order for 2 iPhones. At the end of both the transactions ItemsInStock must be 7, but we have a value of 9. This is because Transaction 1 silently overwrites the update of Transaction 2. This is called the lost update problem. -- Transaction 1 Begin Tran Declare @ItemsInStock int Select @ItemsInStock = ItemsInStock from tblInventory where Id=1 -- Transaction takes 10 seconds Waitfor Delay '00:00:10' Set @ItemsInStock = @ItemsInStock - 1 Update tblInventory Set ItemsInStock = @ItemsInStock where Id=1 Print @ItemsInStock Commit Transaction -- Transaction 2 Begin Tran Declare @ItemsInStock int Select @ItemsInStock = ItemsInStock from tblInventory where Id=1 -- Transaction takes 1 second Waitfor Delay '00:00:1' Set @ItemsInStock = @ItemsInStock - 2 Update tblInventory Set ItemsInStock = @ItemsInStock where Id=1 Print @ItemsInStock Commit Transaction Both Read Uncommitted and Read Committed transaction isolation levels have the lost update side effect. Repeatable Read, Snapshot, and Serializable isolation levels does not have this side effect. If you run the above Transactions using any of the higher isolation levels (Repeatable Read, Snapshot, or Serializable) you will not have lost update problem. The repeatable read isolation level uses additional locking on rows that are read by the current transaction, and prevents them from being updated or deleted elsewhere. This solves the lost update problem. For both the above transactions, set Repeatable Read Isolation Level. Run Transaction 1 first and then a few seconds later run Transaction 2. Transaction 1 completes successfully, but Transaction 2 competes with the following error. Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Once you rerun Transaction 2, ItemsInStock will be updated correctly as expected.
Views: 58887 kudvenkat
SQL Server Integration Services (SSIS) Part 15 - Script Components
 
19:06
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andy Brown https://www.wiseowl.co.uk - This tutorial explains how you can create script components to validate and transform data within data flow tasks in Integration Services. The tutorial uses C# as its programming language, but includes how to find the script in Visual Basic. If you like the style of this video (but agree with us that classroom training is more effective) have a look at our classroom-based training courses at www.wiseowl.co.uk. These include a two-day SSIS course, as well as courses in Reporting Services and Analysis Services.
Views: 48174 WiseOwlTutorials
SQL Server Queries Part 5 - CASE Expressions
 
07:48
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Learn how to use CASE expressions in queries in Microsoft SQL Server. This video teaches you how to test conditions using a CASE expression and provide different answers based on whether the conditions are met. A written version of this tutorial can be found at: https://www.wiseowl.co.uk/blog/s330/case-when.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 126277 WiseOwlTutorials
SQL Server deadlock analysis and prevention in arabic
 
16:02
Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-deadlock-analysis-and.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/sql-server-deadlock-analysis-and_28.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 Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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: 251 kudvenkat.arabic
สอน Data Mining: การติดตั้ง SQL Server 2014 และ Analysis Services
 
11:11
สอนวิธีการติดตั้ง Microsoft SQL Server 2014 และ Analysis Services ==ดาวน์โหลด SQL Server 2014 (Evaluation) ได้ที่ https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014
Views: 6097 prasertcbs
SQL Server Programming Part 13 - Dynamic SQL
 
27:41
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Dynamic SQL allows you to build a complete statement out of individual strings of text and execute it as though it was an SQL statement. It allows you to create immensely flexible queries in which any part of a statement can be parameterised but it can also leave you vulnerable to the dreaded SQL injection attack! This video teaches you how to build dynamic SQL statements, how to use stored procedures to parameterise the process, and the potential dangers of using dynamic SQL in a live system. You can view a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s363/dynamic-sql.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip For more information on SQL injection attacks and how to prevent them you can't do better than Erland Sommarskog's definitive article: http://www.sommarskog.se/dynamic_sql.html For a geeky joke about dynamic SQL see XKCD: https://xkcd.com/327/ You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 63242 WiseOwlTutorials
SQL Server 2008 - Enabling Full Text Search
 
01:46
This is a clip from Collection 2778B: Querying and Modifying Data in Microsoft SQL Server 2008 with Transact-SQL. Visit http://www.cblearning.com to view the full course.
Views: 12556 C.B.Learning
Dynamically Bulk Inserting CSV Data Into A SQL Server Table
 
09:55
This video will show you how to load CSV data dynamically using the bulk insert statement. This video will start to show you how you should start working on developing more of an automated system as it will cover concepts such as try catch, dynamic SQL, and general automation. Please let us know if you have any specific questions or videos you would like to see by commenting below! Also, if you want to watch more of our videos on ETL development and design check out the videos below ETL Automation https://youtu.be/OnzBuzRX3FE ETL Design https://youtu.be/sLhInuwdwcc
Views: 1142 Ben R
SQL Server Programming Part 17 - The Pivot Operator
 
13:53
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - The Pivot Operator in Microsoft SQL Server allows you to group data by columns, as well as by rows, to create simple static pivot tables. This video teaches you how to use the pivot operator including how to apply aggregate functions and, importantly, a quick method for listing out the column headings of your pivot table using the QuoteName function. You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can view a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s417/pivoting-sql-data.htm You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 44725 WiseOwlTutorials
SQL Server Programming Part 3 - Variables
 
19:08
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Using variables allows you to give your SQL procedures a memory. You can store a value in a variable and then retrieve and reuse that value at any point later in the same procedure. This video teaches you how to declare variables, assign values to them and make use of those values in a query. You'll also see how to store the result of a SELECT statement in a variable, as well as how to accumulate the value of a variable. You'll see a couple of methods of displaying the value stored in a variable and we'll end with a quick overview of the global variables in SQL Server. SQL variables are explained in written form here: https://www.wiseowl.co.uk/blog/s333/sql-variable.htm Global variables are explained in more detail on this page: https://www.wiseowl.co.uk/blog/s338/global-variables.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 107206 WiseOwlTutorials
Fuzzy Lookups (Matching) and Fuzzy Grouping using Microsoft Integration Services  (SSIS)
 
15:51
Fuzzy Lookups (Matching) and Fuzzy Grouping are powerful techniques to quantify how similar text is. This allows you to do tasks such as checking whether a person in a leads list is already a customer (using a Fuzzy Lookup)), or whether multiple names in a list are actually the same person (Fuzzy Grouping). This tutorial will demonstrate how to perform both a Fuzzy Lookup and Fuzzy Grouping within Microsoft Integration Services (SSIS) As a special offer, I am also offering those that watch this tutorial a 50% OFF coupon ( ANALYTICS50%OFF ) for my Transact SQL course on Udemy. The course can be found at https://www.udemy.com/t-sql-for-data-analysts/
Views: 12496 Steve Fox
SQL Server Programming Part 8 - Temporary Tables
 
13:27
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - There are many techniques in SQL Server for working with temporary data: this video deals with Temporary Tables (you know, the ones that begin with a #). You'll learn how to create and remove temporary tables, where they live during their short lifespans, how to extend their scope by using global temp tables, and how you can use temporary tables within stored procedures. You can find a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s183/temporary-tables-sql.htm You can download the script used to create the Movies database used in this video at: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 53898 WiseOwlTutorials
SQL Server Programming Part 11 - Common Table Expressions (CTEs)
 
08:49
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - A Common Table Expression in SQL is a technique for creating a temporary recordset that you immediately use in another statement - they're often a neat alternative to using Temporary Tables. In this video we'll teach you how to create and consume a CTE, show you a couple of practical uses for them and hopefully convince you that they're worth using! You can see a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s184/cte-sql.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 42547 WiseOwlTutorials
Read committed snapshot isolation level in sql server
 
06:58
Text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/read-committed-snapshot-isolation-level.html Slides http://csharp-video-tutorials.blogspot.com/2015/08/read-committed-snapshot-isolation-level_20.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 In this video we will discuss Read committed snapshot isolation level in sql server. This is continuation Part 75. Please watch Part 75 from SQL Server tutorial before proceeding. Read committed snapshot isolation level is not a different isolation level. It is a different way of implementing Read committed isolation level. One problem we have with Read Committed isloation level is that, it blocks the transaction if it is trying to read the data, that another transaction is updating at the same time. The following example demonstrates the above point. Open 2 instances of SQL Server Management studio. From the first window execute Transaction 1 code and from the second window execute Transaction 2 code. Notice that Transaction 2 is blocked until Transaction 1 is completed. --Transaction 1 Set transaction isolation level Read Committed Begin Transaction Update tblInventory set ItemsInStock = 5 where Id = 1 waitfor delay '00:00:10' Commit Transaction -- Transaction 2 Set transaction isolation level read committed Begin Transaction Select ItemsInStock from tblInventory where Id = 1 Commit Transaction We can make Transaction 2 to use row versioning technique instead of locks by enabling Read committed snapshot isolation at the database level. Use the following command to enable READ_COMMITTED_SNAPSHOT isolation Alter database SampleDB SET READ_COMMITTED_SNAPSHOT ON Please note : For the above statement to execute successfully all the other database connections should be closed. After enabling READ_COMMITTED_SNAPSHOT, execute Transaction 1 first and then Transaction 2 simultaneously. Notice that the Transaction 2 is not blocked. It immediately returns the committed data that is in the database before Transaction 1 started. This is because Transaction 2 is now using Read committed snapshot isolation level. Let's see if we can achieve the same thing using snapshot isolation level instead of read committed snapshot isolation level. Step 1 : Turn off READ_COMMITTED_SNAPSHOT Alter database SampleDB SET READ_COMMITTED_SNAPSHOT OFF Step 2 : Enable snapshot isolation level at the database level Alter database SampleDB SET ALLOW_SNAPSHOT_ISOLATION ON Step 3 : Execute Transaction 1 first and then Transaction 2 simultaneously. Just like in the previous example, notice that the Transaction 2 is not blocked. It immediately returns the committed data that is in the database before Transaction 1 started. --Transaction 1 Set transaction isolation level Read Committed Begin Transaction Update tblInventory set ItemsInStock = 5 where Id = 1 waitfor delay '00:00:10' Commit Transaction -- Transaction 2 Set transaction isolation level snapshot Begin Transaction Select ItemsInStock from tblInventory where Id = 1 Commit Transaction So what is the point in using read committed snapshot isolation level over snapshot isolation level. There are some differences between read committed snapshot isolation level and snapshot isolation level. We will discuss these in our next video.
Views: 47668 kudvenkat
Text Mining - Using OAuth with Rapidminer
 
14:27
Walks through how to connect to Twitter over OAuth and fetch live FIFA feeds based on a query term using Search API from Twitter with rapidminer.
Views: 2645 Sean c
SQL Server Queries Part 2 - ORDER BY (Sorting in Queries)
 
05:56
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Learn how to sort the results of queries in Microsoft SQL Server. This video teaches you how to use the ORDER BY clause to change the order of your query results, including how to sort by multiple fields and how to select the top 10 items in a list. You can view a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s290/sorting_sql_query_results.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 152823 WiseOwlTutorials
David Itzhak:  Practical SQL 2014 Data Mining and introduction to R
 
01:22:58
Microsoft have acquired Revolution Analytics in order to help customers to find their "Big Data" value. Revolution Analytics is the leading commercial provider of software and services for R, the world’s most widely used programming language for statistical computing and predictive analytics. R will be integrated to SQL 2016 BI. I will give introduction to R and the advantages it gives to Microsoft Data Mining. • An introduction to data mining • SQL Server Data Tools (SSDT) Installations • Demo : Creating a data mining solution with Microsoft association rules • DEMO : Decision Trees example- In short • Prediction with MDX queries , No need to know the syntax . • Identifying Data Patterns – Predictive Models in SSAS
Regular Expressions (Regex) Tutorial: How to Match Any Pattern of Text
 
37:55
In this regular expressions (regex) tutorial, we're going to be learning how to match patterns of text. Regular expressions are extremely useful for matching common patterns of text such as email addresses, phone numbers, URLs, etc. Almost every programming language has a regular expression library, so learning regular expressions with not only help you with finding patterns in your text editors, but also you'll be able to use these programming libraries to search for patterns programmatically as well. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Regular-Expressions Python Regex Tutorial: https://youtu.be/K8L6KVGG-7o ✅ Support My Channel Through Patreon: https://www.patreon.com/coreyms ✅ Become a Channel Member: https://www.youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g/join ✅ One-Time Contribution Through PayPal: https://goo.gl/649HFY ✅ Cryptocurrency Donations: Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3 Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33 Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot ✅ Corey's Public Amazon Wishlist http://a.co/inIyro1 ✅ Equipment I Use and Books I Recommend: https://www.amazon.com/shop/coreyschafer ▶️ You Can Find Me On: My Website - http://coreyms.com/ My Second Channel - https://www.youtube.com/c/coreymschafer Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Instagram - https://www.instagram.com/coreymschafer/
Views: 251983 Corey Schafer
SQL Server Queries Part 11 - Subqueries
 
08:51
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - The idea of a subquery is pretty simple: it's just one query nested inside another. If that doesn't sound particularly useful then you should watch this video to find out why it is! You'll learn how to place a subquery in a SELECT list or a WHERE clause, how to add criteria to a subquery, and how to handle subqueries which return multiple values. You can view a written version of this tutorial here: https://www.wiseowl.co.uk/blog/s339/subquery.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 92823 WiseOwlTutorials
SQL Server Programming Part 16 - DDL Triggers
 
20:18
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - Triggers are special stored procedures that you can attach to various events within a database. This video covers DDL, or Data Definition Language triggers, which you can use to handle events associated with changing the objects in a datatbase. This video concentrates on creating triggers to handle the CREATE, ALTER and DROP events and will show you how to scope a trigger to a single database or to an entire server. You'll also see how to disable and enable triggers, as well as how to change the order in which your triggers fire. You can see a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s388/sql-triggers.htm You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 45221 WiseOwlTutorials