I saw the announcement that we'll get a final SP4 for SQL Server 2012 soon, which is something I like. I think it's a good idea to roll up all the patches at some point and provide this as a final update for users. After all, we may not install the older version on new servers, but in the case of development or DR situations, we may need to create a new instance, and we want the patching to be smooth.

The final patch for SQL Server 2012 will have ( list quoted from MS):

We haven't always seen this. In 2005 we had an SP4, but then more CUs. SQL Server 2008 got to SP3, but with 17 more CUs. SQL Server 2008 R2, perhaps the worst software version name ever, went to SP3 and then just security patches. With 2012, we are getting this final SP and then hopefully continue the path of providing security patches only, but stopping the CU cycle here.

I've asked for final service packs, and while I don't think Microsoft really listens to me, I do hope they see this final patch for a version as a good way to close out support for all versions of their products. If you feel the same way, continue to put pressure on Microsoft, file items on Connect, and ask for one last patch for each version that you manage.

Join the debate, and respond to today's editorial on the forums

SQL Server 2016 : SQL Server 2016 - Administration

Dynamic script to backup many DBs and restore them on different instance - Hello All, I need to move about 50 DBs from my instance to anoter instance. Can you please share with me a...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Learning new programing language (Python or R)? - I'm quite good at SQL and T-SQL and am interested to learn a programming language. What would you recommend learning out...

SQL Query Help - Hi, Below is my sample code. What I want to loop through RN# and find the max(Cust_id) is my Max_id and use...

Performance degraded after migrating to 2016 from 2012 - I migrated my SQL Server database from 2012 to 2016 and I can see 2016 database performance is degraded instead...

SQL Server 2014 : Administration - SQL Server 2014

SQL 2014 & NICs - I just purchased a Dell PE730 which has 4 embedded NICs. I teamed the first two NICs, and I was...

Changing IP Addresses of AlwaysOn Group - We have 2 nodes in an AlwaysOn group. SQL2014 Enterprise. We need to change the IP addresses of the nodes, the...

Malicious Mischief - How to identify the perpetrator? - Recently, there's been a spate of malicious mischief one of my employer's key servers. > A database created, the owner falsified. >...

SQL Server 2014 : Development - SQL Server 2014

UNION returns null values - I have a Query which works fine but when I convert that query into a dynamic query, I get NULL...

SQL Server 2012 : SQL 2012 - General

How to Suppress backupToUrl in Error Log - Hi DBCC TRACEON (3226,-1) Only works for Backup To Disk. I'm hoping to suppress this for BackupToUrl. Any idea

Problem with net framework 3.5 installing sql 2012 server - Hi to all. During an installation of SQL 2012 server I had a problem with feature .net 3.5. I tried to install...

SQL Server 2012 : SQL Server 2012 - T-SQL

History snapshot - Hi, I've scenario to show "as on status" similar to monthly snapshot. Below is the table where I need to display...

Need some help with some "XML Hell" please. - I'm working on an expansion of an incredible idea by Fabiano Amorimthat (https://blogfabiano.com/2012/07/03/statistics-used-in-a-cached-query-plan/) which uses Trace Flag 8666 to add...

Adding conditional logic, help wanted - Hi all, I want to add a couple of features to my code, to add a flag column and then add...

SQL Server 2008 : SQL Server 2008 - General

Parsing out a History table that contains column changes - I have a history table that stores column changes in a column in a string format(i.e. |LastName:Smith|Jones|FirstName:Bill|William). I have a...

Things to consider while creating new table for an application - Hi All, I am going to design a new table for one functionality which we are going to add in our...

SQL Server 2008 : SQL Server 2008 Performance Tuning

Performance issue due to index - Hi All, Yesterday on a production environment we got complaints about very bad performance. I logged in and found out that all...

Reporting Services : Reporting Services

SSRS future - I am currently working on SSRS AND SQL (with Exp in SSIS and some in SSAS). what's the future of SSRS...

Data Warehousing : Integration Services

Unit testing ssis load - Good morning folks. We have a ssis package which is loading multiple files from an FTP location to the SQL server...

SQLServerCentral.com : Articles Requested

SSIS - Execute Package Task - Can someone write a basic article that explains how the Execute Package is used to run a child package or...

SQL Server 2005 : Backups

Naming Backup when saving to Disk with loop - Dear all expert, kindly please help on this syntax, I tried to make database name at filed description/name at msdb.dbo.backupset by...