Tuesday, June 20, 2017

Predicting Hospital Length of Stay

For Hospital management make decisions on how to staff personnel, in real-time, based on patients currently admitted and what treatment is needed,it will be better of they can understand the what is the duration of the patient.
SQL Server 2016, R, and Cortana Analysis was used for this solution.



Thursday, June 8, 2017

How much do you really know about SQL Server 2016 licensing?

Licensing is something I have very very little understanding. I believe it is same with many technical guys. This will give you some understanding about SQL Server 2016 licensing.

Read more at http://searchsqlserver.techtarget.com/quiz/How-much-do-you-really-know-about-SQL-Server-2016-licensing

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.