(Troy Coleman) When I recently wrote about the new DB2 11 drop column support, I admitted that I couldn’t understand why this was such a highly requested feature. A commenter provided some insight.
Author: SSWUG Research
Generate multiple SSIS packages using BIML and metadata
(Koen Verbeeck) In my previous tips about BIML, I first introduced the concepts in Introduction to Business Intelligence Markup Language (BIML) for SSIS and I showed how you can import flat files in Using BIML to Generate an SSIS Import Package. Although BIML is very powerful, you wouldn’t use it to
Working with LINQ to XML
(Komal Mangal) You can use LINQ to XML for following purposes-
MySQL server memory usage troubleshooting tips
(Nilnandan Joshi) There are many blog posts already written on topics related to “MySQL server memory usage,” but nevertheless there are some who still get confused when troubleshooting issues associated with memory usage for MySQL. As a Percona support engineer, I’m seeing many issues regularly rel
Read Only Dictionary in .NET 4.5
(Sumit Maitra) The ReadOnlyDictionary generic type in .NET 4.5 fulfills a long standing feature request for the BCL. It is useful for scenarios where read only Dictionaries need to be exposed. One such case is shown in this article.
The ASM password directory
(Bane Radulovic) Password file authentication for Oracle Database or ASM can work for both local and remote connections. In Oracle version 12c, the password files can reside in an ASM disk group. The ASM metadata structure for managing the passwords is the ASM Password Directory – ASM metadata file
DB2 Tech Talk: Leverage Optim Workload Replay for DB Environment Change
(Cindy Russell) IBM InfoSphere Optim Workload Replay can significantly improve your database testing experience and help you successfully manage change in your database environments, whether you are adopting BLU Acceleration, upgrading DB2, or making the move to DB2.
jQuery AJAX Introduction
(Rohatash Kumar) This article provides a quick overview of how to use jQuery with Ajax in ASP. Net.
ORA-00069
(Andrew Reid) A colleague asked what the table_lock column in dba_tables was for. I did not know so I decided to investigate.First I looked at the distribution of table_lock values in one of our test databases:
Picking and Choosing Features in Your Language
(Peter Vogel) When it comes to advice on writing great code, I still find The Elements of Programming Style by Brian Kernighan and P.J. Plauger worth reading, even if it’s 25 years old and all the examples are in Fortran.