Blog : What’s On Our Mind?

Sharing Our Point of View
By Andy McDermid May 5th 2016
Backup Enhancements
One of the core requirement of being an active DBA is to understand what are some of the backup features to use in your environments. The need to take a backup has been in the industry since relational databases were invented. Hardly we see enhancements coming into this capability as this is so basic. With SQL Server 2016, I was pleasantly surprised to see a number of interesting enhancements coming into this space in this release of SQL Server. In this blog, I thought it…
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…