(Ulf Wendel) Replication is as old as life on earth. No life without replication. MySQL replication is as old as MySQL, almost. No MySQL without replication.
Other News
ASP.NET: Extending the Config File with Custom Sections
(Peter Vogel) If you need to store multiple, interdependent values in your config file, the appSettings element gives you no support: It’s a miscellaneous collection of untyped values with no relations between them. A better solution is to add custom elements to your config file. It’s not a tool I u
DB2 Security; A DB2 LUW perspective (and a Guest Blog Post)
(Willie Favero) Yup, you read that correctly. Today’s post deals with DB2 LUW security. The good news is that I’m not the author. I am (we are) very fortunate to have a real DB2 LUW security expert willing to tackle the topic for me.
Controlling dataset processing time in SSRS reports
(Siddharth Mehta) Long running queries in complex reports is one key performance optimization area. One way to keep your users from waiting for a long period of time to view a report, due to corrupt queries or poorly designed queries, is to configure your reports with an acceptable time limit to wa
Conflicting Goals When Writing Software
New Show! SelecTViews: New SQL Server Injection Attack, Cloud Failures and Best Practices to Address Them. Also, hear from LogLogic, hear about security considerations and much more. [Watch the Show] Conflicting Goals When Writing Software – Resources, Time, Scope, Money, Quality Project Management 101 defines a project as three dimensions, Resource, Time, and Scope. You can increase or decrease any […]
How to find out when a DB recovery model was changed
(Simon Sabin) A client asked me today how to find out when the recovery model had changed on a DB. The reason was that an overnight process broke because the DB was put into full recovery mode and the transaction log filled up.
Using SQL Server Resource Governor to Control Resource Utilization
(Dinesh Asanka) A few years ago there was an MSDN forum post: My SQL Server is accessed by several end user applications. When all the applications are in action my server performance is going down. Some of those applications are business critical hence they should not be disturbed by other appli
Visualizing Linked Data
(Karen Coyle) Chris Oliver, Diane Hillmann and I will be reprising (and updating) our three-part webinar on RDA and the future of library metadata starting on May 11.
Nulls in Ordering
(Arup Nanda) You want to find out the tables with the highest number of rows in a database. Pretty simple, right? You whip up the following query:
Using Socket Gateways To Communicate Between ColdFusion And Node.js
(Ben Nadel) For the past week or two, I’ve been really trying to get my feet wet with Node.js – a server-side Javascript runtime environment. It’s been a lot of fun; but, the question in the back of my mind has always been – OK, now how do I get this to talk to ColdFusion?