Search results
10/31/2010
Video tutorial
Domain Controller - Course Failover Clustering – Lesson 3
After our first VM have been created, we are going to start the windows server 2008 installation, once we are done with the O.S. we will configure the network adapters and disable the firewall service, which is not necessary in our environment, after this we are going to begin the steps to build our domain controller by using add server roles wizard to add the Active Directory Domain Service.
04/28/2010
Video tutorial
If-exists and Schema tricks-SQL Server
In this video, I am discussing couple of tricks that you need when writing sql code. First, I am going to discuss if-exists. Second, information_schema is important because it contains very helpful information about the tables, columns…
02/19/2010
Online Course
E-learning-Transact-Sql
Online Course: In this course you will learn more about the Transact SQL
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.