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
https://www.sqlpass.org/summit/2015/Live.aspx
Date: 11/01/2015
TechEd Live! Big fan of running these conferences to live streaming audiences…Don’t miss out! Don’t...
Date: 05/09/2014
I often talk about the effects of lost productivity to my team and co-workers. I recently stumbled...
Date: 05/07/2014
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
This is a follow-up to the blog entry from Jasper Jugan. This is a modification to the script to...
Date: 04/29/2008
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
Not much to say. I have been angry that he has not returned my emails. Sorry Ken. Ken Henderson...
Date: 02/25/2008
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
So here is my 2nd favorite new gadget on my Windows Mobile device. With the 3G network speed and my...
Date: 10/26/2007
I have really started to like my Samsung Blackjack running Windows Mobile lately. I am going to...
Date: 10/25/2007
Nothing else to be said. GOOCH
Date: 09/25/2007
This function returns an integer of the hour of the year passed as a variable. IF EXISTS (SELECT *...
Date: 09/25/2007
This function returns an integer of the hour of the month passed as a variable. IF EXISTS (SELECT *...
Date: 09/25/2007
This function returns an integer of the number of days in the half year. IF EXISTS (SELECT *...
Date: 09/24/2007
I would have to say that one of my favorite new utilities that shipped with SQL Server 2005 has been...
Date: 09/03/2007
These tables can be used for testing various data types of SQL Server. You can extend as needed. SET...
Date: 08/25/2007
Here is a view that contains column information. This is useful if you need to create a DDL...
Date: 08/24/2007
Here is the link. https://support.microsoft.com/default.aspx/kb/939537 Here are the fixes in this...
Date: 08/22/2007
This script will generate tsql code to bcp and bulk load data for all tables in a given DB. SET...
Date: 08/10/2007
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
This about sums it up! The integration of CA's ERwin® Data Modeler with Microsoft's Visual Studio...
Date: 08/06/2007
This function will return the date name for a given date time. 1: USE [DW_SharedDimensions]; 2: GO...
Date: 08/01/2007
Here it is...the July CTP for SQL Server 2008. I was going to start the download tonight and install...
Date: 07/31/2007
This function will return a datetime for a numeric value. This is using the 1900 date system, the...
Date: 07/31/2007
Technorati Tags: SQL Server, SQL, Function, Intellectually Constipated This function will return a...
Date: 07/31/2007
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
I have now started the process of evaluating the other possible ways of executing the query. These...
Date: 12/15/2006
I am calling this Part I because I know I still have some more details to discover about something I...
Date: 12/11/2006
Today we anounced Visual Studio 2005 Team Edition for Database Professionals "Visual Studio Team...
Date: 05/31/2006
tech·nol·o·geist [ tek nólləgst ] (plural tech·nol·o·geists) noun Definition: 1. method of applying...
Date: 05/23/2006
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
After getting a taste of the things to come in Windows Vista, by loading IE7 and the new Windows...
Date: 05/22/2006
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
Cdnuolt blveiee taht I cluod aulaclty uesdnatnrd waht I was rdanieg.The phaonmneal pweor of the...
Date: 05/15/2006
i have posted an article on developer.com about my take on the pdc this year. i just recorded...
Date: 10/07/2005
now for the final step we just need to add our snippet and add our replacements that we defined in...
Date: 10/07/2005
the schema for the code snippet format is well documented and easy to read. I have put a copy here,...
Date: 09/30/2005
[cricket.mp3 - repeat for 9 months] yes, i had good intentions…anyway… so here we are getting very...
Date: 09/28/2005
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