(Changrui Ren, Bing Shao, Miao He and Jin Dong) In Part 4 of this series, you’ll learn about two advanced analytics features provided by SCPM: the extended process simulation and the Performance Analyzer. The extended process simulation enables the use of scripts for simulation modeling, thus provid
Other News
Merge Comments
Merge Comments Today I had a number of comments regarding an SQL merge process. Jason: If you do the update first you have X rows in the table that it has to evaluate to join on. Now when you delete you still have X rows to join on. I believe you said you do the insert after the update so […]
DB2 Interview Questions
(chandu_gupta143) The Following are the most frequently asked questions….
How To Outsource Your XML
(techno) Since XML is a coding language and not all website proprietors and bloggers have the data and patience to work with XML, it is vital to understand how you can outsource it. Outsourcing has become a great way to get things done that you either are too busy to do yourself, or don’t know the w
A better way to kill database connections
(Mike Dean) This is something that I learned recently that made me wonder why I never knew it previously. Over the years, I have had many occasions when I needed to kill a database session and would use the “alter system kill session ’sid,serial#’” syntax.
Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From Sources
(eduardo.lago.aguiar) This tutorial shows how to create a portable MySQL installation on GNU/Linux. It applies to:
ColdFusion 10 Beta – Generating Hash-Based Message Authentication Codes With Hmac()
(Ben Nadel) We are entering the age of APIs – Application Programming Interface(s). Many of our applications now interface with 3rd party APIs like Twilio, Twitter, EmailYak, FullContact, Face.com, and Facebook. The list goes on and on.
SQL Server Virtualization Summary (Part 5 of 5)
(Scott Shaw) We have discussed different aspects of virtualization in these previous tips tip 1, tip 2, tip 3, tip 4. In this tip we look at additional reading and resources you can use to make the most of your virtualized SQL Server enviornment.
2012-02-23 12.00 IBM InfoSphere Data Replication – Changes and Choices
(Frank C. Fillmore, Jr.) IBM is merging replication offerings with the announcement of the IBM InfoSphere Data Replication (IIDR) V10.1.2 package. The new Data Replication package updates and consolidates SQL Replication, InfoSphere Replication Server, InfoSphere Change Data Capture, and InfoSphere
Learn How to Validate Your Entities in the Entity Framework
(V.N.S Arun) As entity framework has become an essential part of modern day data driven applications and ASP.NET MVC applications, it is important to know the bits and pieces of it. In this article I will explain about the validation techniques that can be used in ADO.NET Entity Framework 4.1 to val