intellectually constipated

How to drop all tables, all views, and all stored procedures from a SQL 2005 DB...

2008-04-29T23:00:36Z

This is a follow-up to the blog entry from Jasper Jugan . This is a modification to the script to allow for schema specific deletes of the SP's, Views and I added Functions. create procedure usp_DropSPFunctionsViews as -- variable to object name declare @name varchar (1000) -- variable to hold object type declare @xtype varchar (20) -- variable to hold sql string declare @sqlstring nvarchar(4000) declare SPViews_cursor cursor...(read more)

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

2008-02-29T22:51:38Z

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 is far and above anything that I think I endured or will ever go through again. This is not training to teach, but rather to enforce and to fill gaps. You must be nominated, then pass a pre-interview to make sure that you are qualified to attempt...(read more)

Bricks seldom feel good.

2008-02-26T02:41:43Z

Not much to say. I have been angry that he has not returned my emails. Sorry Ken. Ken Henderson – We Will Always Remember You Technorati Tags: Ken Henderson , SQL Server , SQL...(read more)

SQL Server Function to merge a date with a time

2007-11-19T05:03:46Z

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 FUNCTION [util].[uf_MergeDate2Time] GO CREATE FUNCTION [util].[uf_MergeDate2Time]( @ date DATETIME, @ time DATETIME ) RETURNS DATETIME WITH EXECUTE AS CALLER AS /*************************************...(read more)

Windows Mobile Slingbox and SlingPlayer Mobile

2007-10-26T19:34:28Z

So here is my 2nd favorite new gadget on my Windows Mobile device. With the 3G network speed and my SlingPlayer mobile, when I am not using Mobile Live search, I am either watching tv or listening to the news on my Windows Mobile Device. The quality is not great, but it is acceptable. I have been trying different settings, and over the past 2 weeks have gotten it to where there is little fragmentation on the screen. The more action on the screen lessens the quality, but the player is optimizing itself...(read more)

Live Search, Windows Mobile and my little GPS friend!

2007-10-26T04:11:46Z

I have really started to like my Samsung Blackjack running Windows Mobile lately. I am going to start to share some of my favorite applications and gadgets as time permits. My latest and probably favorite as of now is Live Search for Windows Mobile. I am not going to run down all the features, but share with you how I managed to get GPS working and how COOL this is. If you haven't seen it, check it out. I really think they need to give more information on this site, as I am sure that more people...(read more)

HALO 3

2007-09-25T23:43:12Z

Nothing else to be said. GOOCH...(read more)

SQL Server Function to get the Hour of the Year

2007-09-25T23:32:20Z

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] GO CREATE FUNCTION [util].[uf_GetHourOfYear]( @ date DATETIME ) RETURNS INTEGER WITH EXECUTE AS CALLER AS /*******************************************************************...(read more)

SQL Server Function to get the Hour of the Month

2007-09-25T23:30:06Z

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 [util].[uf_GetHourOfMonth] GO CREATE FUNCTION [util].[uf_GetHourOfMonth]( @ date DATETIME ) RETURNS INTEGER WITH EXECUTE AS CALLER AS /***************************************************************...(read more)

SQL Server Function to return half year number of days.

2007-09-24T17:29:43Z

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 [util].[uf_GetHalfYearDays] GO CREATE FUNCTION [util].[uf_GetHalfYearDays]( @ date DATETIME ) RETURNS INTEGER WITH EXECUTE AS CALLER AS /************************************************************...(read more)