SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Why DevOps? Employee Satisfaction

DevOps is being embraced by more and more companies, but still a minority of organizations that perform software development. There are plenty of software developers, project managers, and operational staff that are comfortable with their own process, even as they may struggle to produce software for their customers. I think DevOps is a better way to build software, and today I want to look at a benefit beyond faster releases. Today, let's talk employee satisfaction.

The State of DevOps report shows that companies who have implemented a DevOps process have more engaged and happier employees. According to the eNPS (e Net Promoter Score), the employees are more likely to continue to work there, and recommend the company to their friends. That endorsement of the organization comes with two benefits. Employees are more productive, and they bring other good employees to work. After all, how many employees recommend someone they don't want to work with or don't think can do the job?

More deployments, easier deployments, the ability to get your code used by customers while you still remember how it works. These are the keys to helping employees enjoy their jobs. When employees are more engaged, and when they are satisfied with their jobs, they work in a more focused manner, trying to ensure their work produces results that help others in the company. In other words, more valuable code.

DevOps isn't new; it's a name given to a number of productive, effective practices that the best software developers have been following for years. The idea of DevOps is being more and more widely embraced, resulting in better software, along with happier employees.

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 ( 2.8MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

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

SQL Clone

NEW product launch: SQL Clone - live stream this March!

Data Platform MVPs Grant Fritchey and Steve Jones show how to create database copies in seconds using MBs of disk space with Redgate’s NEW database provisioning tool SQL Clone! Tune in to this live stream session on March 29th 2017. Register now.

Featured Contents


Backups in Azure SQL Data Warehouse

Daniel Calbimonte from SQLServerCentral.com

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster. More »


Using Power BI in a Hybrid Environment

Additional Articles from Microsoft MSDN

Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. More »


From the SQLServerCentral Blogs - Help Me, Help You, Deliver DevOps

Grant Fritchey from SQLServerCentral Blogs

I believe in DevOps. Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive. I... More »


From the SQLServerCentral Blogs - Generating Frequency Table

Mala Mahadevan from SQLServerCentral Blogs

This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete... More »

Question of the Day

Today's Question (by Marek Grzymala):

You have a SQL 2014 SERVER\NamedInstance that listens on a statically configured TCP port 1970. One of the old applications needs to connect to that instance using the old default TCP port 1433. You decide to configure the SQL service to listen on multiple TCP ports, by adding ‘,1433’ in the TCP Port box, under Properties -> IPAll in the Configuration Manager, as described here. You restart all services, including the Browser, and verify that the Instance now listens on both ports 1970 and 1433.

Some clients connect using ‘SERVER\NamedInstance’ (rather than ‘SERVER,port#’) in their connection string. To which TCP port(s) will they now connect?

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 2 points in this category: Browser.

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


Securing SQL Server: DBAs Defending the Database

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Which of these enhancements makes AlwaysOn transport compression work faster? (choose 2)


  • Parallel compression options
  • Newer compression algorithms


There are two ways in which Always On transport has improved: new compression algorithsm and parallel compression options.

Ref: SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms - https://blogs.msdn.microsoft.com/psssql/2016/05/03/sql-2016-it-just-runs-faster-alwayson-parallel-compression-improved-algorithms/

» Discuss this question and answer on the forums

Featured Script

Connect to MongoDB on Remote Linux Server with Powershell

Michael D'Spain from SQLServerCentral.com

Depending on your view point, I have the lovely task, or not so lovely task or pulling data from 700+ MongoDBs on a linux servers into a SQL Server DB to build some reporting around a specific data point.  Using Powershell and the POSH-SSH module I was able to accomplish this.  I wasnt able to find much out there for this scenario.  Most of what I found was connection to MongoDB on a Windows box.   Please read my comments in the script for the explanation of how this works.  

Hope you find this useful.  

Good times. 

Michael D'Spain 

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 2016 : SQL Server 2016 - Administration

Production Database - Apply table partition also database is accessible. - Hi  I have a Production Database on my VMM. I have to partition a huge table (billions of rows) horizontally by...

Migrating Databases from old version to new version- in shortest time - Hi, To migrate lots of databases  (~1200 ) , ( some of them VLDB 500 GB ) on a Fri- Sun Maintenance Window 1.Schedule a maintenance...

kill connections to multiple databases in one shot - We have over 300 databases and folks keep sending data from all over the world from the front end app...

Always Encrypted & Powershell Script - Hello everyone. I am starting to work on a project that requires the encryption of a number of columns in...

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

Old Query that I dont quite understand - This is somethign that has been running in our Production system for many years and the more I look at...

QueryOptimization - Hi all, I have like this CREATE TABLE dbo.   (    IDENTITY(1, 1)          NOT NULL ,     NULL,      NULL,   [LastUpdatedat

SQL Server 2014 : Administration - SQL Server 2014

Modify Column - Tried to change the datatype from nvarchar(250) to nvarchar (20) using below script and its threw error ,but the same...

Database Growth and File Growth - We have a database and its files grow 1 GB  every 3 days and the file growth is given as...

Datatype Changes and its effect on Index - Changes dataype of a column which is not part of Clustered index key or any non-clustered index and the change...

SQL Server 2014 Patching (on Cumulatives updates) and Rolling Updates - Need advice - Hi all, As most of of you already know, MS recommends to patch CUs as the same as SPs. I have generally...

SQL Server 2014 : Development - SQL Server 2014

Searching T-Sql embedded in SSRS reports - Hi, Is there a way to search SQL script inside SSRS reports? One of our linked server name is changing. I do...

Create a view to view encrypted columns from a table - Hello All, I have a table that has 5 encrypted columns. I'm using Symmetric Key for the encryption. Usually when I...

Issue with deleting millions of rows of data - Hi all, A client I work with has a database that has been customised by a vendor, which is causing some...

Update Query Performance - Hello Experts, Following update Query takes about 1 Millisecond to update a Product reserve under less Load. But when thousands of...

SQL Server 2008 : SQL Server 2008 - General

Stored Procedure Result Truncation - I just encountered a set of Stored Procedures that had recently been moved to a job running under the SQL...

High CPU for "System" Process - Never really come across this issue, i have a query when i execute overall server CPU gets to 80%.When i...

SQL Server 2008 : T-SQL (SS2K8)

Primary key violation on INSERT, even though TABLOCKX is held - Hi I have an issue where a stored procedure runs the following code and a PK violation is reported (although I...

SQL Server 2008 : SQL Server 2008 High Availability

SQL Mirroring + Multiple End Points on SQL Instance - I have a production SQL Instance running SQL 2008 SP1. I am mirroring several databases to another SQL 2008 SP1...

Database Design : Design Ideas and Questions

MS SQL Licensing - If I have a developer reaching over from a SQLDev instance using a linked server into production is this a...

SQL Server 2005 : Administering

Hung jobs detected. - How do I troubleshoot when I see hung jobs? I'm sure restarting sql services will help but is this the only...

This email has been sent to {user_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.
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.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com