Scientia Nubes
Patrick Gallucci's Cloud Science Blog
Watch SQLPass 2015 Sessions on PASSTV
https://www.sqlpass.org/summit/2015/Live.aspx
Date: 11/01/2015
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...
Date: 05/09/2014
Developer Productivity Measured
I often talk about the effects of lost productivity to my team and co-workers. I recently stumbled...
Date: 05/07/2014
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...
Date: 05/22/2013
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...
Date: 04/29/2008
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...
Date: 02/29/2008
Bricks seldom feel good.
Not much to say. I have been angry that he has not returned my emails. Sorry Ken. Ken Henderson...
Date: 02/25/2008
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...
Date: 11/18/2007
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...
Date: 10/26/2007
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...
Date: 10/25/2007
HALO 3
Nothing else to be said. GOOCH
Date: 09/25/2007
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 *...
Date: 09/25/2007
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 *...
Date: 09/25/2007
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 *...
Date: 09/24/2007
SQLCMD and the power of the little r
I would have to say that one of my favorite new utilities that shipped with SQL Server 2005 has been...
Date: 09/03/2007
SQL Server Data Types Test Tables
These tables can be used for testing various data types of SQL Server. You can extend as needed. SET...
Date: 08/25/2007
Column Information View for SQL Server
Here is a view that contains column information. This is useful if you need to create a DDL...
Date: 08/24/2007
Released - Cumulative update package 3 for SQL Server 2005 Service Pack 2
Here is the link. https://support.microsoft.com/default.aspx/kb/939537 Here are the fixes in this...
Date: 08/22/2007
Generate BCP, Bulk Insert code with TSQL
This script will generate tsql code to bcp and bulk load data for all tables in a given DB. SET...
Date: 08/10/2007
That about sums up my day.
I was got to Hoboken, no path trains, so I waited for a bus. That got me to downtown, so I waited...
Date: 08/08/2007
CA Erwin and Microsoft's Visual Studio Team Edition for Database Professionals
This about sums it up! The integration of CA's ERwin® Data Modeler with Microsoft's Visual Studio...
Date: 08/06/2007
SQL Server Function to Return DateName
This function will return the date name for a given date time. 1: USE [DW_SharedDimensions]; 2: GO...
Date: 08/01/2007
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...
Date: 07/31/2007
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...
Date: 07/31/2007
SQL Server Function to Return Numeric Value for DateTime
Technorati Tags: SQL Server, SQL, Function, Intellectually Constipated This function will return a...
Date: 07/31/2007
HUH?
Technorati Tags: business intelligence, data mining, gooch, sql server, toons a day in the life of a...
Date: 07/11/2007
SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part III
So in Part II of this article I had created a View so that I could then create an index on this view...
Date: 12/18/2006
SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part II
I have now started the process of evaluating the other possible ways of executing the query. These...
Date: 12/15/2006
SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part I
I am calling this Part I because I know I still have some more details to discover about something I...
Date: 12/11/2006
Visual Studio Team Edition for Database Professionals.
Today we anounced Visual Studio 2005 Team Edition for Database Professionals "Visual Studio Team...
Date: 05/31/2006
technologeist
tech·nol·o·geist [ tek nólləgst ] (plural tech·nol·o·geists) noun Definition: 1. method of applying...
Date: 05/23/2006
Why am I Intellectually Constipated?
Even though it is a great time to be a technologeist, this list is the reason why I am IC, with no...
Date: 05/23/2006
Windows Vista Beta 2 - HUH?
After getting a taste of the things to come in Windows Vista, by loading IE7 and the new Windows...
Date: 05/22/2006
Colorado PASS Camp 2006 – SQL Server Technology Summit
First I want to thank everyone who attended the Colorado PASS Camp 2006 in Denver and my session...
Date: 05/19/2006
SQL Intellisense® style word completion for MS Query Analyzer, VS.NET 2003, SQL Server Management Studio and VS 2005.
I think that title says it all. The tool is still in beta and needs to be sharpened up a little, but...
Date: 05/18/2006
Waht deos it maen to be ilcelnteltulay cpnsttiaeod?
Cdnuolt blveiee taht I cluod aulaclty uesdnatnrd waht I was rdanieg.The phaonmneal pweor of the...
Date: 05/15/2006
pdc 2005
i have posted an article on developer.com about my take on the pdc this year. i just recorded...
Date: 10/07/2005
vs 2005 code snippets part 3
now for the final step we just need to add our snippet and add our replacements that we defined in...
Date: 10/07/2005
vs 2005 code snippets part 2
the schema for the code snippet format is well documented and easy to read. I have put a copy here,...
Date: 09/30/2005
vs 2005 code snippets
[cricket.mp3 - repeat for 9 months] yes, i had good intentions…anyway… so here we are getting very...
Date: 09/28/2005
begin the begin
this is the first post of what i intend on being a daily brain drain in order to free up some space...
Date: 12/15/2004