Friday, March 11, 2016

Microsoft SQL Server Announcement


  • Microsoft has indicated that support for SQL Server 2005 will end as of April 12th, 2016.

·         No access to critical security updates, opening the potential for business interruptions
·         Higher maintenance costs for maintaining legacy servers, firewalls, intrusion systems mean increased costs for the business
·         Compliance concerns – as support ends, organizations will likely fail to meet regulatory standards compliance 

  • With the introduction of SQL Server 2016, Microsoft will no longer offer the Business Intelligence edition. Beyond this change, they don’t anticipate any changes in the licensing model with the release of SQL Server 2016.

Tuesday, March 01, 2016

Instance wide script to add user (the 4th way)

My new script to add user to all databases in an instance published on http://www.sqlservercentral.com/ and can be found Instance wide script to add user (the 4th way). The script can be modified and can be used for various purpose.