Report

Lysender's Daily Log Book




Site Details
Current Rank: 9 (Web Development & Design)
URL: http://blog.lysender.com/
Site Description: Lysender is a full time web developer. Interested on PHP, XHTML, CSS, Javascript, Zend Framework, Kohana, Slackware Linux. Also writes about life and technology.
Date Joined: Jun 29, 2010

Tags: linux, kohana, zend framework, php, jquery


Latest Blog Posts

Kohana and Slackware – PCRE UTF-8 Support
on Oct 28, 2010 in Kohana v3 Linux Slackware kohana and slackware kohana install kohana pcre pcre pcre utf8 php pcre php utf8 slackware and kohana slackware pcre It’s been several months that I’m developing on my Slackware box and one of the PHP framework I’m using is Kohana. I was shocked that when I run the Kohana install test, my system did not pass the requirements. It … Continue r...



SQL Server – Using Temporary Tables
on Oct 23, 2010 in SQL SQL Server group by sql server temporary table sql temporary table temporary table temporary tables The original query was almost perfect – it displays the daily totals for a given month. However, specs changed and they need to add the grand total to the last row. Then another specs for the MAX and MIN rows. … Continue reading →...



SQL Server – Using Temporary Tables
on Oct 23, 2010 in SQL SQL Server group by sql server temporary table sql temporary table temporary table temporary tables The original query was almost perfect – it displays the daily totals for a given month. However, specs changed and they need to add the grand total to the last row. Then another specs for the MAX and MIN rows. … Continue reading →...



SQL Server – Dynamic Order By Clause
on Oct 14, 2010 in SQL SQL Server dynamic order by order by sql dynamic order by sql order by sql server dynamic order by clause Yes, I’m too busy for SQL scripting job these recent weeks. I have a union select query that needed to be sorted per union but since it is not allowed to have order by in my unions, I have to … Continue reading →...



SQL Server – Dynamic Order By Clause
on Oct 14, 2010 in SQL SQL Server dynamic order by order by sql dynamic order by sql order by sql server dynamic order by clause Yes, I’m too busy for SQL scripting job these recent weeks. I have a union select query that needed to be sorted per union but since it is not allowed to have order by in my unions, I have to … Continue reading →...



SQL Server Import/Export to CSV
on Oct 13, 2010 in SQL SQL Server export csv export from csv import csv import from csv sql server export sql server import sql server import csv There are tools that will help you in importing or exporting CSV files to and from SQL Server databases. However, using them will slow you down for a factor of 20 because of those click, next, next, next wizard thing. … Continue reading →...



SQL Server Import/Export to CSV
on Oct 13, 2010 in SQL SQL Server export csv export from csv import csv import from csv sql server export sql server import sql server import csv There are tools that will help you in importing or exporting CSV files to and from SQL Server databases. However, using them will slow you down for a factor of 20 because of those click, next, next, next wizard thing. … Continue reading →...



GIT – Restore Delete Files
on Oct 12, 2010 in GIT git checkout git restore deleted file git restore file git restore from repo I have written before about removing deleted files from a GIT repo. Today, I need to restore deleted files (on working copy) from the repo. This means that the files are in the repo, but are deleted in the working … Continue reading →...



GIT – Restore Delete Files
on Oct 12, 2010 in GIT git checkout git restore deleted file git restore file git restore from repo I have written before about removing deleted files from a GIT repo. Today, I need to restore deleted files (on working copy) from the repo. This means that the files are in the repo, but are deleted in the working … Continue reading →...



SQL Server – Select Nth Row
on Oct 11, 2010 in SQL SQL Server select first record select first row select nth row select second record select second row select third record select third row sql server select nth record sql server select nth row Seems like I’m now stuck with .NET development and the current tasks where developing SQL scripts. One of the spec was to return the first record, second record and third record as columns for a row. I know how to … Continue reading ͛...



Statistics
Unique Visitors Today: 8
Page Views Today: 8
Unique Visitors this Week: 8
Page Views this Week: 8
Unique Visitors this Month: 6,273
Page Views this Month: 7,499
Total Unique Visitors: 252,139
Total Page Views: 287,404
Total Hits Out: 349

Site Traffic