The Word of the Week is Fabric

Database Weekly for June 3, 2023 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  Trust! The difference between a low trust society (few individuals within a trust circle outside your family and/or tribe) and a high trust society (general trust of individuals beyond immediate family/tribe associations) generally speaking can be measured as the difference between a low tech (low trust) and high tech (high trust) society. Yes, exceptions abound, but the general rule, largely, holds true. Speaking of trust, our house is actually one full mile (that's 1.6km for those of you using real measurements, or 946.5 smoots) from our mail box. To say the box isn't visible is an understatement. Due to the hills, rocks & trees, I can barely get a radio signal all the way down there, let alone see it, or even set up some kind of wifi device down there. In short, we don't know when we've got mail (although, that's changing as technology does). However, until recently, this wasn't a big deal. I'd get the mail on the way to, or from, somewhere else. We have, or had, a pretty high-trust situation. However, in the last two weeks, the mail has been cleaned out, multiple times. So has our neighbors. We're now holding our mail (low trust) until we get a locking mailbox set up (even lower trust). I posted this recently on Facebook and had a few people respond that they recently had to do the same thing, in communities all over. Are we starting to move from a high trust society to a low trust one? Personally, ever the optimist, I don't think so. I think society, as a whole, is as trustworthy as ever. However, a few bad apples can indeed spoil the bunch, as the saying goes. The real question for me is pretty simple, if we are in a migration to low trust, how will that impact technology? First up, innovation requires that we share beyond our family & tribe. To quote another aphorism, a rising tide & all that. However, beyond innovation, we're likely to hit issues with maintenance. Will we have to put guards on power distribution stations, lest those stinkers over the hill come and take it? As trust fails, it's not just simple stuff like that mail that gets impacted. Same thing for replacement parts for the water pumps, etc., etc.. The tail on our supply chains is far too long for the process to work when the only ones we can trust are our family and village. If the village over the hill is out to get us, one UPS truck hijacking could put us without water, lights, or food. You could even see, within organizations as trust breaks down, that the admin team has it in for the developers who really aren't enamored with QA who... You get the picture. Being officially now an old man (I turned 60 a couple of months ago), I've seen a lot of changes over the decades. I'm here to tell you, especially if you're pessimistic, that in my 60 years, things have improved. Everything (well, except the amount of free time I have) has improved since I was a child. Everything. On all fronts. While our current, and recent, times may seem to be slipping a bit, I'm pretty sure it's an aberation. We'll find the postal thief (and I'm sure it's only one person), or they'll get in trouble somewhere else (because people who tend to steal & do bad things, tend to steal & bad things all over the place) and we'll be able to go back to trusting people... only with a locking mailbox. I suspect similar things will happen over the next couple of years all over with technology. A dip in trust will increase our security, and trust will come back. What do you think, increasing, decreasing or staying the same on trust? 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 [Using Windows Security and Encryption with Flyway]( This article describes a simple technique that will allow you to use Flyway securely, even in cases where more than just the login credentials need to be protected. It uses a PowerShell technique that converts an encrypted Flyway configuration file into an array of parameters that Flyway can read just as if you were typing them in. AI/Machine Learning/Cognitive Services [The Biggest Problem in AI? Lying Chatbots]( From IT Pro - Microsoft Windows Information, Solutions, Tools Despite the leaps in capabilities that "generative" chatbots like OpenAI's ChatGPT, Microsoft's Bing and Google's Bard have demonstrated, they still have a major flaw: They make stuff up all... [AI and the Human Touch: Maximizing IT Issue Resolution]( From IT Pro - Microsoft Windows Information, Solutions, Tools IT operations teams should work with IT service teams, data scientists, and machine learning experts doing the heavy lifting on the build side. [GPT4 vs. Elmar]( From Past News - RSS Feeds GPT4 and ELMAR are both artificial intelligence tools that help companies perform a number of important tasks. But which one is best for your business’s purposes? GPT4 is the... Administration of SQL Server [SQL Server Corruption: What Causes Corruption]( From Steve Stedman There are several common causes of database corrup... [SQL Server 2022: Buffer Pool Scans on Large-Memory Computers]( From Journey to SQL Authority with Pinal Dave Buffer pool scans causing slow operations on large... [Troubleshoot SQL Server Deadlocks in Stored Procedures]( From MSSQL Tips In this article, we walk through the process used ... [SQL Server 2022]( From SQL Seeker It's been almost a year since I blogged about anyt... [Database Health: Finding and Resolving Blocking Queries]( From Steve Stedman Finding and resolving blocking queries is an essential part of database administration, as blocked queries can cause significant performance issues and slow down query execution. The Database Health Monitor... [SSMS 19.1 Performance Improvements]( From Glenn Berry On May 24, 2023, Microsoft released SQL Server Management Studio 19.1. The release notes are here, and they include this item: SSMS 18.X cold startup performance is a big... [Analyze SQL Server Database Space usage with this App]( From MSSQL Tips In this article, we look at a C Sharp application you can easily create to keep track of how much space your largest SQL Servers and databases are using. [Configuring Parallel Index Operations in SQL Server]( From Journey to SQL Authority with Pinal Dave Configuring parallel index operations in SQL Server can significantly impact query performance and scalability. During my popular service, we discuss. First appeared on Configuring Parallel Index Operations in SQL Server [Cheat Sheet for SQL Server DBAs - Monitoring Current Activity, Blocking and Performance]( From MSSQL Tips This article contains several SQL scripts a DBA can use to manage and monitor SQL Server for current activity, blocking, and performance metrics. Analysis Services / BI on the MS Stack [Load Binance Data using API and Python for SQL Server Analysis]( From MSSQL Tips Learn how to use the Binance API and Python to loa... Azure CosmosDB [Great news everyone! Azure Cosmos DB Serverless can scale up to 1TB now.]( From Hasan Savran    Azure Cosmos DB's Serverless option is a great way to save money if your application expects intermittent and unpredictable traffic with long idle times. I use serverless... Azure DevOps [Setting Up a CI/CD Pipeline with GitHub Actions for Stream Analytics Jobs]( From Azure Updates Are you using GitHub for managing your Stream Analytics project and looking to leverage GitHub's powerful CI/CD pipeline? Follow this comprehensive guide and learn to set up a CI/CD... Azure SQL [Easy APIs with Azure SQL Database | Data Exposed: MVP Edition]( From Azure SQL Have you ever wanted to build a REST API or GraphQL interface to your Azure SQL Database? Join Anna Hoffman and Data Platform MVP Joey D’Antoni to learn about... Cloud - AWS [AWS Week in Review – AWS Wickr, Amazon Redshift, Generative AI, and More – May 29, 2023]( From AWS News Blog This edition of Week in Review marks the end of th... Computing in the Cloud (Azure, Google, AWS) [5 Cloud Cost Optimization Best Practices You Might Have Missed]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here are five best practices that organizations of... Conferences, Classes, Events, and Webinars [First speakers announced for Summit 2023]( Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. And don't forget - register before June 7 for a 30% saving on the rate. [PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers]( In the first two webinars, we've discussed why PostgreSQL has become such a force in recent years and some of the main differences for SQL Server users to know. In this follow-up webinar, find out how to take your first steps using PostgreSQL. Join Ryan Booz, PostgreSQL Advocate at Redgate, and discover: The freely available options to help you get started The essential tools you will need when using PostgreSQL Some learning resources to help you take the next steps DMO/SMO/Powershell [Administering Windows Defender with PowerShell]( From Sid 500 PoSh In this article, I will focus on Microsoft Defende... Data Mining / Data Analysis [How to use a log-scale on a histogram]( From AllAnalytics Real-world data often exhibits extreme skewness. I... [Solving the dual norm problem]( From Statistical Odds & Ends Let’s say we are in . Consider the maximization ... [Saving lives: Using data to combat the opioid crisis]( From AllAnalytics Did you know that over 300 people die daily from drug overdoses in the US? As a pharmacist, I have witnessed the harrowing effects of substance use disorder (SUD)... Database Design, Theory and Development [Should You Consider a Unified Data Model?]( From Dataversity A unified data model allows businesses to make bet... [Video: Venn Diagrams are for Sets, NOT Joins!]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we will learn why Venn diagrams are not good for describing join behavior. From there, we’ll learn exactly what Venn diagrams describe... [QR Code Generator in Web-Based App from data stored in SQL Server]( From MSSQL Tips Learn how to add functionality to generate QR Codes from data stored in a SQL Server database and a web-based application. [Why Geospatial Data Should Be Easily Accessible for Every Employee]( From Dataversity Unlocking the power of geospatial data can give organizations a competitive edge, from optimizing supply chain logistics and enhancing customer experience to mitigating fraud and improving public health outcomes.... Hardware [How to Use a Banana as Touch Input for Raspberry Pi Pico]( From Tom's Hardware US Using the bare minimum of parts and CircuitPython ... [Raspberry Pi Pico Controls Wireless Buttons for Bullet Time Video Booth]( From Tom's Hardware US Sebastian Staacks is using a couple of Picos to dr... [Raspberry Pi Adapter Sends Keyboard Input From iPad via HID to Devices]( From Tom's Hardware US Canatee is a teacher using two Raspberry Pis to po... [Raspberry Pi Malware Infects Using Default Username and Password]( From Tom's Hardware US John Hammond takes a look at this Raspberry Pi Mal... [This Raspberry Pi Pico Macropad is a Mouse Controlled by Buttons]( From Tom's Hardware US Joe Scotto is using a Raspberry Pi Pico to power h... [Raspberry Pi Powers Extremely Overclocked Amiga 1200 Accelerator]( From Tom's Hardware US In order to push his Amiga 1200 to the limits, Cla... [Prusa MK4 Alpha Firmware Adds Missing Features]( From Tom's Hardware US Prusa has unveiled a new alpha-stage firmware for ... Hardware Testing [Acer Testing Distinctive GeForce RTX 4090 With Integrated Liquid Cooler]( From Tom's Hardware US We don't know yet when or if these Predator brande... MDX/DAX [[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!?]( From Havens Consulting Video by: Reid HavensLearn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [A First Look at Microsoft Fabric: The Good, the Bad, and the Ugly]( From Prologika (Teo Lachev's Weblog) “May you live in interesting times” – Chines... [Getting Started with Dataflow in Microsoft Fabric Data Factory]( From RADACAD The Dataflow in Microsoft Fabric is an element for... [What is Data Factory in Microsoft Fabric]( From RADACAD Microsoft Fabric is an end-to-end data analytics s... [What is Microsoft Fabric (Public Preview)?]( From Guy in a Cube Maybe you've heard the announcement of Microsoft F... [What Is Microsoft Fabric? My Point of View]( From Paul Andrew Bringing the Data Platform Workspace and the Power Platform workspace Together Over the last 18 months or so I’ve been watching and supporting the development of Microsoft’s new Software... [Spreading your Power BI wings with Microsoft Fabric]( From Kevin Chant Reading Time: 7 minutes In this post I want to cover spreading your Power BI wings with Microsoft Fabric. Since I covered Microsoft Fabric from a SQL Server... [Why can’t I use Microsoft Fabric?]( From Guy in a Cube You've heard about all the great things with Microsoft Fabric, but you don't see it in the portal. You only see the Power BI items and no persona switcher.... [What is Microsoft Fabric Data Warehouse?]( From RADACAD Microsoft Fabric, an end-to-end Saas cloud-based analytics platform, has many workloads and objects. One of the Objects is called Data Warehouse, or in short, Warehouse. In this article, I’ll... Microsoft News [Public Preview: Azure Data Explorer bindings for Azure Functions]( From Azure Updates Azure Data Explorer Bindings for Azure Functions (Public Preview) [Generally available: Zone Redundant Storage for Azure Disks is now available in more regions.]( From Azure Updates Zone Redundant Storage (ZRS) for Azure Disks is now available on Azure Premium SSD and Standard SSD in Brazil South, UK South, East US, East US 2, and South-Central... [Generally available: Azure Files scalability improvement for Azure Virtual Desktop and other workloads that open root directory handles]( From Azure Updates Azure Files has increased the root directory handle limit per share from 2,000 to 10,000 for standard and premium file shares. [Microsoft Announcement: Microsoft Fabric]( From SQLServerCentral Blogs Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which is now available for public preview. Satya Nadella, the CEO of Microsoft, went as far... The... Oracle/PostgreSQL/MySQL/other RDBMS [PGSQL Phriday #009: On Rollback]( From Scary DBA (Grant Fritchey) The invitation this month for #PGSqlPhriday comes ... [10 Requirements for Managing Database Changes]( From Software and Booz The host for PGSQL Phriday #009 is Dian Fay, who h... [Uncovering the mysteries of PostgreSQL (auto) vacuum]( Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered memory parameters, and in this article. In this article will talk about PostgreSQL configuration parameters which manage the (auto)vacuum and (auto)analyze background processes. [Performance Tuning MySQL on a Budget: Techniques and Tools]( From Journey to SQL Authority with Pinal Dave I want to address a pressing question to many data... [PostgreSQL for the SQL Server DBA: Transaction Isolation and Table Bloat]( From Software and Booz This is part of a series I began in 2018, document... Performance Tuning SQL Server [A Little About Improving Modification Query Performance In SQL Server]( From Erik Darling Data A Little About Improving Modification Query Perfor... [A Little About How Overindexing Can Hurt SQL Server Performance]( From Erik Darling Data A Little About How Overindexing Can Hurt SQL Server Performance Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training.... [Introduction to SQL Server Query Store]( From SQLServerCentral Blogs Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and talked out new feature. In this post we'll just take a brief look at it,... The... [Parameter Sensitive Plan Optimization, Why?]( From MS SQL Server Blog One question that we hear quite often is why we chose to capitalize the first three letters when abbreviating this feature sometimes, and at other times, we chose not... [Balancing Performance, Security, and Scalability as a DBA]( From Journey to SQL Authority with Pinal Dave I had the opportunity to engage in a captivating discussion surrounding on database performance, security, and scalability as a DBA. First appeared on Balancing Performance, Security, and Scalability as a... PowerPivot/PowerQuery/PowerBI [Import vs DirectQuery in Power BI]( From Excelerator BI Over the last few months, I have received a number... [Contrasting Power BI Import and DirectQuery Modes]( From Curated SQL Jason Cockington digs into the two modes: Over the... [Compare previous date with sales – Unplugged #52]( From SQLBI Student questions: How to compute the sales amount... [Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security]( From MSSQL Tips In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security. Professional Development [The Importance of Tact]( From Simple Talk 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... [How To Learn Linux: A Comprehensive Guide for Beginners]( From IT Pro - Microsoft Windows Information, Solutions, Tools IT professionals can advance their careers by learning Linux, a widely used and versatile operating system. [Ways to Help Cybersecurity's Essential Workers Avoid Burnout]( From Dark Reading: Dark Reading News Analysis To support and retain the people who protect assets against bad actors, organizations should create a more defensible environment. R Language [INTENSION, EXTENSION AND R-TABLES (t&n)]( From Database Debunkings Note: "Then & Now" (t&n) is a new version ... Security News and Issues [Brute-Forcing a Fingerprint Reader]( From Schneier on Security It’s neither hard nor expensive: Unlike password... [421M Spyware Apps Downloaded Through Google Play]( From Dark Reading: Dark Reading News Analysis A Trojan SDK snuck past Google Play protections to... [Pentagon Leaks Emphasize the Need for a Trusted Workforce]( From Dark Reading: Dark Reading News Analysis Tightening access controls and security clearance ... [Suspected State-Backed Hackers Hit Series of New Targets]( From IT Pro - Microsoft Windows Information, Solutions, Tools A hacking group called Dark Pink targeted government agencies in countries including Indonesia and Thailand, using sophisticated malware and phishing emails. [How to Enable Azure AD Password Protection: A Step-by-Step Guide]( From Petri IT Knowledgebase As an IT admin, preventing your users from using s... T-SQL and Query Languages [T-SQL Gap-Filling Challenge]( From Simple Talk A student of mine sent me a T-SQL challenge involv... [Why Use QUOTENAME?]( From Callihan Data QUOTENAME can be used to make sure database objects are valid in your query. Most of the time, objects like table names only contain valid characters, so there’s nothing... [How to Insert Multiple Rows in SQL Server Like a Hero DBAÂ]( From SQL Server – {coding}Sight Hi there, newbie. Are you still using multiple INSERT statements to insert multiple rows in SQL Server? Let me tell you today that it’s a terrible idea. It gives... Tech News [Raspberry Pi Camera Takes Photos Using AI Instead of Lens]( From Tom's Hardware US Bjørn Karmann has created a Raspberry Pi camera t... [Migrating from EverNote to Joplin]( From SQLServerCentral Blogs Recently I got a message that my Evernote subscription was going up. It’s been a $3 a month service, but moving to $4 for me. From USD$35 to USD$50... The... [AI Leaders Warn of ‘Risk of Extinction’ From the Technology]( From IT Pro - Microsoft Windows Information, Solutions, Tools AI company CEOs and researchers issued another dire warning about the existential harms posed by the fast-developing technology. Critics, however, argue that focusing on hypothetical risks detracts from immediate... [Hands-On: Fractal's Tiny Terra PC Case Has Wood Accents, Adjustable Spine]( From Tom's Hardware US We spent some time building in Fractal Design's ne... [Building Better Insights: Enabling Real-World Data-Driven Drug Development]( From Dataversity By 2025, the drug discovery market is expected to reach $71 billion. While recent growth in the market was largely influenced by the COVID-19 pandemic and the need for vaccinations,... The Lighter Side [Longevity enthusiasts want to create their own independent state. They’re eyeing Rhode Island.]( From Technology Review Feed - Tech Review Top Stories It’s a Friday morning in early May, and I’ve woken up to the sound of waves crashing against the rocks in a small bay on the coast of the... Theory and Design [The Best Linux File Managers for Managing Your Files]( From IT Pro - Microsoft Windows Information, Solutions, Tools Learn about selecting file managers for Linux operating systems. Tools for Dev (SSMS, ADS, VS, etc.) [Important Feature Change in SQL Server Management Studio]( From DCAC When you download SQL Server Management Studio 19.... flyway [Searching Flyway Migration Files using Grep and Regex]( From Product learning – Redgate Software This article demonstrates a cross-RDBMS way of searching through a set of SQL migration files, in the right order, to get a narrative summary of what changes were made,... [Flyway with Multiple Folders]( From SQLServerCentral Blogs A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few... The... history [Xerox stars for accessibility]( I was working for Xerox when the Xerox Star, precursor to all the computer systems in use today, was introduced. Before then, computer users just had command-line or character-based GUIs. The Xerox Star workstations were displayed for the first time for us insiders in a special room, like a secular chapel, guarded over by the priesthood of developers. We were amazed.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -