Improving Skills at Work (2022-12-17 DBW)

Improving Skills at Work

A large part of the success I've had in my career has come from growing my skills, both technical and soft, throughout the years. I've always been driven to learn more and improve my ability to accomplish the tasks I've been assigned. Or those that I've sought out and tackled. A little initiative has been valuable in many successful reviews in the past.

There is a shortage of skilled IT workers. There are numerous job openings that I see in many companies, at least outside of some of the large tech firms. Many of those have been laying off workers, especially in some of their divisions that haven't been as successful as expected during the last few years.

At the same time, a lot of companies are becoming more discriminating about who they hire. They don't just need bodies, they need skilled bodies that can do the work they are struggling with, often in the DevOps, cloud, and data analysis areas.

While a lot of you reading this newsletter will have data skills, are they the ones companies need? Do you understand Git, DevOps, builds, and pipelines? Are you familiar with cloud technologies and gluing systems together remotely? Can you handle python, Spark, Power BI, or business requests to do something with AI/ML?

I'm often not surprised that many senior data people don't have exposure to these technologies and aren't sure how to gain skills. I am surprised that more employers aren't upskilling existing people or reskilling them in new areas. It seems far too many companies don't invest in their people, even in today's world where hiring is both very expensive and time-consuming. It's also frustrating when you can't find qualified candidates.

There's a good article on upskilling and reskilling and the importance of having a plan inside your organization. This goes hand in hand with a number of presentations from companies at the various DOES conferences over the years. The successful companies that embrace a digital transformation (whatever that means), DevOps, and the Cloud have ways to bring their current employees along. They invest in their people, requiring them to grow, but assisting them on the journey.

Not everyone wants to move to the cloud or DevOps or AI/ML. That's fine, but my view is you have to embrace some change in your career if you want to create new opportunities for yourself and have choices in your future roles.

If your company doesn't do enough to help you grow into new roles with new skills, maybe send them this article. Make a business case that you can do more with some help, and you're willing to invest some effort yourself to grow. Managers know hiring is hard, and if you've been a good employee, I think they often are willing to invest in you.

If they're not, then many you ought to think about that a bit and find out what you can do better so that they will invest in you. Not everyone makes it through corporate transformations, but many do if they are flexible and put in some effort.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

This article provides a simple demonstration of how a small team of developers might set up a Flyway Desktop project to manage, automate, and control database development.

Where does data fit into the digital transformation story? Discover how and why it deserves a place in this fascinating piece from Pramod Sadalage, principal consultant at Thought Works.

In this article, I want to talk about a topic that you may never need. The only time I have really had need to look at the bits in a byte pattern. In (what is now) ancient versions of SQL Server didn't have such self-describing columns like in its metadata objects like it does now.

A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The data returned by the subquery is passed into the DML statement and incorporated into its overall logic. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.

In the series of Azure Machine Learning posts: MLFlow is an open-source framework for registering, managing and tracking machine learning models. It is multiplatform, bringing consistent model training and...

In the series of Azure Machine Learning posts: Yesterday we have looked into how to start the MLflow configurations and today, let’s put this to the test. We will...

In the series of Azure Machine Learning posts: Automated ML is a no-code automated machine learning task. It iterates over many combinations of algorithms and hyperparameters in order to...

In the series of Azure Machine Learning posts: Important asset is the “Models” in navigation bar. This feature allows you to work with different model types -> custom, MLflow,...

SAS' Bahar Biller expounds on the idea that stochastic simulations are large-data generation programs for highly complex and dynamic stochastic systems. The post Accelerating what-if analysis with machine learning...

Thank you for joining us on “The cloud hub: From cloud chaos to clarity.” Do-it-yourself (DIY) AI is mutually beneficial for IT and business teams in an organization: DIY...

What is DB chaining?What are the limitations of ow...

In SQL Server, locking and blocking are mechanisms that are used to protect data integrity and consistency by controlling access to data by concurrent transactions. Locking is the process...

We use to receive cases where our customers wants to connect to their Azure SQL Database servers using the Private Endpoint IP instead the Azure SQL DB FQDN. Two main...

Based on this public documentation Auto-failover groups overview & best practices - Azure SQL Database | Microsoft Learn , we received several questions about how to identify if any data has been not synced between primary and secondary when we performed a force failover in Azure Transparent Failover Group.

In my last blog How To Monitor All SQLServers LIVE, I shared how I use open-source SQLMonitor every day to monitor SQLServers in my organization. This tool helps me and my team to ensure that we proactively detect any issue with SQLServers even before users can reach out to us.

People are always saying things about the importan...

A log cache block holds log records for the databa...

Reading Time: 2 minutes For this months T-SQL Tuesday contribution I want to explain why I tend to spend a lot of time finishing off outstanding tasks r...

T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Garry Bargsley (blog | twitter) wants to know what activities we...

Based on this public documentation Auto-failover groups overview & best practices - Azure SQL Database | Microsoft Learn , we received several questions about how to identify if any data has...

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application...

File seeding is a useful way of maintaining and deploying static, or very slowly changing, reference data for a data model to use repeatably and reliably across environments, whilst benefitting from source control.

I've been reviewing customer questions centered around "Have I tried using MSSparkUtils to solve the problem?"

Sometimes you think you have something down. With years of SQL Server experience, you would think you’d know at least the basics of the SELECT statement no matter the relational database. Well, my friends, you’d be wrong.

A typical routine of a data engineer includes writing code, choosing and upgrading the compute infrastructure, and testing both the new and changed data pipelines. Most of the time, engineers looking to test the changes they wish to apply need to run their tested pipelines in parallel to production.

Sometimes you think you have something down. With years of SQL Server experience, you would think you’d know at least the basics of the SELECT statement no matter the...

In this episode of Data Exposed with Carlos Robles and Anna Hoffman, we will discuss the recent public preview release of the Azure SQL Database offline migrations using the...

Read the 2022 recap of all the Azure SQL and SQL Server news or catch the live episode! If you missed the episode, you can find them all at...

Initialize Transaction Replication subscription from a Backup (on-premise to Managed Instance) Initialize with Backup sample script This article provides you with a sample script for creating a transactional replication with the...

Initialize Transaction Replication subscription from a Point-in-time-restored backup (Managed Instance to Managed Instance) Use INITIALIZE FROM LSN with a PITR backup This article provides you with steps for initializing a Managed...

Organizations should look to upskilling and reskilling their existing IT talent as a way to keep pace with digital transformation, but a strategy that is clearly thought through is...

Data analysts are specialists in statistics, mathematics, and computer science, enabling them to serve in a variety of departments, including operations analysis, financial analysis, and marketing analysis. A data...

Reading Time: 3 minutes My Festive Tech Calendar 2022 contribution was released this week. It is a video available on YouTube called “Viewing a list of Christmas presents...

This is a bit of a niche blog post, because you don’t actually need this to make your Azure Function work :). When you create a new HTTP-triggered Azure... The...

Migrating to the cloud can be a challenge from hardware to software and the stack in between. In this episode of Data Exposed: MVP Edition, Melody Zacharias shows you...

I am honored to present A Day of Azure Data Factory at SQL Saturday Atlanta 2023 – BI & Data Analytics Edition (#1042) 24 Feb 2023! Abstract In this session we provision...

I recorded the first of a series of podcasts for the SQL Server 2022 timeframe recently. Once again, it was great to chat with another old friend Davide Mauri....

It's time for on-the-record answers to questions a...

Thank you for joining us on “The cloud hub: From cloud chaos to clarity.” Data privacy is no longer just about risk management; it can play a significant role...

That Solidigm P44 Pro is the SK hynix Platinum P41...

From CPUs to GPUs, 3D printers, laptops and other PC components and accessories, these hardware products rose above the rest.

USERNAME: Returns the domain name and user name of...

The one-to-one relationship is just a particular type of one-to-many relationship…

Microsoft released its monthly “Patch Tuesday” updates for Windows 11...

+OK

Today, I worked on a case that our customer reported a performance issue running SELECT TOP 100 * FROM HeapTable. This table has around 500K rows and is taking...

+OK

+OK

+OK

Power BI is not only a cloud-based reporting technology. Due to the demand for some businesses to have their data and reporting solutions on-premises, Power BI also has the option to be deployed fully on-premises. Power BI on-premises hosting is called Power BI Report Server. This post concerns using Power BI in a fully on-premises solution with Power BI Report Server.

People have done creative things with SVG measures...

In some situations, customers that are using PowerBI and Direct Query reported performance issues depending how the query has been defined by PowerBI. In this scenario, I would like to share...

Expanding on my previous blog on this subject, the...

Let's look at how to build a slicer panel in your ...

Thoughts on why Power BI is a semantic layer or metrics layer

ABSTRACT The session will focus on the topic o...

I love Excel as an alternative to Power BI reports...

I wrote an article about Power BI Datamarts which ...

In some situations, customers that are using PowerBI and Direct Query reported performance issues depending how the query has been defined by PowerBI. In this scenario, I would like...

Learn how to leverage the features of the Bookmark Navigator button to implement an easier solution for creating on/off (toggle) formatting for a single button. Tune in to learn...

This tip will go through some guidelines for creating an optimized data model when working with Power BI for performance and accurate results.

In some situations, customers that are using PowerBI and Direct Query reported performance issues depending how the query has been defined by PowerBI. In this scenarion, I would like to share...

How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems...

This book aims to give you a holistic approach to migrating on-premise databases to Azure, how does it fare?

We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.2. The update addresses a few issues on top of the 10.2.1 release. Fixed issues Clear prepared statement cache...

Santa’s elves took a break from building toys and shipped a new version of the First Responder Kit. There are some great improvements in here, like a makeover for...

Authenticate to Azure Functions with Azure Active Directory using the Azure Cosmos DB extension version 4.

Create Azure Cosmos DB for PostgreSQL clusters now in the Sweden Central and Switzerland West regions.

Build a business case in Azure Migrate today to understand the return on investment for migrating your servers, SQL Server deployments and ASP.NET web apps running in your VMware...

Encrypt your data with customer-managed keys to enable an extra layer of security for data at rest.

Extend storage up to 32 TB to host databases with a size greater than 16 TB for Azure Database for PostgreSQL – Flexible Server.

Microsoft has released a fix for a memory leak bug...

SQL Server has had the native ability to encrypt d...

We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –... The...

The most recent iPhone update—to version 16.1.2�...

Threat actors leak employee email addresses, corporate reports, and IT asset information on a hacker forum after an attack on an Uber technology partner.

Jira, Confluence,Trello, and BitBucket affected.

Thank you for joining us on “The cloud hub: From cloud chaos to clarity.” Vishal Salvi, from Infosys, and Ross Anderson, a professor at Cambridge University, engage in an...

This article explores SQL Server functions to add ...

In this article, we look at different ways to check query syntax by using PARSEONLY, NOEXEC as well as executing the code to see how SQL Server handles each...

This article aims to explain the WHERE, GROUP By, ...

Learn about prepared statements in SQL Server, wha...

Introduction In the previous post of this series, ...

Today, I will describe the SQL SUM () function along with its use cases in this article. There are various mathematical calculations we need to do in day-to-day business...

Despite economic circumstances calling for more innovation from IT teams, cost pressures are stalling those efforts, a Snow Software report finds.

Technological advances are transforming everything from transportation and manufacturing to financial services and healthcare. These advances make digital transformation imperative for organizations to adapt to shifting marketplace realities. Nine...