July 2007 - Posts

• 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

• SQL Server Function to Return Date from Numeric Value

  This function will return a datetime for a numeric value. This is using the 1900 date system, the same as used by Excel. See http://office.microsoft.com/en-us/excel/HP100791811033.aspx for more examples. 1: IF EXISTS ( SELECT * FROM sys.objects WHERE Read More... Posted Tuesday, July 31, 2007 9:31 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function

• SQL Server Function to Return Numeric Value for DateTime

  Technorati Tags: SQL Server , SQL , Function , Intellectually Constipated This function will return a numeric value for a given date. This is using the 1900 date system, the same as used by Excel. See http://office.microsoft.com/en-us/excel/HP100791811033.aspx Read More... Posted Tuesday, July 31, 2007 7:49 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function

• HUH?

  Technorati Tags: business intelligence , data mining , gooch , sql server , toons a day in the life of a business intelligence consultant... Read More... Posted Wednesday, July 11, 2007 6:55 AM by Patrick Gallucci | 1 Comments