Does safety make you too comfortable? That and lots of advice from past people to future others!

Database Weekly for July 13, 2024 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 Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -