TechEd North America Live Stream Starting May 12

TechEd Live! Big fan of running these conferences to live streaming audiences…Don’t miss out! Don’t miss Keynote speaker Brad Anderson, Corporate Vice President of the Windows Server and System Center and other sessions, such as: · Deep Dive: The Future of .NET on the Server · Enabling Enterprise Mobility with Windows Intune, Microsoft Azure, and…


Developer Productivity Measured

I often talk about the effects of lost productivity to my team and co-workers. I recently stumbled across this article (Programmer Interrupted) that was posted by a friend (Ward Pond) on his Facebook page. It is clear the impact that a single interruption can have. When you multiply that by 5 or 10 times a…


What is Big Data?

Our data platform has over 600 petabytes of data. The data mining team that I work with has 1/6 of that total space with 73.4 petabytes being utilized.


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

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)…

6

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 is far and above anything that I…

1

Bricks seldom feel good.

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

1

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

2

Windows Mobile Slingbox and SlingPlayer Mobile

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…

1

Live Search, Windows Mobile and my little GPS friend!

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…

3