Finding New Employment (2022-05-07 DBW)

Database Weekly for May 7, 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  Finding New Employment I have been working for Redgate Software for 15 years (14 as an FTE). I think this is the best job I've ever had, and I hope this is the last FTE job that I ever have (fingers crossed).  Plenty of people have found new jobs during the pandemic, which surprised me. I thought many people would be careful and cautious, but the pandemic opened up remote work, new possibilities, and opportunities that didn't exist in the past. Both employers and organizations took advantage of the changes to better their situations. I know quite a few friends who found new positions, with better compensation, during the last two years.  I think that trend continues as technology is an area that is adapts well to remote, hybrid, or in-person work. If you're looking for a job, or you need to hire some candidates, [Brent Ozar put out a post]( that lets either side post a comment and let people know there are jobs and talented people available. I posted a note about Redgate in there, as we are looking for software developers in the UK.  There are plenty of other positions. In Denver, I had lunch with a friend working at a new company, [Sierra Space](. They are growing and hiring quite a few people and they use SQL Server. My son works at ULA, and he said [they need people]( as well. While some businesses struggled the last two years, it seems that many technology companies thrived and there are lots of opportunities out there.  I am a big proponent of actively managing your career. I give talks on professional development and building your brand. My view is that you should work to improve your skills, showcase them, build a network of colleagues, and then find the dream job that fits you. That's different for all of us, but a little work and effort can help you find something you love.  I'm approaching retirement in my 50s, and I love my job. Many of you are much younger and still building careers, learning what you like and don't like (which is more important). You're deciding what type of job you want and what interests you. Study, learn, come to [SQL Saturdays]( (or ask your local group to run one), and pick the opportunity that works for you.  Drive your career forward and I know you'll be as happy to go to work each day as I am. 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 [[Re-post] Tackling the Challenges of Hybrid Estates]( It's an oldie but a goodie: Redgate Advocate Grant Fritchey takes us through how best to manage hybrid estates. Read on to find his expert recommendations. AI/Machine Learning/Cognitive Services [ML for the Lazy: Can AutoML Beat My Model?]( n this fourth (and hopefully final) entry in my “Icing the Kicker” series of posts, I’m going to jump back to the first post where I used tidymodels to predict whether or not a kick attempt would be iced. However, this time I see if using the h2o AutoML feature and the SuperLearner package can improve the predictive performance of my initial model. [Artificial Intelligence Enables Next-Gen Data Loss Prevention]( From Past News - RSS Feeds Data management and security practices are changing rapidly as data becomes fully distributed and fully situated in the cloud today. Every organization is using hundreds of software-as-a-service (SaaS) apps—many... [Who is responsible when AI is irresponsible?]( From AllAnalytics We hear a lot about responsible AI or AI ethics in the marketplace today. At SAS, we believe there should be a larger conversation about responsible innovation. In reality,... Administration of SQL Server [Azure SQL Database backup history]( There is a new DMV currently in preview which returns information about backups of Azure SQL databases except for the Hyperscale tier. Microsoft official documentation is here. [SQL SERVER – Find Owner of Database – Change Owner of Database]( From Journey to SQL Authority with Pinal Dave As there was no owner, it was not possible to open... [Resource Hog! What’s my busiest database?]( From SQLServerCentral Blogs Imagine that we’re seeing very heavy load on our... [A simple guide to Transparent Data Encryption in AWS RDS SQL Server]( From SQLServer-DBA.Com SQL Server TDE on AWS RDS is similar to SQL Server... Azure Databricks, Spark and Snowflake [Databricks Vs Synapse Spark Pools – What, When and Where?]( Databricks or Synapse seems to be the question on everyone’s lips, whether its people asking why you are using Databricks instead of Synapse Spark Pools or people asking what I should use and when, it’s definitely a hot topic right now. Given Microsoft are developing, investing, and recommending Synapse it is a reasonable question for everyone to be asking. [Databricks Vs Synapse Spark Pools – What, When and Where?]( From Adatis Databricks or Synapse seems to be the question on ... Azure DevOps [One YAML pipeline for many Azure Synapse environments in Azure DevOps]( From Kevin Chant Reading Time: 5 minutes In this post I want to ra... Azure SQL [Azure SQL News Update: May 2022]( From Azure SQL Today Data Exposed goes live at 12PM PT on LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming... Azure SQL Managed Instance [Maximize performance and scale with new SQL Managed Instance capabilities - Part 3]( From Azure SQL This is the third blog of a series focused on SQL ... [High Availability in Azure SQL MI: General Purpose service tier]( The purpose of this series of articles is to describe some of the details of how High Availability works and how it is implemented in Azure SQL Managed Instance in both Service Tiers - General Purpose and Business Critical. Career, Employment, and Certifications [Fintech, Cloud, and Finding Ways to Bridge the Skills Gap]( From IT Pro - Microsoft Windows Information, Solutions, Tools Can reskilling employees and financial planning so... [Who’s Hiring in the Database Community? May 2022 Edition]( From Brent Ozar Unlimited Is your company hiring for a database position as ... [TSQL Tuesday #150 Invite – Your first technical job]( From SQLServerCentral Blogs This month for TSQL Tuesday I’d like to hear abo... [What’s remote onboarding like for new people at Redgate?]( From Blog – Redgate Software Like lots of companies, Redgate has moved to a hybrid working model with some people working mainly from home and others now returning to the office a few days... Computing in the Cloud (Azure, Google, AWS) [Azure SQL Database Deployment Fails with ARM template setting AAD admin]( ARM templates are widely used when we need to repeatedly deploy solutions/infrastructures in the cloud. Leveraging the concept of infrastructure as code ARM templates are a powerful resource to ease our daily job, however we might face some challenges when using them. [Azure Redis Cache and Geo-replication]( From SQLServerCentral Blogs The concept of a geo-replicated partnership betwee... [Keeping an Eye on Your Azure Costs in Under 2 Minutes]( Using cloud services provides various conveniences. One of which is the transparent auto-scaling of the infrastructure. Especially with the event-driven architecture approaches, we enjoy deeper sleep during the night while our app and the underlying platform flex their muscles to serve our customers. I bet you are implementing all the security measures that come to the top of your backlog [Extended Events in AWS RDS]( From SQLServerCentral Blogs For the longest time, we didn’t have one of the ... [Design an Azure Data Platform that InfoSec will love – Azure Storage]( From Craig Porteous Reading Time: 5 minutes Building upon Azure Datab... [Building a Data Mesh Architecture in Azure – Part 8 – What is a Data Product?]( From Paul Andrew Defining a Data Product Use the tag Data Mesh vs Azure to follow this blog series. I was recently asked by Data Mesh Radio host Scott Hirleman and several... Conferences, Classes, Events, and Webinars [Group By is Back, May 24 and 25]( Just because conferences and training events are cancelled this year doesn’t mean technology in the data platform will stand still. Connect with your peers and keep the #SQLFamily strong with a free two-day virtual conference, plus access to all previous sessions. [Global Azure 2022 - How to get the most from Azure SQL Database (Session Delivered)]( From Azure Database Support Blog This last 5th of May, my colleague Sabrin Alsahsah... [DataWeekender CU5 schedule is now live]( From Kevin Chant Reading Time: 4 minutes In this post I want to an... [SQL Saturday Jacksonville 2022 In-Person on May 14]( Jacksonville's 14th Annual SQL Saturday event includes two paid pre-con tracks and one FREE day of training sessions for Microsoft Data Platform professionals and those wanting to grow their skill set in Business Intelligence, Analytics, and SQL Server. [Come to VS Live Austin in June]( From SQLServerCentral Blogs I’ll be at VS Live this June to speak on a coupl... [Webinar – Data Warehouse Modernization]( From SQLServerCentral Blogs I’m delighted to announce I’m participating in a panel discussion about data warehouse modernization. The full title is “Data Warehouse Modernization – Crafting a Successful Migration Strategy ​​​​​​​Post Pande​​​​​​​mic​​”.... The... [Webinar: Introducing Database DevOps]( Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover what we mean by Database DevOps, why you need to include the database in your DevOps initiative and the benefits its offer you, your teams, and your organization. [Summit Learning Pathways Announced]( Whatever your learning objectives or career goals are, Summit has the guided learning pathways you need to achieve them. Summit attendees can choose from 9 learning pathways, featuring over 40 industry-leading speakers, which have been designed to walk you through a specific set of learning outcomes to ensure that you leave Summit with the skills you need to make an immediate impact in your organization. Presenters include Ginger Grant, John Morehouse, Erin Stellato, Dustin Vannoy, and many more! DMO/SMO/Powershell [Visual Studio Code Powershell Debugging]( Microsoft has a created a great Powershell extension for VS Code that makes it easy to work with Powershell files. Once the plugin is installed you get intellisense, syntax highlighting, and even visual debugging for files that have a Powershell extension. This debugger can be easily started by pressing F5 when you’re in a Powershell script. Stopping execution on a particular line is as easy as setting a breakpoint by clicking next to a line number. [An Iron Scripter Warm-Up Solution]( From The lonely Administrator We just wrapped up the 2022 edition of the PowerSh... [PowerShell for the DBA - Basic Functions]( From MSSQL Tips In this article we look at how to get started writing functions in PowerShell along with several basic examples to get you started. [How To Use a For Each Loop in PowerShell]( From IT Pro - Microsoft Windows Information, Solutions, Tools For Each loops let you perform an action against multiple items in PowerShell. Read these step-by-step instructions to learn how to use a For Each loop. Data Science [What is principal stratification in causal inference?]( From Statistical Odds & Ends Principal stratification was proposed in Frangakis... [Combinations, permutations, and derangements]( From Simple Talk Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.… The post Combinations, permutations, and derangements appeared first on Simple Talk. Data Visualisation [what your audience really wants]( From Storytelling with Data A few seats remain for our inaugural Craft the Narrative public workshop on May 11-12! If you want to break out of the “death by PowerPoint” spiral and... ETL/SSIS/Azure Data Factory/Biml [CSV or alternatives? Exporting data from SQL Server data to ORC, AVRO, Parquet, Feather files and store them into Azure data lake]( From TomazTsql CSV data format is an old format and very common f... [Overview of ETL Tools in the Microsoft Data Platform ? Part 1]( From MSSQL Tips In this article we look at various ETL tools to he... Hardware [Best Ultrabooks and Premium Laptops 2022]( From Tom's Hardware US Our picks for the best ultrabooks (super thin and ... [Mushkin Delta 1TB SSD Review: Mediocrity Defined]( From Tom's Hardware US Mushkin's 1TB Delta SSD leverages QLC flash, excha... [How to Build a PC](5867.html) From Tom's Hardware US Are you looking to build a PC but intimidated abou... [Stack Overflow Updates Triple Key Keyboard With RGB Lighting]( From Tom's Hardware US The Key v2 is a triple-key macropad with RGB light... [Seagate Reveals Star Wars-Branded FireCuda External HDDs]( From Tom's Hardware US Seagate's special edition Star Wars HDDs have Boba... [Lenovo's New 'Slim' Laptops Come in Glass and Carbon]( From Tom's Hardware US Lenovo's new premium clamshells are dubbed the Lenovo Slim series, including CPUs from Intel and AMD and GPUs from Intel and Nvidia. MDX/DAX [RELATED vs LOOKUPVALUE in DAX: How and when to use them in Power BI]( From MSSQL Tips In this article we cover how and when to use the D... [CONFIDENCE.NORM, CONFIDENCE.T – DAX Guide]( From Sqlbi CONFIDENCE.NORM: Returns the confidence interval f... [NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV – DAX Guide]( From Sqlbi NORM.DIST: Returns the normal distribution for the specified mean and standard deviation. NORM.INV: Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.... Machine Learning [The ins and outs of joining tables in SQL Server]( Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server. Microsoft News [Microsoft’s Update Compliance Service Will Soon Require Azure AD]( From Petri IT Knowledgebase Microsoft has announced some important changes regarding its Update Compliance... Oracle/PostgreSQL/MySQL/other RDBMS [The nuances of MySQL indexes]( Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL. Performance Tuning SQL Server [How I Learned To Hate The Plan Cache]( From Erik Darling Data Used To Love Her I used to get so excited about l... [“Index Seek” Doesn’t Mean Much.]( From Brent Ozar Unlimited When you see “index seek” on an execution plan, that doesn’t mean SQL Server is jumping to exactly the row you’re looking for. It only means that SQL Server... [Local Variables vs Forced Parameterization]( From Erik Darling Data Questions, Arise! I think it was sometime in the last century that I mentioned I often recommend folks turn on Forced Parameterization in order to deal with poorly formed application... PowerPivot/PowerQuery/PowerBI [Power BI Hack: Download Report Authored in Browser as PBIX]( Most of you have probably run into a situation where someone in your organization has authored a report in the Power BI web service, and now they want to make changes that can only be done with Power BI Desktop. So, you try to download the PBIX file from the Power BI web service, only to discover that you can’t, because if it wasn’t created as a PBIX, it can’t be downloaded as a PBIX. Infuriating! [Reporting data from Azure Cosmos DB using Power BI]( From SQLShack In this article, we will learn how to report data ... [(Livestream Replay) Everything You Need to Know about Power BI Goals - with Treb Gatte]( From Havens Consulting DESCRIPTION Do you have a lot of reports but are still searching for answers? Do you really know what you are working toward? If so, we need to... [Sharing individual Power BI dataflows, but how?]( Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintained many different dataflows in a single workspace, but did not want to share the entire workspace with others. What now? How can they share a single dataflows in Power BI? [About waiting time for Power BI Desktop to open]( From Sqlbi Did you ever experience a long waiting time while ... [The Power Query XML Functions, Missing Or Null Values And Inconsistent Schema Inference]( From Chris Webb's BI Blog A few months ago one of my colleagues at Microsoft... [Template for automating Power BI Refresh]( From Simple Talk I wrote before about Automating table Refresh in P... [Calling the Power BI REST API with VS Code - with Mathias Thierbach]( From Havens Consulting This talk introduces Visual Studio Code as a simpl... [Microsoft Graph API in Power Automate: Adding Guest Users to your Tenant]( From SQLServerCentral Blogs This is video three in a four-part series walking ... [Top Five Mistakes to Avoid When Developing Power BI Reports]( From RADACAD Because Power BI is an easy-to-start platform and you don’t need an extensive learning curve to get started with Power BI Desktop, we often see some bad practices in... [Power BI: Creating an Info Button with UNICHAR()]( From Data on Wheels (Steve Hughes) Reports are only as useful as they are easily understandable. When making reports for executives and other business leaders, it is vital to ensure the context and insights of... [My Excel file is in the cloud! Why isn’t refresh working in Power BI???]( From Guy in a Cube Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get... [Create a Custom Theme with an Image Background]( From BlueGranite Blog While there are settings that you can customize through the menu system in Power BI for a custom theme, one of the settings you cannot edit is to add... Product Upgrades and Releases [SQL Server Diagnostic Information Queries for May 2022]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [General availability: Azure Machine Learning announcements for March 2022]( From Azure Updates Label data with text classification using machine ... [Availability of Microsoft Information Protection labels for Azure SQL native data classification]( From Azure SQL We are happy to announce that Azure SQL database,�... Python [Getting Started with Statistics using Python]( From MSSQL Tips In this article we look at how to use Python to ge... R Language [Diffify]( You know that sinking feeling that you get when you’re months into a big project and you log in one day and nothing works? Turns out something has updated and things have been removed that you needed and now you need to spend hours-days figuring out what’s changed and your masters deadline is getting closer and … ok, apparently this took me back to a very specific event. [Little useless-useful R functions – Animating datasets]( I firmly believe that animation and transition between different data states can give end-users much better insights and understanding of the data, than a single table with data points or correlation metrics. [Little useless-useful R functions – Finding total sum of all sub-arrays and sum of maximums]( From TomazTsql When it comes to O(N log(N)) time complexity funct... [A short note on the startsWith function]( From Statistical Odds & Ends The startsWith function comes with base R, and determines whether entries of an input start with a given prefix. (The endsWith function does the same thing but for suffixes.)... SQL Server News [The Top Feature Requests for SQL Server]( From Brent Ozar Unlimited If you want to get a look at where Microsoft SQL Server is heading in the future, it helps to get an idea of what users are repeatedly asking... SQL Server Security and Auditing [SQL Server vulnerabilities and assessment]( SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server. Security News and Issues [VHD Ransomware Variant Linked to North Korean Cyber Army]( From Dark Reading: Dark Reading News Analysis Researchers use code, Bitcoin transactions to link... [Microsoft, Apple, and Google Promise to Expand Passwordless Features]( From Dark Reading: Dark Reading News Analysis The passwordless future just became closer to reality, as Microsoft, Apple, and Google pledge to make the standard possible across operating systems and browsers. [Critical Vulnerabilities Leave Some Network-Attached Storage Devices Open to Attack]( From IT Pro - Microsoft Windows Information, Solutions, Tools QNAP and Synology say flaws in the Netatalk filese... [SolarWinds Attackers Gear Up for Typosquatting Attacks]( From Dark Reading: Dark Reading News Analysis The same infrastructure traced back to Russian-speaking threat group Nobelium is being used to set up misspelled domain names, presaging impersonation attacks bent on credential harvesting, analysts say. [REvil Revival: Are Ransomware Gangs Ever Really Gone?]( From IT Pro - Microsoft Windows Information, Solutions, Tools The infamous ransomware group appears to be back from the dead -- maybe -- and using the old brand, but experts question whether a reconstituted gang will have much... [Security Stuff Happens: What Will the Public Hear When You Say You've Been Breached?]( From Dark Reading: Dark Reading News Analysis A company's response to a breach is more important than almost anything else. But what constitutes a "good" response following a security incident? (Part 2 of a series.) [Microsoft Authenticator Now Lets Users Generate Strong Passwords]( From Petri IT Knowledgebase Microsoft has released a new update for its Authenticator app... Software Development [Overcoming Technical Debt Requires a Strategic Approach]( From IT Pro - Microsoft Windows Information, Solutions, Tools Most companies are over-spending to meet cloud migration deadlines, and incurring technical debt in the process. What’s the impact of this down the line? T-SQL and Query Languages [A Quick and Dirty Way to Concatenate Two Vaguely Related Tables in SQL]( Every now and then I run across a use case for the arcane NATURAL JOIN SQL operator, and I’m even more delighted when I can make that a NATURAL FULL JOIN [The Empty Catch Block]( From Erik Darling Data Don’t Know Why Normally people handle errors to... [Fun With KQL – Take]( From Arcane Code Fun With KQL - Take [Comparing Daily Estimates to Actuals–#SQLNewBlogger]( From SQLServerCentral Blogs Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post I wrote about using... The... [Getting started with SQL MAX Function with Use Cases]( From MSSQL Tips In this article we look at how to use the SQL MAX() function in SQL Server to find the maximum values in a result set along with several examples... The Lighter Side [DEN to LAX Views]( From SQLServerCentral Blogs I wrote about this trip for an editorial, and here... Virtualization and Containers/Kubernetes [Lightweight Kubernetes Showdown: Minikube vs. K3s vs. MicroK8s]( From IT Pro - Microsoft Windows Information, Solutions, Tools Minikube, K3s, and MicroK8s all provide an easy way of running lightweight Kubernetes. Here's what sets them apart from each other.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -