Tuesday, May 30, 2017

SQL Server Sizing Guide

This document can be used when configuring hardware for physical and virtual SQL servers. It should be used as a guideline, with actual configuration depending on size of databases, reports, and types of usage.

Read more at http://www.ceservices.com/sites/default/files/resources/docs-protected/CES_SQLServerSizing.pdf


CAST and TRY_CAST

We always face issues with casting. When we write casting we expect, it to be in required data type. However, often we see there error with CAST when the correct data is not provided. This might cause entire process to fail.


This issue can be avoided in SQL Server 2012 with TRY_CAST.





Wednesday, May 17, 2017

Best Practices for SQL Server Deployment in Healthcare

Though this article is specific about SQL Server security in health care,  we can apply the same principals for other environments as well,

Read more at http://healthitsecurity.com/news/best-practices-for-sql-server-deployment-in-healthcare