(Holger Linke) For migrating databases from an on-premise SQL Server to Azure SQL Database, Transactional Replication has become more and more popular. This approach has some important advantages: you may maintain a live copy of your production data in Azure SQL Database, and reduce the downtime for
(Mark Gillis) So the last few blogs have been a bit negative and have been built around common expressions and assumptions that make my hackles rise (If it ain’t broke, don’t fix it, We’re Risk Averse and Best Practice).
(Ben Nadel) Yesterday, I started to explore the Timeout attribute of the CFQuery tag, which is used to terminate long-running queries in ColdFusion.
(Joe Pluta) I think arrays are fantastic. I love how they can be used to represent so many things: the lines in an order, the stores in a city, or the cards in a poker hand.
(Fahd Mirza) Due to some unexpected data load, the space in DATA diskgroup became critically low on one of the production systems during middle of night on the weekend. There was no time to get a new disk and we needed the space to make room for new data load scheduled to be run after 3 hours.
(stewashton) Applications today use “optimistic locking” to avoid lost updates.
(Hemant K Chitale) Earlier I have already demonstrated adding and managing custom services in a RAC environment in a blog post and a video.
(John Scott) In a perfect world, one would upgrade databases one version at a time and not let them get too old. But our databases are where the “crown jewels” are. They must stay up 24×7.
(Tim Smith) We have a set of live data that frequently changes, even though there isn’t many data points and we had developers introduce other architectural layers, like caching mechanisms, but these introduced new bugs we hadn’t seen before their introduction.
(gaurav_rwt) In this post, I will explain the gridview paging technique that has numeric paging as default along with custom first and last page.