A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

Roll Up All the Versions

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):

All fixes and CUs for SQL 2012 up to and including SQL Server 2012 SP3 CU9.
Scalability and performance improvements for SQL Server.
Additional monitoring capabilities through enhancements in DMV, Extended Events and Query Plans
New improvements based on connect feedback items filed by the SQL Community.
Some of the Improvements originally introduced in SQL 2014 SP2 and SQL Server 2016 SP1.

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.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( MB) podcast or subscribe to the feed at iTunes and Libsyn.

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial.

Library of articles for DevOps, DLM, & Continuous Delivery

Discover best practices and processes for more agile methods of database delivery. Find out how automating the build, test and deployment of database changes reduces risk and speeds up the delivery cycle. Read more on Simple Talk.

Featured Contents

Comparing and Synchronizing Two Folders with Azure

Daniel Calbimonte from SQLServerCentral.com

In this article, we will compare two folders using PowerShell, the command prompt and other tools. More »

SQL Server Temporal Tables: How-To Recipes

Additional Articles from SimpleTalk

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alex Grinberg shows how. More »

Azure SQL Database - Dynamic Data Masking

Additional Articles from Database Journal

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article. More »

Webinar: Microsoft’s Agile Transformation Story

Learn how Microsoft adopted DevOps at scale in this free Redgate webinar on June 12. Donovan Brown, Senior DevOps Program Manager in Microsoft’s US Developer Division, will share how Microsoft embarked on its own DevOps journey reducing a three-year release cycle down to three weeks. Sign up now. More »

From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 51 – Hierarchy Slicer)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Hierarchy Slicer Power BI Custom Visual. The Hierarchy Slicer visual... More »

From the SQLServerCentral Blogs - Power BI Report Server–Trial

Thomas LeBlanc from SQLServerCentral Blogs

I just installed the Power BI report server following @SQLDusty YouTube 13 minute Step-by-Step video. You have to download both... More »

Question of the Day

Today's Question (by Stanley Kapfunde):

Which of the following is not a valid system database in SQL Server 2014?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: SQL.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Exam Ref 70-761 Querying Data with Transact-SQL

Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

How can I prevent connections to my SQL Server from all applications except for the one I choose, and then only one connection?

Answer: Use the -m parameter with an application name

Explanation:

The way to do this easily is to use the -m parameter with an application name. You can do this as:

sqlsrvr.exe -mSQLCMD

sqlsrvr.exe -m"Microsoft SQL Server Management Studio - Query"

Ref: Database Engine Service Startup Options - https://msdn.microsoft.com/en-us/library/ms190737.aspx

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit 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...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.

This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.