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
 

Insiders Selling Data

There is a report that the lowest-paid employees at various banks are selling customer data, which is sad and also not unexpected. Those who have access to sensitive information can be tempted to part with it for a quick profit. I've seen this in the past in restaurants and retail stores. Sometimes with credit card or other data, but also with knowledge (or keys) that would let someone burglarize the premises.

There's a great quote in the article that says: "The more employees there are inside a company with access to sensitive customer information, the higher the risk that access is going to be abused." I think that's very true in most companies, which is why governance and data controls are becoming more important in some organizations. I wish it were a global trend at all companies, but far too many don't think there is a high risk, or that their employees will abuse their privileges.

I'd like to think most IT people wouldn't be tempted to sell or disclose info, but I'm not sure that's true. While many IT staffers are paid well, well is relative. Some might not think they're compensated enough or they might feel pressure from their own financial stresses to compromise that data of others.

Privileged access is just that: privileged. While it can be a pain to have a separate account for certain access, the intention is that you are reminded that this account can access things that others should not see. In my career, I've tried to remember this and be careful with my access, though admittedly, I've done plenty of non-privileged things with a privileged account, being lucky enough that nothing bad happened.

Security continues to be a problem in so many places, and with the vast amounts of data we collect, and the growing desire for many organizations to let AI LLMs view that data, I suspect we'll likely have more problems in the future not less. While we might not have as many humans that decide to sell our data, I suspect we'll have many more AIs that can be tricked into disclosing it.

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

Generating an Activity Log for Flyway Migrations

Flyway's JSON output makes it much easier to report and log database migration activities, providing structured details about version changes, execution times, and warnings. This article demonstrates how to use this JSON output along with a Flyway callback to create a human-readable log of Flyway migrations. It explores how to customize these logs with project-specific details or extend them to send notifications, helping developers better track and understand their database migration processes.

AI/Machine Learning/Cognitive Services

11 Ways to Spot AI-Generated Text

From Purple Frog Systems

As artificial intelligence (AI) continues to evolve, its applications in text generation are becoming increasingly sophisticated. AI-generated text can be found in articles, emails, reviews, and even creative writing....

Newbies, Kids & Teens Prompt Engineering Tutorial

From Little Miss Data

A tutorial tailored for kids. teens and beginners ...

The fraught ethics around AI, ChatGPT, and Power BI.

From SQLGene – Learning SQL Slowly

The more I tried to research practical ways to make use of ChatGPT and Power BI, the more pissed I became. Like bitcoin and NFTs before it, this is...

Career, Employment, and Certifications

Advice I Like: Experience and Aptitude

From SQLServerCentral Blogs

Experience is overrated. Most breakthrough accomplishments were done by people doing them for the first time. Therefore when hiring hire for aptitude and attitude and then train for skills.... The...

Why You Should Write Down Your Goals for 2025

From Callihan Data

2024 is winding down. Have you taken time to revie...

Capturing Ideas for Blogs

From SQLServerCentral Blogs

 

Cloud - Azure

Grab Yourself Some Free Azure SQL Offerings

From Andy Broadsword

Its the time of year where things may winding down...

Computing in the Cloud (Azure, Google, AWS)

Managed SQL databases in AWS, Azure and GCP

AWS, Azure and GCP all have a fully managed services for SQL Server databases. In this post, I’ll provide a brief overview of the offerings from these hyperscalers.

Data Privacy, Compliance, and Governance

Strategies for Managing Data Debt in Growing Organizations

From Dataversity

As organizations scale, data debt can accumulate silently, affecting productivity, efficiency, and decision-making quality. Data debt refers to the accrued cost of shortcuts and inefficiencies in data management that...

 
Hardware

Rumors say next-gen RTX 50 GPUs will come with big jumps in power requirements

From Ars Technica

We'll likely find out more about Nvidia's next GPUs at CES next week.

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

Microsoft Fabric: Unlocking the Secrets to Mastering Shared Semantic Models – Part 2 – Implementation

From BI Insight

This blog series complements a YouTube tutorial I ...

Oracle/PostgreSQL/MySQL/other RDBMS

Oracle Architecture Overview

I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but understanding where Oracle has been and where it’s going is essential to us building the best products to support this enterprise, robust RDBMS platform. I was disappointed by many of the documents out on the Oracle support site, etc., so this is an internal document to help understand how a seasoned Oracle DBA might navigate, learn and understand Oracle.

Performance Tuning SQL Server

How To Write SQL Server Queries Correctly: Apply

From Erik Darling Data

How To Write SQL Server Queries Correctly: Apply T...

How To Write SQL Server Queries Correctly: EXISTS and NOT EXISTS

From Erik Darling Data

How To Write SQL Server Queries Correctly: EXISTS and NOT EXISTS Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about,...

How To Write SQL Server Queries Correctly: Subqueries

From Erik Darling Data

How To Write SQL Server Queries Correctly: Subquer...

SQL in Sixty Seconds – CPU Threads and Uneven Workload

From Journey to SQL Authority with Pinal Dave

When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less. First...

How To Write SQL Server Queries Correctly: Joins

From Erik Darling Data

 

PowerPivot/PowerQuery/PowerBI

DOWNLOAD A REPORT OR MODEL FROM FABRIC

…if the Power BI “download this file” is greyed out and you’re unable to download it from the user interface.

Power BI Copilot And The Data Category Property

From Chris Webb's BI Blog

I have known for a while that setting the Data Cat...

Replacing Images in PBIR Format Reports

From SQLServerCentral Blogs

 

Product Reviews and Articles

Generating an Activity Log for Flyway Migrations

From Product learning – Redgate Software

Flyway's JSON output makes it much easier to report and log database migration activities, providing structured details about version changes, execution times, and warnings. This article demonstrates how to...

BK’s Bookshelf: Never Split the Difference

From SQLServerCentral Blogs

I picked up Never Split the Difference: Negotiating As If Your Life Depended On It by Chris Voss, a former FBI negotiator. Given what I do, I realized that... The...

Product Upgrades and Releases

SQL Server Diagnostic Information Queries for January 2025

From Glenn Berry

Introduction These are my SQL Server Diagnostic Information Queries for January 2025, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration...

Updated First Responder Kit and Consultant Toolkit for December 2024

From Brent Ozar Unlimited

 

SQL Server News

Five changes to SQL Server I’d love to see

From Simple Talk

I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once...

Security News and Issues

Whistleblower finds unencrypted location data for 800,000 VW EVs

From Ars Technica

Der Spiegel and Chaos Computer Club were able to t...

AI-generated phishing emails are getting very good at targeting executives

From Ars Technica

Hyper-personalized emails use "an immense amount" of scraped data.

Bank Insiders Are Leaking Data on Client Accounts as Scams Surge

From IT Pro - Microsoft Windows Information, Solutions, Tools

Prosecutions across the U.S. reveal sales via social media and the dark web.

Tech News

Anthropic gives court authority to intervene if chatbot spits out song lyrics

From Ars Technica

A small win for music publishers in the fight over Claude outputs.

Let AI Help You Plan Your Next IT Budget

From IT Pro - Microsoft Windows Information, Solutions, Tools

Budget planning is never easy. AI stands ready to help, though the human element remains vital to the process.

USB-C gets a bit more universal as the EU’s mandate goes into effect

From Ars Technica

Apple has already pulled devices to comply with the Common Charger Directive.

Siri “unintentionally” recorded private convos; Apple agrees to pay $95M

From Ars Technica

Apple users may get $20 each for up to five Siri-enabled devices.

Testing Software

tSQLt – Automate Unit Test Execution with Azure DevOps Pipelines

In the previous data recipe, tSQLt for Data Warehousing, test your Stored Procedure, we created our first Unit Test to validate our SQL Server Stored Procedures. In this data recipe, we will dive into the process of Database Unit Testing automation with Azure DevOps.

The Lighter Side

It’s January, which means another batch of copyrighted work is now public domain

From Ars Technica

More Mickey Mouse versions, early talkies, and classic novels all go public.

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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