SQL Posts

SQL

Automating Website File Backups

Droo Hastings • December 5, 2017

Automating Website File Backups Admittedly, this is not the most exciting topic to some, but one of the greatest things about the ever-evolving tech landscape is how we continue to find ways to offload tasks that…

Read More

SQL

Import Microsoft Access .accdb File to MS SQL Server

Mark Holmes • February 5, 2014

These steps are for exporting an .accdb file if it cannot be viewed as a table. This may be needed if the data file was generated by a Microsoft Access form. If the desired file can…

Read More

PHP

WordPress Stylesheet Missing in Safari

jsandahl • April 15, 2013

This is an interesting situation. You might have migrated your blog lately or your hosting provider moved your database somewhere and all the sudden your WordPress blog is no longer showing up in Safari. It may…

Read More

Kohana

Getting Started with Kohana

jsandahl • September 19, 2012

So you’ve read my Model-View-Controller article from last week and now you’re ready to get started working with Kohana, the best open-source, lightweight MVC out there for PHP. I’ve simplified the process I use for your…

Read More

Linux

How To Duplicate a PGSQL database

Tim Barsness • August 10, 2009

Recently I needed to create a duplicate of PGSQL database.  Being a MySQL guy, I didn’t know off hand how to do it, but here is an easy way: pg_dump original_db > original_db.sql createdb new_db psql…

Read More

SQL

SQL Server Error 3154

Tim Barsness • July 16, 2009

I ran accross the SQL Server error 3154. In SQL Server 2008, it says “Restore Failed for Server ‘ServerName\InstanceName’” Additional Information: “System.Data.SQLClient.SqlError: The backup set holds a backup of a database other than the existing ‘dbname’…

Read More

SQL

Escaping Single Quotes in MS SQL Server (T-SQL)

Tim Barsness • June 2, 2009

Escaping single quotes (‘) in Transact-SQL is done by replacing the single quote with two single quotes. So: SELECT ‘I went to Kinko”s’ Returns “I went to Kinko’s” The only case where two consecutive single quotes…

Read More