by XTIVIA | May 6, 2015 | Blog, Data Management, Databases
Tip # 6 – Change History, Top 10 Tips for SQL Server Performance and Resiliency This article is part 6 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake...
by XTIVIA | Jun 18, 2014 | Blog, Perspectives
This article is part of an ongoing series. See the blog entry Delivering Your Enterprise: The ilities for an overall discussion. We’ve all been on projects where management stood up and announced some variation of “The project is running late – we...
by Derek Nerenberg | Jul 12, 2013 | Blog, Databases, Enterprise Java, Portals
Set the transaction isolation level to READ_COMMITTED with READ_COMMITTED_SNAPSHOT turned ON. Yay! When I mention the words “transaction isolation level” to SQL Server DBAs, the first words out of their mouths are almost always “READ...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Two bits of Information I picked up from our principal Informatica Architect. When I used these, it did really work wonders. Aggregators and joiners should have sorted input. The Sorter Transformation sorts rows more efficiently that the Aggregator...
by Kathleen Long | Jan 4, 2013 | Blog, Data Management, Databases
Every database holds different business data and has its own recovery needs. Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking...
by XTIVIA | Sep 28, 2012 | Blog, Databases
Given the general mayhem and wanton destruction database developers can inflict on an organization, you’d think there’d be a best-practices set of SQL Server permissions that DBAs should grant developers. Or better yet, a “dbdeveloper” server...