TempDB, PowerShell, and more in Database Weekly (2022-01-01)

Database Weekly for January 1, 2022 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  Education to solve the tech skills shortage I’ve been teaching T-SQL to groups of students since 2014 at the non-profit [LaunchCode]( in St. Louis. LaunchCode provides free tech training, paid apprenticeships, and career support to hundreds of people who have the ability and interest but not always the opportunity to land tech careers. For example, not having a college degree can eliminate an otherwise qualified applicant and keep them from ever getting an interview. Even with a degree, applicants can be ruled out due to a lack of experience. The LaunchCode organization was founded in 2013 by tech entrepreneur Jim McKelvey. McKelvey and his friend Jack Dorsey (yes, that Jack Dorsey) started the financial company [Square]( in St. Louis. Still, they could not find enough developers and had to move the company to San Fransico. Because of this, McKelvey decided to find a way to solve the tech gap in St. Louis, believing that the talent was there but just not discovered. This led him to start LaunchCode in St. Louis to provide training and opportunities especially to underserved populations. It’s now available in Kansas City, Northwestern Arkansas, and Philadelphia as well. Students completing the training and apprenticeships are typically hired at double their previous income. LaunchCode is working on two problems at once: filling the technology pipeline and lifting people out of poverty. Teaching at LaunchCode is by far the most important thing I’ve ever done. I’ve written books, presented at dozens of conferences, and coached new speakers, but these activities will never make the same impact in the world. I’ve seen my students go on to become developers, database administrators, and scrum masters or gain skills to get promotions in their current careers such as insurance or human resources. Some of my former students now teach at LaunchCode, which makes me so proud! Many of the students at LaunchCode are single parents who work multiple jobs. It’s not easy to find time to study and complete assignments. It takes a ton of dedication, but moving into high-paying careers with great futures is worth it. I’m thrilled that I am making a difference in the lives of so many others.    Kathi Kellenberger [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. AI/Machine Learning/Cognitive Services [An Overview of Azure Cognitive Search Service]( From MSSQL Tips In this article we take a look at the Azure Cognitive Search Service to allow you to build full text search capabilities for your data. Administration of SQL Server [Monitoring SQL Server TempDB with Dynamic Management Views]( From SQLShack In this article, we will learn how we can detect w... [Queries that Fail and How to find Them]( From SQLServerCentral Blogs Queries will fail. That is as inevitable as death ... [Purging a SQL Server Express Database]( From DallasDBAs.com This is not another IRL post, but rather is more o... [Software Vendor Mistakes With SQL Server: Overly Complicated Triggers]( From Erik Darling Data Necessary Evils Triggers can be quite useful to p... Azure SQL Database [Create Index for Full Text Search using Azure Cognitive Service and Azure SQL Database]( From MSSQL Tips In this article we look at how to build a new inde... Azure Synapse (SQL Data Warehouse and Data Lake) [Azure Synapse Analytics with Managed VNet + DEP]( From 36 Chambers – The Legendary Journeys The Azure Synapse Analytics Managed Virtual Networ... [Key Vault and Azure Synapse Analytics TokenLibrary]( From 36 Chambers – The Legendary Journeys I ran into a really frustrating error around using... DMO/SMO/Powershell [PowerShell Plans for 2022]( From The lonely Administrator I’m not much for writing year in review pieces. Nor, to be honest, do I often write New Year’s resolutions. But I’ve been thinking about the work I’ve done... ETL/SSIS/Azure Data Factory/Biml [Install and Configure SSIS Catalog Archive]( From AndyLeonard.blog() Yesterday (27 Dec 2021), I streamed Introducing SSIS Catalog Archive. Since then, I’ve finished the first draft of documentation. Today (28 Dec 2021) I streamed about configuring SSIS Catalog... MDX/DAX [ABS, SIGN – DAX Guide]( From Sqlbi ABS: Returns the absolute value of a number. https... [What happened in the DAX world in 2021]( From SQLBI The second year of the pandemic is coming to a clo... PowerPivot/PowerQuery/PowerBI [Removing Leading or Trailing Zeroes with Power Query]( From Curated SQL Nicky van Vroenhoven wants to clean up some text: ... [Another Power BI optimization tool – Report Analyzer]( From Guy in a Cube Already optimized your data model and still having... [Hybrid Tables, Incremental Refresh and Table Partitioning in Power BI]( From Paul Turley's SQL Server BI Blog The December 2021 Power BI Desktop update introduced a long-awaited upgrade to the partitioning and Incremental Refresh feature set. The update introduces Hybrid Tables, a new Premium feature... [Power BI Zoom and Focus]( From MSSQL Tips In this article we look at how to add the zoom fea... [Power BI New Navigation Features]( From MSSQL Tips Learn about the new navigation features in Power BI to make for better interactive Power BI reports for the end users. Professional Development [Stability and Reporting – Love at First Sight]( From SQLServerCentral Blogs Stability and reporting go hand in hand. You canno... Python [Functional Programming in Python]( From Curated SQL Mehreen Saeed tries to tempt me into liking Python... R Language [Little useless-useful R functions – Creating tiny Fireworks with R]( From TomazTsql New Year’s eve is almost here and what best way ... Security News and Issues [As a DBA are you ready if you get hit with ransomware?]( From Steve Stedman On the day after Christmas this 2021, also know as... T-SQL [SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL]( From MSSQL Tips Learn about identity column sequence gaps and chan... [Tower of Hanoi game with T-SQL]( From TomazTsql T-SQL Code for the popular game of “Tower of Hanoi”, that can be played in Microsoft SQL Server, Azure Data Studio or any other T-SQL editor with support of... [Local Temp Tables and Global Temp Tables]( From Callihan Data Have you ever noticed a temp table with not one bu... Virtualization and Containers/Kubernetes [Installing and Configuring containerd as a Kubernetes Container Runtime]( From SQLServerCentral Blogs In this post, I’m going to show you how to insta... [What is a Virtual Server?]( From Petri IT Knowledgebase Using virtual machines (VM) and virtual servers is no new task. We have been working with the concept of providing time-sharing solutions since the late 1960s and early 1970s....  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -