Database Weekly for June 24, 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
 The Best Career Advice I don't know that I have the best advice, but [this month's T-SQL Tuesday]( is asking for people to share what they think is the best advice they've been given or have for you. I wrote [my own piece]( where I noted that learning to say "No" was one of the best things I've ever done. Not that I say no to everything, but I do default to no, especially when someone asks for me to tackle something new. Actually, it's slightly more nuanced than that. As I've gotten used to my workload, I will say yes to things, and certainly, I'm more likely to commit to one-off things. It's the longer-term, larger things that I don't want to agree to do unless I'm sure I can deliver. There are lots of other things people wrote. [Deb]( that you should trust your instincts and realize you can contribute, even if you're new. [Hugo]( notes the user is often right. [Mala]( is more cautious with work and practices discretion. [Rob]( the advice to take it slow, learn his job, and figure out what he likes and doesn't. There are lots of other advice, from [Pragati]( you to get a mentor to [Mikey]( saying you should find a job you love. If you check out the comments in the invitation above, you'll see plenty more responses, many with interesting back stories and more details. If you only read through one set of T-SQL Tuesday responses, this might be the one to pick. I'm a big fan of actively managing your career. Make the decisions that move in the direction that matters to you. As noted in a few posts, we spend a lot of our lives at work. At times more than we spend with family, so be sure you have a career you enjoy. This takes work, but it's an investment that can repay itself over many years. Both in financial rewards and less stress on a regular basis. Every job is a job some days, but when you enjoy your work, it doesn't feel like work. 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 [SQL Server 2022: Capture SQL Anti-Patterns]( One of the new Extended Event available in SQL Server 2022 is the query_antipattern. This extended event allows to identify anti-patterns on the SQL queries sent to the server. An anti-pattern in this case is some code that the SQL Server optimizer canât do a great job optimizing the code (but cannot correct the issue automatically). [T-SQL Gap-Filling Challenge]( A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I found the challenge interesting and common enough and figured that my readers would probably find it interesting to work on as well. Iâll present the challenge and three possible solutions, as well as the results of a performance test. AS always, I urge you to try and come up with your own solutions before looking at mine. [Storing Credentials Securely on a Windows-based Flyway Installation]( This article demonstrates how to use PowerShell to fetch your login credentials from Windows Credential Manager and pipe them securely to Flyway without ever saving them in any form, such as in a file or environment variable. AI/Machine Learning/Cognitive Services [When to Use AutoML vs. Manual ML: A Full Guide]( From Dataversity Automated machine learning (AutoML) is a set of to... [The Download: AI training AI, and the future of robotaxis]( From Technology Review Feed - Tech Review Top Stories This is todayâs edition of The Download, our w... [ChatGPT, Google Bard Generates Generic Windows 11, Windows 10 Pro Keys]( From Tom's Hardware US Sid, also known as @immasiddtweets on Twitter, use... Administration of SQL Server [Indexes and Statistics with Always Encrypted]( From SQLServerCentral Blogs In this short post we look at the ability to be ab... [What are Statistics in SQL Server?]( From SQLServerCentral Blogs Statistics are vitally important in allowing SQL S... [Lesson Learned #378: What does mean Pool Blocking Period?]( From Azure Database Support Blog Microsoft.Data.ProviderBase.DbConnectionPool.Check... [SQL Server Deadlocks â Interview Q and A]( From Journey to SQL Authority with Pinal Dave Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers First appeared... [sp_WhoIsActive: Advanced Logging To Tables²]( From Erik Darling Data sp_WhoIsActive: Advanced Logging To Tables Going F... [Lesson Learned #380:Unable to load adalsql.dll (Authentication=XYZ).Error code:0x2]( From Azure Database Support Blog Analyzing a support case that our customer got the following error faced: "Unable to load adalsql.dll (Authentication=ActiveDirectoryPassword). Error code: 0x2" using an older application to the Azure SQL database.... [Lesson Learned #374: Execution of class com.microsoft.aad.adal4j.AcquireTokenCallable failed.]( From Azure Database Support Blog Today, we encountered an interesting case while obtaining the Azure Active Directory token using ActiveDirectoryPassword authentication using the latest version of MSAL in Java. Finally, the issue was resolved...
Azure Databricks, Spark and Snowflake [Snowflake: A Cloud Warehouse Solution for Analytics]( From Simple Talk This article explains what Snowflake data warehous... Azure SQL [Calling a REST service from Azure SQL DB | Data Exposed]( From Azure SQL With the new system stored procedure sp_invoke_ext... Azure SQL Managed Instance [Tools for Optimizing Azure SQL MI Performance]( From Curated SQL Rie Merritt breaks out the toolbox: Azure SQL Mana... [Securing your data ecosystem in Azure SQL Managed Instance]( From Azure SQL When you run SQL Servers on-premises, you own the ... Career, Employment, and Certifications [T-SQL Tuesday 163: Best piece of career advice]( From Curious..about data This monthâs T-SQL Tuesday is hosted by Gethyn E... [The Best Career Advice I Ever Got (#TSQL2sday)]( From Brent Ozar Unlimited I have been absurdly lucky to be around so many am... [T-SQL Tuesday 163 â Career advice]( From SQL Server Fast Itâs that time of month again! Or rather, itâs... [T-SQL Tuesday #163 â Career Advice I received]( From SQLServerCentral Blogs Itâs time for our monthly blog party and thanks ... [Being a parent at Redgate]( From Blog â Redgate Software As a Talent Acquisition Coordinator at Redgate, I ... [T-SQL Tuesday #163 Invitation â Career Advice]( From Callihan Data  [T-SQL Tuesday #163]( From Deb the DBA Happy T-SQL Tuesday! I feel bad that Iâve missed that last several but Iâm glad Iâm able to jump back in. Thanks to Gethyn Ellis ( t | b... Cloud - AWS [New â Amazon EC2 Hpc7g Instances Powered by AWS Graviton3E Processors Optimized for High Performance Computing Workloads]( From AWS News Blog At AWS re:Invent 2022, Adam Selipsky, CEO of AWS, explained high performance computing (HPC) workloads typically can either be compute-intensive, compute- and networking-intensive, or data- and memory-intensive in his... [How to recursively delete files, folders or bucket from S3?]( From Hadoop in the Real World In this post we will see how to recursively delete files/objects, folders and bucket from S3. Recursively deleting a folder in S3 rm ârecursive followed by [â¦] The post How... Cloud - Azure [Choosing a Load Balancing Option in Azure]( From Curated SQL Santosh Hari looks at the options: Azure docs have... Conferences, Classes, Events, and Webinars [Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders]( Is your team looking to modernize and migrate your data but have questions about the complex organizational challenges? This webinar panel on June 29th covers all aspects of data modernization and migration that senior IT leaders should be aware of, including organization culture, communication, and politics. Why not send it to your boss? [First speakers announced for Summit 2023]( Your first speakers in the line up 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. DMO/SMO/Powershell [How To Use PowerShell to Track Group Policy Drift]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell can be used to detect changes in group ... [Downloading Files with PowerShell: A Video Tutorial]( From IT Pro - Microsoft Windows Information, Solutions, Tools Brien Posey provides a tutorial for downloading fi... Data Visualisation [A Picture Is Worth 1,000 Words: The Importance of Data Visualization]( From Dataversity Have you ever heard the saying, âA picture is wo... [Storytelling for DBAs and Other Technical Folk po]( From SQLServerCentral Blogs (for your reading pleasure, written by Jules. âe... [Data Visualization Technology Landscape]( From Curated SQL Andy Kirk has a catalog: My long-running catalogue... DevOps and Continuous Delivery (CI/CD) [Automating a shift-left CI/CD security workflow to track, report, and analyze software security vulnerabilities]( From AllAnalytics SAS' Phuong Ngo demonstrates an automated shift-le... [Agile WestâHow Do I Get Started with Database DevOps]( From SQLServerCentral Blogs This week I had the chance to deliver a talk at Ag... DocumentDB/Key-Value/Graph/other NoSQL Databases [When NOT to choose SQL Server to store your data]( From Kendra Little's Blog I recently posted on LinkedIn that I was interview... ETL/SSIS/Azure Data Factory/Biml [One Simple Example of ADF Pipeline Return Value]( From AndyLeonard.blog() This post is part of a short series on Azure Data Factory pipeline return value functionality, which is in preview at the time of this writing. The Problem I... [Lesson Learned #377:Running Multiple Instances of SqlBulkCopy in Parallel from PowerShell]( From Azure Database Support Blog Today, we encountered an interesting service reque... [Exporting to a CSV file from SSMS â Simple BCP Method]( From Purple Frog Systems Export table contents to a CSV file from SQL Server It may be useful to export a tables contents to a CSV file for some exploratory analysis, to feed... Hardware [The Aurora Supercomputer Is Installed: 2 ExaFLOPS, Tens of Thousands of CPUs and GPUs]( From AnAndTech Argonne National Laboratory and Intel said on Thur... [Seagate's FireCuda 540 PCIe Gen5 SSD Listed: 1.5M IOPS]( From Tom's Hardware US Seagate's FireCuda 540 set to hit 10 GB/s, accordi... [Why Building Your Own PC Is Still a Smart Move in 2023]( From Tom's Hardware US Putting together your own desktop should save you money and help you take control of your tech life. [Raptor Lake Refresh CPUs Reportedly Launch In October]( From Tom's Hardware US Hardware leaker shares the alleged launch dates fo... [Manufacturers Roll Out New Firmware For Next-Gen Intel CPUs]( From Tom's Hardware US Motherboard vendors are readying their 700-series ... MDX/DAX [Introducing RANK window function in DAX]( From Sqlbi RANK is a new DAX function to rank items based on ... [Ranking with DAX]( From Curated SQL  Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)]( From Guy in a Cube You've got your data into OneLake and a Lakehouse,... [Automating pause of Synapse dedicated pool â Part I]( From Ten Bulls Synapse Analytics is an enterprise analytics engine that offers multiple (compute) Pool types that you can use for varying data processing and analytics requirements. Each Pool type has a... [Microsoft Fabric Notebook: What and Why?]( From RADACAD One of the objects in the Microsoft Fabric is the Notebook. If you havenât worked with Azure Notebooks before, you might ask yourself; what is Notebook? Why should I... [Microsoft Fabric introduction video]( From SQLServerCentral Blogs I blogged about Microsoft Fabric a few weeks ago, and wanted to follow up with an introduction video that covers the basics so hopefully you will understand the major... The... Microsoft News [Microsoft Acknowledges High CPU Utilization Bug in Windows 11 File Explorer]( From Tom's Hardware US Microsoft says that the File Explorer bug can caus... [Microsoft Says It Will Build a Quantum Supercomputer Within Ten Years]( From Tom's Hardware US Microsoft announced its very own roadmap towards b... Performance Tuning SQL Server [SQL Server Wait Type: PREEMPTIVE_OS_ENCRYPTMESSAGE]( From Steve Stedman Wait statistics, in the context of SQL Server, ref... [Execution Plans of Graph Tables in SQL Server]( From Curated SQL Hugo Kornelis looks at the execution plan: Welcome... [SQL Server slow performance troubleshooting documentation expanded]( In the past 1.5 years we in the SQL Server CSS and content teams have been working on creating new documentation to assist with troubleshooting SQL Server slow performance issues. Here is a list of articles that were produced over this period. Hope you find these useful. Please share with others and donât hesitate to provide feedback at the bottom of each article page by clicking on âWas this page helpful?â. [Understanding SQL Server Deadlocks: A Beginnerâs Guide]( From Journey to SQL Authority with Pinal Dave Welcome to this introductory blog post on SQL Server Deadlocks. In this post, we'll help you understand what deadlocks are, and how they occur. First appeared on Understanding SQL Server... [sp_WhoIsActive: Getting Memory Grant Details]( From Erik Darling Data sp_WhoIsActive: Getting Memory Grant Details Going Further If this is the kind of SQL Server stuff you love learning about, youâll love my training. Iâm offering a 75% discount... PowerPivot/PowerQuery/PowerBI [(Livestream Replay) The Data Dojo: A Power BI Community of Practice - with James Bartlett]( From Havens Consulting DESCRIPTION In recent years, data-driven decis... [Digging into DYNAMIC format strings for DAX Measures in Power BI]( From Guy in a Cube DYNAMIC format strings recently were made availabl... [Adding Images to the New Power BI Card Visual]( From Curated SQL Leila Etaati shows off some new functionality: One... [Power Bi â Recalculate / Refresh a Calculation Group]( From Purple Frog Systems  [The âVisual Has Exceeded The Available Resourcesâ Error In Power BI Desktop]( From Chris Webb's BI Blog Why the "visual has exceeded available resources" error occurs in Power BI Desktop and what you can do about it The post The âVisual Has Exceeded The Available Resourcesâ Error... [Introducing the New Power BI Project, and why it is important]( From Paul Turley's SQL Server BI Blog The enterprise Business Intelligence and IT community have been anxiously awaiting this capability for many years and it has finally arrived - at least in Preview form for testing... [Convert Matrix data in Excel to Tabular Data in Power BI.]( From RADACAD There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data.... Product Reviews and Articles [Running Flyway Pre-Migration Checks on the Database]( From Product learning â Redgate Software This article demonstrates how to run a preliminary check that issues a warning, or throws an error, if the conditions aren't met for a Flyway migration to succeed. It... Product Upgrades and Releases [Updated First Responder Kit and Consultant Toolkit for June 2023]( From Brent Ozar Unlimited This oneâs a pretty quiet release: just bug fixe... [Generally Available: Azure Cosmos DB to Azure Data Explorer Synapse Link]( From Azure Updates Now generally available: managed ingestion from Azure Cosmos DB to Azure Data Explorer in near real time. [Database Health Monitor â June 2023 update]( From Steve Stedman Today I have release the June 2023 update of Database Health Monitor version 1018. The big focus on this update was the wait time involved in reconnecting to SQL... Python [Python idioms for reading/writing from files/pickles]( From Statistical Odds & Ends Writing to and reading from text files and pickle ... R Language [Trying the sample() Function in R]( From Curated SQL Steven Sanderson gathers a sample: Sampling is a f... [Mastering the Power of Râs diff() Function: A Programmerâs Guide]( As a programmer, itâs crucial to have a deep understanding of the tools at your disposal. In the realm of data analysis and manipulation, R stands as a powerhouse. One function that proves to be invaluable in many scenarios is diff(). In this blog post, we will explore the ins and outs of the diff() function, showcasing its functionality and providing you with practical examples to enhance your programming skills. SQL Server Security and Auditing [Lesson Learned #376: Resolving 'Msg 15151' error when modifying SQL Login in Azure Active Directory]( From Azure Database Support Blog Changing the password of SQL Logins in Azure SQL D... [Lesson Learned #379: ADALNativeWrapper.ADALGetAccessToken error using AAD - Password Authentication]( From Azure Database Support Blog Issue  Analyzing one of the cases in which we encountered an error using Azure Active Directory with Password Authentication, I would like to share the lessons learned during this process,... Security News and Issues [Schneider Power Meter Vulnerability Opens Door to Power Outages]( From Dark Reading: Dark Reading News Analysis A severe security vulnerability allows credentials... [Azure AD 'Log in With Microsoft' Authentication Bypass Affects Thousands]( From Dark Reading: Dark Reading News Analysis The "nOAuth" attack allows cross-platform spoofing... [Lessons From a Pen Tester: 3 Steps to Stay Safer]( From Dark Reading: Dark Reading News Analysis From hardening Windows systems to adding access co... [Power LED Side-Channel Attack]( From Schneier on Security This is a clever new side-channel attack: The first attack uses an Internet-connected surveillance camera to take a high-speed video of the power LED on a smart card readerÂâor of... T-SQL and Query Languages [List Top Tables in SQL Server Database by Size]( From SQLServerCentral Blogs There are countless queries you can find on intern... [Union in KQL]( From Curated SQL Robert Cain combines some tables: In todayâs pos... [Video: Common Table Expressions and Subqueries]( From 36 Chambers â The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we will look... [Finding the Actual Error Line in sp_executesql]( From Curated SQL Thom Andrews solves a problem: Notice that the err... [Fun With KQL â Union]( From Arcane Code Fun With KQL - Union Tools for Dev (SSMS, ADS, VS, etc.) [[Video] Office Hours: Github Copilot in Azure Data Studio]( From Brent Ozar Unlimited I start todayâs Office Hours by playing with the... [SQL Server Management Studio (SSMS) 19.1 and Recent Changes, Part 3]( From MS SQL Server Blog This is the final post in a series covering changes in SSMS 19. Please review Part 1 and Part 2 for details about Microsoft.Data.Sqlclient, MSAL, removal of the SQL...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -