31 Mar
Got API?

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 (2)
3 Oct
A GUI Mess, or a Productivity Booster?

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 (8)
3 Nov
How To Full-Text Search

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

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 (8)
24 Oct
Group By Queries for MS SQL Server

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 (13)

Page 1 of 1