(Henrik Loeser) Once you get started with processing XML data within a database, such as DB2, the next question usually is: How can I update XML documents? Well, (relational) database systems usually have an UPDATE statement for modifying data.
Other News
Investigate state-of-the-art XML compression techniques
(Sherif Sakr) XML is considered a standard for data representation and exchange over the World Wide Web. XML has great flexibility and wide acceptance, but one drawback is the large size of XML documents.
Is Parallelism married to Partitioning?
(Rekha Balwada) In the last couple of months I have been asked a number of times about the dependency of parallelism on partitioning. There seems to be some misconceptions and confusion about their relationship, and some people still believe that partitioning is required to perform operations in par
Using MvcPaging in ASP.NET MVC Apps
(Shiju Varghese) In this post, I will demonstrate how to use NuGet package MvcPaging in ASP.NET MVC apps. MvcPaging provides a Pager HtmlHelper that renders a pager based on a PagedList implementation.
APAR Friday: Install fixes
(Willie Favero) It’s late Friday afternoon and I really wanted to end the week with a great blog post. That quickly turned a blog post, which in a panic turned to “Hurry up and write anything”. That’s just the way my Fridays go sometime.
Securing the SQL Server Platform, Part 1
(Buck Woody) Security should always be a concern for a technical professional, but as I write this article it is certainly in the forefront of the news. High-profile break-ins at companies large and small, releasing sensitive data that in some cases is even life-threatening show up as stories by the
Comparing Databases with mysqldbcompare
(Chuck) If you have two or more database servers containing the same data, how do you know if the objects are identical. Furthermore, how can you be sure the data is the same on all of the servers?
Full Database Backup from SSMS in SQL Server
(Paresh Prajapati) I want to write here some general activity for everyone who are worked with SQL Server, even they are database developer or DBA. I know everyone know for the database backup and they are performing it as well. Below are the whole demonstration of to do full database backup. I hope
Reduce database recovery time by using DB2 Advanced Recovery Solution for Linux, UNIX, and Windows
(Anson Kokkat and Ivan Nikittin) From an IT perspective, manual backup and recovery processes are tedious, error prone, and time consuming, therefore, they are not frequently implemented. As the volume of data increases, though, it becomes more difficult to back up and recover without longer downtim
Steps to Create your First SSIS Package
(Deepti Saxena) The purpose of this tutorial is to provide detailed steps on how to create a SSIS Package. The package given below reads the data from a source tab delimited text file and based on certain conditions, saves the output in two separate Excel Output Files.