Scientia Nubes

Patrick Gallucci's Cloud Science Blog

Watch SQLPass 2015 Sessions on PASSTV

https://www.sqlpass.org/summit/2015/Live.aspx

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] Date: 10/25/2007

HALO 3

Nothing else to be said. GOOCH

Author: Patrick Gallucci [US] 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 *...

Author: Patrick Gallucci [US] 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 *...

Author: Patrick Gallucci [US] 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 *...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] Date: 07/31/2007

HUH?

Technorati Tags: business intelligence, data mining, gooch, sql server, toons a day in the life of a...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] Date: 05/31/2006

technologeist

tech·nol·o·geist [ tek nólləgst ] (plural tech·nol·o·geists) noun Definition: 1. method of applying...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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,...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] 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...

Author: Patrick Gallucci [US] Date: 12/15/2004