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 Danger of Safety Assistance Tools

During a speaker dinner the other week, a lot of topics were swirling around and a few caught my ear. One of these topics dovetailed nicely with a mistake I recently made. More on that later.

The discussion was on the effect on safety that all the new safety-based tech is having on driving. Some features are a net positive, like airbags and seat belts. Of course, they, too, have a slight negative. Before seat belts, most drivers were much more cautious and less likely to drive super fast (there are always counter-examples!)

While it is true that safety technologies like the Tesla Auto Pilot and Self Driving features (not to mention simpler versions like the simple lane-keeping system that is part of the broader Co-Pilot system from Ford that I have on my vehicle) saves us when we get distracted. However, such features may also facilitate such distractions as habits where you often take your eyes off the main job when there is a steering wheel in front of you. Overall, though, looking at the data from the insurance companies (the ones that failures in traffic safety costs the most money before they pass it on to you and me, of course), it seems that this isn't the case.

No, this is not a driving advice blog

Note I said" overall." Overall can mean something is very helpful in 90% of the cases and 10% unhelpful. This is where my mistake comes into the story. It has nothing to do with driving safety, but rather email safety. 90% or more of the phishing attempts that come in are caught by the email filters (and well over 98% of the stuff caught by those filters are evil attempts to get me to click on it and start a chain reaction that brings down my organization or life.)

But the ones that slip through are the worrisome ones, especially when the spammer does an adequate job of being evil. A few days ago, I got such a message. I opened it, I scanned it, I checked the links, and wasn't sure. In my checks, did I click on the link?

Of course not. In fact, I rarely, if ever, use email links to go to a site I work with, much less ones I need clarification on unless I just requested a link. I can't believe you even thought such things. But the lack of it being caught by the safety system made me think it was possibly, perhaps even probably real.

So I forwarded it to someone and asked. And that right there was my mistake—forwarding possibly evil content to another person to see what they do. Now I forwarded it to someone who would also know better, but what should I have done? Either ask the person I needed to without forwarding the (I wasn't sure if we used a particular service) or send my question to the group that handles this sort of thing and let them deal with it. (Again, not forwarding the email itself!)

The moral of the story

The moral of the story? Don’t let safety checks lull you into a false sense of security. Security software, like driving assistance tools, are assistants, not absolutely right all the time. In fact, all non-strict security, like email scanning, is just like the automobile tech that helps nudge you back on course, with a little assistance.

All it takes is to open, click, and download without using all your brains, and then real trouble may occur. This is true whether you are using your company email system, computer, or phone, where you probably also have access to company resources.

What is the saddest part of this blog is that it must really work well, because phishing has been going on almost as long as Phish has.

Louis Davidson (@drsql)

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

Simpler Enterprise Test Data Management using Database Instance Provisioning

Business applications are rarely self-contained, often depending on multiple interconnected databases, each playing a vital role in the functioning of the system. How can we create, refresh, and maintain test data for these complex database systems, and still support dedicated databases and test-driven development processes? This article explains how database instance provisioning helps meet this challenge, and how teams can use the database provisioning, or cloning, component of Redgate Test Data Manager, to create and manage test data for larger and more complex database systems.

Save $200 on a standard price 3-day ticket to PASS Summit 2024 by registering before July 16

PASS Data Community Summit 2024 is taking place in Seattle from November 4-8. With over 150 sessions and over 140 different speakers, this year's event promises something for everyone, with a broad variety of topics covered by a range of data industry experts. If you're looking to connect, share and learn with the data community this year, make sure you register for PASS Summit before the next price bump and save $200 on a 3-day ticket. Beat the price bump by registering for your ticket before July 15, 23:59 PM PT.

AI/Machine Learning/Cognitive Services

How Will Every Company Invest Its AI Time Savings?

From IT Pro - Microsoft Windows Information, Solutions, Tools

If AI tools do eventually help automate workers’ tasks and shave time off the stretch from assignment to deliverable, managers have a choice: They can assign more work or...

Administration of SQL Server

It’s a recovery strategy, not a backup strategy

I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. I can’t possibly care if my backups succeed if I’m not bothering to test that they can be restored. And if they can’t be restored then, both technically and practically, I don’t have backups.

Identify Tables With Dropped Columns

From SQLServerCentral Blogs

On my last article - What happens when we drop a c...

Capturing Stored Procedure Executions with Extended Events in SQL Server

From Journey to SQL Authority with Pinal Dave

We'll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data. First appeared on Capturing Stored Procedure...

Conferences, Classes, Events, and Webinars

It’s Nearly Time: Let’s Build an Outlier Detector in Baton Rouge

From 36 Chambers – The Legendary Journeys

What: SQL Saturday Baton RougeWhere: Baton Rouge, LouisianaWhen: Friday, July 26th for the pre-con and Saturday, July 27th for the main eventAdmission to SQL Saturday itself is free. Register on Eventbrite.The...

DMO/SMO/Powershell

PowerShell: Measure Objects (Count, Average, Sum …)

From Sid 500 PoSh

The Measure-Object cmdlet counts objects. But it c...

Data Visualisation

Unlock the Power of Colour: Make Your Power BI Reports Pop

From Adatis

Colour is a powerful visual tool that can enhance ...

"need to know" vs. "good to know"

From Storytelling with Data

Have you ever agonized over how much detail you should include in a chart, a slide, or a presentation? This was a constant struggle for me in my own...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Working with Documents in the MongoDB Compass GUI

From Simple Talk

Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following along, you should now have a good sense of...

General

SSMS 20.2 and a Preview of 21

From Curated SQL

Erin Stellato reaches out: Hey SQL Tools fans!  We’re halfway through 2024 and due to a confluence of events we have a release of SQL…

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

Microsoft Fabric, the Land of Wizards and Trolls

In this article, I would like to go deep into the dark corners of Microsoft Fabric, since there are some gray areas, some amazing features, and some traps. In my daily role as a Microsoft Fabric administrator for the past 6 months (not counting the years of PowerBI development and administration experience before that) I find myself sitting right on the ridge where three lands meet: the very popular Microsoft PR fluff about how great and mighty Fabric is, the outcries and the struggles of the business users trying to deliver and consume data insights, and the comments of a guild of tech-savvy data engineers who for the most part refuse to bite into this Fabric apple.

Fabric CI/CD with Git deployment and release strategies

From Data – Marc

Recently, I wrote a blog about the new branch-out ...

Copilot in Microsoft Fabric

From SQLServerCentral Blogs

Microsoft Copilot is an app that uses AI to help you find information, create content, and get things done faster (see What Is Copilot? Microsoft’s AI Assistant Explained).  Copilot is... The...

Microsoft Fabric: New Features you should not miss

From Simple Talk

Microsoft Build was full of new features announcements and the fact it was so close to the Fabric May Updates only helped to overwhelm us with new features to...

Microsoft Fabric is the New Office

From Thomas LaRock

At Microsoft Build in 2023 the world first heard about a new offering from Microsoft called Microsoft Fabric. Reactions to the announcement ranged from “meh” to “what is this?”...

Performance Tuning SQL Server

Parameter Sniffing, Predicate Selectivity, And Index Key Column Order In SQL Server

From Erik Darling Data

Parameter Sniffing, Predicate Selectivity, And Index Key Column Order In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning...

What’s The Point of 1 = (SELECT 1) In SQL Server Queries?

From Erik Darling Data

What’s The Point of 1 = (SELECT 1) In SQL Server Queries? Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning...

PostgreSQL

Radim Marek: Gentle Introduction to Window Functions in PostgreSQL

From Planet Postgres

Understanding the relationship between data points...

Umair Shahid: Guide to Auditing and Monitoring Access in PostgreSQL

From Planet Postgres

In the data-driven world of today, maintaining the...

Migrate a SQL Server Database to a PostgreSQL Database

From MSSQL Tips

Learn about various options to migrate an entire S...

JSON and JSONB Data Types in Postgres

From Curated SQL

Andrea Gnemmi covers a pair of data types to manag...

PowerPivot/PowerQuery/PowerBI

DAX Measures That Never Return Blank

From Chris Webb's BI Blog

Following on from my earlier post on the Query Mem...

How to create a slick way to adjust your Power BI visual

From Guy in a Cube

Create a slick way to adjust your Power BI visual ...

LLM Adventures: Text2DAX

From Prologika (Teo Lachev's Weblog)

In my previous post, I covered how large language models, such as ChatGPT, can be used to convert natural queries to SQL. Let’s now see how Text2DAX fairs. But...

Professional Development

T-SQL Tuesday 176 – Advice I would give past me when starting my first data platform job

From Kevin Chant

Reading Time: 2 minutes For this months T-SQL Tue...

Use “We” Not “You”. #tsql2sday

From Brent Ozar Unlimited

For T-SQL Tuesday this month, Louis Davidson sugge...

T-SQL Tuesday #176: One piece of advice for Past Steve

From SQLServerCentral Blogs

I almost missed this month, so this is also a good...

T-SQL Tuesday #176 One piece of advice that you wish Past you had

From Curious..about data

This month’s T-SQL Tuesday is hosted by a dear f...

T-SQL Tuesday #176: Advice to My Past Self

From Callihan Data

The T-SQL Tuesday invite for July 2024 comes from ...

T-SQL Tuesday #176: What Advice Do You Wish Current You Could Go Back and Give Past You as You Were Starting Your First Data Platform Job?

From AndyLeonard.blog()

July 2024’s T-SQL Tuesday is hosted by Dr. SQL h...

T-SQL and Query Languages

Create Document Templates in a SQL Server Database Table

From MSSQL Tips

In this article, we look at how to create document...

Lesson Learned #507:Error 4429 - View or function 'XYZ' contains a self-reference.

From Azure Database Support Blog

This last week, we worked on a service request whe...

Removing Leading Zeroes from a String in T-SQL

From Curated SQL

Steve Stedman gets rid of leading zeroes: When wor...

The Lighter Side

Windows Notepad gets spellcheck and autocorrect, after 41 years

From All about Microsoft Blog RSS | ZDNet

The minimalist text editor has remained largely un...

Does code rot over time?

From Ayende @ Rahien

“This is Old Code” is a programmer’s idiom meaning “There Be Dragons”.  The term “Legacy Code” is a nice way to say “Don’t make me go there” Those are...

How to use ChatGPT to digitize your handwritten notes for free

From All about Microsoft Blog RSS | ZDNet

This is easily the most underrated GPT-4o feature.

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

Announcing SSMS 20.2 ... and getting feedback for SSMS 21

From MS SQL Server Blog

Hey SQL Tools fans!  We’re halfway through 2024...

SSMS 20.2 Update Resolves Certificate Chain Not Trusted with SSIS and SQL Agent

From AndyLeonard.blog()

I’m reading Announcing SSMS 20.2 … and getting...

Virtualization and Containers/Kubernetes

Docker Logging Guide Part 2: Advanced Concepts & Best Practices

Welcome to part 2 of our Docker Logging Guide series. In this article, we will cover Docker logging in detail. We will explore advanced concepts and Docker logging best practices to help you optimize your logging strategy.

 
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

 

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