New SQL Server Management Studio Released, Security Challenges, Fear, and much more (2023-01-28 DBW)

Database Weekly for January 28, 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  Fear of "What If" Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly aware of being afraid of. - I have a car in the shop for routine service - It is my first time compiling the [Database Weekly newsletter](. I will skip over the first one, if you own a car, you understand that fear all too well. The second one is not a worry of the unknown. I have very well recorded set of instructions on what the task is, what settings to set, and what buttons to push. The fact that you are reading this right now is, in fact, evidence that it all worked one way or another. Of course, back here in the pre-newsletter published timeline, my fear is that I might do something wrong. As I am preparing the newsletter, I am thinking of all the ways I have messed up in the past sending emails and documents. - What if I don’t follow the instructions right? - What if I make a critical mistake? - What if I made a spelllong error like misspelling spelling? - What if this editorial isn’t awesome, or even worse, inadvertently, yet deeply, offends someone. For me, fear rests in a lot of questions prefixed with “What if?” And right now, while I am working through the process, the fear is palpable. No matter how much I think I understand the process, no matter how careful I am, I might make a mistake. At this point I may sound as if I am actively having a panic attack sitting under my desk contemplating a career change. It couldn’t be farther from the truth. I mentioned age earlier. There is a saying, “With age comes wisdom.” What this really means is, “The longer you live, the more mistakes you have made and not only learned from them, you have survived them. Remember what you did that worked before.” As a longtime DBA before becoming an editor, with access to personal data and mission critical database servers that I could have easily destroyed (easily!) I have honed these rational fears of making a mistake into a type of efficiency. Checking over and over to satiate the fears makes me as sure as possible I haven’t done anything stupid, without becoming paralyzed by that same fear and then missing deadlines. Fear keeps us from doing dumb things, the trick is to not let it keep you from doing anything. The better question is "What if I don't do anything of value" and that is scarier than anything. As scared as I am to press the "Newsletter is ready to publish button." that is my next task. Also, just got the call, $700 in normal, routine, (and reasonable) maintenance and repairs. Part of me want to say "no", but the fear of what happens if I don't take care of my vehicle is a fear that I have all too many lessons stored up about. 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 [Getting Started with Flyway Migrations on Oracle]( A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial version of the database then filling it with development data. [A Simple Example of Flyway Development using GitHub Branching]( This article demonstrates one way to do branch-based database development with Flyway, using GitHub to manage the branches and Flyway configuration files to allow Flyway to switch smoothly between databases, when we move between branches in GitHub. [PostgreSQL Basics: Roles and Privileges]( Information security, whether in databases, applications, or larger IT systems, is based on the principles of Authentication and Authorization, often referred to as AuthN and AuthZ respectively. Likewise, PostgreSQL security involves creating roles that allow access to server resources (AuthN) and then granting privileges to database objects appropriately (AuthZ). Understanding how each of these components work together is essential to effectively manage security in a PostgreSQL cluster. [Using SQL Data Compare from the Command Line with a Project]( From SQLServerCentral Blogs SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I... The... AI/Machine Learning/Cognitive Services [Use ChatGPT to see multiple perspectives. An example: ORMs and database code]( From Kendra Little's Blog There’s a lot of hype, concern, and fear regarding generative AI lately. Tools like ChatGPT are so good at generating groups of words that it feels like magic– however,... [Testing for AI Bias: What Enterprises Need to Know]( From IT Pro - Microsoft Windows Information, Solutions, Tools The meteoric growth of artificial intelligence is increasing concerns about ethics, leading to tools and procedures to ensure responsible development. [Microsoft Announces New Multibillion-Dollar Investment in OpenAI]( From Petri IT Knowledgebase Microsoft has announced a new multibillion-dollar partnership with OpenAI. The... Administration of SQL Server [Things to look out for while TDE is encrypting existing data]( From SQLServerCentral Blogs Monitoring for Problems The encryption of your existing data occurs as a background process referred to as the encryption scan, but it will consume resources while it runs, so... The... [Recovering data with crash consistent snapshots]( From SQLServerCentral Blogs When we talk about snapshots of SQL Server there are two types, application consistent snapshots and crash consistent snapshots. Application consistent snapshots require freezing IO on a database allowing... The... Big Data [Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory]( From MSSQL Tips Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article. Conferences, Classes, Events, and Webinars [Join us in our castle at SQL Bits, March 15-18]( SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book. [The Database DevOps Transformation]( Digital transformation is a buzzword that is often thrown about. But what isn’t discussed in depth, is how DevOps fits into the initiative and what the pitfalls are. This on-demand session answers these questions and provides actionable takeaways from real-life database deployment automation projects. You’ll also hear how the key trends in Database DevOps have influenced Flyway product development. Data Warehousing [How Reverse ETL Powers Modern Customer Marketing: Concrete Examples]( From Dataversity How often do you take the time to fill out feedback forms or surveys about the products and services you use? If you’re part of a customer marketing team,... Hardware [Intel Core i9-13900KS Review: The World's First 6 GHz 320W CPU]( From Tom's Hardware US We put Intel's Core i9-13900KS, the first 6 GHz CP... Performance Tuning SQL Server [Evaluating SQL Server Filtered Indexes in a Multi Table SQL Join]( From MSSQL Tips In this tip, we look at filtered indexes and how to create them in SQL Server as well as how to get a filtered index to work when pulling... [Understanding SQL Server Hardware: How Unused Indexes Hurt The Buffer Pool]( From Erik Darling Data +OK PowerPivot/PowerQuery/PowerBI [Why You Should Avoid Calculated Columns in Power BI]( From eHansalytics First off I want to make sure it is clear that I am not saying “never use calculated columns.” I am not. What I am saying is they should... [Unpivot a matrix with multiple fields on columns in Power Query]( From SQLServerCentral Blogs I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power BI model, but the only source of the data is a matrix that is output from another system. And that matrix has multiple fields populating the columns. An example of this is below. The matrix has fiscal year and product category on columns, vertical on rows, and the profit metric populating the values [Understanding The “A cyclic reference was encountered during evaluation” Error In Power Query In Power BI Or Excel]( From Chris Webb's BI Blog Why the "cyclic reference" error in Power Query in Excel or Power BI occurs Security News and Issues [Federal Agencies Infested by Cyberattackers via Legit Remote Management Systems]( From Dark Reading: Dark Reading News Analysis Hackers don't need a key to get past your defenses... [The Evolution of Account Takeover Attacks: Initial Access Brokers for IoT]( From Dark Reading: Dark Reading News Analysis Head off account takeover attacks by being proactive about IoT security. Start with designing and building better security protocols into IoT devices, always change weak default configurations, and regularly apply patches to ensure that IoT devices are secure. [Microsoft to Block Excel Add-ins to Stop Office Exploits]( From Dark Reading: Dark Reading News Analysis The company will block the configuration files, which interact with Web applications — since threat actors increasingly use the capability to install malicious code. [No-Fly List Exposed]( From Schneier on Security I can’t remember the last time I thought about the US no-fly list: the list of people so dangerous they should never be allowed to fly on an airplane,... [Fun With KQL – Top-Nested]( From Arcane Code Fun With KQL - Top-Nested T-SQL and Query Languages [Using Synonyms on SQL Server]( From Steve Stedman Synonyms in SQL Server are a useful feature that a... Testing Software [Testing before coding: shifting farther left]( A term I have only recently learned is "shift left testing." You can read more about this on Wikipedia here. The term was coined in 2001 and generally means testing earlier in the development lifecycle. Hence, shifting your testing left in the timeline. Just how left should you shift your testing, though? In my mind, so early, the rooster hasn't entirely fallen asleep yet. The Lighter Side [How a Viking Princess defeated ChatGPT]( From Blog – Redgate Software In the first of a series of articles about how ChatGPT and other AI tools like DALL-E will change the way we work with words, code and images, we... Tools for Dev (SSMS, ADS, VS, etc.) [SQL Server Management Studio (SSMS) 19.0 Released!]( From MS SQL Server Blog The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here!    This is the recommended release for SQL Server 2022, and it includes support for combability level...  [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -