One of the biggest downsides of using SQL Server Management Studio as an interactive query tool is the limit on text/grid output. SSMS 18.2 fixes that!
Microsoft has released Cumulative Update #8 for SQL Server 2012 Service Pack 2. KB Article: KB #3082561 24 fixes total (23 fixes listed publicly at time of publication) Build number is 11.0.5634 Relevant for @@VERSION 11.0.5058 through 11.0.5633
Microsoft has released Cumulative Update #9 for SQL Server 2014. See this blog post for more information. KB Article: KB #3075949 30 fixes listed publicly at time of publication (31 total) Build number is 12.0.2553 Relevant for @@VERSION 12.0.2000 through 12.0.2552 Note: This cumulative update is only for RTM – […]
Microsoft has released Cumulative Update #2 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3075950 46 fixes listed publicly at time of publication (51 total) Build number is 12.0.4422 Relevant for @@VERSION 12.0.4050 through 12.0.4421 Note: This cumulative update is only […]
Microsoft has released Cumulative Update #7 for SQL Server 2012 Service Pack 2. This update has 38 fixes, including the QFE security fix from MS15-058. If you've installed MS15-058 (either the QFE – 11.0.5613 – or the GDR – 11.0.5343), you can still install this cumulative update. If you haven't […]
Well, it's that time again: Patch Tuesday. SQL Server hasn't had a security update since August, but today we're giving the hotfix download servers a run for their money. Both GDR and QFE fixes were released in Security Bulletin MS15-058, to address a vulnerability in remote code execution (for details […]
Microsoft has released Cumulative Update #1 for SQL Server 2014 Service Pack 1. See this blog post for more information. KB Article: KB #3067839 121 fixes listed publicly at time of publication (141 total) Build number is 12.0.4416 Relevant for @@VERSION 12.0.4050 through 12.0.4415 Note: This cumulative update is only […]
Microsoft has released Cumulative Update #8 for SQL Server 2014. See this blog post for more information. KB Article: KB #3067836 38 fixes listed publicly at time of publication (40 total) Build number is 12.0.2546 Relevant for @@VERSION 12.0.2000 through 12.0.2545 Note: This cumulative update is only for RTM – […]
Microsoft has released a hotfix (12.0.2504) which includes two fixes. KB #2999809 : FIX: Poor performance when a query contains table joins in SQL Server 2014 – this actually has to do with segment elimination in clustered columnstore indexes. KB #3058512 : FIX: Unpivot Transformation task changes null to zero […]
Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is 12.0.2495 Relevant for @@VERSION 12.0.2000 through 12.0.2494 Note: This cumulative update is only for RTM – […]
Stop me if you've heard this one before. Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services team blog: Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS […]
Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock cannot be resolved automatically. The hotfix can be downloaded from KB #3048751 and will bump SQL Server to 12.0.2488. […]