Tag Archives: SQL

Calculating the Previous Month’s Date Range in SQL

Here’s a handy snippet that calculates the start and end dates for the previous month based on the current date. I find this very handy when I have an automated script that reports on the figures for only the last … Continue reading

Posted in Tips and Tricks | Tagged | Leave a comment

Full-Text Indexing for PDFs

In this post I’ll show how to enable full-text indexing of PDF documents using SQL Server 2008 (64-bit), and the Adobe iFilter component. The iFilter component is required to bridge the gap between the Windows Indexing Service and the PDF … Continue reading

Posted in Reference | Tagged , | Leave a comment

Hashing Text with SQL

Recently I was faced with the task of hashing some clear text in a database. The database was shared between different systems, some written in classic ASP, some written in C#.NET. I didn’t want to write the same hashing code … Continue reading

Posted in Tips and Tricks | Tagged , | Leave a comment