Blog : What’s On Our Mind?

Sharing Our Point of View
By Craig Mullins May 3rd 2016
Character Versus Numeric Data Types
Most DBAs have faced the situation where one of their applications requires a code that is used to identify products, accounts, or some other business object. All of the codes are numeric and will stay that way. But, for reporting purposes, users or developers wish the codes to print out with leading zeroes. So, the users request that the column be defined as text, let’s say CHAR(4), to ensure that leading zeroes are always shown. But what are the drawbacks, if any,…
By Owens Gollamandala April 28th 2016
Virtualizing Old SharePoint
Why virtualize? Virtualizing SharePoint provides the flexibility and rapid deployment capabilities needed to meet ever-changing and complex business requirements. It provides simplified administration, and the capability to improve service levels via provisioning of management capability of multiple virtual hosts, by rapidly provisioning SharePoint farms and servers, and by transferring physical servers to virtual servers. Selecting hypervisor: hosted or bare metal? One of the most important decisions you’ll make when virtualizing your SharePoint farm is the selection of either “bare metal” or “hosted” hypervisor technology to host your…
By Eric Russo April 26th 2016
Performance Improvements
New capabilities get added with every single version that get introduced in every software. SQL Server 2016 is no brainer in this challenge. There are tons of great capabilities that get added in the area of performance tuning. Let me share a story about the same. Whenever there is a query which is executing for long time in SQL Server, one of the common question would be “where exactly the query is stuck”. In such situations, DBA used to check if IO or CPU is changing…
By Craig Mullins April 21st 2016
Dynamic SQL and Performance
The performance of dynamic SQL is one of the most vexing issues for DB2 developers and DBAs. In the past, most shops tried to avoid it, but that is no longer possible for modern systems. ERP/CRM systems, Java/JDBC programming, .NET programming, and web applications all rely heavily on dynamic SQL, and as such, dynamic SQL has become ubiquitous in DB2 shops everywhere. So why did DBAs attempt to strictly control dynamic SQL usage in days gone by? Well, the biggest reason is that the access…