Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Featured Script
Redgate Database Devops
The Voice of the DBA

A Mindset Shift

I've been working with people at Microsoft for nearly two decades in different circumstances. It's been interesting to me to work with developers, Microsoft consultants, and community people across the lifetime of SQLServerCentral, especially the last 5 years. For years I never wanted to work there, but I've started to think I might find it to be interesting in the last couple years.

There are two good articles that talk about the ways that Microsoft has changed. The first is from the high level culture perspective and tries to explain how the mindset has changed. If I hadn't been witness to it, I wouldn't believe it. These changes really happened, and they were amazing to me. I've been going to Redmond for 15 years, often working with a couple groups and since Satya Nadella took over, I've seen these changes get implemented. I've watched teams grow and change, and learn to reframe the way they look at their work. I think it's been a change for the better.

The second one is a little more technically detailed, and perhaps more interesting to anyone that would like to get their organization to adopt DevOps. There are some specifics with tools, but really read about the mindset changes and the feedback they use to improve software. I think too many managers think automation and features and forget that quality, experimentation and learning are keys to this working well. Make sure you point those out to managers if you pass this along.

Not everyone at Microsoft made the transition. Some left, some were probably asked to leave. New people came, but plenty adapted, altered their mindset, and have bought into the way that the company has evolved. They've certainly gone from a company I wouldn't want to work for because of the stacked ranking and competition to one I'd now consider. That's if they want someone remote in Denver.

I'm proud that Redgate is also moving in this type of direction. We've learned a lot from DevOp and we're learning that culture is important. We hire those that work well with us and help us build better tools for software developers in a team culture. Those that don't want to work with a team, work in a DevOps flow, and be accountable for their autonomy will probably move on. That's fine. We're learning who we are and implementing that into our staff. I've tried to do the same in my life, know who I am and be that. I hope you can do the same.

Steve Jones - SSC Editor

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

Redgate University
  Featured Contents

Challenge Your Code Design

gary.strange-sqlconsumer from

How to structure your T-SQL
objects and incorporate design principles.

What you need to consider for your monitoring strategy in 2020

Press Release from Redgate

Are you ready for growth in 2020? Whether that means wider business growth which you and your team will be expected to support, expansion of your SQL Server estate, or even your own professional development. Join Redgate in this free webinar on November 20th and be prepared for the coming year.

Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer

Additional Articles from

In this tip we look at how to use the SQL Server Maintenance Designer to build maintenance plans for your databases and instance.

From the SQL Server Central Blogs - #PowershellBasics: Get-Help -Online

Kenneth.Fisher from SQLStudies

One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading

From the SQL Server Central Blogs - Updated: Getting Started with Installing Kubernetes

aen from Anthony Nocentino's Blog

Let’s get you started on your Kubernetes journey with installing Kubernetes and creating a cluster in virtual machines. Kubernetes is a distributed system, you will be creating a cluster...


  Question of the Day

Today's question (by Steve Jones - SSC Editor):


Query the Services

Which services for a SQL Server 2017 install can I query in sys.dm_server_services?

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)

Halloween Protection

What is Halloween Protection?

Answer: This prevents an update from re-running changes to rows that were already updated

Explanation: Happy Halloween! Halloween protection protects against changes made by a process from affecting the process again. This is where SQL Server will read data, then keep a list of values before making changes, preventing the same values from being reprocessed. This is described by Dr. Greg Low in SQL: What on earth is Halloween protection?

Discuss this question and answer on the forums


Featured Script

STRING_SPLIT with Index as Table-Valued Function

bteague from SQLServerCentral

STRING_SPLIT with Index as Table-Valued Function

CREATE FUNCTION [capinv].[tvfn_String_Split_with_Index]
@String varchar(max)
,@Separator varchar(10)
SELECT ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS [Index], value AS [Character]
FROM STRING_SPLIT(@String, @Separator)

More »


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 2017 - Administration
SQL Upgrade (From SQL 2014) Suggestions - Hello Folks, We are planning to virtualize for one of our SQL environments. As part of this project, we are planning to upgrade SQL as well. Current version/Ed is SQL 2014 Enterprise. Do you recommend to upgrade to SQL 2016 or SQL 2017 or SQL 2019?   Please share your valuable thoughts... Thanks!
Transactional Replication - Hi, I've setup some publications and subscriptions today and use a backup to start off the process ( init from backup ). Restored a backup to server Added in new subscriber using a backup file - it creates the subscription and SQL job etc ok no errors. But I just get this ( I've setup […]
SQL Server 2016 - Administration
SQL Server Sizing - I am trying to migrate Mysql Database which is hosted on Linux to SQL Server. So as starting point i am thinking to go with same configuration as Linux box(CPU, RAM etc). However, I agree with SQL Server we have (in memory tables etc). That would need more memory. But i was thinking do the […]
Always on - I have question, i am configuring always on AG, so one of the replica would be used for reporting server(async mode). Looking at storage space, keeping the same space as primary replica would be good option, since primary replica server has only one DB and that would be used to replicate to the secondary replica? […]
Newbie Q: Restore fails with "Database in use" - I'm apparently very late to the game here - I intermittently (reluctantly) end up becoming someone's DBA and used to use all the time - great community, lots of great help provided. Looks like that ship sailed a couple years back! Anybody know what happened to them? That crap site in place of it […]
SQL Server 2016 - Development and T-SQL
CHECKSUM(3) = CHECKSUM(-3) ??? - I am trying to use CHECKSUM() to streamline a WHERE clause that detects when a row in one table is different from a row in a second joined table. Today I was surprised to discover that changing the sign of a decimal value does NOT result in CHECKSUM() calculating a different value. DECLARE @SomeValue1 decimal(18,8) […]
SQL 2012 - General
SP Estimated Execution Plan - Please let me know your thoughts. FYI.. I removed the tb and Dbname. First question.. Attached is the screen shot of the SP for which I generated the estimated plan the steps I did to create the plan was USE DBNAME EXEC SPNAME – then right click on the code estimated plan. My only concern […]
SSMS - Results Tab - Keyboard Shortcut - Greetings, In the results tab, is there a keyboard shortcut to copy a whole column of data starting from row number xx? I currently achieve this via another method by selecting a couple of cells in a column at the appropriate row number and then highlighting them by using shift and the mouse wheel. Ideal […]
NEED HELP - Hi all I am so happy to be part of our community. Hope to be shared your tips, knowledge cos I am new Ths in advance ^^  
SQL Server 2012 - T-SQL
Minor code change will it make a difference. -   Please let me know your thoughts on the below. Updated a small portion of the code. Just want to make sure it will give the same result. AND EXISTS (SELECT * FROM tbTask JOIN tbX_Dim_LatestVersion X ON X.X_ID = OD_X_ID AND X.X_Id = @X_ID WHERE Origin_ID = FI_ID) IS the below code does the […]
SQL Server 2008 Administration
How to upgrade to SP3 with multiple named 2008R2 instances on same server - I have a server with two named instances of 2008 R2, SP1.  I have downloaded the upgrade executables from Microsoft to upgrade to SP3 and then do the Meltdown patch.  Do I need to run each executable twice, one for each instance? If so, how?  I tried looking for posts describing how to do this […]
Upgrade from SP1 to SP3 on server with two named instances, run upgrade twice? - I have a server with 2008 R2 SP1 using two named instances.  When I run the SP3 upgrade executable (SQLServer2008R2SP3-KB2979597-x64-ENU), do I run this once or twice (one for each instance)?  I also realize that I need to run the Meltdown Patch executable, I presume also one time or two times?  For my single instance […]
Integration Services
NULL(DT_DATE Variable in SSIS - i have a variable in my SSIS package called Name                 datatype          value                       expression lastupdated      datetime          12/30/1899           NULL(DT_DATE)   My package has logic based on this date. if @[User::lastupdated] == (DT_Date) "12/30/1899" it goes to leftflow if @[User::lastupdated] ! = (DT_Date) "12/30/1899" it goes to rightflow.   i am using this same variable form my dtsconfig […]
Used Stored procedure in SSIS with different database name in DEV, Test and Prod - Hi, Can you please give me Idea, how can i use stored procedure in SSIS with different database name in Dev, Test and Prod ? In stored procedure, I am going to use source server as Phm_Dev ( Reading the data ) and load into  Med_Dev (destination server) So when I move my SSIS In […]
Unable to Open SSIS 2017 package - Hi,   There are a couple of SSIS package (2017) version developed by another developer that are running flawlessly from the server. As the developer moved to a new role, he saved the packages in a folder in the server . I am unable to open those packages from the server. When i asked another […]


RSS FeedTwitter

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 This newsletter was sent to you because you signed up at
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -