Monthly Archives: August 2012

55 posts

Taking In Command-Line Arguments In a .NET Console Application

Command-line arguments are a staple of most programming and scripting languages. In a strictly shell based environment, this type of project will function like a normal command-line executable, and can both show help messages on usage as well as take in varying input from the user. There are some exceptions and some caveats, such as whether the file-name of the executable is the first member of the argument array, or what system parameters might be passed in and available for use. Improper array checking is also common, and often leads to complete program halt rather than a recoverable error. In this video, I will show you how to create a simple program that will take any number of command line arguments, and different ways of solving the validation problem.

Connecting to a Microsoft SQL Server Using The Visual Studio 2008 Designer

An inherently powerful feature in Visual Studio is the ability to create a SQL connection and manipulate data in the same fashion as adding components and controls to a project. There is some debate on whether this method is better or worse than interacting strictly via the code, but it is an important feature that developers should know about, should they wish to use it. In this video, I will use a sample database and table previously created, and show you how to create a SQL connection from scratch, a common error encountered during the process, and how to visually manipulate the data directly from your Windows Forms application, without the need for an external editor or administration tool.

Installing SQL Server 2008 Management Studio

SQL Server Express is installed by default along with Visual Studio, which saves developers a lot of time in choosing an appropriate relational database platform. It also exposes most of the concepts one will find in comparable products, and for using a Structured Query Language in general. This means that developers do not have to re-learn fundamental concepts when switching to other technologies such as Oracle and MySQL. There is, however, one thing that is missing by default, and that is a administration option using a graphical tool that most DBA's are familiar with. This can lead to frustrating debugging sessions and more. In this video, I will show you where to get the SQL Server 2008 Management Studio installer, and how to navigate a somewhat unintuitive installation process. From there, I will show you how to view and edit data contained in one of the tables.

.NET 3.5/WPF Creating A Splash Screen

Most users are familiar with the concept of a ‘splash screen’, a graphic that displays while the program is still loading, and goes away when the loading is complete. It was previously quite complicated to add a splash screen to a .NET application, but luckily .NET 3.5 and above introduce […]

Introduction to Spatial data types in SQL Server

In this article I would introduce you to the new data types added in SQL Server 2008 called as spatial data types and the different terminologies and the structures used in them. Prior to SQL Server 2008 spatial data used be stored in a conventional manner by basically creating  two different […]

VMWare Management : vApps , Resource Pool

This video shows you how to create and configure vApps , which are virtual applications composed of different system: For instance, if you have n tiers applications using a specific server in an Os, a database using another Os, and a syslog server, so you would have 3 OSs and […]

Vmware vSphere Storage vMotion

In this video we are going to explain what is Storage vMotion and to how use this feature. First of all in your storage side you have a LUN which stands for Logical Unit Numbers (similar to volumes) and in your virtual infrastructure side you have datastores that are mapped […]

VMWare vSphere 5 Installation

This video will show you how to install Vmware vsphere 5 hypervisor. The server requirements are minimum 2 CPUs and at least 2 GB of RAM. How to change your default configuration using the DCUI (Direct Control User Interface), changing network configuration, your troubleshooting options which are disabled by default like […]

Restoring Database Backups Differential and Transaction Log Backups, Part 4 of 4

The video is a continuation of the previous part of the series in which we explored how to take differential and full backups and the logic behind the working of these backups. The series will wind up in the next video where we explore how to perform page level restores and how to take file and filegroup backups.

Taking Database Backups Differential and Transaction Log Backups, Part 3 of 4

This next video in the series explores the slightly more advanced concepts when taking database backup. The traditional role of backups is to bring the database back online with as little data loss as possible and this video shows how to achieve this goal. The video explore the different types of backups that are available in addition to the Full database backup that was explored in the previous video.

How to Restore a Database Backup, Part 2 of 4

The video is aimed at the novice DBA and will get more and more detailed as we progress through the series. The next series in the video will cover how to take differential backups and restore them. Each video will build on top of previous videos to comprehensively cover the backup and restore options available within MS SQL Server.

Understanding Database Backups in MS SQL Server 2008 R2, Part 1 of 4

The video is the first of a series of videos on MS SQL Server backup and restore technologies and covers many aspects that need to be considered as part of implementing a successful disaster recovery plan.

Conditional Programming in Objective-C

Conditional programming is a common feature used in all the programming languages. It is used to run through different execution paths based on the states of some parameters. If you have a background in C or C++, you are already familiar with conditional programming syntax for Objective-C, as it's basically a superset of C, and it uses exactly the same syntax.