Monthly Archives: December 2012

faster split function

I’ve got to admit.. I have to use SPLIT function like ALL the time in SQL Server. I really have to reccomend this article- it’s behind a FREEWALL , so register and READ THIS ARTICLE!?!?! http://www.sqlservercentral.com/articles/Tally+Table/72993/

Posted in SQL Server | Tagged | Comments Off on faster split function

[Rant] So Oracle has a "One problem per SR" policy… : sysadmin

http://www.reddit.com/r/sysadmin/comments/15ia89/rant_so_oracle_has_a_one_problem_per_sr_policy/?sort=confidence

Posted in SQL Server | Tagged | Comments Off on [Rant] So Oracle has a "One problem per SR" policy… : sysadmin

Why everyone wants a slice of Raspberry Pi

So can I run Windows embedded on raspberry pi device?? http://www.cnn.com/2012/12/21/tech/innovation/raspberry-pi-computer-upton/

Posted in SQL Server | Tagged | Comments Off on Why everyone wants a slice of Raspberry Pi

upsert in SQL Server

Upsert is something that was introduced in SQL 2008 in order to remain competitive with other databases. IF FOUND THEN UPDATE ELSE INSERT; I generally don’t trust it yet- as I’m plenty comfortable with INSERT / UPDATE I prefer those … Continue reading

Posted in SQL Server | Tagged | Comments Off on upsert in SQL Server

What Compsci textbooks don't tell you: Real world code sucks : programming

All I want for Christmas is a mentor . http://www.reddit.com/r/programming/comments/159fjf/what_compsci_textbooks_dont_tell_you_real_world/?sort=confidence

Posted in SQL Server | Tagged | Comments Off on What Compsci textbooks don't tell you: Real world code sucks : programming

fastest disk ever?

So I’ve been using this ‘AMD Ramdisk’ product.. I’m probably going to start using it at home also… http://www.amd.com/us/products/desktop/radeon-memory/Pages/ramdisk-overview.aspx here is a benchmark I Just got from taking a database backup BACKUP DATABASE successfully processed 236395 pages in 3.220 seconds … Continue reading

Posted in SQL Server | Tagged | Comments Off on fastest disk ever?

http://wpcandy.com/reports/automattic-launches-wordpress-com-enterprise/

Five hundred a month really isn’t that expensive!! Long live WordPress!! http://wpcandy.com/reports/automattic-launches-wordpress-com-enterprise/

Posted in SQL Server | Tagged | Comments Off on http://wpcandy.com/reports/automattic-launches-wordpress-com-enterprise/

HTML5 specification finalized

I can’t believe people actually write stuff that hasn’t been spec’ed out yet! http://www.reddit.com/r/programming/comments/1505l4/w3c_finalizes_html5_specification/

Posted in SQL Server | Tagged | Comments Off on HTML5 specification finalized

adp update query with form input

how to build ADP update query with form input 1) create Access Data Project 2) create new form 3) build new stored procedure ‘spStoredProcedure’ create procedure spStoredProcedure ( @Parameter1 varchar(50) ) as Select ProductID, ProductTitle From Products Where Description like ‘%’ … Continue reading

Posted in SQL Server | Tagged | Comments Off on adp update query with form input

go and build amazing applications

http://zef.me/4235/pick-your-battles So, here’s my advice: go and build amazing applications. Build them with the most boring technology you can find. The stuff that has been in use for years and years. Where every edge case has been covered. Where every … Continue reading

Posted in SQL Server | Tagged | Comments Off on go and build amazing applications