MrBool Search
Google Search

Search results
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.
03/31/2014 Video tutorial
Handling exceptions - Oracle PL SQL Course - Lesson 22
This video discusses how to proper handle the messages generated by Oracle when an error happens inside PL/SQL block by using the EXCEPTION clause.
07/29/2013 Video tutorial
Try/Catch Blocks - T-SQL Step by Step Course - Lesson 29
In this video we will discuss try/catch blocks.
02/27/2013 Video tutorial
How to use the select statements on the correct database - T-SQL Step by Step Course - Lesson 6
In this video, we will continue the select statement discussion.
10/28/2011 Article
Nightmare scenarios - Solving the daily basis DBAs problems – Part 2
This article contains a discussion regarding the alternatives to solve specific problems found in a DBAs normal day at work.
10/08/2013 Article
Identifing deadlocks in SQL Server
In this article we will describe the details about dead locks in SQL server DB. Dead lock is one of the important areas where every data base developer should pay more attention.
10/27/2011 Article
A talk about problematic situations - Solving the daily basis DBAs problems - Part 1
This article contains a discussion regarding the alternatives to solve specific problems found in a DBAs normal day at work
11/22/2013 Article
SQL Data Generator
In this article, we can take a general idea of how we can prepare SQL Server Data Generator to produce information.
06/04/2014 Video tutorial
Managing dependencies - Oracle PL SQL Course - Lesson 35
This video explain the scenarios and situations where object dependency is an issue in Oracle and provide some examples that show how an object can be invalid because of a broken chain on dependency.
12/18/2013 Article
Stored Procedures in SQL
Stored procedures are one of the important areas in database programming. In this article we will discuss about different areas of stored procedure in details.
10/31/2010 Video tutorial
Installing MSCS - Course Failover Clustering – Lesson 8
Now that we have our shared disks in place we are going to install Microsoft Cluster Service – MSCS
12/13/2013 Article
SQL Custom Data Types
In this article we will discuss about the data persistence for custom data types in SQL databases. We will see how to persist custom data types.
06/07/2013 Article
How to use Packages in Oracle
In this article we are going to learn how we can create, import and export packages in Oracle.
03/30/2015 Article
Stored Procedures and Functions in MySQL with PhpMyAdmin
See this article how to use Stored Procedures and Functions in MySQL using PhpMyAdmin tool, with some real scenarios.
06/17/2013 Article
Concepts of Oracle Database
Today we are going to learn “basics of Oracle” .This is a series of Oracle tutorials in which the first part is Introduction to Oracle for beginners. This first part explains the relational theory on which database are built.
11/11/2011 Article
Populating the database – Part 1
See this article a discussion of alternatives to fill up the database with test data
12/19/2011 Article
Analysis of the WordPress, Joomla, Drupal and Magento data models – Part 1
See in this article an analysis of the data models of the four main platforms used for publishing content on the Web
12/02/2013 Article
Understanding Non-functional testing
Non functional testing is a special type of testing performed to test the non functional requirements like response time, portability, stability etc. In this article we will discuss non functional testing in details.
11/04/2013 Article
How to capture and execute queries in SQL Server
In this article we will see how to capture and execute queries by means of sys.dm_exec_requests in SQL Server
01/30/2014 Article
SQL Server Control Flow Elements
The organize flow in a SSIS wrap up is constructed by using dissimilar types of manages flow elements, just like Pot, Job and Priority constraints. In this article we will discuss about the details of control flow.
11/11/2013 Article
Uses of SQL Desc
In this article we will discuss one of the most important functions in the SQL world. The DESC is known as the description in database system. It is used to know the description of database components.
03/17/2014 Article
What is Disaster Recovery Planning in SQL Server
In this article we will talk about the recovery planning in SQL Server. We will learn what is this and how to use it.
03/14/2014 Article
What is Disaster Recovery Planning in SQL Server
In this article we will talk about the recovery planning in SQL Server. We will learn what is this and how to use it.