SQL Saturday Pre-Conferences (Dec. 8, 2011) SQL Saturday #104 Colorado Springs – Pre-Conference Seminar Opportunity With SolidQ and Confio Software, SSWUG.ORG is proud to partner on sponsoring three pre-conference seminars at the upcoming SQL Saturday #104 in Colorado Springs, Colorado. Enjoy your SQL Server educational options with Glenn Berry’s "Scaling SQL Server," Erik Veerman’s "Data Warehouse Dimensional Design and Architecture […]
Other News
C# wins developers, but Java still reigns
(Paul Krill) Microsoft’s C# language appears set to overtake C++ in regard to its popularity with developers, a monthly survey of programming languages finds. But the language could be held back because C++ is better for mobile application development, an official in charge of the survey said.
Practical SQL: UDFs and Service Programs, Part II
(Joe Pluta) In the previous article in this series, I created a simple user-defined function (UDF) that acted as an SQL interface to an RPG service program procedure. It was simple and easy to do, but the emphasis was on simple. The UDF simply passed parameters from the SQL environment straight thro
Running SAP Solutions with DB2 10 for z/OS on zEnterprise
(Lydia Parziale, Petra Bührer, Matthias Gimbel, Martin Hagelstrom, Maxim Kukarev, Oliver Petrik and Franz Voelker) SAP AG is one of the world’s largest independent software providers and the leading manufacturer of enterprise application software and solutions. The company is headquartered in Walldo
Integrating Ajax Code into the ASP.NET Validation Infrastructure
(Peter Vogel) In a comment to a tip in our “.NET Tips and Tricks” blog , a reader noted that what he needed was an example of how to ensure that no invalid data is entered into a FormView when data had to be validated against several other controls (and had to be checked against server-side data).
Flexible Oracle Identity Manager Integration
(Anthony Shorten) In a past post I mentioned that we updated the Oracle Identity Manager integration for the Oracle Utilities Application Framework. One of the features of the integration is the ability to customize the interface to suit your needs.
Solid Choices for Oracle Tuning on Solid State Disk
(Kellyn Pot’Vin) As I continue to work on very large databases, (VLDB), I am exposed to more opportunities to speed up IO. This can involve Oracle’s solution of Exadata or stand alone improvements with options such as SSD, (Solid State Disk) which can offer faster IO performance at a fraction of t
Day 5: The Twelve Days of SQL: The query cost is only an estimate
(Iggy Fernandez) The Cost column in query plans can be confusing because a query can take a long time to execute even if the cost is low. The natural assumption is that execution time will be low if the cost is low and high if the cost is high.
Understanding and using IMS SOAP Web services
(Robert Crawford) In the last few years, Service Oriented Architecture (SOA) has become a pervasive method for exchanging information between servers. IBM keeps the mainframe in the information exchange mix by providing SOA support for transaction processors like IMS and CICS. This article will disc
For SMBs, the data expedition starts with BI integration
(Don Jones) The whole point of a business intelligence (BI) system is to access your existing organizational data: sales data, payroll, shipping costs, customer records — the more the merrier. By getting at this data and tying it together, the system lets you see connections, explore trends and pat