Newsletter Subject

Do We Need to Learn Linux? (2021-07-10 DBW)

From

sqlservercentral.com

Email Address

subscriptions@sqlservercentral.com

Sent On

Sat, Jul 10, 2021 10:02 AM

Email Preheader Text

Database Weekly for July 10, 2021 Problems displaying this newsletter? . The Complete Weekly Roundup

Database Weekly for July 10, 2021 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  Do We Need to Learn Linux? This week we got an announcement about SQL Server in Containers. Microsoft put out a blog noting that [the beta program for SQL Server on Windows containers is suspended](. They didn't give any details, citing "ecosystem challenges and usage patterns" as a reason so suspend the program for the foreseeable future. Not only that, they noted that they were deleting docker hub images for express and developer, which makes sense from their perspective. They don't want to support these. From the developer perspective, however, this will break and flow, pipelines, or even local scripts from developers. I understand the desire to delete images, but doing so without any notice doesn't seem like fair treatment for people using them. This means that if you want to run SQL Server in a container, you have to use Linux. I think that containers will be the future of database development, as they standardize and simplify how we can get an environment up and running. They also ensure consistent environments between developers, branches, automated systems and more. I think it's going to take years, but that's the direction where I think many of us will go over time. Those days of the Developer Edition will be gone, and instead we'll just run a container. I've been using Linux containers for a few years, and they make it easy to quickly set up a clean environment with a new instance and a database or two. In that time, I've had to use a little Linux at times, but really, I start a container from a command line and then it acts like an instance I've installed. There isn't a reason to actually do much in Linux. At least not for the core database stuff. Most of the ways that you'll work with a Linux instance as a developer stay the same. For system administrators and DBAs, however, you might need to learn more. While setting up an instance on Linux isn't hard, and easier in a container, if you are called on to work in bash, execute sudo, or some other Linux command, you might want some basic familiarity. Fortunately, you don't need another workstation as Windows 10 includes a [Windows Subsystem for Linux]( that let's you play around in Linux inside Windows 10. I think Linux is fascinating, and it's evolved in many ways since I first saw it in 1991. Even if it's not something you expect to use daily, spending a few hours learning how to navigate around and get things done is good for your mind, forcing you to learn a bit. The [San Diego TIG did a series]( a few years ago, and you might go through those meetings or pick up a book and spend some time playing around with something new. You never know when this might be required in your career and a little familiarity could give you a jump start in the future. Do we need to learn Linux? No, but it's not a bad idea to build a few skills in this area. Steve Jones - SSC Editor [Join the debate, and respond to the editorial on the forums](  The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. AI/Machine Learning/Cognitive Services [Azure Arc-enabled Machine Learning – Run AML anywhere]( In practical Machine Learning workloads, various infrastructures and devices (such as, a variety of GPUs, high-speed inter-connections, etc) are required and used. With Azure Arc-enabled Machine Learning, you can bring AML open architecture into existing external resources, such as, on-premise GPU machines or 3rd party platforms (EKS, GKE, etc). Administration of SQL Server [Scale your SQL Server MDF database data files]( From David Klee Do you have quite large MDF files on your database... [Attach Database Without Transaction Log File]( From Callihan Data What if you’re moving a database to a new server... [How to Fix SQL Database Error 8961?]( From SQLServerCentral Blogs Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext... The... [How to enable SQL Server trace flags]( From Simple Talk DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to enable SQL Server trace flags.… The post How to enable... [Managing SQL Server transaction log size]( The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg Larsen explains how to manage the transaction log size. [Server Review Essentials for Accidental and Junior DBAs—Daily Server Checks (Part 1)]( From DallasDBAs.com Welcome back to the series “Server Review Essentials for Accidental and Junior DBAs.” So far in this series we’ve taken a look at how to set up your work... [Get Ready: SQL Server 2016 Mainstream Support Ends in One Week.]( From Brent Ozar Unlimited Who am I kidding? You’re not really going to get ready, but let’s talk about this anyway. SQL Server 2016 mainstream support ends Tuesday, July 13, 2021. According to... [Permissions Needed To Force Plans in Query Store]( From Scary DBA (Grant Fritchey) I was recently asked what permissions were needed to force plans in query store. I’m sure I knew at one point, but at the moment I was asked, I... [Benefits of Optimize for Ad hoc Workloads]( From Callihan Data Anytime you run a query, SQL Server needs to build an execution plan to use as directions for best executing that query. These execution plans can be stored in... [#SQLServer: There's Something About SQLOS Memory Node Free Memory on NUMA systems...]( From sql.sasquatch In 2018 I wrote two blog posts about memory accounting behavior on NUMA servers I was seeing in SQL Server 2016, 2017, and eventually 2019. Some amount of memory counted... Analysis Services / BI on the MS Stack [Historical Data Loading – Part 5 – Migrating AAS to PPU]( From FourMoo In this blog post I am looking at how to load or r... Azure CosmosDB [Learn NoSQL in Azure: Getting started with DocumentDB SQL API]( From SQLShack This article is a part of the series Learn NoSQL in Azure where we will learn about the DocumentDB SQL API in detail. Azure Cosmos DB is a serverless... Azure Databricks, Spark and Snowflake [Dynamic M Parameters, Snowflake Native SQL And Paginated Reports]( From Chris Webb's BI Blog There were a couple of new features and enhancements to existing features in the June 2021 Power BI Desktop release that don’t seem to have much to do with... Azure DevOps [One Power BI report for both Azure Boards and GitHub]( From Kevin Chant Reading Time: 4 minutes In this post I want to cover creating one Power BI report for both Azure Boards and GitHub. Because I covered it in a... Azure SQL Database [How to learn about Azure SQL]( From Simple Talk It was always important to me to keep up with the ... [Azure SQL Database Maintenance Window]( From SQLShack Azure SQL Database and SQL Managed instance are Microsoft offerings for PaaS SQL Server in cloud infrastructure. In the case of a traditional on-premises SQL Server, at certain times,... Career Growth and Certifications [Who’s Hiring in the Database Community? July 2021 Edition]( From Brent Ozar Unlimited Is your company hiring for a database position? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your... [Do you need SQL for a data related job?]( I wanted to talk about this because I see a lot of doubts and lack of direction from people who are either beginning now in IT land or thinking about switching careers. The short answer to “do I need to know SQL for a data job?” , is yes. In the next few paragraphs I explain why I think so. [The SQL Server community and the rising tide (and all that).]( From SQLServerCentral Blogs I was speaking with one of my favorite people in the SQL Server community, Grant Fritchey (blog|twitter), on twitter today. ... Continue reading The post The SQL Server community and... [Free Training For SQL Server Beginners]( From Erik Darling Data Month Of Sundays All this month I’m going to be giving readers (watchers? stalkers?) access to my Starting SQL video course. It’s part of my paid training content, which... Community Interests [On accessibility in our community]( From Born SQL Today I want to write about the community that brought us all together. The community that got this very website on your radar. The community that got many of... Computing in the Cloud (Azure, Google, AWS) [Case-insensitive collation support for string processing in Amazon Redshift]( Amazon Redshift is a fast, fully managed, cloud-native data warehouse. Tens of thousands of customers have successfully migrated their workloads to Amazon Redshift. We hear from customers that they need case-insensitive collation for strings in Amazon Redshift in order to maintain the same functionality and meet their performance goals when they migrate their existing workloads from legacy, on-premises data warehouses like Teradata, Oracle, or IBM. With that goal in mind, AWS provides an option to create case-insensitive and case-sensitive collation. [Azure Resource Manager Template]( From SQLServerCentral Blogs Azure Resource Manager (ARM) Template is a cloud automation API for deploying Azure resources such as VM, database, network and storage services repeatedly with little(more...) The post Azure Resource Manager... Conferences, Classes, Events, and Webinars [How estate monitoring enables Vistaprint and their 17 million global customers]( Join Vistaprint Senior DBA, Adam Brenden and Microsoft Data Platform MVP, Grant Fritchey to hear first-hand how proactive estate monitoring and accurate reporting, now enable the Vistaprint team to detect, diagnose, and resolve performance problems before they impact operations or customers. [Join me for a SQLBits Replay of Faster SSIS 15 Jul!]( From AndyLeonard.blog() I am honored to join viewers for a SQLBits Replay ... DMO/SMO/Powershell [Display-Object: a PowerShell utility Cmdlet]( From Simple Talk How do you list all the objects and values within a PowerShell object, investigate an object or explore its structure? There must be a simple way. I used to... Data Visualisation [connecting the slide title to the graph]( From Storytelling with Data Today’s post outlines one approach to get your message across more clearly: use color to connect the slide title to the graph. First, a bit of background. When communicating with... Database Design, Theory and Development [Much Ado about nothing: missing data]( Joe Celko explains how missing data is handled from the printing press to databases. ETL/SSIS/Azure Data Factory/Biml [New Azure Data Factory home page, what's in it for me?]( From SQLServerCentral Blogs (2021-July-07) Back in the late 90s when I was a college student intern at a local power supply company, I was invited to a social event of our IT department.... The... [Data Wrangling with Power Query in Azure Data Factory]( From SQLShack This article will help you get started with Power Query in Azure Data Factory to perform Data Wrangling. Introduction Modern data landscape and infrastructure consist of a variety of... Hardware [Intel Hybrid CPU Starts 'End of Life' Process]( From AnAndTech As I opened my inbox this morning, I was surprised. I keep track of when Intel puts products on End of Life (or starts the process through something called... MDX/DAX [FILTERS – DAX Guide]( From Sqlbi FILTERS: Returns a table of the filter values applied directly to the specified column. [Quickly Format All DAX Code in Tabular Editor]( If you aren’t using Tabular Editor to format all of your DAX code for you, you are missing out. I’ve written a super short script that will format all of your DAX code in measures, and make it look picture perfect in Power BI Desktop. [How the UNICHAR() DAX Function Enhances Power BI Reports]( The UNICHAR() DAX function is a text function that takes a numerical Unicode value and displays its associated character. For example, UNICHAR(128515) will display as: [Optimizing conditions involving blank values in DAX]( From Sqlbi Learn how blank values in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases. [GROUPBY, CURRENTGROUP – DAX Guide]( From Sqlbi GROUPBY: Creates a summary the input table grouped by the specified columns. CURRENTGROUP: Access to the (sub)table representing current group in GroupBy function. Can be used only inside... Performance Tuning SQL Server [Starting SQL: SARGability]( From Erik Darling Data Starting SQL: SARGability If you want to check out... [Add DBCC INPUTBUFFER to Your Performance Tuning Toolbox]( From DCAC A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU... [SQL Server performance monitor data: Introduction and usage]( Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some of the SQL Server performance monitor data and how to collect it. [Plansplaining, part 19. Temporal tables (part 4)]( From SQL Server Fast Welcome to part nineteen of the plansplaining series, where I will finally wrap up the discussion on temporal tables. In the first three parts, we looked at execution plans... PowerPivot/PowerQuery/PowerBI [Create Buckets or Groups with Power Query in Power BI]( From Guy in a Cube There are different ways you can create buckets or... Product Reviews and Articles [THE QDS TOOLBOX]( The QDS Toolbox is set of tools that can help you review and store the performance related data in Query Store. This was released by ChannelAdvisor last September thanks to the hard work of a number of my coworkers. [Migrating Between Monitoring Systems]( From Blog – Redgate Software This question comes up all the time: How do you migrate between monitoring systems? The answer is both simple and complicated. In order to understand this better, rather than... [Getting the Script from the SQL Compare Command Line]( From SQLServerCentral Blogs In the last few posts, I’ve written about using the SQL Compare command line for a specific object and shown how to get a report. This post will look... The... Python [Pedestrian Detection using PyTorch]( From Data Blogger In this blog post, you will learn how to implement... R Language [Using different fonts with ggplot2]( was recently asked to convert all the fonts in my ggplot2-generated figures for a paper to Times New Roman. It turns out that this is easy, but it brought up a whole host of questions that I don’t have the full answer to. [Little useless-useful R functions – Inserting variable values into strings]( From TomazTsql Another useless function that could be found in ma... Replication [Troubleshooting SQL Server Transactional Replication Issues]( From SQL Server – {coding}Sight SQL Server Transactional Replication is one of the most common Replication techniques used to copy or distribute data across multiple destinations. In the previous articles, we discussed SQL Server... Security News and Issues [Morgan Stanley discloses data breach that resulted from Accellion FTA hacks]( From Ars Technica Financial services firm says data was stolen by ex... [Details of the REvil Ransomware Attack]( From Schneier on Security ArsTechnica has a good story on the REvil ransomware attack of last weekend, with technical details: This weekend’s attack was carried out with almost surgical precision. According to Cybereason, the... [Security 101: The Windows 'PrintNightmare' Flaw]( From IT Pro - Microsoft Windows Information, Solutions, Tools A closer look at the Windows printer software vulnerability – and what you can do about it. [Why the password isn’t dead quite yet]( From Ars Technica Everyone hates the old ways of authentication. But change comes with its own drawbacks. [Vulnerability in the Kaspersky Password Manager]( From Schneier on Security A vulnerability (just patched) in the random number generator used in the Kaspersky Password Manager resulted in easily guessable passwords: The password generator included in Kaspersky Password Manager had several... T-SQL [UI Design Patterns That Don't Scale]( From SQLPerformance.com Michael J Swart takes a look at a few common UI design patterns that don't necessarily scale well with SQL Server. The post UI Design Patterns That Don't Scale appeared... [TSQL Basics Part 14: FULL OUTER JOIN w/ exclusion – Video Explanation]( From Steve Stedman This is part 14 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and... [Stop using sp_hexadecimal & sp_help_revlogin]( From Andy M Mallon – AM² Since I started at Stack Overflow, I’ve had the ... [File Validation in SQL Server with xp_fileexist]( From SQLShack In this article, we will explore the xp_fileexist extended stored procedure usage and other details. At the same time, we will take a look at alternative methods to this... [Ways to Compare Data]( From Sherpa of Data Today’s one of my favorite days – the day we s... Tech News [Pentagon kills Microsoft’s $10B JEDI cloud contract, says tech is now outdated]( From Ars Technica Amazon's legal stall tactics seem to have paid off. [Biden’s right-to-repair order could stop companies from blocking DIY fixes]( From Ars Technica Executive order comes amid growing state, federal push to open repair process. The Lighter Side [New Blog: Data On The Road]( From Paul Turley's SQL Server BI Blog That’s right! I’m starting a new blog site tod... [Four new electric platforms, five gigafactories: Stellantis’ EV plan]( From Ars Technica The world's fourth-largest OEM just laid out its electrification strategy. [No driver? No problem—this is the Indy Autonomous Challenge]( From Ars Technica Ars meets the college engineers who hope to revolutionize racing. [Peugeot plans to win Le Mans in 2022 with this 9X8 hybrid prototype]( From Ars Technica The French Lion last tasted victory at La Sarthe in 2009. Virtualization and Containers/Kubernetes [Azure Container Instance and SQL server part 2]( From SQLServerCentral Blogs In the last post we built an image of SQL server 2019 Linux hosted in Azure Container Instance for fast access to SQL server. So, your next question is... The... [Update- Beta program for SQL Server on Windows container is suspended.]( From MS SQL Server Blog As you may be aware, the SQL Server on Windows Containers Beta program began in 2017. It has remained in Beta mode meant for only test and development environment...  [RSS Feed]( 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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

EDM Keywords (311)

yes years written write world workloads work without weekend week website webinars ways wanted want vulnerability variety using used use us unsubscribing understanding understand types two turns traditional tools together times time thousands thinking think test talk takes taken take table suspended suspend surprised sure support sundays summary structure strings storytelling stored store stop stolen starts starting started start standardize sqlshack sqlserver spend speaking something skills since simplify simple signed shown sherpa sharpen several setting set sessions series sent seem seeing see security script schneier scale running run road right review resulted respond required report repeats removed remained released receiving reason really read radar questions query program process problem ppu posts post pick perspective permissions performance people patched password part paragraphs paper paid outdated order option optimize opened one objects object number ntext notice noted next newsletter needed need must much moving morning month moment missing migrate might meetings meet measures means may managed manage mallon make maintain lot looking looked look load little list linux like life let legacy least learn last land laid lack knew kinds kidding keep joins job invited instructions instead instance installed inbox image ibm hope honored hiring help hear headlines hard handled guy groups graph got good gone going goal go give github ggplot2 getting get future functionality fourmoo found forums format fonts follow find fascinating far express explore explain expect executing evolved environment enhancements end enable email editorial easy easier driver doubts displays display discussion directions direction differences devices developers developer details desire department debate dcac dba days day dax database cybereason customers cube covered couple could copy convert containers container connect computing complicated community communicating command collected collect check changing certifications case carried career called built build brought break book bit biden benefits behavior background azure aware authentication attack asked articles article answer announcement andy anandtech amount affect actually accidental accessibility 2022 2018 2017

Marketing emails from sqlservercentral.com

View More
Sent On

11/11/2024

Sent On

28/10/2024

Sent On

16/10/2024

Sent On

09/10/2024

Sent On

07/10/2024

Sent On

05/10/2024

Email Content Statistics

Subscribe Now

Subject Line Length

Data shows that subject lines with 6 to 10 words generated 21 percent higher open rate.

Subscribe Now

Average in this category

Subscribe Now

Number of Words

The more words in the content, the more time the user will need to spend reading. Get straight to the point with catchy short phrases and interesting photos and graphics.

Subscribe Now

Average in this category

Subscribe Now

Number of Images

More images or large images might cause the email to load slower. Aim for a balance of words and images.

Subscribe Now

Average in this category

Subscribe Now

Time to Read

Longer reading time requires more attention and patience from users. Aim for short phrases and catchy keywords.

Subscribe Now

Average in this category

Subscribe Now

Predicted open rate

Subscribe Now

Spam Score

Spam score is determined by a large number of checks performed on the content of the email. For the best delivery results, it is advised to lower your spam score as much as possible.

Subscribe Now

Flesch reading score

Flesch reading score measures how complex a text is. The lower the score, the more difficult the text is to read. The Flesch readability score uses the average length of your sentences (measured by the number of words) and the average number of syllables per word in an equation to calculate the reading ease. Text with a very high Flesch reading ease score (about 100) is straightforward and easy to read, with short sentences and no words of more than two syllables. Usually, a reading ease score of 60-70 is considered acceptable/normal for web copy.

Subscribe Now

Technologies

What powers this email? Every email we receive is parsed to determine the sending ESP and any additional email technologies used.

Subscribe Now

Email Size (not include images)

Font Used

No. Font Name
Subscribe Now

Copyright © 2019–2025 SimilarMail.