(Craig S. Mullins) In this day and age of database breaches, regulatory compliance and hacking, improved security is a must. Thankfully, DB2 10 adds multiple improvements for securing the data in your databases.
Other News
Data normalization reconsidered, Part 1: The history of business records
(Susan Malaika and Matthias Nicola) Relational databases have been fundamental to business systems for more than 25 years. Data normalization is a methodology that minimizes data duplication to safeguard databases against logical and structural problems, such as data anomalies.
Securing and protecting SQL Server data, log and backup files with TDE
(Brady Upton) I need to keep some old SQL data and log files in a backup folder for DR purposes. What is the best way to protect these files? In this tip we look at using TDE to safeguard your files and the steps necessary to move a TDE database to another SQL Server instance.
The Page Adapter Pattern for Testing Web Apps
Goals for the New Year 2012 is here. So, what’s going to make it any better than 2011? Or, was your 2011 so great that you don’t think it can get any better? I’m curious what you are doing to change your world this year. I’d like to collect ideas from our readers to see if I can find any […]
System Testing ? What to test?
System Testing – What to test? You can’t test everything. That is a given. Even with some of the simplest software, the number of permutations for which tests could be written is astronomical. There is also a limited amount of time to execute your tests for them to be practical. Some engines perform faster than others. Still, if it takes […]
Identifying the load with the help of pt-query-digest and Percona Server
(Ovais Tariq) Profiling, analyzing and then fixing queries is likely the most oft-repeated part of a job of a DBA and one that keeps evolving, as new features are added to the application new queries pop up that need to be analyzed and fixed. And there are not too many tools out there that can make
Implementing validation callout in Asp.net MVC (with data annotations)
(Kedar Kulkarni) I always liked validation callout extender that is available in Ajax control toolkit. However in MVC, we largely rely on jQuery plugins to do all the fancy stuff (and of course important tasks too).
Creating OData Entries in WCF Data Services
(Jeffrey Juday) Open Data Protocol (OData) is built on Web standards like HTTP and AtomPub. Creating data on an OData Endpoint is simply an HTTP POST that contains an AtomPub payload. Leveraging WCF HTTP capabilities, WCF Data Services implements OData for .NET code.
FORCE_MATCH for Stored Outlines and/or SQL Baselines????? – follow up
(tonyhasler) As has happened a couple of times recently, comments on a blog of mine have helped me understand the subject matter on which I am commenting far better.
MERGE: MAKE Your UPSERTs quick!!!
(samkumar) Hi guys… I am back… this time as a Advanced DB2 9.7 DBA… Thanks to Sathy for helping me prepare for the exam and Beth Flood for giving me a free voucher (otherwise I never had guts to put 5k on stake for my capabilities)… But very soon an all new DB2 is expected I am hope it will