(Lucas Jellema) The article “Quickly creating, deploying and testing a WebService interface for ADF Business Components” (http://technology.amis.nl/blog/9726/quickly-creating-reploying-and-testing-a-webservice-interface-for-adf-business-components) that I recently published describes a way of very r
Other News
Removing Unused Indexes
(Michael Campbell) A common sentiment that prevails in many SQL Server environments or shops is that when query performance begins to lag, it’s time to add new indexes.
Restore of Replicated Database fails with Cannot drop the table [table name] because it is being used for replication.
(Sateesh Yele) Issue: Restore of a replicated database fails with the following message.
Three SQL Server hardware upgrades to enliven performance
(Don Jones) The time will come — if it hasn’t already — when you’ll have to look at your SQL Server computer’s hardware and decide what, if anything, you can upgrade to get better performance out of the ol‘ box. I’ll assume that you’ve already taken care of the software side of performance: You’ve
WPF: Sorting On Something Other Than the First Letter of a String
(Ged Mead) I’m sorry – that’s a very clumsy description of what I’m doing here, but sometimes it’s hard to get a catchy heading that adequately describes what the item is about. So, picture this: You have a data source that contains names of contacts.
XML in the Cloud
More and more enterprises are discovering the advantages of implementing database applications in the cloud:
SQL SERVER – Copy Statistics from One Server to Another Server
(Pinalkumar Dave) I was recently working on a performance tuning project in Dubai (yeah I was able to see the tallest tower from the window of my work place). I had a very interesting learning experience there.
Share information while protecting privacy using IBM Optim Data Redaction
(Yasutomo Nakayama and Eisuke Kanzaki) IBM Optim Data Redaction enables effective disclosure of public information while protecting confidential information of the enterprise, as well as personal customer data. It masks private information in free-text documents and forms, based on the role of the r
Troubleshooting MySQL Slow Queries with Tcpdumps
(Sean Hull) MySQL has a wonderful facility for capturing slow queries called the slow query log. However if yours is not enabled when trouble occurs, and restarting the database is not an option, you’ll need another solution. This is where a tcpdump can come in handy. It can be used to watch a n
Are You Working with New Database Platforms?
Have You Seen the Latest SQL Server Show? Check out SelectViews – it’s an online show about the database world, including tips, news happenings. [Watch the Show Here] Are You Working with New Database Platforms? There are so many different things happening with new database platforms. From cloud-based alternatives that look and feel like your existing servers to cloud-based systems […]