(Pinal Dave) There are multiple ways by which we can take a backup of the SQL Server database. One of the methods used by 3rd party providers is using VSS (Volume Shadow Copy Service). One of my clients contacted me that 3rd party backup is failing.
Community
Tips for Delivering MySQL Database Performance – Part One
(Bart Oles) The database backend affects the application, which can then impact organizational performance. When this happens, those in charge tend to want a quick fix. There are many different roads to improve performance in MySQL.
Singleton Design Pattern With Java Sample
(Nagaraj M) Singleton design pattern is a creational design pattern. It is used to maintain single instance throughout the application.
Microsoft Tools That Help Query Tuning
(Grant Fritchey) Query tuning is not easy. In fact, for a lot of people, you shouldn’t even try. It’s much easier to buy more, bigger, better hardware. Yeah, the query is still slow on newer, faster hardware, but not as a slow as it was.
Cache in Java With LRU Eviction Policy
(Sunil P V) LRU (or Least Recently Used) is a cache eviction strategy, wherein if the cache size has reached the maximum allocated capacity, the least recently accessed objects in the cache will be evicted.
Ansible tips’n’tricks: defining –extra-vars as JSON
(Martin Bach) While I’m continuing to learn more about Ansible I noticed a nifty little thing I wanted to share: it is possible to specify –extra-vars for an Ansible playbook in a JSON document in addition to the space-separated list of key=value pairs I have used so often.
Size of Flashback Logs
(Marco Mischke) The todays blog post is about the Flashback Database feature inside the Oracle Database. I use this feature mostly in the context of Data Guard, but there are also other possible use cases like having a fallback during updates/upgrades etc.
OCI: When and How to Create an Integration to Call a Service from a Process?
(Jan Kettenis) With the Oracle Integration Cloud, when you have to call a service from a Process you can choose to call an external service directly or you can put an Integration in between. This article gives some directives why you may want to do the latter, and how to prevent a pitfall that is ea
Cardinality Without Runstats
(Joe Geller, Dave Simpson and Tony Andrews) As we all know, for each statement, Db2 determines the access path to use to find the data. It chooses the cheapest access path using the table statistics.
Filter Pinned Members in Watch Window – Debugging Tip
(Abhijit Jana) Filter Pinned Members in Watch Window helps in tracking member variables and faster debugging. Watch Windows is one of the most powerful and commonly used debugging tools inside Visual Studio.