Microsoft SQL Server 2016 / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.1.5026.0)

Microsoft SQL Server 2016 / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.1.5026.0)
  SQL SERVER 2016 SP2 Update Version: MSSQL 2016 SP2, Build: 13.0.5026.0 / 13.1.5026.0, Release Date: April 2018, Download: https://www.microsoft.com/en-us/download/details.aspx?id=56836; SQL SERVER 2016 SP1 Update Version: MSSQL 2016 SP1 CU-8, Build: 13.0.4474.0 / 13.1.4474.0, KB: KB4077064, Release Date: March 2018, Download: https://support.microsoft.com/en-us/help/4077064/cumulative-update-8-for-sql-server-2016-sp1; Update Version: MSSQL 2016 SP1 CU-7, Build: 13.0.4466.4 / 13.1.4466.4, KB: KB4057119, Release Date: January 2018,...
read more

Microsoft SQL Server 2014 / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0)

Microsoft SQL Server 2014 / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0)
SQL SERVER 2014 SP2 Update Version: MSSQL 2014 SP2 CU-11, Build: 12.0.5579.0 / 12.2.5579.0, KB: KB4077063, Release Date: March 2018, Download: https://support.microsoft.com/en-us/help/4077063/cumulative-update-11-for-sql-server-2014-sp2; Update Version: MSSQL 2014 SP2 CU-10, Build: 12.0.5571.0 / 12.2.5571.0, KB: KB4052725, Release Date: January 2018, Download: https://support.microsoft.com/en-us/help/4052725/cumulative-update-10-for-sql-server-2014-sp2; Update Version: MSSQL 2014 SP2 CU-9, Build: 12.0.5563.0 / 12.2.5563.0, KB: KB4055557,...
read more

Microsoft SQL Server 2012 / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)

Microsoft SQL Server 2012 / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
SQL SERVER 2012 SP4 Update Version: MSSQL 2012 SP4 SECURITY UPDATE, Build: 11.0.7462.6 / 11.4.7462.6, KB: KB4057116, Release Date: January 2018, Download: https://support.microsoft.com/en-us/help/4057116/security-update-for-vulnerabilities-in-sql-server; Update Version: MSSQL 2012 SP4, Build: 11.0.7001.0 / 11.4.7001.0, KB: KB4018073, Release Date: October 2017, Download: https://support.microsoft.com/en-us/help/4018073/sql-server-2012-service-pack-4-release-information; SQL SERVER 2012 SP3 Update Version: MSSQL 2012 SP3 SECURITY UPDATE,...
read more

SQL Server / Instant File Initialization

SQL Server / Instant File Initialization
Instant file initialization reclaims used disk space without filling that space with zeros. What those this means for our SQL Server data files? Data file grow needs to be completed immediately.   Lets do a simple test. I will create additional tempdb files with fixed 10GB size without Instant file initialization enabled for the SQL Server service account. /* Adding additional tempdb files */ USE [master]; GO ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev2', FILENAME = N'D:\MSSQL\TempDB\tempdev2.ndf' , SIZE = 10GB , FILEGROWTH = 0);...
read more

SQL Server / 64KB Allocation Unit Size

SQL Server / 64KB Allocation Unit Size
MS SQL Server Best Practices Article suggests as a SQL Server configuration best practice is to format your data, logs, and tempdb file drives with a 64KB allocation unit size. NTFS Allocation Unit Size When formatting the partition that will be used for SQL Server data files, it is recommended that you use a 64-KB allocation unit size for data, logs, and tempdb. Be aware however, that using allocation unit sizes greater than 4 KB results in the inability to use NTFS compression on the volume. SQL Server, although it is not recommended that...
read more

SQL Server / Monitor Backup and Restore progress

SQL Server / Monitor Backup and Restore progress
Recently I had a situation on QA environment where Backup and Restore took a long time to finish. It was HA environment with two nodes in Always On High Availability Group, so backup and restored occurred over network shared location. Drives were slow, database was huge and network latency not the best  so it took a long time to add database to the availability group. To follow up backup or restore progress with start time, total elapsed time and estimated completion time in similar situation you can use following script SELECT Session_id as...
read more

SQL Server / MySQL / Linked Server / An unexpected NULL value was returned for column

SQL Server / MySQL / Linked Server / An unexpected NULL value was returned for column
Error: Msg 7342, Level 16, State 1, Line 8 An unexpected NULL value was returned for column “[MSDASQL].column” from OLE DB provider “MSDASQL” for linked server “LinkedMySQL”. This column cannot be NULL At the same time when I started writing this blog I also became active on MSDN forum, where I am trying to help SQL users to resolve theirs database issues. I just wanted to share with you one interesting issue appeared today (Msg 7342, Level 16, State 1, Line 8, An unexpected NULL value was returned for...
read more

SQL Server / Extended Events / Finding Deadlocks

SQL Server / Extended Events / Finding Deadlocks
Recently we experienced deadlocks on one of our staging servers, so I wanted to capture those deadlocks using Extended Events. This how I did it. First of all you need location where you gonna keep your XEL file, then we can create Extended Event session Using SSMS Creating new Extended Event session   Selecting Events you want to capture, in this case xml_deadlock_report   Save the event data to an XEL file   Using T-SQL CREATE EVENT SESSION [Deadlock_Report] ON SERVER ADD EVENT sqlserver.xml_deadlock_report ADD TARGET...
read more

SQL Server / Monitoring / SSMS Activity Monitor and Page Splits per Second on TempDB

SQL Server / Monitoring / SSMS Activity Monitor and Page Splits per Second on TempDB
On one of our older instances I noticed unusually high number of page splits per second, nothing spectacular, average around 20+ (normally below 5) just something unusual for that period of time.   Same period of time day before   I was curious and wanted to investigate what is causing this additional page splits. I did not noticed any performance issues. As well I checked the indexes of all user databases and there where no additional page splits. SQL Server provides a DMV to track page splits sys.dm_db_index_operationl_stats. You...
read more

Powershell / Use PowerShell to Backup all user databases to Azure Storage

Powershell / Use PowerShell to Backup all user databases to Azure Storage
Script Download: The script with usage example is available for download from https://gallery.technet.microsoft.com/Use-PowerShell-to-Backup-3bb0a397 Summary: Backup all user database from specified SQL Server instance to the buffer location, and then copy from the buffer location to the azure storage, and create log file with results. Description: This PowerShell script can be invoked remotely from another PC trough the command line, with PowerShell or executed remotely through task scheduler adding parameters – instance name, backup...
read more

« Previous Entries Next Entries »