Monthly Archives: January 2012

SSIS: A Simple Stop and Start Processes Task

There are a lot of methods to stop and start services in a Windows environment. Things like WMI scripts and PowerShell scripts are the first two to come to mind. One of the most commonly used SSIS packages I use … Continue reading

Posted in Sql Server | Leave a comment

First Time PASS Summit 2011 Attendee. So how was my experience?

It has been a few months since the PASS Summit 2011 but I thought I would take the time to tell you a little about my trip to Seattle, WA. When registering for PASS I had no idea what I … Continue reading

Posted in Uncategorized | 1 Comment

Getting ready for the Patriots Game

When the Baltimore Ravens square off against the New England Patriots in Foxborough tomorrow to decide which team will represent the AFC in the Super Bowl, it won’t be a game. It will be a war. May the Patriots win … Continue reading

Posted in Uncategorized | Leave a comment

My MCITP and MCTS certification experience

Almost two years ago I took the required 70-432 and 70-450 exams to get my MCITP 2008 Database Administrator certification. Recently I went back and passed 70-433 for my MCTS 2008 Sql Server Developer certificate. And yes now I am … Continue reading

Posted in Sql Server | Leave a comment

Automatic Memory Tuning in Oracle 11g

Automatic Memory Tuning in Oracle 11g is now possible by setting the memory_max_target parameter In 11g, all memory can be tuned automatically by setting one parameter. Prior to Oracle 11g, the DBA set the sga_target and sga_max_size parameters, allowing Oracle … Continue reading

Posted in Oracle | Leave a comment

Sql Server 2008 single statement performing multi-row inserts.

  Here is an insert statement I didn’t realize was possible. INSERT INTO MyTable (FirstCol, SecondCol)VALUES (‘First’,1),(‘Second’,2),(‘Third’,3),(‘Fourth’,4),(‘Fifth’,5) I just came across this by accident the other day, and after searching the web I see that Pinal Dave had posted the … Continue reading

Posted in Sql Server | Leave a comment

Willett Compute ? comes to life today!

Welcome to Willett Compute ? I’ve always had the desire to blog about database and programming paradigms. Having a goal of sharing common problems and solutions, some of these may or may not compute baised on my understanding. Hence the name, … Continue reading

Posted in Uncategorized | Leave a comment