Attendance was excellent with 227 total consisting of locals and groups from Minnesota, Iowa, Missouri, Indiana,… Read more
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.
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
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
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
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.
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
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
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
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
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
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…
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
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.
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
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
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
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
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