Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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