(Yaniv Etrogi) When using transactional replication to replicate data in a one way topology from a publisher to a read-only subscriber(s) there is no need to manage identity ranges.
Other News
When does a foreign key not reference a primary key ?
(Gary Myers) Generally your foreign key will point to the primary key in the parent table. However it is actually possible to point a foreign key to any column, or set of columns, where uniqueness is enforced through a constraint.
Concurrency Series: Basics of Transaction Isolation Levels
(Sunil Agarwal) In this series of blogs, I want to show some common concurrency questions that we get asked by customers. Before we look into common concurrency issues seen by customers, it will be good to review the transaction isolation levels provided in SQL Server.
BPM Portal 11g PS3 – How To Configure Oracle BPM 11g PS3 Process Portal on Oracle WebCenter Spaces 11g PS3
(Andrejus Baranovskis) If you are working with Oracle BPM 11g and Oracle WebCenter 11g technologies, definitely you will be interested to join these two together and create enterprise portal.
Index Block Splits — with REVERSE KEY Index
(Hemant K Chitale) An earlier post “Index Block Splits : 90-10” demonstrated 90-10 block splits for an index on a monotonously increasing sequence — as is defined in a Unique Index.
Not Your Standard Sorting Requirement
(Craig Mullins) Sometimes the requirements of a particular application dictate that data needs to be sorted using some irregular collating sequence.
Configuring Claims-Based Authentication in SharePoint Server 2010
(Jeremy Jameson) I thought it would be helpful to share my step-by-step procedures for manually configuring claims-based authentication in SharePoint Server 2010 using an “ASP.NET database” and corresponding membership and role providers.
Third Episode of ‘DB2 has Talent’
(Susan Visser) What an exciting week! With Watson winning on Jeopardy, meeting a member of the Watson team, and then today, the 3rd episode of the DB2Night Show’s competition DB2 has talent.
Using jQuery.ajaxSetup() To Accumulate Global Data Parameters For AJAX Requests
(Ben Nadel) In jQuery, we have the ability to make one-off AJAX requests with the $.ajax() method, or any one of its short-hand versions (ie. get(), post(), etc.). We also have the $.ajaxSetup() function which allows us to define globally-shared properties for all the AJAX requests made within a sin
Using Schemas in SQL Server 2008
(Danny Lesandrini) I’m not an expert on SQL Server Schemas. I first saw them implemented in the Adventure Works database and I have to admit I didn’t understand what I was looking at. The following explanation, right from an MSDN article, clearly describes schemas in newer versions of SQL Server: