(Xaprb) A frequently asked question about MySQL replication is “how do I know whether my slave is identical to the master?” Until recently there hasn’t been a good way to know, but now you can compare all the data in your master to the data in the slaves and get a reliable yes-or-no answer. And you
Other News
Make Your Site’s RSS Feed Shine
RSS is a way of life these days, but there’s no reason your site’s RSS feed needs to look like it was written by a computer. Sure, in order for an RSS feed to be read by most RSS readers it needs to be valid XML, but who says you have to stop there?
Native XML in Relational Databases – DB2 9.2
(Edmon Begoli) DB2 9.2 is in many aspects a benchmark for a true XML-Relational database. Here is why I see it that way: –Seamlessness of the XML integration from the API perspective –Storage model –Performance
SQL Server Stored Procedures
(Mike Chapple) Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.
Oracle Spatial and TopLink Essentials JPA
(Andrejus Baranovskis) It seems Oracle Spatial functionality can be used successfully with TopLink Essentials JPA also. I have reviewed in detail Doug Clarke (Principal Product Manager for Oracle TopLink) post about how it looks in theory – Oracle Spatial using TopLink Essentials JPA. And, have impl
Automate your .Net build – I
(Partha S) Automating build processes for .Net applications go a long way in ensuring a proper build and makes the build independent of developer habits. It reduces risk by making the build independent of developer’s local machine environment.
Forms Personalizations
(Anil Passi) In this article, I would like to explain different possibilities of Forms Personalizations. Surely before explaining what can be done, first we will touch base upon what exactly it is.
Generating GUIDs with VB.NET
(Irina Medvinskaya) Developers use globally unique identifiers (GUIDs) for various reasons, such as assigning unique identifiers to classes or when dealing with databases. GUIDs are the Microsoft implementation of the distributed computing environment (DCE) universally unique identifier (UUID). GUID
Restore a dropped table with hot backup
(Brian Peasland) I have a 2-terabyte database. I don’t have a standby database and I don’t have a cold backup of the database. I have last night’s hot backup. One user unexpectedly dropped a table. How can I restore the table with minimal time? (R)
Update of SQL Server Database Publishing Toolkit for Web Hosting
(Scott Guthrie) A few months ago I posted about the new SQL Server Database Publishing Hosting Toolkit built and published by the SQL Server team. You can read about what it offers and how to use it in these previous two blog posts of mine: –Recipe: Deploying a SQL Database to a Remote Hosting