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...
As your production data grows, you will ultimately discover a need for a reporting database environment – that is, a database separate from production that allows ad hoc queries and reports to be generated from production data. The benefits of such a database are...
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...
One of the biggest issues with HP Service Manager is the format and storage of arrays as large data types such as CLOB (Oracle) or TEXT (SQL Server) fields. These data types are not indexed and are slow to query. If you want, for...
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...
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...