Newsletter Subject

The State of Data Growth (2021-09-11 DBW)

From

sqlservercentral.com

Email Address

subscriptions@sqlservercentral.com

Sent On

Sat, Sep 11, 2021 10:16 AM

Email Preheader Text

Database Weekly for September 11, 2021 Problems displaying this newsletter? . The Complete Weekly Ro

Database Weekly for September 11, 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  The State of Data Growth About a decade ago I did some presentations on Filestream and Filetable in SQL Server. These were technologies that Microsoft added with the idea that lots of data would need to be linked to data in a database, but wasn't necessarily a good fit for a relational table. At the time, I looked at the growth of data, which was incredible back then. Statistics I had from that time were from the invention of the printing press for the next 500 years, we created 1 EB of data. In the 2011/2012 time frame, we created 2EB each day. That's changed. I saw [a blog on the story behind the explosive growth of data]( which looked at a recent IDC report that showed we created and replicated (a strange term) about 64ZB of data in 2020. With a ZB being 1000 EB, we can see that a decade has brought us multiple orders of magnitude of data growth. That doesn't mean we need to store all this data. The report notes that a lot of this is consumption data, which is transferred, but not saved. This means that we do need strong networks, but that most of the time the data is being viewed and not actually stored. That's certainly the case with things I see on Netflix, where I may end up transferring part of a show multiple times to get through it, usually because I fall asleep. The estimate for the next 5 years, through 2025, does indicate that we expect to need 200% more storage capacity and that a lot of data storage is going to be at the edge, in devices and server machines, as well as in the core, made up of data centers, cloud and private. While plenty of this data will be outside of databases, and plenty will be in non-relational stores, this does tell me that working in the database business as a career is one that's going to be in demand for a while. I've enjoyed my career working with data, and I expect to keep doing so for the foreseeable future. I am confident there will always be work for those that know how to work with data in a variety of situations. I also expect a very high demand, and high compensation for those that do it well. Steve Jones - SSC Editor [Join the debate, and respond to the editorial on the forums](  [pass-pro-educational-series]( 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. Vendors/3rd Party Products [Our Top Findings from The State of Database Monitoring Survey]( Over 2500 global database professionals answered questions on their experiences with database monitoring in our annual survey earlier this year. We’re creating four reports from the findings and in our first, The real-world challenges of growing server estates, you’ll discover both insights and trends along with advice for how to tackle the most common challenges. [Why pay for open-source software?]( The very definition of open-source software means that developers can change the code, which means that exclusive, paid, licensing is not a part of the deal. In short, open-source is free. Free of licensing anyway. So, why might you choose to pay for an open-source software like Flyway? Grant Fritchey explores. AI/Machine Learning/Cognitive Services [ML{.NET} Image Classification]( From SQL Server – {coding}Sight One of the best scenes from Silicon Valley is Jian... [Data Annotation Tools for Machine Learning]( From Dataversity Click to learn more about author Seapee Bajaj. In ... Administration of SQL Server [Using Query Store Hints to Optimize Memory Grants Improving Performance | Data Exposed]( From Azure SQL Query store hints enables changing query plan shap... [How to Configure SQL Server Temporal Tables Part 2]( In the initial post, we talked about some very basic items to get you up and running with temporal tables. In part 2, I’ll cover a few more things to think about and implement when working with temporal tables. [SQL Server Resumable Index: Is it good for you?]( From SQL Server – {coding}Sight SQL 2017 introduced the ability to pause and resum... [Customizing With Trace Flags]( From Callihan Data Trace flags are used to turn certain settings on or off in SQL Server. They can range from suppressing backup logs to affecting query plans. While some can be... [[Video] Office Hours: Ask Me Anything About SQL Server On My Patio]( From Brent Ozar Unlimited I sit on the porch and discuss your highly voted questions from . Today’s discussion includes: 00:00 Introductions 00:27 DK: What was your Gordian Knot problem? 03:25 George: How... Azure Databricks, Spark and Snowflake [Databricks Delta Change Data Feed]( From MSSQL Tips In this article we cover how to implement a batch ... [Exploring Streams in Snowflake for Change Data Capture]( From MSSQL Tips In this article we look at using streams in Snowflake to set up a change data capture scenario where only new or modified rows are processed. Azure SQL Database [The Azure SQL portfolio]( Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options. [Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold]( From SQLShack This article will explore Azure automation for sca... Backup and Recovery [Cold vs. Hot Data Storage: What’s the Difference?]( From Dataversity Click to learn more about author Ashok Sharma. When it comes to data storage, the temperature must be taken into consideration. The level of layered data storage service, from... Career Growth and Certifications [I Can't Keep Up! Turning Discomfort into Personal Growth in a Fast-Paced World]( From Cathrine Wilhelmsen At Data Saturday Oslo 2021, I delivered the keynote called Turning Discomfort into Personal Growth in a Fast-Paced World. The recording is now available! Continue Reading I Can't Keep Up!... Conferences, Classes, Events, and Webinars [Donovan Brown & Mark Fussell talk Cloud Native development with Dapr]( Join Donovan Brown, Partner Program Manager, and Mark Fussell, Lead Program Manager from the Azure CTO Incubations team at Microsoft as they talk all things modern Cloud Native development with Dapr. [DPS 2021 is a few days away!]( From Azure SQL Data Platform Virtual Summit 2021 (DPS 2021) is r... [PASS Data Community Summit 2021 Precon Announcement]( From SQLServerCentral Blogs I’m thrilled to announce my preconference traini... DMO/SMO/Powershell [How to view the current Powershell session security permissions]( From SQLServer-DBA.Com How can I see the current PoSH security ? [Fun With PowerShell Advanced Functions]( From Arcane Code Introduction In my previous post, I covered the use of PowerShell Basic Functions. In this post we’ll cover Advanced Functions. Advanced Functions provide several abilities over basic ones. First,... Data Privacy, Compliance, and GDPR [Azure Purview Series – Part 4: Data Map]( From BlueGranite Blog Welcome to the final installment of our Azure Purview Series, focusing on Purview Data Map. The Purview Data Map is the foundation for data discovery and serves as the... Database Design, Theory and Development [Should I Use A Unique Identifier As A Primary Key?]( From Steve Stedman Take the following sample code.   Four similar ... [Understanding Relational Constraints]( From Database Debunkings “The data in a relational database is stored in form of a table. A table makes the data look organized. Yet in some cases we might face issues while... DevOps and Continuous Delivery (CI/CD) [Protected: A simple database deploy pipeline using sqlpackage]( From Sunday morning T There is no excerpt because this is a protected po... ETL/SSIS/Azure Data Factory/Biml [SSIS Pivot transformation vs. Unpivot transformation]( From SQLShack This article explains the SSIS pivot transformation and how it differs from the unpivot transformation. This article is the thirteenth article in the SSIS feature face-to-face series, which aims to... [How Interchangeable Are Integration pipelines Between Azure Data factory and Azure Synapse Analytics?]( From Paul Andrew Inspired by an earlier blog where we looked at ‘How Interchangeable Delta Tables Are Between Databricks and Synapse‘ I decided to do a similar exercise, but this time with... [Importing data from OData APIs using Azure Data Factory]( From SQLShack In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories. Introduction Data practice has the following major... Hardware [Lenovo clones the iPad Pro with the $610 P12 Pro]( From Ars Technica It has Android 11 and an SoC that would be at home in a 2020 flagship smartphone. MDX/DAX [Variables in DAX]( From Excelerator BI Earlier this week I did a live stream event. I put out a poll and asked people to tell me what topic they wanted me to talk about. The... [NONVISUAL – DAX Guide]( From SQLBI NONVISUAL: Mark the filter as NonVisual. [Fixing “Top N and others” report when filtering by date – Unplugged #35]( From Sqlbi This video describes how we answer a question abou... [NATURALINNERJOIN, NATURALLEFTOUTERJOIN – DAX Guide]( From Sqlbi NATURALINNERJOIN: Joins the Left table with right table using the Inner Join semantics. NATURALLEFTOUTERJOIN: Joins the Left table with right table using the Left Outer Join semantics. NoSQL [How to find the available free space in HDFS?]( It is a quite common need to find the available free space in HDFS. There are a couple of ways to find this information. Performance Tuning SQL Server [Wait Stats During Exchange Spills]( From Erik Darling Data Inorganic Lots of people say these are rare — a... [Wait Stats During Hash Spills]( From Erik Darling Data Jam Job Hash spills are, as we’ll see, sometimes identified by a different wait than sort spills. In small quantities, spills are often not worth bothering with. But when they... [SQL Server Stored Procedure Recompilation Factors]( From SQLShack In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes... PowerPivot/PowerQuery/PowerBI [Text Mining and Sentiment Analysis: Oracle Text]( Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text. [When to use Power Query/M vs Data Modelling/DAX]( From Excelerator BI Ken Puls and I decided we would do a live stream c... [Intro to Power BI Aggregations]( This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article is for you. [Doing relative-time Slicers properly in Power BI]( A very common requirement for a Power BI report that I stumble across at almost all of my customers is to automatically show data for the current day/month/year when a report is opened. At first sight this seems like a very trivial problem but once you dig into the problem, you will realize that all of the common solutions out there have some disadvantages and only solve the problem partially. [When is a date not a date in Power BI?]( From Guy in a Cube When is a date not a date? We all use them in our ... [Nifty Power BI fix in Synapse Studio]( From Kevin Chant Reading Time: 4 minutes In this post I want to share a nifty Power BI fix in Synapse Studio that I found. So that you can link to... [Matching DAX Queries To Individual Visuals In A Published Power BI Report]( From Chris Webb's BI Blog The integration between Azure Log Analytics and Power BI opens up a lot of new possibilities for Power BI administrators. It’s still in preview (there’s a lot more cool... Product Reviews and Articles [Book Review: Microsoft Azure Data Fundamentals Exam Ref DP-900]( This book aims to introduce Azure data services and their use with different types of data and workloads, how does it fare? Product Upgrades and Releases [Announcing Databricks Serverless SQL]( Databricks SQL already provides a first-class user experience for BI and SQL directly on the data lake, and today, we are excited to announce another step in making data and AI simple with Databricks Serverless SQL. [Scalar UDF Inlining now available on Azure SQL]( From Azure SQL Scalar UDF inlining is now available for Azure S... [Microsoft Drivers 5.10.0 Beta 1 for PHP for SQL Server Released]( From MS SQL Server Blog We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.10.0-beta1. This beta release has been built with PHP 7.3+ and tested on... R Language [The Four Pipes of magrittr]( The magrittr package is a part of the extended tidyverse – i.e., not one of the ones normally loaded. It is the one that supplies the pipe operator (%>%), but it turns out that the package actually contains four pipe operators in total. All are intended to streamline and improve the readability of code, though the three non-basic ones are a bit more situational, and I’ve rarely seen them used, so I thought I would go into them a bit. SQL Server Security and Auditing [Auditing with “C2 Auditing” and “Common Criteria Compliance”]( From SQLServerCentral Blogs I’m going to be fairly high level on these becau... [Tracking with Triggers]( From Callihan Data Have you ever come across triggers being used to audit table changes? In this post, we’ll look at a few examples of DML triggers in action. Tracking LastEditDate with... [Grant, With Grant, Revoke and Deny statements in SQL Server and Azure SQL Database]( From SQLShack This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database. Principals, Securable and Permissions It is an essential and... Security News and Issues [You Don't Need to Burn off Your Fingertips (and Other Biometric Authentication Myths)]( From Troy Hunt 111 years ago almost to the day, a murder was committed which ultimately led to the first criminal trial to use fingerprints as evidence. We've all since watched enough... [More Detail on the Juniper Hack and the NSA PRNG Backdoor]( From Schneier on Security We knew the basics of this story, but it’s good to have more detail. Here’s me in 2015 about this Juniper hack. Here’s me in 2007 on the NSA backdoor. [Titanfall 2 allegedly hacked via “simple exploit”]( From Ars Technica Respawn investigating, does not believe the exploit poses serious risks. Software Development [Decision Making at Netflix]( From Netflix TechBlog - Medium Martin Tingley with Wenjing Zheng, Simon Ejdemyr, ... T-SQL [Script to create copies of the existing object]( From SQLServerCentral Blogs Many a time we need copies of an object but with d... [SQL Server SEQUENCE]( From Steve Stedman In 2012 SQL Server introduced the SEQUENCE object.... [SQL Server, Oracle and PostgreSQL Date Functions]( From MSSQL Tips In this article we look at some of the differences... [Time to give the data a TRIM()]( From Sherpa of Data For years, when it came to getting rid of the spac... [How LAG compares to other techniques]( From Simple Talk LAG pulls a column from another row without a self... [Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations]( From SQLPerformance.com Itzik Ben-Gan returns to his table expressions series, covering what you need to think about when using a view to modify its underlying table(s). The post Fundamentals of Table Expressions,... [How to Use SQL Server T-SQL Function SUM: 5 Use Cases]( From SQL Server – {coding}Sight The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of all values in the specified column – note that it applies... [Why I don't like the WHILE (1=1) pattern]( From SQLBlog.org In this tip, I discuss one way to help avoid infinite loops in common while loop patterns. [Learning the SQL GROUP BY Clause]( From MSSQL Tips Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group... [Is SQL DISTINCT Good for Removing Duplicates in Results?]( From SQL Server – {coding}Sight Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when duplicates appear. Some say it’s bad and suggest using... Tech News [Amazon fights high warehouse turnover with offer of free college tuition]( From Ars Technica Benefit comes as Amazon warehouses face increasing... [Google.com dark mode is rolling out to everyone]( From Ars Technica Say goodbye to the blinding-white Google.com start... [Digital Transformation Guide: Definition, Examples & Strategy]( From Past News - RSS Feeds It’s hard to pinpoint the first use of the phras... The Lighter Side [After ignoring EVs for too long, Toyota will invest $13.6 billion in batteries]( From Ars Technica Company says it wants 180 to 200 GWh in battery capacity by 2030. Tools for Dev (SSMS, ADS, VS, etc.) [Remote Desktop: Force the resolution to match the screen size.]( From SQLStudies One of the things I hate most about using remote desktop is when the resolution for the remote server is ... Continue reading  [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 (284)

zb years year would workloads working work well week ways wanted want walk viewed view variety values usually using used use unsubscribing understand turns trim triggers transferred total topic today tip time thrilled thought think things tested test tell technologies techniques talked talk taken tackle table synapse supplies summarize sum streamline story stored store stop still statistics state sqlshack sqlbi spac solve soc snowflake situations situational sit signed showed sherpa sharpen share set serves sent see security schneier say saw saved running rolling results respond resolution report replicated repeats removed reminder refresher recording receiving realize readability rare range put purpose problem private preview presentations premises post porch poll plenty pinpoint phras php permissions perform pay pause patio part outside opened one often offer object newsletter new netflix need necessarily murder modify might microsoft means mean match magrittr magnitude lots lot looked look list linked link like level learn know knew keep keen issues invention interchangeable intended integration instructions insights indicate includes improve implement idea home headlines hdfs hate hard guy growth group grant good going give get functionality foundation found form follow first fingertips findings find filtering filter filetable filestream feature factors explore experiences expect excited excerpt examples evidence everyone estimate essential enjoyed email editorial edge discuss discover disadvantages dig differs difference devops devices development developers detail demand delivered definition decided decade debate deal day dax date databricks databases database data customers cube created covered cover couple consideration configure confident common committed command comes column collected code clause choose changed change certifications certainly cases case career came calculate burn built blog bit bi believe batteries basics bad azure available article applies anything answer announce always almost aims advice administration ability 64zb 2025 2020 2015 2007

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.