Logshipping to SQL Server on Linux (SQLServerCentral 6/5/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Logshipping to SQL Server on Linux]( - [Introduction to Azure Cosmos DB Security]( - [Choosing a Color Palette For Your Power BI Report]( (From the SQLServerCentral Blogs) - [Power BI Custom Visuals Class (Module 105 – Text Wrapper MAQ Software)]( (From the SQLServerCentral Blogs) Featured Script - [SQL Server All View Refresh]( The Voice of the DBA The Journey to DevOps Netflix is one of those companies that I find amazing. I was an early subscriber to their mail DVD service, and thought it was amazing how they processed both orders and physical objects with [technology](. As they pivoted to streaming, I continued to be impressed with their technology growth, from the [chaos monkey]( to their [DevOps deployments](. They have been an organization often looked to as a model for other technology companies. I certainly think there are things to learn from Netflix, as they've scaled and build quite a resilient system. They aren't necessarily worth copying, however, as the problem domain they solve is both narrow and also quite different than that many of us work in. If someone can't watch a movie, it's annoying, but they can pick another one. If a customer can't transfer money, communicate with another user in an app, or schedule a ride, it's a bigger deal for other problem domains. Still, Netflix didn't build this system overnight. They didn't come up with amazing DevOps techniques for building and deploying their software from the beginning. It's been a journey, and they talk about some of [the full cycle developer challenges in a recent blog post](. This looks at one team's journey across 6 years, from 2012 to this year. The piece is an interesting read, and it's not advocating for their particular approach, but rather trying to explain the value that they received from moving to a DevOps model, where they have a group that must run what they build. As I try to help customers and clients move to Database DevOps models, I see lots of similarities to what's in this post. As we look to optimize the entire software development life cycle, this requires a changing of roles and closer cooperation between groups. As I look at the evolution of Netflix, using a centralized group to build tools and then ensuring you have a better staffed development team that works to both build and support their software, ensuring clients get the value (or features) they need quickly. I've worked in orgs that did this in groups, and for the developers to be involved in operations is an eye opening experience. Developers will learn ensure they think about their design and test more because they don't like getting woken up. They listen Operations and learn about the ways in which they can better build a system that works. They start to realize "works" is a feature, perhaps the most important one. I've also found my role as a DBA can facilitate DevOps. I'm often between development and Operations, with a foot in both camps. I help developers build better tools and techniques to work with databases. I understand the impact on production databases, meaning I can help ensure that deployments are smoother, and we avoid risky changes. We build indexes early, install primary keys, test queries for performance, and more. The DBA is the one of the ways in which DevOps can grow in an organization, if they work with the developers instead of against them. 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]( ( 4.7MB) 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. ADVERTISEMENT [SQL Provision]( NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. [Download your free trial]( [SQL Compare]( 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]( Featured Contents  [] [Logshipping to SQL Server on Linux]( Evgeny Garaev from [SQLServerCentral.com]() An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.[More »](Server+2017/172693/) ---------------------------------------------------------------  [] [Introduction to Azure Cosmos DB Security]( Additional Articles from [Database Journal]() When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies. In addition, when dealing with data services, it is also necessary to distinguish between the data plane, facilitating access to the underlying content and the management plane, which allows for delegation of administrative tasks. In this article, Marcin Policht explores how these concepts apply to the Azure Cosmos DB offering.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Choosing a Color Palette For Your Power BI Report]( meaganl from [SQLServerCentral Blogs]( Color is a powerful attribute in data visualization. In a good visualization, it can focus attention and enhance meaning and...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Power BI Custom Visuals Class (Module 105 – Text Wrapper MAQ Software)]( Devin Knight from [SQLServerCentral Blogs]( In this module you will learn how to use the Text Wrapper by MAQ Software. The Text Wrapper allows you...[More »]( Question of the Day Today's Question (by Steve Jones): In SQL Server 2017, what are the limits for FKs on a table? 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: Foreign Keys (FK). We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [The DevOps Handbook: How to Create World-Class Agility, Reliability, and Security in Technology Organizations]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1942788002) More than ever, the effective management of technology is critical for business competitiveness. For decades, technology leaders have struggled to balance agility, reliability, and security. The consequences of failure have never been greater?whether it's the healthcare.gov debacle, cardholder data breaches, or missing the boat with Big Data in the cloud. [Get your copy from Amazon today]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1942788002). tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1942788002 Yesterday's Question of the Day Yesterday's Question (by Steve Jones): What is returned by this code? DECLARE @x VARCHAR = '777'; SELECT @x; Answer: 7 Explanation: This code returns 7. Why? The declaration of this variable as a varchar without a length, is a varchar(1). If you CAST or CONVERT to varchar without a length, then 30 characters are used. Note: Declaring a varchar without a length is a bad habit, as noted in the first reference below. Ref: Bad habits to kick : declaring VARCHAR without (length) - [click here]( char and varchar - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Featured Script [SQL Server All View Refresh]( Yusuf Kahveci from [SQLServerCentral.com]() run the script I prepared to update all the views in the database. Yusuf KAHVECI yusufkahveci@sqlturkiye.com www.sqlturkiye.com Thanks [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]( : [SQL Server 2017 - Administration]( ["Take a tail-log backup"]( - I'm testing a new backup technology and it has raised a question I thought I'd ask here. When you hear... [Final steps for making legacy application work on SQL server express 2017]( - I have a very old legacy application (from 2001) that was bundled with SQL server express 2000 (and did install... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Some users showing in error log as attempting to open a database they do not have access to]( - We use AD groups, SQL Server 2016. One AD group (with over a dozen users) that doesn't have any permissions/privileges... [SQLOLEDB vs SQLNCLI11]( - I am little confused. When i query sys.syservers i see provider name as 'SQLOLEDB' for some and 'SQLNCLI11' for some.... [Regulary delete and rebuild of table influences perfomance?]( - Ahoi, Situation: i have a table with around 40 million rows and a clustered primary key set by IDENTITY(1,1). Theres regulary deletes and... [Upgrading from SQL Server 2016 SP1 to SP2]( - Hi, I'm running SQL Server 2016 SP1 (specifically SP1-CU4) Developer on my development machine. I had downloaded the full SQL Server... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Wht is the best way to load 15 million rows into a table with a pk? There are known duplicates.]( - Good morning, I have a table that needed a Primary key on the table id column (tableID int). The table has... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [Die whitespace, DIE !!]( - Hi all, Trying to delete some white spacebar as follows...    /****** Object: Table .   Script Date: 04/06/2018 22:43:46 ******/ SET ANSI_NULLS ON GOSET... [create table from select]( - What's the correct syntax? CREATE TABLE Title2 AS SELECT * FROM Title Msg 156, Level 15, State 1, Line 2 Incorrect syntax near... [Extract columns from Json array]( - Hi Everyone, Does anyone know or suggest a way to extract column information from the Json array. We are still using... [Trying to select both "paths" through data]( - I'm working with one of the developers, he has an application which logs the "path" taken by a process. The... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Performance tuning a transaction]( - Hello SSC, Ok, I am going to try and explain this. Please bear with me :) I have this stored procedure that... [GUIDs as clustered index]( - Hi All, Looking for some suggestions. Currently, In our system we have GUIDs are primary keys and as the database... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [I need help getting last day of prior month in a view statement]( - so this is my code  CONVERT [Filegroups on different physical drives]( - Hi there,   Is there a disadvantage of having filegroups of a database on different physical drives? My Database is very... [Same query, two users, different performance]( - Hey Gurus, I have a query that performs differently depending upon the user executing it. This was first brought to my... --------------------------------------------------------------- [Programming]( : [Powershell]( [Powershell email throwing error]( - $File="gci \\abcd\efgh\ijkl | select -last 1" $From = "adcb@gmail.com" $To = "efgh@gmail.com" $Attachment = $File $Subject = "Here's the Email Subject" $Body = "This is what I want to say" $SMTPServer = "smtp.gmail.com" Send-MailMessage... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Importing a Flat File Containing Header and Detail Rows]( - Hello All, I'm not quite sure how to explain my situation without confusing the living hell out of everyone but i'll... [Flat File Comparison Approaches]( - We are about to upgrade to SQL Server 2016. Every day, we receive a "complete" text file for import. That... --------------------------------------------------------------- [SQLServerCentral.com]( : [SQLServerCentral.com Announcements]( [Website Work]( - We are beginning a project to redo the website in its entirety, with the exception of the forums. The forums... 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](. 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com