Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Beer, Cheese and SQL Saturday 118 Madison

This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS team did a fantastic job on their first SQL Saturday.

Attendance was excellent with 227 total consisting of locals and groups from Minnesota, Iowa, Missouri, Indiana,… Read more

1 comments, 469 reads

Posted in The Gerasus Software Blog on 26 April 2012

SQL Saturday 98, Iowa City

Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!

It’s time for another SQL Saturday at the beautiful University of Iowa campus.

The speaker lineup looks great.

I’ll be there presenting on the SSIS Script Task.

There will be more SSIS goodness presented by Ted Krueger and… Read more

0 comments, 348 reads

Posted in The Gerasus Software Blog on 28 September 2011

PowerShell, the New SQL Hammer

This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the presentation is having some fun with the old quote, “If you have a hammer, everything is a nail”; which allows me use a real hammer in the presentation to good… Read more

0 comments, 423 reads

Posted in The Gerasus Software Blog on 17 April 2011

SQL Saturday 67 Chicago Pre-con Double Down

Yes, this looks familiar. Didn’t I write this last week? Well it’s new and the same. We have another pre-con available on the Friday, 3/25, before SQL Saturday 67.

Here is the link to register, http://sqlsat67troubleshootingprecon-estw.eventbrite.com/

The presenter is Kevin Kline, MVP, SQL Server expert, author, keynote presenter, Sql cruiser,… Read more

1 comments, 380 reads

Posted in The Gerasus Software Blog on 9 March 2011

SQL Saturday 67 Chicago Pre-con

We have big news for SQL Saturday #67 Chicago. There is going be a pre-con on Friday 3/25 at the Hampton Inn right around the corner from the SQL Saturday venue.

Here is the link to register, SQL Saturday #67 Pre-Conference: DBA Skills Upgrade Toolkit.

 

Questioning why you should… Read more

0 comments, 419 reads

Posted in The Gerasus Software Blog on 22 February 2011

Getting Drive Info, Part 5, the SSIS WMI Data Reader Task

In the final installment of the Getting Drive Info series (Part 1, Part 2, Part 3, Part 4), SSIS will again be used to collect and save the drive information. This WMI Data Reader Task will be used to collect the drive information.

WMI, Windows… Read more

1 comments, 718 reads

Posted in The Gerasus Software Blog on 4 December 2010

Un-SQL Friday 001 : Branding for Business

I really like Jen’s (MidnightDBA,#sqlawesomesauce) idea for the first Un-SQL Friday. I was struggling with the topic and had to read some of the posts from earlier today. No one had written from a business perspective yet, so I decided to write about my journey… Read more

1 comments, 377 reads

Posted in The Gerasus Software Blog on 20 November 2010

Troubleshooting Connectivity with UDL files

I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and this was the first package being placed into production that was using Oracle as a source. Arrangements had been made to have the Oracle OLE DB drivers installed on the… Read more

0 comments, 2,260 reads

Posted in The Gerasus Software Blog on 24 October 2010

Getting Drive Info, Part 4, the SSIS Script Component

In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to collect and save the drive information. SSIS provides multiple ways to accomplish this task. This installment will focus on using the Script Component to collect the drive… Read more

3 comments, 639 reads

Posted in The Gerasus Software Blog on 13 September 2010

Getting Drive Info Part 3, CLR

In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive info with methods that will work on SQL Server 2000 were presented. Now it is time to move on to look at the options that the newer… Read more

0 comments, 686 reads

Posted in The Gerasus Software Blog on 2 September 2010

Getting Drive Info Part 2, DTS

In this installment of the drive info series we will gather the drive information via a DTS package. Part 1 of this series used the File System Object from the Windows Scripting Host via the sp_OA suite of stored procedures to gather the drive information. The File System Object will… Read more

0 comments, 530 reads

Posted in The Gerasus Software Blog on 23 August 2010

sp_help_partition

If you are using partitioned tables, this may come in handy. I’ll keep it short and just post the code. Let me know if there are errors or you have improvements.

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_help_partition]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_help_partition]
GO…

Read more

1 comments, 621 reads

Posted in The Gerasus Software Blog on 8 August 2010

Getting Drive Info Part 1, sp_OA

This blog series will cover several different methods to collect drive information from a Windows server that is running SQL Server. I’ve answered several requests in forums, news groups and twitter in the past about how to get the drive size of all of the hard drives on the server… Read more

0 comments, 1,044 reads

Posted in The Gerasus Software Blog on 29 June 2010

SSIS-DTS Package Search 2.0.18 released

SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search of the parameter and ResultSet bindings in the Execute SQL task.


Read more

0 comments, 410 reads

Posted in The Gerasus Software Blog on 8 June 2010

Living with DTS on SQL Server 2005 and 2008

The DTS support in SQL Server 2005 and 2008 is excellent (almost). Typically the packages and jobs do not need any modification in order to run on SQL Server 2005 or 2008. Unfortunately, I have read far too many news group posts that indicate a complete conversion to SSIS MUST… Read more

0 comments, 605 reads

Posted in The Gerasus Software Blog on 2 November 2009

Which version of SSIS-DTS Package Search is right for you

The download page for SSIS-DTS Package search presents three choices:

  • SSIS-DTS Package Search for SQL Server 2000 on Windows x86
  • SSIS-DTS Package Search for SQL Server 2005 on Windows x86
  • SSIS-DTS Package Search for SQL Server 2008 on Windows x86

Although there are really only two different versions of the… Read more

0 comments, 531 reads

Posted in The Gerasus Software Blog on 12 August 2009

Moving to Hyper-V

My primary development machine for the past 3 years was a 32 bit Toshiba Satellite notebook running XP named PROBE-DROID. I was very happy with the machine. It went through several upgrades, more memory and a new 7200 RPM Hitachi hard drive. The purpose of PROBE-DROID was a portable virtual… Read more

0 comments, 286 reads

Posted in The Gerasus Software Blog on 4 June 2009

Anti-Virus Adventures

Denny Cherry wrote a blog post recently discussing whether to run anti-virus software on Sql Server machines. He said you should and I agree. It is just too risky not to run anti-virus with all of the notebook computers coming in and out of the office. The post did remind… Read more

0 comments, 271 reads

Posted in The Gerasus Software Blog on 20 May 2009

SQL This, Not That – Episode 2

When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC command, make sure the data type of this column is sysname. The data type of this column should not be VARCHAR(50) or some other arbitrary data type that should… Read more

0 comments, 625 reads

Posted in The Gerasus Software Blog on 30 April 2009