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.
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.
I continue my #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
I caution about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.
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...
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...
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...
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...
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...
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
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...
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...
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...
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...
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...
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...
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...
I warn about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
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...
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...
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...
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....
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...
The SQL Server team has released CU #10 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2891666 Build # is 11.0.2420 This build has 4 fixes For most customers, this cumulative update hardly justifies the download,...
The SQL Server team has released CU #6 for Service Pack 1. KB article: KB #2874879 Build # is 11.0.3381 This build has 23 fixes by my count. The most interesting (to me) are:...
The SQL Server team has released CU #9 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2867319 Build # is 11.0.2419 This build has 7 fixes, including an interesting one involving LIKE Relevant for builds 11.0.2100...
The SQL Server team has released CU #5 for Service Pack 1. KB article: KB #2861107 Build # is 11.0.3373 This build has 30 fixes by my count. Relevant for builds 11.0.3000 -> 11.0.3372....
The SQL Server team has released CU #8 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2844205 Build # is 11.0.2410 This build has 6 fixes Relevant for builds 11.0.2100 -> 11.0.2409. Do not attempt to...
The SQL Server team has released CU #4 for Service Pack 1. KB article: KB #2833645 Build # is 11.0.3368 This build has 39 fixes by my count. For more information about this cumulative...
The SQL Server team has released CU #7 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2823247 Build # is 11.0.2405 This build has 17 fixes Relevant for builds 11.0.2100 -> 11.0.2404. Do not attempt to...
Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…
In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.
SQL Server 2012 Service Pack 1 Cumulative Update #3 Build # 11.0.3349 KB Article: KB #2812412 38 fixes! Relevant for builds 11.0.3000 -> 11.0.3348 NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999) SQL...
The SQL Server team has released CU #6 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2728897 Build # is 11.0.2401 This build has 22 fixes Relevant for builds 11.0.2100 -> 11.0.2400. Do not attempt to...
The SQL Server team has released CU #2 for Service Pack 1, which should include all of the fixes from CU #5, as well as some others. KB article: KB #2790947 Build # is...
Microsoft has released Cumulative Update #5 for SQL Server 2012 RTM. Note this is *not* a cumulative update for Service Pack 1. So if your build # is >= 11.0.3000, you should not be...
Some important informations on updates for SQL Server 2012.
Waited to deploy SQL Server 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4? You're running...
Last week I mentioned in passing that Service Pack 1 is now available, while I was blogging from the PASS Summit keynote. I wanted to put up an official post instead of having it...
Extended Events becomes much more usable in Management Studio.
Microsoft released new cumulative updates for SQL Server; they announced them on their blog several hours ago. SQL Server 2012 RTM Cumulative Update # 4 KB Article: KB #2758687 25 fixes are listed at the...
This morning the SQL Server team announced the release of Service Pack 1 CTP4 for SQL Server 2012. Back in July I talked about CTP3 and how the release contained BI features only; no...
There was a little bug in the cumulative update installer in early CU builds of SQL Server 2012 RTM.
Today the SQL Server Release Services Team has released the third Cumulative Update for SQL Server 2012. The KB article is at: http://support.microsoft.com/kb/2723749. The build number is: 11.0.2332.0. There are 35 fixes publicly documented at the...
Back on July 5th, I somehow missed that the SQL Server team had published a Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1. This is the 3rd CTP (I guess I...
See some of the ways to produce running totals, including new functionality in SQL Server 2012.
Today the SQL Server Release Services Team has released the second Cumulative Update for SQL Server 2012. The KB article is at: http://support.microsoft.com/kb/2703275. The build number is: 11.0.2325.0. There are 37 fixes publicly documented at the...
UPDATE 2020-01-28 – Microsoft has addressed my primary concern here in the SQL Server 2019 License Terms dialog: This is a great change, but I suspect a lot of people will still just check-check-next....
Tonight I presented my "What's New in SQL Server 2012" deck to the folks up in Portsmouth, NH. The deck can be downloaded here. File Attachment: AB_NH_SQL2012.pptx.zip
While I joked earlier this month that SQL Server 2012 Service Pack 1 was released on the same day as General Availability (hey, it's Microsoft's fault since they decided to GA on April 1),...
Microsoft has released Service Pack 1 for SQL Server 2012. Though so far it is only being made available for the x64 platform. You can download here: http://www.microsoft.com/en-us/download/details.aspx?id=35575 And read about the fixes in...