SiteCrafting, Inc.

31 Mar

Got API?

gotAPI.com is one of the most useful online resources I've come across, primarily because it places resources spread all over the internet into one simple...

Read more →

MS SQL Server
by Nick Williams | Comments (1)
3 Oct

A GUI Mess, or a Productivity Booster?

While writing up a review on a database tool I discovered today, I was inspired to spark a discussion about database GUIs in general. The...

Read more →

MS SQL Server
by Nick Williams | Comments (6)
3 Nov

How To Full-Text Search

Here's a quick how-to on implementing Full-Text Searching using Microsoft SQL Server 2005. Originally, I planned on just using LIKE statements in the WHERE clause...

Read more →

MS SQL Server
by Ken Foubert | Comments (1)
27 Oct

MS SQL Server 2005 text and ntext

How I discovered that text, ntext, and image data types have been deprecated and replaced by varchar(max), ntext(max), and varbinary(max).Recently, I needed to perform a...

Read more →

MS SQL Server
by Ken Foubert | Comments (6)
24 Oct

Group By Queries for MS SQL Server

Back in the day, we worked on developing a specialty application that was basically a lead generation system with a database that stored over 200,000...

Read more →

MS SQL Server
by Ken Foubert | Comments (10)

Page 1 of 1