Search Results - Mr.Bool

by kind:

All

Articles

Video tutorials

Online Courses

by channel:

All

.net

Java

SQL

Delphi

webDeveloper

02/19/2010 Online Course
E-learning-Transact-Sql
Online Course: In this course you will learn more about the Transact SQL

02/18/2010 Video tutorial
SQL Server-XML-Lesson 9-Using trigger to raise an error when the user tries to delete a customer from the Customers table
In this video, we will use a trigger to raise an error when the user tries to delete a customer from the Customers table.

02/18/2010 Video tutorial
SQL Server-XML-Lesson 8-Grouping sets and triggers
In this video, we discuss grouping sets and triggers.

02/09/2010 Video tutorial
SQL Server-XML-Lesson 7-Using Row_Number(), Rank(), Dense_Rank(), and NTile()
In this video we will see how we can use Row_Number(), Rank(), Dense_Rank(), and NTile().

02/09/2010 Video tutorial
SQL Server-XML-Lesson 6-Using MAXRECURSION with Common Table Expressions (CTE)
In this video we will see how we can use MAXRECUSRSION with Common Table Expressions (CTE).

02/09/2010 Video tutorial
SQL Server-XML-Lesson 5-Using OpenRowSet() and EVENTDATA()
In this video we will see how we can use OpenRowSet() and EVENTDATA().

01/24/2010 Video tutorial
SQL Server-XML-Lesson 4-Using modify() to replace and delete xml data that match an XPath expression
In this video, we continue the discussion of different faces of modify().

01/23/2010 Video tutorial
SQL Server-XML-Lesson 3-Using the XML type, and the methods query(), value(), exist(), modify()
In this video We explore the powerful methods: query(), value(), exist(), and modify().

01/21/2010 Video tutorial
SQL Server-XML-Lesson 2-Adding xmlSchema to ‘for xml’
In this video, we continue our discussion of using XML in SQL Server. We add xmlSchema to ‘for xml’.

01/21/2010 Video tutorial
SQL Server-XML-Lesson 1-Using ‘for xml’, ‘auto’, and ‘raw’ to generate xml from table data
This is our first video of using XML in SQL Server. Support for XML started since SQL Server 2000.

11/24/2009 Video tutorial
The T-SQL Debugger in SQL Server 2008
In this video we will see how to debug a programable object in SQL Server, such as a stored procedure or a user defined funcion.

05/15/2009 Video tutorial
Using traces in SQL Server 2008 without the Profiler
The video uses examples to explain how to create two stored procedure that start and stop a trace via T-SQL commands. The commands inside the stored procedures are explained step by step, showing how to use the system stored procedure to create, starts and stop traces.

05/15/2009 Video tutorial
Tracking data changes with CDC in SQL Server 2008
This video uses examples to explain how to enable and disable the CDC (Change Data Capture) feature of SQL Server 2008.

02/27/2009 Video tutorial
Passing a Table to a Stored Procedure in SQL Server
This video shows us four approaches to overcome the lack of data structures in SQL Server.

02/09/2009 Video tutorial
How to prevent a SQL Injection attack in SQL Server
This video shows how this type of attack exploit simple SELECT statements and stored procedures.

01/31/2009 Video tutorial
E-learning-Developing Custom Activities with Windows Workflow Foundation
In this lesson we are going to take a look at Developing Custom Activities with Windows Workflow Foundation.

01/29/2009 Video tutorial
E-learning-Design Patterns-Understanding more about Behavioral Design Patterns-Lesson 04(End)
In this fourth lesson about design patterns we are going to understand more about Behavioral Design Patterns.

01/29/2009 Video tutorial
E-learning-Installing Sql Server 2008-Lesson 04(End)
In this lesson we will be starting with the selection of the authentication mode, then the data directories.

01/28/2009 Video tutorial
E-learning-Installing Sql Server 2008-Lesson 03
In this lesson we are going to select the features that we are going to install, first we do a brief description of each feature

01/21/2009 Video tutorial
E-learning-Installing Sql Server 2008-Lesson 02
In this lesson you will learn How to Join a computer in the domain and How to Start the Sql Server 2008 installation setup.

01/19/2009 Video tutorial
E-learning-Installing Sql Server 2008-Lesson 01
In this lesson you will learn How to Promote a server to a Domain Controller and How to create a Domain Services accounts.

01/19/2009 Video tutorial
Transform XML Data into Relational Data and How to use OPENXML - XML on SQL Server
In this lesson you will learn How to transform XML Data into Relational Data and How to use OPENXML.

01/10/2009 Video tutorial
An introduction to a free and open source ETL tool
In this video we are going to see how to use a free and open source ETL tool called Kettle on Linux.

12/29/2008 Video tutorial
value() method, the exist() method and the modify() method - XML on SQL Server
In this lesson you will learn how to use the value() method, the exist() method and the modify() method.

12/29/2008 Video tutorial
XML Data Type, Xml Data Type Methods and FLWOR Expressions Clauses - XML on SQL Server
In this lesson you will learn how to retrieve data from XML Data Type, Xml Data Type Methods and FLWOR Expressions Clauses.

12/27/2008 Video tutorial
Introduction to the MySQL locking schema
In this video we will see how the MySQL locking schema works though the explanation of the locking and blocking concepts.

12/27/2008 Video tutorial
FOR XML EXPLICIT - XML on SQL Server
In this lesson you will learn how to retrieve relational data formatted as a XML Fragment using the FOR XML EXPLICIT clause.

12/13/2008 Video tutorial
Creating a clustering environment with MySQL
In this video We will see an explaining the architecture of the cluster and then define the Management SQL

12/04/2008 Video tutorial
Creating a replication with MySQL
The video begins explaining the architecture of the replication and then define the Master and the Slave roles.

11/30/2008 Video tutorial
FOR XML PATH - XML on SQL Server
In this lesson you will learn how to retrieve relational data formatted as a XML Fragment using the FOR XML PATH clause.