(Emmanuel Tissandier and Stéphane Lizeray) In an active-active topology, the server is installed in several data centers that all serve requests from mobile applications. Such a topology requires that you establish a database replication between the data centers.
Other News
Java SE 8 new features tour: Traversing, filtering, processing collection, & methods enhancements with Lambda
(Mohamed Taman) In this article of the “Java SE 8 new features tour” series, we will deep dig into explanation, and exploring the code, on how to traverse the collections using lambda expression and with method references, filtering them with predicate interface, implementing default methods in inte
T-SQL – How to find Next Business day from a given date
(Prashanth Jayaram) There are many methods to find next business day. One common way is to use of calendar table. This post is to get an output using T-SQL Or UDF function.
Using SQL Server’s GROUP BY clause to Summarize your Data
(Gregory Larsen) There are times when you want to have SQL Server return an aggregated result set, instead of a detailed result set. SQL Server has the GROUP BY clause that provides you a way to aggregate your SQL Server data.
Discrete and Continuous data in SQL
(Joe Celko) Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constr
SQL SERVER – What is is_not_trusted in sys.foreign_keys?
(Pinal Dave) My greatest source of learning is via my blog. Many of you take time in asking your toughest questions and sometimes basic questions that make me think. This interaction creates a source of exploration for me and ultimately translates into my knowledge sharing.
Solving SQL Error -805
(Troy L Coleman) In my career as a DBA, developers have asked me countless times about SQL Error -805. I’ll tell you what I’ve always told them: This error can be triggered for any number of reasons.
How to get the DB2 server instance owner
(Jack Vamvas) Getting the DB2 server instance owner is a common requirement for auditing and inventory management. As a DBA, application owners request my team start managing a DB2 server.
Database Performance: A Guide to Tools and Analysis
(Zach Fischer) If your business thoroughly understands how to leverage the information that is gathered and stored in your company database can be crucial to better understanding your audience and improving your business.
WPF Shapes – Path – Path Geometry
(Richard Carr) The one hundred and twenty-seventh part of the Windows Presentation Foundation Fundamentals tutorial starts to look at path geometry. This provides the most flexible way to draw open or closed shapes. However, it is the most complex option.