How to install & use TortoiseSVN

TortoiseSVN is a really easy to use Revision control / version control / source control software for Windows. Since it's not an integration for a specific IDE you can use it with whatever development tools you like. TortoiseSVN is free to use. You don't need to get a loan or pay a full years salary to use it. In the following part you will learn how to set up and use TortoiseSVN.

Setting Default Value in Mysql Datetime Column

As you know MySQL datetime column does not accept functions as default values. The workaround is to use triggers. This trigger updates the datetime value to NOW(). This is how it is done:

FPDF Output Methods for PDF Files in PHP

FPDF is a PHP class which allows you to generate PDF files with pure PHP, that is to say without using the PDFlib library. For those who are already familiar with FPDF, this post will show you how to output your PDF file using FPDF. There are 4 methods that you can use according to your own needs:

How to Configure SQL Server 2005/2008 to Accept SQL Authentication?

There are 2 methods of authentication to SQL Server 2005/2008. These are: Windows authentication (default) SQL Server authentication (or mixed authentication). In this article I'm going to show you the 2nd method (SQL Server authentication): In order to use SQL Server authentication you must first configure your server using the steps below.

How to Truncate all the Tables in a Microsoft SQL Database

You can truncate all the tables in a database with the next easy-to-use query:

use [database]
/* where 'database' is the database you want to truncate the tables from */


How to Change The 'Prevent Saving Changes' Option in Microsoft SQL

To change the Prevent saving changes that require the table re-creation option, follow these steps: Open SQL Server Management Studio (SSMS). On the Tools menu, click Options. In the navigation pane of the Options window, click Designers. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

Using PIVOT in Microsoft SQL

In this post I'm going to show you how to use the PIVOT relational operator to change a table-valued expression into another table, as it follows.

Notice that timetable, Room, Days, pvt, Monday, Tuesday etc. are contextual elements that you (should) replace with your own values (see your table's name, collumns etc.)!

First, let me show you how my table normally looks like:

SELECT * FROM timetable