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
 

Gentlest of Reminders, Don't Stop Learning

I was on the road for just over two weeks. I was able to travel around to a few places and present some sessions. But, better than that, thanks to SQL Konferenz, I was able to go to a couple of sessions and learn some stuff.

I'm lucky/cursed in my position at Redgate. We have a bunch of software, and a bunch of developers. For some reason, they seem to do quite a lot of work, expanding, enhancing and changing all those tools. And I have to learn it all. It's never ending. On top of that, I'm trying to pick up PostgreSQL (and you can read about my struggles). Not to mention, I'm absolutely not letting my existing skill set in SQL Server atrophy, so I'm trying to figure out how things work there as well. Oh, and Azure DevOps, AWS Developer Tools, Octopus, Github Actions and all the other DevOps tools & processes. Learning, non-stop learning, as you can tell, is literally a major part of the job.

It's a big part of your job too.

Sure, maybe you only, ever, work within SQL Server/PostgreSQL/Oracle/InsertYourDataToolHere. It could be you're in a position that's not going to do a cloud migration anytime soon, if ever. You may not have a burning need for automation and process improvement through building out DevOps-style deployments and testing. And you may not work for a software vendor constantly churning out new stuff. So, in this position, you can just sit back & relax. No learning needed right?

You must be joking.

Even if you're doing any of the stuff listed above, your data is growing. The estate you manage is growing. There's new stuff coming from your internal developers. You need to apply the latest service patch or upgrade to a new version of your data management system. You're hitting limitations on your servers and don't understand why. Performance is tanking in an old application. In short, you have metric tonnes of learning that you need to do, all the time, same as me.

So, if you're not learning, get on it. If you're unsure where to get started, I suggest starting with your community. Find the local meetup, user group or whatever. Go to that. Talk to people (yeah, I know). Find a PGDay in your area. Track down a Data Saturday or a SQL Saturday. Maybe go to PASS Data Community Summit with a couple of thousand of your closest friends. Pick up a book. Do something. Do everything. Keep learning, because technology isn't standing still, and you're going to need that job in the future, so prepare for it now.

Grant Fritchey

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

Detecting AI-Generated Text

From Schneier on Security

There are no reliable ways to distinguish text wri...

AI in Retail: What You Need to Know

From Past News - RSS Feeds

Artificial Intelligence (AI) is revolutionizing th...

Microsoft AI Researchers Accidentally Leaked 38TB of Sensitive Data

From Petri IT Knowledgebase

Cybersecurity researchers have uncovered a 38TB st...

Will Generative AI Shake Up Security Operations Centers?

From IT Pro - Microsoft Windows Information, Solutions, Tools

The growing popularity of generative AI has fueled interest in its application within cybersecurity. Here’s a status report on generative AI’s role in security operations centers.

Administration of SQL Server

T-SQL Tuesday #166: Wrap-up

From Scary DBA (Grant Fritchey)

Once more, my apologies for being late on getting ...

Common Mistakes in SQL Server – Part 1

From SQLServerCentral Blogs

In this series of articles I will be sharing the c...

Lesson Learned #429:Leveraging the Full Range SQL Server INT Data Type: Negative and Positive Values

From Azure Database Support Blog

SQL Server's INT data type, by design, provides a ...

SQL SERVER – Understanding Incremental Statistics

From Journey to SQL Authority with Pinal Dave

Statistics are updated automatically or manually r...

How to Upgrade SQL Server from Evaluation Edition to Standard or Enterprise

From MSSQL Tips

Learn how to upgrade SQL Server from the Evaluatio...

SQL Server 2022 Cumulative Update 8

From Glenn Berry

On September 14, 2023, Microsoft released SQL Serv...

Gherkin Scenarios: 3 Examples to Follow and 6 to Avoid

From Journey to SQL Authority with Pinal Dave

The quality of your Gherkin scenarios can make or ...

SQL SERVER – Stripping HTML Tags from Text

From Journey to SQL Authority with Pinal Dave

In this blog post, we'll explore a method for stripping these HTML tags from your text data using SQL Server. Let us explore the post. First appeared on SQL SERVER...

SQL SERVER – Modern Explicit JOIN Syntax – A Brief Note

From Journey to SQL Authority with Pinal Dave

Over time, SQL has evolved and offers two distinct styles for performing JOIN operations: the old-style comma-separated join and the more modern explicit JOIN syntax. First appeared on SQL SERVER...

Azure Databricks, Spark and Snowflake

Spark – LIMIT on Large Datasets – CollectLimit, GlobalLimit, LocalLimit, spark.sql.limit.scaleUpFactor

From Large-Scale Data Engineering and Analytics in Cloud

You use the LIMIT clause to quickly browse and rev...

What is the default number of cores and amount of memory allocated to an application in Spark?

From Hadoop in the Real World

Number of cores spark.executor.cores controls the ...

Managing Azure Databricks with the Azure Cloud Shell Command Line Interface

From MSSQL Tips

The Databricks Command Line Interface (CLI) allows...

Azure DevOps

General Availability: GitHub Advanced Security for Azure DevOps

From Azure Updates

Learn how to enable GitHub Advanced Security for A...

Azure SQL

Private preview of Data Virtualization in Azure SQL Database

From Azure SQL

We are very happy to announce the private preview ...

Lesson Learned #428: SqlError Number:229 provisioning DataSync in Azure SQL Database

From Azure Database Support Blog

We got a new issue when our customer found provisi...

Azure SQL Edge Update - September 2023

From MS SQL Server Blog

Today, I am providing an update on the supported c...

Ledger database vs ledger tables

From Azure SQL

There is sometimes a misconception about the usage...

Lesson Learned #431: Determining Connection Type to Azure SQL Database: Proxy or Redirect

From Azure Database Support Blog

When connecting to Azure SQL Database, it's important to understand the type of connection established. Azure offers two primary connection policies: Proxy and Redirect. Knowing which one you're using...

Backup and Recovery

Verify Backups With Test-DbaLastBackup

From Callihan Data

Is the process of testing your backups something y...

Cloud - AWS

AWS Weekly Roundup: C7i Instances, Knowledge Base for Amazon Bedrock, and More (Sept. 18, 2023)

From AWS News Blog

While daylight is getting shorter in the Northern ...

SQL Athena Introduction - How it works, Use Cases and Advantages

From MSSQL Tips

Learn about Amazon Athena, how it works, why you w...

New – NVMe Reservations for Amazon Elastic Block Store io2 Volumes

From AWS News Blog

Amazon Elastic Block Store (Amazon EBS) io2 and io...

New – Add Your Swift Packages to AWS CodeArtifact

From AWS News Blog

Starting today, Swift developers who write code fo...

New Amazon X2iedn High-Memory Instances

From Brent Ozar Unlimited

Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and...

Cloud - Azure

Microsoft Azure Data Leak Exposes Dangers of File-Sharing Links

From Dark Reading: Dark Reading News Analysis

Shared Access Signature (SAS) link exposed a stora...

Lesson Learned #430: Addressing Error 3201 with Azure Blob Storage: "Operating system error 86"

From Azure Database Support Blog

Today, I worked on a service request that our cust...

Cloud - GCP

Configuring a Virtual Private Cloud (VPC) for Google Cloud Platform (GCP)

From MSSQL Tips

Learn how to use the Google Cloud Platform to shar...

Community Interests

DataMoshpit!

From SQLServerCentral Blogs

Today I’m presenting at DataMospit, the most met...

The Last Price Bump for the Data Community Summit

From SQLServerCentral Blogs

This week the cost of the PASS Data Community Summ...

Security Conferences Keep Us Honest

From Dark Reading: Dark Reading News Analysis

Conferences are where vendors and security researc...

New approaches to the tech talent shortage

From Technology Review Feed - Tech Review Top Stories

We live in a tech-enabled world, but for organizations to advance world-changing innovations, they need skilled people who can build, install, and maintain the systems that underlie them. Finding...

Computing in the Cloud (Azure, Google, AWS)

Migrating to the cloud transforms business

From Technology Review Feed - Tech Review Top Stories

In 2017, BP took on a cloud-first approach that co...

How to Minimize Multi-Cloud Complexity

From IT Pro - Microsoft Windows Information, Solutions, Tools

Successfully juggling multiple clouds can sometime...

Why Cloud Will Remain Dominant: 4 Reasons

From Past News - RSS Feeds

Cloud computing is having a moment. No longer an e...

DMO/SMO/Powershell

PowerShell: Error Handling with $Error

From Sid 500 PoSh

The $Error Variable in PowerShell contains all err...

Data Mining / Data Analysis

Breaking the cycle: Data driven strategies for addressing substance use disorder among supervised populations

From AllAnalytics

Some research shows that an estimated 65% percent ...

Avoid domain errors by using Taylor series

From AllAnalytics

The other day I was trying to numerically integrat...

5 practical ways to increase resilience before 2024

From AllAnalytics

The massive disruptions of the last few years have made clear how critical it is for businesses to be resilient. Some companies flexed successfully with the changes, while others...

Data Privacy, Compliance, and Governance

Data Governance in the Age of Generative AI

From Dataversity

AI-based business models and products that use gen...

AI and Privacy Issues: What You Need to Know

From Past News - RSS Feeds

Artificial intelligence (AI) is becoming increasin...

CCPA vs. GDPR: Differences and Similarities for Data Protection

From Dataversity

The California Consumer Privacy Act (CCPA) and the General Data Protection Regulation (GDPR) were created to empower individuals with greater control over their personal information. Both laws regulate the...

Data Science

What Is Metaflow? Quick Tutorial and Overview

From Dataversity

As data science continues to evolve, new tools and technologies are being developed to help individuals and organizations streamline their workflows, improve efficiency, and drive better results. One of...

Database Design, Theory and Development

DBDEBUNK REFRESH

From Database Debunkings

After 23+ years DBDebunk.com has undergone a sligh...

Data Platform SLAs

From SQLServerCentral Blogs

Database professionals of the world – I have a q...

Seamless Data Exchange: Best Practices for Modern Businesses

From Dataversity

In today’s dynamic business landscape, the abili...

Moving data through the supply chain with unprecedented speed

From Technology Review Feed - Tech Review Top Stories

Product information is a powerful commodity in today’s digital economy. Making it accessible can let consumers know if an item contains allergens, help retailers respond swiftly to product recalls,...

Database management and the cost of doing nothing

From Blog – Redgate Software

Your data is one of your most important assets, and the database – the home of it all – has long been the unsung hero in many a business....

DevOps and Continuous Delivery (CI/CD)

How to Set up Jenkins CI/CD on Kubernetes Cluster using Helm

From Simple Talk

Jenkins is an open-source multi-platform software ...

Better Database Development: The Role of Test Data Management

From Product learning – Redgate Software

Any organization that aims for reliable, online de...

Creating an Empty Repo in GitHub–#SQLNewBlogger

From SQLServerCentral Blogs

I saw someone struggling with getting started with...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Use PROC SGPLOT to embed a graph inside another graph

From AllAnalytics

Did you know that you can embed one graph inside a...

The Power of Graph Databases to Detect Fraud

From Dataversity

Graph databases play a key role in fraud detection...

ETL/SSIS/Azure Data Factory/Biml

Build a Pipeline to Stop an ADF Azure-SSIS IR Course Now Available

From AndyLeonard.blog()

I am excited to announce the availability of Build...

Hardware

Intel Shows Off Work on Next-Gen Glass Core Substrates, Plans Deployment Later in Decade

From AnAndTech

Although Intel’s annual Innovation event doesn�...

Machine Learning

Video: Using GitHub Actions to Run Azure ML Pipelines

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, we use GitHu...

Make machine learning work for you

From Technology Review Feed - Tech Review Top Stories

The enthusiasm for AI and its applications is reaching a nadir, according to an August 2023 Gartner Hype Cycle press release, where generative AI is nearly perched atop the...

Bolstering enterprise LLMs with machine learning operations foundations

From Technology Review Feed - Tech Review Top Stories

Generative AI, particularly large language models (LLMs), will play a crucial role in the future of customer and employee experiences, software development, and more. Building a solid foundation in...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Microsoft Fabric Personas

From MSSQL Tips

Learn about personas when working with Microsoft F...

Share a Microsoft Fabric Data Warehouse Database Project with the new target platform

From Kevin Chant

Reading Time: 5 minutes In this post I want to co...

Azure Service Fabric 10.0 Release

From Azure Updates

This release includes new features and quality imp...

Microsoft Azure Data Leak Exposes Dangers of File-Sharing Links

From IT Pro - Microsoft Windows Information, Solutions, Tools

A Shared Access Signature (SAS) link exposed 38TB ...

Microsoft Fabric: Checking and Fixing Tables V-Order Optimization

From Simple Talk

Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are V-Order optimized. We noticed this configuration depends on our...

Using Microsoft Fabric Workspaces (Power BI and more!)

From Guy in a Cube

Workspaces are a way to organize and manage conten...

New Microsoft Fabric Data Warehouse Target Platform is now included as part of the latest Azure Data Studio update

From Kevin Chant

Reading Time: 2 minutes In this post I want to raise awareness about the fact that the new Microsoft Fabric Data Warehouse Target Platform is now included as...

Editing your Direct Lake Datasets from Tabular Editor? Yes please!

From Guy in a Cube

Wanting to edit your Direct Lake Power BI Dataset ...

Oracle/PostgreSQL/MySQL/other RDBMS

Microsoft Unveils New Partnership to Bring Oracle Cloud Hardware to Azure Datacenters

From Petri IT Knowledgebase

Microsoft is expanding its existing partnership wi...

Learn MySQL : Path to Data Management Excellence

From Journey to SQL Authority with Pinal Dave

Let us explore Learn MySQL : Path to Data Manageme...

Performance Tuning SQL Server

A Little About Select Queries That Cause Writes In SQL Server

From Erik Darling Data

A Little About Select Queries That Cause Writes In...

Improving Merging & Appending Power Query (Queries) with Ken Puls

From Havens Consulting

Video by: Reid HavensLearn an improved way to merg...

Parameter Sniffing Issue with Temporary Tables in SQL Server 2022

From MSSQL Tips

In this article, we look at how parameter sniffing...

Three Free Things You Should Do Before You Have Your Next SQL Server Performance Problem

From Erik Darling Data

Attribution SQL Server doesn’t do much to help y...

The Waiting Life Of A SQL Server Query, Revisited

From Erik Darling Data

Often Asked Sometimes people will ask me penetrating questions like “why does SQL Server choose a bad execution plan?” or “why is this query sometimes slow?” Like many things...

PowerPivot/PowerQuery/PowerBI

Multiple Connections To The Same Data Source In The Power BI Service With Shareable Cloud Connections

From Chris Webb's BI Blog

Why Shareable Cloud Connections solve Power BI con...

(Livestream Replay) Pareto Principle for Power BI: Few Tricks, Big Wins - with Denis Selimovic

From Havens Consulting

DESCRIPTION By focusing on a few key tricks, you can solve the majority of your Power BI issues and achieve big wins with your reports. We'll cover a range...

Professional Development

Dissolving Partnerships

From Prologika (Teo Lachev's Weblog)

I’ve been an independent consultant for almost 2...

3 ways upskilling and continuous learning drive long-term career advancement

From AllAnalytics

From solutions engineers and students to analysts ...

A Playbook for Bridging Africa's Cybersecurity Skills Shortage

From Dark Reading: Dark Reading News Analysis

A pledge to solve the skills and talent shortage b...

Software Engineering Talent in Strong Demand in 2023

From IT Pro - Microsoft Windows Information, Solutions, Tools

A new survey reveals that software engineering tal...

On the Cybersecurity Jobs Shortage

From Schneier on Security

In April, Cybersecurity Ventures reported on extre...

How Organizations Can Overcome the Lack of Tech Talent

From IT Pro - Microsoft Windows Information, Solutions, Tools

Organizations are turning to automation, citizen d...

How Choosing Authentication Is a Business-Critical Decision

From Dark Reading: Dark Reading News Analysis

MFA may go a long way in improving password securi...

Strategies for Tackling Digital Transformation Resistance

From Dataversity

The often-overused phrase “digital transformation” instills a sense of excitement and progress for many executives. But for some business leaders, digital transformation means intimidation or mystery. When the former group is...

Python

How to combine images using Python

From Purple Frog Systems

In this blog post, I will be showing how to combin...

SQL Server Security and Auditing

SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives

From Simple Talk

One of the primary reasons to implement RLS is to ...

How to Find and Block Breached Passwords in Active Directory

From Petri IT Knowledgebase

Cybercriminals love passwords. They’re simple to...

Security News and Issues

How to Get Your Board on Board With Cybersecurity

From Dark Reading: Dark Reading News Analysis

CISOs can refine their soft skills to help get the...

GitLab Users Advised to Update Against Critical Flaw Immediately

From Dark Reading: Dark Reading News Analysis

The bug has a CVSS score of 9.6 and allows unautho...

FBI, CISA Issue Joint Warning on 'Snatch' Ransomware-as-a-Service

From Dark Reading: Dark Reading News Analysis

The group's use of malware that forces Windows com...

'Culturestreak' Malware Lurks Inside GitLab Python Package

From Dark Reading: Dark Reading News Analysis

The GitLab code hijacks computer resources to mine...

T-Mobile Racks Up Third Consumer Data Exposure of 2023

From Dark Reading: Dark Reading News Analysis

The mobile company states that the issue was due t...

Secure Browser Tech Is Having a Moment

From Dark Reading: Dark Reading News Analysis

Cloud adoption is driving secure browsers' moment ...

Mastering Defense-In-Depth and Data Security in the Cloud Era

From Dark Reading: Dark Reading News Analysis

Though widely used in many organizations, the conc...

Hikvision Intercoms Allow Snooping on Neighbors

From Dark Reading: Dark Reading News Analysis

The intercoms are used in thousands of apartments ...

Understanding the Differences Between On-Premises and Cloud Cybersecurity

From Dark Reading: Dark Reading News Analysis

The nature of cloud environments means security an...

Software Development

Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# application

From SQLServerCentral Blogs

If you happen to be using C# there is a very easy ...

T-SQL and Query Languages

Alternatives To SQL Server 2022 Built-in function GREATEST

From Simple Talk

If you haven’t already heard, SQL Server 2022  ...

Rounding Numbers to the Nearest Integer with T-SQL

From MSSQL Tips

In this article, we look at how to use T-SQL to ro...

Tech News

Advanced Linux User Management: Privileges, Resource Limits, and More

From IT Pro - Microsoft Windows Information, Solutions, Tools

If you are looking to better manage Linux environm...

Unified Acceleration Foundation Goes Beyond oneAPI to Revolutionize Accelerated Computing

From IT Pro - Microsoft Windows Information, Solutions, Tools

The new Linux Foundation project aims to build a u...

What’s next for the world’s fastest supercomputers

From Technology Review Feed - Tech Review Top Stories

MIT Technology Review’s What’s Next series looks across industries, trends, and technologies to give you a first look at the future. You can read the rest of our series...

Microsoft Teams Premium to Retain Real-time Telemetry Data for Up To Seven Days

From Petri IT Knowledgebase

Microsoft is set to enhance how organizations harn...

How electricity could clean up transportation, steel, and even fertilizer

From Technology Review Feed - Tech Review Top Stories

This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. Have you ever repeated a word...

Cisco Moves into SIEM with $28B Deal to Acquire Splunk

From Dark Reading: Dark Reading News Analysis

Cisco's surprise agreement could reshape secure in...

Linux User and Group Management Security Best Practices

From IT Pro - Microsoft Windows Information, Solutions, Tools

This guide explores how to manage Linux users and groups for better system security.

Tools for Dev (SSMS, ADS, VS, etc.)

Azure Data Studio 1.46 and New Features

From MS SQL Server Blog

We’re rolling towards conference season and the Azure Data Studio engineers have been working hard on two things:   adding new functionality improving stability and performance within the application   As always, new features...

flyway

Friday Flyway Tips–Commit and Push

From SQLServerCentral Blogs

Flyway Desktop includes version control features w...

Practical uses for Database Models with Flyway

From Product learning – Redgate Software

A database model is a standard document that represents the logical design and structure of a database. If we save a model each time Flyway creates a new version...

history

New Revelations from the Snowden Documents

From Schneier on Security

Jake Appelbaum’s PhD thesis contains several new revelations from the classified NSA documents provided to journalists by Edward Snowden. Nothing major, but a few more tidbits. Kind of amazing that...

 
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 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

 

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