(Ben Snaidero) By now we’ve all read the improvements that can be gained with respect to performance by using the new SQL Server 2014 In-Memory OLTP feature, but are there any drawbacks to the feature?
Other News
Let the Data Guard Broker control LOG_ARCHIVE_* parameters!
(Uwe Hesse) When using the Data Guard Broker, you don’t need to set any LOG_ARCHIVE_* parameter for the databases that are part of your Data Guard configuration. The broker is doing that for you. Forget about what you may have heard about VALID_FOR – you don’t need that with the broker.
Apex substitution strings in reports, not always replaced with their values, guess why?
(Flavio Casetta) It’s amazing to you find out how easy is to take for granted certain features of Apex for the simple fact that you have been using them for a long time without paying too much attention to certain specific details.
Exadata and Virtual Private Database: will it offload my query?
(Martin Bach) During one of the classes I taught about Exadata optimisations I had an interesting question:
Getting started with MySQL Group Replication
(Pedro Gomes) The multi master plugin for MySQL is here. MySQL Group Replication ensures virtual synchronous updates on any node in a group of MySQL servers, with conflict handling and failure detection. Distributed recovery is also in the package to ease the process of adding new nodes to your serv
How to Refactor for Dependency Injection, Part 6: Binding by Convention
(Ondrej Balas) Explicitly setting all the bindings needed to compose your application — that’s a lot of work! See how to use convention over configuration to save time and make your composition easier to understand.
Using params in a C# Method
Here’s a little C# technique that can save you time when you passing an undefined set of data from one method to another. This may be a newbee kind of thing. But, if you haven’t come across it yet, it can be very handy. Let me start out with an example problem. Have you ever used the string.Format method in […]
Handling errors in T-SQL code
Handling errors in T-SQL code Author: Basit A. Farooq Like other programming languages, Transact-SQL provides a sophisticated mechanism that captures and handles errors during execution. The mechanism for handling errors during execution includes the Transact-SQL tradition error handling function @@ERROR and object-oriented-programming-style TRY…CATCH construct. In this article, you’ll examine both techniques. Traditional error handling Earlier versions of SQL Server supported...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Best practices for integrating IBM WebSphere DataPower SOA Appliances with WebSphere MQ
(Chintamani (Chin) Sahoo) IBM WebSphere DataPower SOA Appliances are purpose built computing devices that provide many integration end points for backend services. WebSphere MQ is one of the services used with DataPower to process messages in the enterprise. The integration of DataPower application
DB2 for z/OS: Thoughts on Table Space and Index Page Size Selection
(Robert Catterall) The other day I got a note, from a DB2 for z/OS DBA, in which I was asked for my thoughts regarding the selection of page size for a table space. I typed out what I hoped would be a useful response, and found myself thinking, as I sometimes do, “Hey — I could turn this into a […]