Monthly Archives: September 2015

Month name and Weekday name in SQL Server

Ever wonder how you can get Month name and Weekday name in SQL Server? You need not hardcode and write any logic but you can use the function datename instead of datepart. Quick example on how it works… FYI:

Posted in Productivity, SQL Query, SQL Server | Tagged , , , , , | Leave a comment

AlwaysOn Availability Groups notes

AlwaysOn can broadly categorized into 2 (AlwaysOn Failover Cluster Instances, and AlwaysOn Availability Groups). I will capture Availability group highlights… AlwaysOn Failover Cluster Instances: failover cluster instance (FCI) is a single instance of SQL Server that is installed across Windows … Continue reading

Posted in High Availability, SQL Server | Tagged , , | Leave a comment