SQL Posts


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


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


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


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 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


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