Blog : What’s On Our Mind?

Sharing Our Point of View
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…
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…
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…
MySQL Clustering
There are two different cluster solutions available to MySQL users: Galera and MySQL Cluster. Both have some very nice features, but they also have issues. MySQL Cluster “MySQL Cluster is a scalable, real-time in-memory, ACID-compliant transactional database, combining 99.999% availability with the low TCO of open source,” says Andrew Morgan, MySQL Principal Product Manager at Oracle. MySQL Cluster is built around a distributed, multiple-master architecture with no single point of failure. MySQL Cluster scales horizontally on standard servers and is accessed with SQL and NoSQL interfaces. Originally designed…