Patch Tuesday : Security Updates for SQL Server 2012, 2014, 2016
Security updates were released today to patch a remote code execution vulnerability in Reporting Services, but I would install the patch even if you're not running SSRS.
Category: SQL Server 2012
#BackToBasics: DATEFROMPARTS()
I continue my #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
A "drop column" fix you will want for SQL Server 2012 / 2014
I caution about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
SQL Server 2012 Service Pack 3 is available!
SQL Server has released SQL Server 2012 Service Pack 3. You can download here and see some other details here. Build number is 11.0.6020.0 37 fixes (see the full list in KB #3072779) SP3...
SQL Server 2012 Service Pack 2 Cumulative Update #8
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...
SQL Server 2012 Service Pack 2 Cumulative Update #7
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...
Vulnerability Affecting All Supported Versions of SQL Server
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...
March 2015 Cumulative Updates for SQL Server 2012
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...
Out-of-band AG hotfix for SQL Server 2012 SP2 and SQL Server 2014
A hotfix has been released for an issue that causes Availability Groups to show as NOT SYNCHRONIZING. The original issue is described in KB #3033492 and in this SQL Server Release Services Team blog...
November 2014 Cumulative Updates for SQL Server 2012
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...
September 2014 Cumulative Updates for SQL Server 2012
The SQL Server team has released two cumulative updates for SQL Server 2012. SQL Server 2012 Service Pack 2 Cumulative Update #2 KB Article: KB #2983175 Build # is 11.0.5548 Currently there are 50...
Security Updates Available for SQL Server 2008, 2008 R2, 2012, 2014
If you are running 2008 SP3, 2008 R2 SP2, 2012 SP1 (SP2 is not affected, RTM is no longer supported), or 2014, you'll want to check out Security Bulletin MS14-044 for details on a...
SQL Server 2012 Service Pack 2 Cumulative Update #1 is available!
The SQL Server team has released SQL Server 2012 SP2 Cumulative Update #1. This cumulative updates Service Pack 2 to include the fixes from SP1 CU#10 and a few from CU#11, including the fix...
SQL Server 2012 Service Pack 1 Cumulative Update #11 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #11. This cumulative update includes a fix for the online index rebuild corruption issue I discussed recently on SQLPerformance.com. KB Article: KB...
SQL Server 2012 Service Pack 2 is available – but there's a catch!
Service Pack 2 is available: http://www.microsoft.com/en-us/download/details.aspx?id=43340 The build number is 11.0.5058, and this includes fixes up to and including SQL Server 2012 SP1 CU #9. (The complete list of fixes is exhaustive, including all...
Fixes for SQL Server 2012 & 2014 Online Index Rebuild Issue
I warn about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
SQL Server 2012 Service Pack 1 Cumulative Update #10 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #10. KB Article: KB #2954099 Build # is 11.0.3431 Currently there are 36 public fixes listed (38 total) Relevant for builds 11.0.3000...
SQL Server 2012 Service Pack 1 Cumulative Update #9 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #9. KB Article: KB #2931078 Build # is 11.0.3412 Currently there are 29 public fixes listed (33 total) Relevant for builds 11.0.3000...
SQL Server 2012 Service Pack 1 Cumulative Update #8 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #8. KB Article: KB #2917531 Build # is 11.0.3401 Currently there are 32 public fixes (34 total); the most interesting to me...
SQL Server 2012 RTM Cumulative Update #11 is available!
The SQL Server team has released CU #11 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2908007 Build # is 11.0.2424 This build has 15 fixes NOTE: This is THE LAST CU for the RTM branch....
SQL Server 2012 Service Pack 1 Cumulative Update #7 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #7. KB Article: KB #2894115 Build # is 11.0.3393 Currently there are 47 fixes (plus three undisclosed issues resolved); the most interesting...