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
 

Looking Back and Forward

I took part in a podcast this week, Arrested DevOps. I did one with them once before, almost ten years ago. The host and I were both a little surprised that it had been so long. This caused us to look back a bit. Interestingly enough, ten years ago meant I was only about two years into my gig with Redgate. Things were so different then. I don't want to say better or worse, but very different. I think the biggest thing is that we had really just launched ourselves into the whole DevOps thing.

Now you may be a lot younger than I am and so you don't have ten years of experiences within IT to look back on. Doesn't matter. It's not a bad thing to look back on your career, life, whatever, and see how you've come along (or haven't). Take a moment. Mourn the losses, but don't linger there. Savor the triumphs. Hold that for a second.

Now, face forward. What's on the agenda for the next ten years? Yeah, you can't really say for certain. The future is quite literally, unknowable. However, goals, at least a sense of direction, that is something that you can know. Have something, anything, to shoot for. Myself, I've got a couple of goals. At work, I'm really hoping to get recognition as a PostgreSQL influencer, teacher, go-to person. Outside work, I'm barely scratching the surface as a maker (focused on electronics), but I'm really hoping to build that skill set & grow. In addition to the core, care for and love of my family, these goals keep me going. Identify your goals, and your core, and keep going at it. The future will work itself out, one way or another. But you'll have set a direction and brought influence to bear so that, ten years on, you can look back with some pride and a lot of learning. Then do it all again.

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

Real-Real-World Programming with ChatGPT

From O'Reilly Radar - Insight

If you’re reading this, chances are you’ve pla...

Generative AI Apps Prone to Compromise, Manipulation

From Dark Reading: Dark Reading News Analysis

Researchers find artificial intelligence applicati...

Andy’s Generative AI Poll

From AndyLeonard.blog()

Last week I posted polls on Twitter and LinkedIn a...

AI – Will robot overlords take over the world

From Purple Frog Systems

Everyone assumes that AI is the Hollywood version with robot overlords taking over the world. In reality, AI is already here and we are using it in society. Phone...

AI builds momentum for smarter health care

From Technology Review Feed - Tech Review Top Stories

The pharmaceutical industry operates under one of the highest failure rates of any business sector. The success rate for drug candidates entering capital Phase 1 trials—the earliest type of...

Ryanair Hit With Lawsuit Over Use of Facial Recognition Technology

From Dark Reading: Dark Reading News Analysis

Airline violates privacy protections of the EU's G...

The Growing Impact of AI on Data Science in 2023

From Dataversity

While AI’s ubiquity is becoming increasingly evident through everyday tools like chatbots, smart cameras, and smart content generation, there’s an expansive universe of less recognized but highly potent advancements...

Administration of SQL Server

Test Restore Your SQL Server Databases

From SQLServerCentral Blogs

Pain Point: Something bad happened and you need to...

SQL Agent job history on a Managed Instance

From SQLStudies

The defaults for saving SQL Agent Job history are ...

SQL Agent job history on a Managed Instance

From SQLServerCentral Blogs

The defaults for saving SQL Agent Job history are ...

What Are Ghost Records?

From Callihan Data

Have you ever had to deal with ghost records? Whil...

Which Schema is Queried First?–#SQLNewBlogger

From SQLServerCentral Blogs

I had to test something for a customer, and as a p...

Presenting at PASS Summit 2023 – Atomic Habits

From SQLServerCentral Blogs

I’m excited to be presenting at PASS Summit 2023...

Tracking SQL Server Data Change History with Triggers versus Temporal Tables

From MSSQL Tips

In this article, we look at two different methods ...

SQL SERVER – The Two Doors, Two Guards Puzzle

From Journey to SQL Authority with Pinal Dave

I came across a puzzle about "The Two Doors, Two Guards," popularly known as the "Two Doors Riddle" or the "Heaven and Hell Riddle". First appeared on SQL SERVER –...

Create images in Microsoft Designer with AI and store in SQL Server

From MSSQL Tips

Learn how to generate images using AI and Microsof...

Analysis Services / BI on the MS Stack

Fun With KQL Windowing Functions – Prev and Next

From Arcane Code

Fun With KQL Windowing Functions - Prev and Next

Inside Calculation Groups

From Sqlbi

Learn how to use calculation groups and how they w...

Azure CosmosDB

How to perform a Full-Text Search in Azure Cosmos DB

From Hasan Savran

     Incorporating Full-Text Search functionali...

Azure Databricks, Spark and Snowflake

What is the difference between client and cluster deploy modes in Spark?

From Hadoop in the Real World

This post aims at describing the differences betwe...

Snowflake for SQL Server Developers - Transactions in Stored Procedures

From MSSQL Tips

In this article, we discuss transactions in Snowfl...

Snowflake: A Cloud Warehouse Solution for Analytics

This article explains what Snowflake data warehouse is and how it is different from other traditional data warehouses. This article will cover how to create virtual warehouses and different types of tables, how to handle semi-structured data, how to profile queries, and the benefits of clustering keys. Practical demonstrations of the concepts explained will be provided throughout the article.

Azure DevOps

Azure DevOps July 2023 updates

From Azure Updates

In July, we've delivered multiple improvements ac...

Azure SQL

Connect from Azure VM (VNet) to an Azure SQL Database

From Azure Database Support Blog

I'm going to show you different configurations to ...

Lesson Learned #407:Exploring Azure SQL Database Performance with sys.dm_os_performance_counters

From Azure Database Support Blog

In this blog post, we will embark on an exciting journey into the world of Azure SQL Database performance monitoring using PowerShell and the powerful sys.dm_os_performance_counters system view. By...

Azure SQL Managed Instance

Well-architected framework performance in the Azure SQL Managed Instance

From Azure SQL

Performance pillar in the   Well-Architected Framework for Azure  is focused on ensuring that your workload can meet performance requirements and that it can efficiently use resources to deliver results.   There...

Career, Employment, and Certifications

Production postmortem: The dog ate my request

From Ayende @ Rahien

A customer called us, quite upset, because their R...

Why I Have Never Liked Personas

From AndyLeonard.blog()

First, A Story Years ago I managed an ETL Team at ...

100 Blog Posts Milestone

From SQLServerCentral Blogs

Good morning dear reader, Long time no talk. It ha...

12 Years, 50 Courses: A Tale of Enthusiasm, Determination, and Resilience

From Journey to SQL Authority with Pinal Dave

12 Years, 50 Courses: A Tale of Enthusiasm, Determ...

I’m back! I’m still a Microsoft Data Platform MVP. And other minor life updates.

From SQLStudies

I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading

Top Résumé Tips To Stand Out in Automated Screenings and With Recruiters

From IT Pro - Microsoft Windows Information, Solutions, Tools

Job recruiters share advice to help applicants increase the chance of landing the job, even as more tech is used in the process.

What's the difference between DBAs, DBREs, and Data Engineers?

Kendra Little examines the differences between rol...

Cloud - AWS

AWS Week in Review – Redshift+Forecast, CodeCatalyst+GitHub, Lex Analytics, Llama 2, and Much More – July 24, 2023

From AWS News Blog

Summer is in full swing here in Seattle and we are...

7 Essential Roles for a Successful AWS Migration

From Dataversity

Increasingly more organizations initiate AWS migr...

Top Announcements of the AWS Summit in New York, 2023

From AWS News Blog

It’s probably no surprise that generative artifi...

New – Amazon EC2 P5 Instances Powered by NVIDIA H100 Tensor Core GPUs for Accelerating Generative AI and HPC Applications

From AWS News Blog

In March 2023, AWS and NVIDIA announced a multipar...

AWS Entity Resolution: Match and Link Related Records from Multiple Applications and Data Stores

From AWS News Blog

As organizations grow, the records that contain in...

New: AWS Local Zone in Phoenix, Arizona – More Instance Types, More EBS Storage Classes, and More Services

From AWS News Blog

I am happy to announce that a new AWS Local Zone in Phoenix, Arizona is now open and ready for you to use, with more instance types, storage classes,...

Cloud - Azure

Azure SQL—Public preview updates for mid-July 2023

From Azure Updates

Public preview enhancements and updates released f...

Community Interests

Why You Should Attend PASS Data Summit This Year

From Erik Darling Data

Promo Video I couldn’t have said it better myself. Registration is here. Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love...

Computing in the Cloud (Azure, Google, AWS)

How Cloud Cost Optimization Can Help Solve the Tech Hiring Crisis

From Past News - RSS Feeds

For workers outside the tech sector, the Great Res...

Why Foundational Skills for IT Engineers Remain Critical in a Cloud-Native World

From IT Pro - Microsoft Windows Information, Solutions, Tools

Fundamental engineering skills are crucial for IT ...

IBM Cloud Carbon Calculator: Enabling Environmental Goals

From Past News - RSS Feeds

With much of the U.S. and many other parts of the ...

Why and How to Adopt Event-Native Computing

From IT Pro - Microsoft Windows Information, Solutions, Tools

Here's why organizations need to get on board with...

Data Portability May Save Your Cloud Workloads

From Dataversity

As businesses try to optimize their costs during e...

Conferences, Classes, Events, and Webinars

Sessions for Summit 2023 are now LIVE!

The wait is finally over. This year’s PASS Data Community Summit sessions are now live!

DMO/SMO/Powershell

How To Filter Objects in PowerShell

From IT Pro - Microsoft Windows Information, Solutions, Tools

Watch this video to learn techniques for working w...

10 Popular PowerShell Tips and Tricks in 2023

From IT Pro - Microsoft Windows Information, Solutions, Tools

This midyear roundup of our most-read PowerShell a...

How To Automate PowerShell Scripts With Windows Task Scheduler

From IT Pro - Microsoft Windows Information, Solutions, Tools

Automate the execution of PowerShell scripts using...

Lesson Learned #406:Monitoring Resource Usage and Open Ports with PowerShell & Bash Script

From Azure Database Support Blog

In today's fast-paced digital landscape, it is crucial for organizations to efficiently monitor and manage their infrastructure's resource utilization. High resource consumption or misconfigured open ports can lead to...

Microsoft Asks IT Admins to Import Updates into WSUS with PowerShell Script

From Petri IT Knowledgebase

Microsoft has announced some important changes com...

Data Mining / Data Analysis

Becoming Data-Driven Without a Data Analyst

From Dataversity

Data analysts are an important part of modern busi...

Simplicidad, flexibilidad y accesibilidad + tecnología: claves del marketing moderno para mejorar la experiencia del cliente

From AllAnalytics

El objetivo es siempre el mismo: poder desarrollar...

Trustworthy AI examples from the SAS Hackathon

From AllAnalytics

As a member of the SAS Data Ethics Practice, I was...

Recharge Day: La importancia de desconectar para el bienestar de nuestros empleados

From AllAnalytics

El ritmo de vida actual puede resultar, en ocasion...

Predictive Analytics Use Cases for Citizen Data Scientists

From Dataversity

Gartner technology analysts predict that organizations leveraging augmented analytics solutions will grow at twice the rate of those that do not use these solutions. Those organizations that provide self-serve augmented analytics to...

Database Design, Theory and Development

Why monitoring server estates from a single pane of glass is key

From Blog – Redgate Software

The last few years have seen a big change in the size, make-up, and nature of database estates. Data is growing both in volume and complexity, it is now...

DevOps and Continuous Delivery (CI/CD)

GitHub Copilot for Azure Data Studio to Boost Database Development Productivity - Part 1

From MSSQL Tips

In this article, we will look at GitHub Copilot fo...

What Is GitOps and How Can It Support Machine Learning Operations?

From Dataversity

GitOps is a way of implementing continuous deliver...

10 reasons to choose Flyway

From Blog – Redgate Software

Thousands of organizations use DevOps practices ev...

How to Put the Sec in DevSecOps

From Dark Reading: Dark Reading News Analysis

Learn the importance of adding security practices ...

Assumptions in Regression: Why, What, and How

From Dataversity

“Garbage in, garbage out” defines the importan...

Comprehensive Guide to What a DevOps Engineer Does

From IT Pro - Microsoft Windows Information, Solutions, Tools

Looking for a career in software development? Check out our guide on what a DevOps engineer does and what it takes to become one.

Editorial

The Importance of Tact

The concept of tact is simple. Telling people truths, often harsh truths, without making it seem harsh. Hopefully, it is clear that being truthful is one of the more essential things in life. As a person in technology (and certainly as an editor), we often need to be honest when the truth hurts a bit more than average.

Hardware

Crucial X9 Pro and X10 Pro High-Performance Portable SSDs Announced

From AnAndTech

Crucial's X6 and X8 Portable SSDs have been attrac...

Machine Learning

Video: Training a Model with the Azure ML Designer

From 36 Chambers – The Legendary Journeys

THE VIDEO THE SYNOPSIS In this video, we will trai...

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

What is Microsoft Fabric?

From MSSQL Tips

This article discusses what Microsoft Fabric is an...

Exploring limitations of Fabric Warehouse: 3 key observations

From Joyful Craftsmen – The Business Intelligence Agency

Introduction Fabric Warehouse is a new interesting...

Microsoft News

Microsoft 365 Defender Adds New URL Page to Block Phishing Attacks

From Petri IT Knowledgebase

Microsoft has launched a URL page for its Microsof...

Microsoft Defender for IoT Gets New Firmware Analysis Capabilities

From Petri IT Knowledgebase

Microsoft has released a new firmware analysis fea...

Microsoft Teams to Add New Meet App to Manage Meeting Activities and Content

From Petri IT Knowledgebase

Microsoft Teams is getting a new Meet app that sho...

Happy Birthday Windows Server (the artist previously known as Windows NT) !

From The Bit Bucket

On July 27th 1993, Microsoft released Windows NT, ...

Oracle/PostgreSQL/MySQL/other RDBMS

Beginners Guide to PostgreSQL Database Hardening

Mutaza Umair gives an introduction to security within the PostgreSQL framework.

Querying PostgreSQL: Learning PostgreSQL with Grant

From Simple Talk

Writing queries to retrieve the data from a databa...

SQL Server vs Oracle: Historical Query Performance Statistics

From MSSQL Tips

In this article, we look at how to get historical ...

Exporting data from a MySQL database using SELECT…INTO OUTFILE

From Simple Talk

In the previous article in this series, I introduced you to the MySQL LOAD DATA statement, which lets you retrieve data from a plain text file and insert it...

Performance Tuning SQL Server

A Little About Windowing Functions And Joins In SQL Server

From Erik Darling Data

Do Best Going Further If this is the kind of SQL S...

Deciphering the SQL Server Performance Mysteries with SQL DM

From Journey to SQL Authority with Pinal Dave

Decipher the SQL Server performance mysteries with SQL DM. Microsoft's SQL Server is a robust and widely adopted database. First appeared on Deciphering the SQL Server Performance Mysteries with SQL...

PowerPivot/PowerQuery/PowerBI

Options for Data Source Credentials When A Service Principle Owns A Power BI Dataset

From SQLSwimmer

In today’s world of wanting to automate everythi...

Power BI – Testing Row Level Security (RLS) for multiple users in Excel

From FourMoo

I have been doing a fair amount of work on Row Lev...

SQL Server Security and Auditing

A Security Change with SQL Compare 15

From SQLServerCentral Blogs

Actually, this is a change for many products and s...

SQL Server Security Fundamentals at Pluralsight

From Journey to SQL Authority with Pinal Dave

I'm delighted to announce the launch of my 51st co...

Security News and Issues

China Propaganda Spreads via US News Sites, Freelancers, Times Square

From Dark Reading: Dark Reading News Analysis

A widespread disinformation campaign aimed at Amer...

Zero-Day Vulnerabilities Discovered in Global Emergency Services Communications Protocol

From Dark Reading: Dark Reading News Analysis

Weak encryption algorithms leave radio communicati...

Backdoor in TETRA Police Radios

From Schneier on Security

Seems that there is a deliberate backdoor in the t...

Peloton Bugs Expose Enterprise Networks to IoT Attacks

From Dark Reading: Dark Reading News Analysis

Hackers have three key pathways — the OS, apps, ...

SEC Adopts New Rule on Cybersecurity Incident Disclosure Requirements

From IT Pro - Microsoft Windows Information, Solutions, Tools

Boards must now file notice of a "material inciden...

Despite Post-Log4J Security Gains, Developers Can Still Improve

From Dark Reading: Dark Reading News Analysis

Developers need more software security safeguards ...

Millions of People Affected in MOVEit Attack on US Gov't Vendor

From Dark Reading: Dark Reading News Analysis

Living up to its name, Maximus sees a whale of a b...

Indirect Instruction Injection in Multi-Modal LLMs

From Schneier on Security

Interesting research: “(Ab)using Images and Sounds for Indirect Instruction Injection in Multi-Modal LLMs“: Abstract: We demonstrate how images and sounds can be used for indirect prompt and instruction injection in...

T-SQL and Query Languages

Lesson Learned #405: How many TSQL operations you said?

From Azure Database Support Blog

In today's data-centric landscape, Azure SQL Datab...

Using T-SQL for Investing and Trading Financial Securities

From MSSQL Tips

This tip presents a high-level overview of impleme...

Tech News

What’s next for the moon

From Technology Review Feed - Tech Review Top Stories

MIT Technology Review’s What’s Next series loo...

Virtualization and Containers/Kubernetes

Public preview: Azure Application Gateway for Containers

From Azure Updates

Application Gateway for Containers is the next evo...

Running SQL Server in Docker Swarm

From DBA From The Cold

I haven’t touched Docker Swarm for a looooong ti...

Kubernetes and the Software Supply Chain

From Dark Reading: Dark Reading News Analysis

Trusted content is paramount in securing the suppl...

Deploy Containers with Go-SqlCmd

From MSSQL Tips

Go-SqlCmd provides additional features for deployi...

 
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

 

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