February 2010 - Posts

• Calculating Holidays in SQL

  Ask about nearly any kind of SQL-based date calculation in the newsgroups , and you'll likely get responses that include use of an auxiliary calendar table . It's a really good idea, and something I highly recommend to anyone who has to do date-based Read More... Posted Thursday, February 25, 2010 5:51 PM by Mike C | 4 Comments Filed under: auxiliary date table, floating holidays, functions, holidays, SQL, sql 2005, SQL 2008, SQL Server, SQL Server 2008, t-sql

• Service Packs... Coming to a Download Near You!

  Based on feedback from the community ( https://connect.microsoft.com/SQLServer/feedback/details/522123/sql-server-2008-service-pack-2 and https://connect.microsoft.com/SQLServer/feedback/details/522122/service-pack-4-for-sql-server-2005 ), Microsoft has Read More... Posted Sunday, February 14, 2010 7:07 PM by Mike C | 0 Comments Filed under: service pack, SQL, sql 2005, SQL 2008, SQL Server, SQL Server 2008

• Almost T-SQL Tuesday #003: Calculating Products - An Oldie But Goodie

  Looks like I just missed the deadline for T-SQL Tuesday #003 [oh well, whatcha gonna do]. The other day someone asked me about an oldie but goodie that hits on a math-based relationship. SQL Server has several aggregate functions like SUM for summation. Read More... Posted Wednesday, February 10, 2010 1:11 AM by Mike C | 5 Comments Filed under: aggregate function, math, SQL, SQL Server

• NJ .NET User Group Presentation: Building a SQL Server Search Engine in .NET

  I'll be presenting at the Northern NJ .NET User Group meeting on Tuesday February 9. Topics we'll cover include: Intro to SQL Server 2008 Integrated Full-Text Search (iFTS) features and functionality, including: Full-text indexes Thesaurus Word breakers, Read More... Posted Sunday, February 07, 2010 2:11 PM by Mike C | 2 Comments Filed under: .NET, full-text search, iFTS, SQL, SQL 2008, SQL Server, SQL Server 2008

• It's Official - SQLSaturday is Coming to NYC!

  New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010! The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices. The speaker line-up is growing fast—if you'd like to present, Read More... Posted Saturday, February 06, 2010 3:59 PM by Mike C | 0 Comments Filed under: .NET, BI, business intelligence, presentation, professionals, programming, R2, speaking, SQL, sql 2005, SQL 2008, SQL Server, SQL Server 2008, SSAS, SSIS, SSRS