(Debadatta Mishra) As you know XML plays a major role in our product or project development and from an XML document we gather lot of information and also we can perform CRUD operations with XML files. But it is a matter of concern as to how we can ensure that the data available in an XML file are a
Author: SSWUG Research
How To Synchronise Multiple Database Objects Across Two SQL Server Databases or Instances
(Marcin) In two of my previous posts (HERE and HERE) I explored the concept of dynamic data synchronisation between tables in two different databases. Lately, I have been working with a client who required not only data to be replicated between individual tables but also the objects themselves.
Manual cleanup Change Data Capture for a SQL Server database
(Kun Lee) I had a database where the log file kept growing and used 99.99% of the available space. The database recovery model was set to “SIMPLE” and there was no replication setup for this database, but the transaction log kept growing. The next thing I looked at was Change Data Capture (CDC) to
Parsing List of JSON Elements as List With JSON.Net
(Amit Choudhary) I’ve been a big fan of JSON.Net for the past few years. Always helping me with less code and high performance conversion of JSON to C# objects. Thanks to James who made it possible as the fastest framework for manipulating JSON with great documentation.
Why low cardinality indexes negatively impact performance
(Ember Crooks) Low cardinality indexes can be bad for performance. But, why? There are many best practices like this that DBAs hear and follow but don’t always understand the reason behind. This article empowers DBAs to understand the logic behind why low cardinality indexes can be bad for performan
Sequences – transactional behavior
(Hans-Juergen Schoenig) In this posting I would like to describe some important aspects of PostgreSQL sequences. In our daily work we have noticed that some people are not fully aware of those implications described in this section.
Going Beyond Usernames and Roles with Claims-Based Security in .NET 4.5
(Peter Vogel) Claims-based security lets you manage your site’s authorization process using any criteria that makes sense to you. And the Microsoft .NET Framework 4.5 provides some performance support for you once you start using claims-based security.
DB2 Naming Standards
(Ember Crooks) Last week, I read this article by Craig Mullins: http://bitonthewire.wpengine.com/articlesection/default.aspx?TargetID=70585. Go read it, this blog entry will still be here when you get back.
Big Data Disaster Recovery: 4 Reasons Why DB2 Cloning is Excellent
(Dave Beulke) Big Data disaster recovery is a big issue. Of course, any Big Data business sponsor vows that the entire Big Data database is necessary, and demands it be included in the disaster recovery plans.
Data Driven Custom View Engine in ASP.NET MVC
(Sumit Maitra) The ASP.NET MVC framework, as we know, is highly pluggable, allowing you to easily swap out pieces of the framework with custom implementation.