Browse by Tags

• Business Intelligence
• Data Warehouse
• Katmai
• Microsoft Certified Architect
• SQL Function
• sql server 2005
• Training

• The few, the proud, the fortunate. Microsoft Certified Architect Program

  And I really do mean fortunate. On March 10th I am to embark in five weeks of some of the toughest technical training that I will do during my career. I have been to week long ramp-ups and boot-camps to help facilitate learning during my career. But this Read More... Posted Friday, February 29, 2008 2:51 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Server 2008, Katmai, Microsoft Certified Architect, Training

• SQL Server Function to merge a date with a time

  I use this when I need to join two fields. One has a date, the other has a time.   IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_MergeDate2Time]' ) AND type in (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP Read More... Posted Sunday, November 18, 2007 9:03 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, Business Intelligence, SQL Function, SQL Server 2008, Katmai, Data Warehouse

• SQL Server Function to get the Hour of the Year

  This function returns an integer of the hour of the year passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfYear]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP FUNCTION [util].[uf_GetHourOfYear] Read More... Posted Tuesday, September 25, 2007 4:32 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function, SQL Server 2008, Katmai, Data Warehouse

• SQL Server Function to get the Hour of the Month

  This function returns an integer of the hour of the month passed as a variable. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHourOfMonth]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP FUNCTION Read More... Posted Tuesday, September 25, 2007 4:30 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function, SQL Server 2008, Data Warehouse

• SQL Server Function to return half year number of days.

  This function returns an integer of the number of days in the half year.   IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetHalfYearDays]' ) AND type IN (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' )) DROP FUNCTION Read More... Posted Monday, September 24, 2007 10:29 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function, SQL Server 2008

• SQL Server 2008 (Katmai) July CTP - Do you feel the need for speed?

  Here it is...the July CTP for SQL Server 2008. I was going to start the download tonight and install in the morning...but I forgot I was on Verizon FIOS...man I love that Fiber! Download your copy now! https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470 Read More... Posted Tuesday, July 31, 2007 10:50 PM by Patrick Gallucci | 2 Comments Filed under: SQL Server 2008, Katmai