how-to

Maintaining A SQL Server Database - Maintenance Plans

This video shows you how to create a maintenance plan in SQL Server 2005 to backup and maintain your database. It also shows you how to use choose the right...

1 replies - 2018 views - 07/19/08 by Schalk Neethling in News

Database Scalability

Database is typically the last piece of the puzzle of the scalability problem. There are some common techniques to scale the DB tier.IndexingMake sure...

0 replies - 2167 views - 07/15/08 by riho in News

Efficient Paging in SQL Server 2005

It is a little bit off topic for my blog, but I came across a situation today while at work where I needed to page the results of a stored proc, but at the...

1 replies - 2739 views - 07/10/08 by justin_etheredge in News

.NET LINQ to MSI - Part 1 - Interop

Without any physical data access layer, there's no way to build abstractions on top of it. So, in this part of this series we'll take a look at some very...

0 replies - 1735 views - 06/24/08 by bdesmet in News

Setting Up A WAMP,phpMyAdmin, Wordpress development environment

In this article I will cover getting PHP set-up on Windows, with Apache and MySQL (WAMP). At the end I will also cover how to get phpMyAdmin and Wordpress...

0 replies - 8403 views - 06/18/08 by Schalk Neethling in News

How-To Remote MySQL Database Administration With MySQL GUI tools

In this short article I will demonstrate how you can set-up a user for remote access to your MySQL server. This will allow you to use the array of awesome GUI...

0 replies - 5938 views - 06/18/08 by Schalk Neethling in News

ASP.NET - Preventing SQL Injection Attacks

Consider a simple web application that requires user input in some fields, lets say some search box. Suppose a user types the following string in...

0 replies - 13883 views - 06/18/08 by Schalk Neethling in News