Home » Installation
Category Archives: Installation
Cumulative Update #2 for SQL Server 2016 SP1
The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU#2 KB Article: https://support.microsoft.com/en-us/help/4013106 Understanding Incremental Servicing Model for SQL Server Microsoft® SQL Server® 2016 SP1 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=54613 … Continue reading
Cumulative Update #11 for SQL Server 2014 SP1
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. Please visit: CU#11 KB Article: https://support.microsoft.com/en-us/help/4010392/cumulative-update-11-for-sql-server-2014-sp1 Understanding Incremental Servicing Model for SQL Server Microsoft® SQL Server® 2014 SP1 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=51186 Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx (Source … Continue reading
Restrict user to login from single Host
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can achieve it through SERVER LEVEL LOGON TRIGGER. ALTER TRIGGER TR_CHECK_LOGIN_TEST_HOST ON ALL SERVER FOR LOGON AS BEGIN DECLARE @HOSTNAME VARCHAR(48) DECLARE @PROGNAME VARCHAR(100) SELECT @HOSTNAME = HOST_NAME FROM SYS.DM_EXEC_SESSIONS WHERE SESSION_ID = @@SPID IF ORIGINAL_LOGIN() … Continue reading
What’s new in SQL Server 2016 installation?
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window. 2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access to perform instant file initialization … Continue reading
Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2. Those who are facing severe issues with their environment, they can plan to test … Continue reading