(Willie Favero) Ya, I know… it’s not z/OS… however, even though this webpage’s content is completely DB2 LUW specific, it’s still extremely cool. It contains lots of podcast covering different aspects of DB2 for LUW. It’s also set up as an RSS feed so you can subscribe to the page and get notified w
Author: SSWUG Research
Create a temp file with VB.NET
(Irina Medvinskaya) Temp files are generally used for temporary storage and data manipulation. This is often necessary for storing user data, user preferences, session information, application cache, and many other types of information.
Erik Meijer on LINQ, XML, and the future at XTech 2007
Erik Meijer gave a talk at the XTech 2007 conference on LINQ, XML, and his vision for “LINQ 2.0”. The presentation covers the formal underpinnings of LINQ to XML, the additional XML features in VB9, and some thoughts about the next steps.
SQL to calculate days to next status change
(Rudy Limeback) I would like to find out how long a particular customer order has been on hold. The current system allows the status of an order to be placed on hold which gives me the beginning date via the history timestamp. Unfortunately, the only action I can take next is to change the status to
Updated Oracle SQL Developer Migration Workbench Early Adopter Release
(Donal Daly) We have updated the early adopter release of Oracle SQL Developer Migration Workbench today on OTN. You can get it from here. This is our final preview release, before we go production. We are now functionally complete for this initial production release and are now focused on fixing ou
Can Master Data be Managed?
(Karim K. Hirji) The spectacular collapses of once venerable companies (Enron, WorldComm, and so on) led to a paradigm shift in the way business is conducted. Stakeholder expectations and public scrutiny of performance and business conduct have increased. Individual shareholders, institutional inves
How to eliminate temporary tables in MySQL
(Xaprb) I’ve written before about how to make MySQL replication reliable. One thing I think you need to do to make statement-based replication reliable is eliminate temporary tables. I found an elegant way to replace temporary tables with real tables in the systems I maintain. This article explains
Creative uses for coalescence in SQL Server
(Arthur Fuller) COALESCE() accepts a series of values and a value to use in the event that all items in the list are null; then, it returns the first not-null value. This tip describes two creative uses of the COALESCE() function in SQL Server.
Index Build strategy in SQL Server – Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
A source partitioned table can be mis-aligned to the index partition in many different ways. For example, by using the same partition function and scheme, we can have non-aligned case like the following where the table and the index are partitioned on different columns.
Positing the Intelligence: Conditional Formatting in the Analysis Services Layer
(William Pearson) An important consideration, when designing a Business Intelligence system within any environment, is “where to put the intelligence” among the various “layers” within the system. I have stated many times in the past, in both articles and presentations, that “multi-layered reportin