SQL Server

Querying the File System - From ColdFusion to SQL Server

While looking for a solution of a different problem, I realized that SQL Server has a feature called extended stored procedures. Extended stored procedures, at...

0 replies - 745 views - 03/17/08 by Boyan Kostadinov in News

Querying Active Directory Through SQL Server

Integrating your application with Active Directory (or another LDAP based directory) is a common requirement in many business applications. Almost every...

1 replies - 2683 views - 02/11/08 by Boyan Kostadinov in News

Get Business Days and Working Hours in a Month

In business applications, there often is a need to know the number of business days and/or hours in a month/year. There is a dozen ways to do this depending on...

0 replies - 1023 views - 02/07/08 by Boyan Kostadinov in News

Custom Date Formatting in SQL Server

Most people that use SQL Server are familiar with formatting dates inside SQL Server. The common approach is: convert(varchar, getdate(), 106) -- Displays a...

1 replies - 3477 views - 02/04/08 by Boyan Kostadinov in News