tactek data systems

There are many techniques for doing quick, full loads of data with Microsoft SQL Server Integration Services (SSIS) for a reporting environment. This one is the quick change artist of the bunch. Our goal is to create a mechanism for doing a full data table load with little to no interruption to production reports that may rely on that table’s data. We’re going to quick load 30,000 or more records of data in the blink of an eye using a very simple, if commonly overlooked, technique. (continue reading…)

Yesterday, I posted a relatively well-known table-value function called fnSplit() for Microsoft SQL Server that splits delimited data from a single field into multiple data rows. Today, we will improve on that function by including an index number column and retaining null entries within the array. (continue reading…)

While the HP Service Manager client is a great tool, sometimes you still need to run a direct SQL query on the data. You may want the data to appear on some external report or you just need some “quick and dirty” numbers to send on to management. If you manage HPSM environments long enough, you will invariably find yourself connecting to the database to run queries from time to time. And that’s when you’ll discover that HPSM has been storing the data you need in a difficult-to-query array.

Although the example in this article applies to HP Service Manager, the method can be used whenever delimited data needs to be split and joined to another table in Microsoft SQL Server.

(continue reading…)

Any HP Service Manager developer will undoubtedly see the value in a local installation of the software. However, even with the release of HPSM 9.20, Windows 7 continues to present challenges. The Windows 7 Aero theme creates visual issues with the installer, the supplied Java 1.5 lags behind most local java installations, and known issues with SQL Server 2005 Express edition are all good reasons to avoid tackling a local instance altogether. This guide will walk you through setting up your local installation complete with database, application, and Windows client. (continue reading…)