SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

Running a Production Docker Container

Featured Script

Previous Monday to the Start of the Previous Quarter

The Voice of the DBA

More MVPs Than Awards

July 1 is the Microsoft MVP Renewal date and quite a few people received good news that day. I was one of those renewed for another year. I am honored that Microsoft chose me again, and I congratulate all the others that received the award for the first time as well as those that were renewed.

Not everyone was renewed, and some very popular names were dropped from the list. I don't mean to leave anyone out, but a couple good friends were not renewed: Kevin Kline and Andy Kelley. Both are extremely talented SQL Server professionals and generous with their time and knowledge with the SQL community. They are truly MVPs to me, as are many others.

The MVP program is run by Microsoft, under their rules, and with their discretion about who is awarded and who isn't. I don't feel they did anything wrong here as I don't know what criteria they use or what information they had access to. I also know they have a limited budget and have to make decisions about who to award each year.

The award is an indication that you are providing a lot of valuable contributions to the technical community about some Microsoft product. The "lot" is some level reached by Microsoft. There are many people that provide very close to "a lot" of contributions to the community, but they don't make the cut off.

Think of the 100m dash in the Olympics. Only three people get to stand on the podium with medals after the final heat. They are those that are awarded. Don't think for a minute that the other 5 in that heat aren't fast. They are some of the fastest humans on the planet. They just didn't make the cutoff for the medal. They are still Olympians and worthy of fan's praise for their efforts on behalf of their country.

The same thing for Kevin, Andy, numerous others that didn't get renewed, and even more numerous others that help me, you, and many people in their technical community.

There are many more individuals out there that act like MVPs than Microsoft can award each year. Remember that when you read a response to a question you posted. Remember that when you attend the next SQL Saturday or other conference and listen to a speaker that is donating their time to teach you something. Remember that when you read an article by someone at SQLServerCentral or elsewhere. There are lots of MVPs for the data platform out there. Only a few of them get to use the designation from Microsoft, but there are many more worth thanking.

Steve Jones - SSC Editor

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

Featured Contents

Querying Temporal Tables

Diligentdba 46159 from SQLServerCentral

Temporal tables a.k.a Table Versioning was introduced in SQL Server 2016 and is an easy, convenient way to track changes to data. A good introduction to temporal tables can be found here. One of the key advantages of versioning tables is easy of querying – or getting a ‘single pane of glass’ look of how […]

New release: Data Masker 6.3 for SQL Server

Additional Articles from Redgate

The newest version of Data Masker for SQL Server includes a new rules window with in-product guidance for choosing the right rule, and a new menu bar for fast access to the items you need.

Introduction to DevOps: The Application Delivery Pipeline

Additional Articles from SimpleTalk

Some of the terms in the DevOps pipeline, such as CI and CD, can be confusing. In the second article of this series, Robert Sheldon explains these terms and how they fit in the DevOps pipeline. He also talks about some of the tools you might use.

From the SQL Server Central Blogs - Event Files on Linux

SQLRNNR from SQL RNNR

For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...

From the SQL Server Central Blogs - T-SQL Tuesday #116–Always Linux

Steve Jones - SSC Editor from The Voice of the DBA

This month is an interesting invitation from Tracy Boggiano. It’s on Linux, which I like. I hadn’t thought about this in terms of T-SQL Tuesday, but I think it...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Running a Production Docker Container
I want run a SQL Server 2017 in a container in production. Which of these variables must I specify when I execute the docker run command?
Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Resetting Status

What does sp_resetstatus do?

Answer: This resets the suspect flag on a database

Explanation: This will allow you to reset the suspect status on a database. Ref: sp_resetstatus - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-resetstatus-transact-sql?view=sql-server-2017

Discuss this question and answer on the forums

Featured Script

Previous Monday to the Start of the Previous Quarter

philmac750 from SQLServerCentral

Previous Monday to the Start of the Previous Quarter

SELECT
       DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) -1, 0) as BeginingOfPreviousQuarter, --beginning of
quarter.
       DATEADD(wk,DATEDIFF(wk,0,DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) -1, 0)),0) as PreviousMondayBeforeStartOfPreviousQuarter

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 - Administration

Cost Threshold For Parallelism - How do I find last update timestamp for Cost Threshold For Parallelism value? Is it logged somewhere?

Get history of blocking - Hi Is there any view that stores blocking history? Thanks

to change the netbios name on a replication server - Hello everyone I have a server in transactional replication I have a netbios change request from this server the Publisher and Distribution Server are configured on the same server what will be the impact of this change on the good functioning of my replication must change the logical no of this server through the command […]

Software need db owner permission to master database (sql2016) - We have a manufacturer whose software requires authorization for the master database. (only db owner working) Unfortunately, the manufacturer can not tell us why this access to the master database is necessary. Without Permission the application will not start What are your opinions? Have you ever seen such software? We have 200 different applications but […]

SQL Server 2016 - Development and T-SQL

Joining two tables using wild cards to populate a third - Good day folks, I could use some help, please. I am trying to populate a user access table: User_name, User_country, User_company, User_branch My first source table is : User_name, User_country, User_company, User_branch Joe, CA,01,* (or I could use %) Sally,CA,*,* Fred,*,*,* Wilma,CA,01,05 Barney,*,*,10 My second source table is : User_country, User_company, User_branch CA,01,10 CA,01,20 CA,01,30 […]

MCSA: SQL 2016 Business Intelligence Development Prep (Exams 70-767 & 70-768) - Did anyone take these certification exams? Can you point me to solid training and test prep materials? Thanks.

full text search - Trying to understand why when I search for numerics in full text, contains does not return, but containstable does. It seems that in that in this instance the 0's are repeatable and not indexed, but why does one work and the other not? Is there a way to make it work regardless? CREATE TABLE [dbo].[EquipSrch]( […]

Disable DCD on table fails - Hello everyone, I have CDC enabled on a few tables. Recently i had changed one column in 2 tables from varchar(20) to varchar(50) and then capture agent CDC job started to fail. What i found is that there is a bug in all SQL versions and no fix. The work around i found is: Drop […]

SQL 2012 - General

New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012? - MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new vulnerability in MSSQL, published 2019-07-09: CVE-2019-1068 | Microsoft SQL Server Remote Code Execution Vulnerability https://portal.msrc.microsoft.com/en-us/security-guidance/advisory/CVE-2019-1068#ID0EMGAC mysteriously excludes MSSQL 2012. The oldest supported version in the table is MSSQL 2014 SP2. And the article states "If your SQL Server version number is […]

SQL Server 2008 - General

Cannot upgrade SQL 2008R2 DB Engine - Hi; thanks for reading the post i have inherited a legacy SQL Farm with a couple servers running SQL2008. I am attempting a side-by-side upgrade on the servers (due to constraints out of my hands) I have successfully upgraded a number of them but have a troublesome few remaining. When I attempt an upgrade […]

SSRS 2016

PowerBI Server - Hi all, First of all forgive me if this is the wrong forum for this, I couldnt find a specific channel for PowerBi, so sorry. Anyway, I'm researching PowerBI and I've got myself a bit confused, imagine the scenario that I develop a report and then publish it to the cloud powerbi.com as I want […]

SSDT

pivot on SSDT 2017 - Good Morning everyone I have a problem with a tabular Project on SSDT 2017, I have a 1 table with columns Q1, Q2, Q3 & Q4, I need to Pivot this columns, the manual say that I used the transform Menu, but I dont Find this Menu, Could anyone help me please. I appreciate your […]

Integration Services

SSIS - I am trying to connect oracle 11.2 using Integration service Oracle Destination Editor and OLE DB Destination .Installed the Oracle database client on the SSIS server but still get the below error. There was an error trying to establish an Oracle connection with the database server. Did anyone made successful connection.Any idea or advise please? […]

SSIS Package/Agent Job Not Failing!!! - I have a package running in SQL 2016 using Project Deployment. One of the steps executes a stored procedure. All of the tasks have their error parameters left at default so any error should cause the package to fail because the maximum error count is 1. In this particular instance the database user account used […]

SQL Server and Sharepoint

Page Output cache problem - I have several users who see old page layout rather than new one. I am not sure what is the problem. Page output Cache profile says inherit inside site content cache option. Is this causing a problem?. I tried clearing browser cookies from user PC, but same problem thanks

This email has been sent to {email}. 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.