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
 

Friendship and Your Career

PASS Data Community Summit is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up because I've been incredibly lucky in the friendships I built with people I met at Summit. I want to take a moment to talk about the importance of friendship in your career.

On one level, you could say that we're all in competition for the same jobs. It's not something I believe, but there are those who do. Then, there's another idea. While, sure, there's a little competition locally, maybe a fight for a promotion or a cool project, there is way more work out there than those of us who are even remotely qualified can handle. What's more, with this constantly shifting technology landscape, even if today we're qualified, tomorrow we might not be. So, we're not in competition. In fact, the very best thing we can do for ourselves and our careers, and I'm talking pure selfishness here, is to make a few friends in the industry.

Why?

Because you can't learn it all. You can't. However, having a bunch of friends who also work in the industry, you've got resources for the stuff you don't know. Sure, you can post questions on the forums (I regularly haunt them, trying to help out) and you'll probably get an answer. Maybe use the #sqlhelp or #pghelp hashtags on Twitter to get a quick answer. But, a friend can give you an answer even quicker. Plus, be around for follow-up questions. Heck, even more important, they can be a shoulder to cry on, a mentor, a sounding board for ideas, all these things. Further, you can help them with all of the same. That's what friends do.

As I say, I've made some incredible friendships through my years of involvement at the PASS Data Community Summit. I've also made a few at SQLSaturday, Techorama, DataMinds Connect, SQL Bits, and other events, all around the world. If you can't make it to Summit, make it to another event, even a local meetup. While there, talk to people (yeah, I know). Make some friends in this industry. It'll be good for you. It'll be good for them. It'll be good for all of us. I truly believe a rising tide lifts all boats. The more we connect with one another and share, the better off we all are.

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.
Vendors/3rd Party Products

Backing up MySQL Part 1: mysqldump

sql

AI/Machine Learning/Cognitive Services

Machine learning could vastly speed up the search for new metals

From Technology Review Feed - Tech Review Top Stories

Machine learning could help develop new types of m...

Responsible AI has a burnout problem

From Technology Review Feed - Tech Review Top Stories

Margaret Mitchell had been working at Google for two years before she realized she needed a break. “I started having regular breakdowns,” says Mitchell, who founded and co-led the...

Administration of SQL Server

Quickly Evaluate SQL Server Best Practices with Invoke-SqlAssessment

From MSSQL Tips

Learn how to use the PowerShell Invoke-SqlAssessme...

Memory Grant Feedback: Persistence and Percentile Grant

From Microsoft SQL Server Blog

Part of the SQL Server 2022 blog series. Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence,...

SQL Server Registered Servers

From SQLServerCentral Blogs

Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs The post SQL Server Registered Servers appeared first on DallasDBAs.com. The post SQL Server Registered Servers appeared...

Azure Databricks, Spark and Snowflake

Snowflake DDL and DML Statements in Transactions compared to SQL Server - Part 2

From MSSQL Tips

In this article, we look at running DDL and DML st...

Snowflake – Search Optimisation Service

From SQLServerCentral Blogs

Rarely do I say I love a feature across any technologies I have come across, in the snowflake world this is right up there. I tend to find this... The...

Azure SQL

The-connection-is-broken-and-recovery-is-not-possible-()-and-other-errors-4891-1326-2250-13800-21036

From Azure Database Support Blog

Issue: When trying to generate a snapshot, the job is failing with the error: Error 1- "The connection is broken and recovery is not possible. The connection is marked by the...

How to identify suitable SKUs for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM

From SQLShack

The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM....

Azure SQL Managed Instance

Lesson Learned #244: No such host is known connecting to Azure SQL Managed Instance Private Endpoint

From Azure Database Support Blog

Today, I worked on a service request where our cus...

Community Interests

The SQL Server Central Casino Party #SeattleSummitMoments

From SQLServerCentral Blogs

Redgate started a new marketing thing and I like i...

Aha moments at PASS Data Community Summit

From Blog – Redgate Software

Anyone who has attended Summit will recount tales ...

Azure Data Community Newsletter Sept/Oct 2022

From Azure SQL

Connect with other members of the Azure Data Community on LinkedIn group.    Share how you got started speaking by joining the effort, #NewStarNovember   The organizers of New Stars of Data want...

Computing in the Cloud (Azure, Google, AWS)

How to Migrate a SQL Server Database to the Google Cloud using Cloud SQL

From MSSQL Tips

In this article, we look at how to migrate a SQL S...

AWS Week in Review – October 24, 2022

From AWS News Blog

Last week, we announced plans to launch the AWS As...

Quickly Deploy SQL Server on Linux using AWS Launch Wizard

From MSSQL Tips

Learn how to quickly deploy a SQL Server on Linux (standalone) on Ubuntu (Linux) using AWS Launch Wizard.

Moving to Distributed Systems Can Ease the Path to Cloud Infrastructure

From Dataversity

Companies plan to increase their spending on cloud infrastructure but may be slowing down on taking a “cloud-first” approach. These are two of the conclusions outlined in the Enterprise...

Big 3 Public Cloud Providers Highlight Cost Control Capabilities

From IT Pro - Microsoft Windows Information, Solutions, Tools

Amazon, Microsoft, and Google all reported quarterly cloud earnings, emphasizing the ability of the cloud to reduce operating costs.

Conferences, Classes, Events, and Webinars

Join a community like no other at Summit

We're only we couple of weeks away until PASS Data Community Summit takes place, and there's still time to register for an in-person or online pass, and unlock access to over 300 world-class sessions. Join liked-minded attendees at the year's largest hybrid data platform conference. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE Register now

Expert-led PASS Data Community Summit Pre-cons

Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now.

Sign up to PASS Data Community Summit 2022

There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE. Register now.

DMO/SMO/Powershell

How to Use a PowerShell Foreach Loop

From Petri IT Knowledgebase

The PowerShell Foreach statement is useful when wo...

Data Mining / Data Analysis

Please Consider Your Business Users When Selecting an Analytics and Data Search Tool

From Dataversity

Business users are business professionals who have...

Poker, risk and the game of life: An interview with Liv Boeree

From AllAnalytics

Liv Boeree answers our questions about the game of...

Talking mental health, analytics and whole person care with Mayim Bialik

From AllAnalytics

Question: This neuroscientist and SAS Explore host is known for appearing on "Blossom," "The Big Bang Theory" and "Jeopardy." Answer: Who is Mayim Bialik, Ph.D.? Today, instead of Bialik...

Data Privacy, Compliance, and Governance

Strategies for Data Intelligence, Data Governance and Data Operations

From Journey to SQL Authority with Pinal Dave

Data intelligence and governance is at the heart o...

Data Warehousing

Developing Agile Data Warehouse Architecture Using Automation

From Dataversity

In the past, designing and developing a robust data warehouse that satisfied the need for timely and effective business intelligence (BI) was an overwhelmingly difficult task, as it required significant time,...

Database Design, Theory and Development

NOBODY UNDERSTANDS NORMALIZATION 2 (sms)

From Database Debunkings

Note: In "Setting Matters Straight" posts I debunk...

Build Confidence in Your Data with Ledger Databases and Tables | Data Exposed: MVP Edition

From Azure SQL

You’ve done all the work to build confidence in ...

Why Low-Code/No-Code App Development Has Inherent Security Risks

From IT Pro - Microsoft Windows Information, Solutions, Tools

The security risks of low-code/no-code are real an...

DevOps and Continuous Delivery (CI/CD)

MLOps: Why Now for Open Source

From Dataversity

According to Gartner, a whopping 47% of machine l...

Overcome Cloud-Native App Development Challenges with CI/CD Best Practices

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here are practical ways to improve cloud-native ap...

Maintaining a Utilities Schema in a Flyway Project

From Product learning – Redgate Software

Whatever development methodology you use, it is us...

GitLab Adds Governance, Software Supply Chain Enhancements

From Dark Reading: Dark Reading News Analysis

Developers will be able to scan for vulnerabilitie...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Introducing Amazon Neptune Serverless – A Fully Managed Graph Database that Adjusts Capacity for Your Workloads

From AWS News Blog

Amazon Neptune is a fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets. With Neptune, you can use...

Hardware

Raspberry Pi Powers DIY Headless M8 Synthesizer

From Tom's Hardware US

Maker Ricardo has built a custom synthesizer using...

PicoBerry is a Tiny Raspberry Pi Compute Module 4 Carrier Board

From Tom's Hardware US

A tiny Compute Module 4 carrier board has emerged,...

TikToker Improves CPU Cooling by Adding Salt to Thermal Paste

From Tom's Hardware US

An enthusiast with the handle @mryeester found tha...

vSphere 8 CPU Topology Device Assignment

From frankdenneman.nl

There seems to be some misunderstanding about the ...

TSMC Reportedly Halts Shipments to China's GPU Specialist, Biren

From Tom's Hardware US

Biren's first GPUs can challenge Nvidia's A100 GPU...

Collaboration and Communication Technology Sparks Enterprise Concern

From IT Pro - Microsoft Windows Information, Solutions, Tools

A survey by Theta Lake found that unmonitored comm...

FreeSync vs. G-Sync 2022: Which Variable Refresh Tech Is Best?

From Tom's Hardware US

We compare FreeSync versus G-Sync to find out whet...

Oracle/PostgreSQL/MySQL/other RDBMS

Managing schema in Azure Database for PostgreSQL using pgAdmin

From SQLShack

In this article, we will learn how to use the feat...

Getting started with procedures in Azure Database for PostgreSQL

From SQLShack

In this article, we will learn how to work with pr...

Public preview: Read replicas for Azure Database for PostgreSQL Flexible Server

From Azure Updates

Read replicas are used to offload read workloads a...

Oracle optimizer Or Expansion Transformations

From Simple Talk

The previous instalment of this series examined ag...

Performance Tuning SQL Server

SQL Server For Beginners: SQL Server Query Plans

From Erik Darling Data

SQL Server Query Plans Going Further If this i...

How to Analyze Query Plans in Azure Data Studio | Data Exposed

From Azure SQL

Azure Data Studio has introduced query plan viewer functionality within the core application – you no longer need to install an extension to view and analyze plans. In this...

Improve Performance and Management of Large Table by Converting to Partitioned View in SQL Server

From MSSQL Tips

In this article, we will walk through the steps of taking a very large SQL Server table and converting it to a partitioned view to help improve management and...

PowerPivot/PowerQuery/PowerBI

Why Power BI totals might seem inaccurate

From Sqlbi

A common question is why Power BI totals are inacc...

Why Power BI totals might seem wrong

From Sqlbi

A common question is why Power BI totals are inacc...

Introducing the Measure Killer (External Tool) for Power BI!

From Havens Consulting

Learn about an up and coming external tool that ma...

Power BI Development Best Practices

From RADACAD

Regardless of the job function, you have with Powe...

Make Q&A more effective in Power BI

From Guy in a Cube

Most struggle with getting Q&A to be effective...

Does it matter where your Power BI reports are deployed?

From Guy in a Cube

Where to deploy your Power BI Report? My Workspace? Regular Workspace? What about Apps? Adam breaks it down to help you make the right choice and understand why it...

Product Upgrades and Releases

Microsoft Introduces the On-Premises Unified Update Platform for Seamless Windows Updates

From Petri IT Knowledgebase

Microsoft has announced a public preview of the Un...

Professional Development

On Experience

From AndyLeonard.blog()

The following images (from FreeCell) illustrate a ...

Getting Help Online

From Scary DBA (Grant Fritchey)

I spend a lot of time in the forums on various web...

how do I give unsolicited feedback to a colleague?

From Storytelling with Data

  ...

R Language

Editing Camera Image Metadata with R

From Curated SQL

Neil Saunders has some trail cameras: The camera m...

Security News and Issues

HR Departments Play a Key Role in Cybersecurity

From Dark Reading: Dark Reading News Analysis

A more secure organization starts with stronger al...

Threat Groups Repurpose Banking Trojans into Backdoors

From IT Pro - Microsoft Windows Information, Solutions, Tools

Ursnif, a one-time banking Trojan also known as Go...

Open Source Is Just the Tip of the Iceberg in Software Supply Chain Security

From Dark Reading: Dark Reading News Analysis

As more of the software stack consists of third-pa...

Why Retail Stores Are More Vulnerable Than Ever to Cybercrime

From Dark Reading: Dark Reading News Analysis

When we think about cybercrime and retail it is na...

The “Autonomous SOC” Is a Pipe Dream

From IT Pro - Microsoft Windows Information, Solutions, Tools

The autonomous SOC will never be a reality because technology is simply not capable of human ingenuity.

Big Changes are Afoot: Expanding and Enhancing the Have I Been Pwned API

From Troy Hunt

Presently sponsored by: Varonis. Reduce your SaaS ...

Critical Vulnerability in Open SSL

From Schneier on Security

There are no details yet, but it’s really important that you patch Open SSL 3.x when the new version comes out on Tuesday. How bad is “Critical”? According to OpenSSL,...

Software Development

Microsoft starts shipping its Windows on Arm device for developers: Windows Dev Kit 2023

From All about Microsoft Blog RSS | ZDNet

Microsoft's 'Project Volterra' $599 device for dev...

T-SQL and Query Languages

The Rivalry Between SELECT INTO and INSERT INTO

From Callihan Data

Data can be inserted into one temp table from anot...

What can you do with a SELECT statement without a FROM clause?

From SQLStudies

Some people have shower thoughts, I have 1am thoug...

Using GENERATE_SERIES function to generate a series of Dates

From Hasan Savran

    GENERATE_SERIES function is introduced in SQ...

SQL LIKE Statement for Various Text Patterns

From MSSQL Tips

In this article, we look at how to use SQL LIKE statement to find various text patterns contained within a set of text along with many different examples of...

Tech News

The US Navy wants swarms of thousands of small drones

From Technology Review Feed - Tech Review Top Stories

The US Navy is working on ways to build, deploy, a...

Accenture’s Greg Douglass on the Growth of the Chief Transformation Officer

From Past News - RSS Feeds

I spoke with Greg Douglass, Global Lead, Technolog...

Everything dies, including information

From Technology Review Feed - Tech Review Top Stories

Everything dies: people, machines, civilizations. ...

Raspberry Pi Drives Pharmacy Sign Demo Video

From Tom's Hardware US

This team uses a Raspberry Pi to power a custom de...

IT Leaders Dissatisfied, Looking for New Opportunities

From IT Pro - Microsoft Windows Information, Solutions, Tools

IT departments have been performing heroically since the pandemic, but even more could have been done if IT decision-makers had better support, a new report finds.

2023 Predictions: Cyber Asset Management to Future-Proof IT Infrastructure

From Dataversity

Now more than ever, business success relies on an agile cyber asset management strategy. Over the past year, inflation, supply chain delays, cybercrime, transitions to remote work, and the...

Will lab-grown meat reach our plates?

From Technology Review Feed - Tech Review Top Stories

This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. Would you eat lab-grown meat? Plenty...

The Lighter Side

How scientists want to make you young again

From Technology Review Feed - Tech Review Top Stories

A little over 15 years ago, scientists at Kyoto Un...

How to see inside a tornado

From Technology Review Feed - Tech Review Top Stories

Tornadoes form in 10 seconds or less. So Howie Blu...

Ten to One founder aims to change people’s perception of rum

From Technology Review Feed - Tech Review Top Stories

When you think of rum, what comes to mind? A straw...

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

SSMS Performance Dashboard for Managed Instance shows different percent of CPU usage

From Azure Database Support Blog

Symptom:  When using Performance Dashboard on Azu...

Virtualization and Containers/Kubernetes

AWS Batch for Amazon Elastic Kubernetes Service

From AWS News Blog

Today I’m pleased to announce AWS Batch for Amaz...

Top 10 Kubernetes Security Risks Every DevSecOps Pro Should Know

From Dark Reading: Dark Reading News Analysis

The mission to run any containerized application o...

 
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

 

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