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...
Fun with THROW: Avoid % and use semi-colons!
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
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...
SQL Server 2012 RTM Cumulative Update #10 is available!
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,...
SQL Server 2012 Service Pack 1 Cumulative Update #6 is available!
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:...
SQL Server 2012 RTM Cumulative Update #9 is available!
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...
SQL Server 2012 Service Pack 1 Cumulative Update #5 is available!
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....
SQL Server 2012 RTM Cumulative Update #8 is available!
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...
SQL Server 2012 Service Pack 1 Cumulative Update #4 is available!
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...
SQL Server 2012 Cumulative Update #7 is available!
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 Announces SQL Server 2012 R2 and SQL Server 2012 R3!
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…
Performance-related fixes for SQL Server 2012
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.
March 2013 Cumulative Updates – SQL Server 2012 SP1 & 2008 SP3
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...
SQL Server 2012 RTM Cumulative Update #6 is available!
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...
SQL Server 2012 Service Pack 1 Cumulative Update #2 is available!
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...
Cumulative Update #5 is available for SQL Server 2012 RTM
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...
SQL Server 2012 Service Pack 1 & Cumulative Update 1
Some important informations on updates for SQL Server 2012.
SQL Server 2012 Service Pack 1 Cumulative Update #1 is available!
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...
SQL Server 2012 Service Pack 1 is available – this time for sure!
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...
An important change to Extended Events in SQL Server 2012
Extended Events becomes much more usable in Management Studio.
October 2012 Cumulative Updates are available – SQL Server 2008 R2 & SQL Server 2012
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...
SQL Server 2012 Service Pack 1 CTP4 is available
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...
SqlLocalDb vs. Cumulative Updates
There was a little bug in the cumulative update installer in early CU builds of SQL Server 2012 RTM.
SQL Server 2012 Cumulative Update #3 is available!
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...
SQL Server 2012 Service Pack 1 CTP3 is available – but there's a catch
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...
Best approaches for running totals – updated for SQL Server 2012
See some of the ways to produce running totals, including new functionality in SQL Server 2012.
SQL Server 2012 Cumulative Update #2 is available!
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...
A cautionary tale about CAL licenses in SQL Server 2012 Enterprise
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....
Seacoast SQL Users Group : What's New in SQL Server 2012
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
SQL Server 2012 Cumulative Update #1 is available!
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),...
SQL Server 2012 Service Pack 1 is available!
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...