Learning Isn’t Easy, But It’s Vital

In between other work, for the last four weeks or so, I’ve been trying to learn AWS DevOps Pipelines. Let me tell you, they are not simple. At least, I still haven’t quite figured them out. However, I’m going to keep on trying until I figure it out.

I’m doing this for a few reasons, and I think they may apply to all of us.

First, and I’m not even going to mince words on this, I’m doing it so I’m more valuable to my organization. If I know more and can do more, I’m a good person for the organization to keep around. I’m also worth more in terms of cash. Simply put, a more knowledgeable employee is a more valuable employee.

However, I’ve got an affliction called the “Helper Gene.” It means I’m always trying to help others. In this case, if I can figure out how to get AWS Pipelines working, maybe I can translate that learning for others. If I’m having a hard time with learning something, it could be that what I’m learning is beyond me. However, it’s also an indicator that others are probably having a hard time as well. That makes for clear opportunities in helping others.

Finally, let’s face it, if you want to stay a technologist, and you’re more than 3-5 years away from retirement, you need to up your skills. You’ll have to learn the next version of whatever data platform you’re on. You must learn, and implement, automation. Technology and the technology landscape is constantly shifting. A lot of our built-up knowledge will serve us extremely well in this changing landscape. Unfortunately, it won’t be enough as things continue to change.

So, best to be learning new things. It’s a muscle. Exercise it.

Grant Fritchey

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

When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.

Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like SQL Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events.

Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.

The database recovery model controls how a SQL Ser...

In my last post, I talked about how you can get 43...

Did you know it is possible for SQL Server Agent t...

we figured out that they had slow overall performa...

Total: 1 Average: 5Introduction The SQL Server design implies a one-to-many mapping between the database engine (instance) and the databases hosted on the instance. It means that you can...

I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,... The...

One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP... The...

My teammate Meagan (b|t) messaged me in Teams yesterday afternoon to say “Joey, the client created a new database using your automated process, and my ETL user (which is...

Click to learn more about author Bernard Brode. Ta...

TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading The post As a DBA, am I...

The new way of work requires a new way of managing, whether you like it or not.

Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains what to expect when interviewing and how to prepare.… The...

Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got... The...

[MSSQLFUN & Decode ITeS becomes a family of 17...

Billing in Microsoft Azure is a strange beast to g...

Join Microsoft MVP Kendra Little to discover how you can fully left-shift your deployments with version control and automatic cloning using Redgate's latest innovations.

I’ll be speaking at the PASS Summit in 2020, and I have some things to prepare for that. I get a conference admission for the event and access for... The...

My first course Kubernetes Package Administration with Helm has been published on Pluralsight and is now available! Check out the course overview here This course is aimed at anyone... The...

You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a couple of production SQL Servers, no high availability or disaster recovery,...

This post is part of the series showing practical usage examples.

PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more.

Click to learn more about author Amar Kanagaraj. T...

Several new Azure Files features went into public preview earlier this year to help organizations move file shares to the cloud with confidence. The post Microsoft Improves Data Protection in...

Ready to learn more about how to evolve software development for databases? Here's a sample list of resources to get you going. The post Ramping Up on Database DevOps: A...

Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.

A new feature in version 3.9 of the Visual Studio 2019 SSIS extension is “skip package validation.” I’ve tested the functionality and it works well. Here’s how you set...

eWEEK PRODUCT REVIEW: For those working from home-...

Most x64 bit server hardware shipping today has TPM 2.0 and Secure Boot, but the features are often turned off by default. The post TPM 2.0 and Secure Boot Become...

There’s so much I need to get written down these days, but there’s only so many hours in a day Tags:  azure, Lift and Shift, oracle, Oracle on Azure Del.icio.us ...

Scrabble Words You spend most of your life waiting. Sometimes it’s not bad. Even a long wait can be okay if you only have to do it once. Once I waited...

Going For Distance There are waits, and then there are waits. If you know, you know, you know? If you don’t know, here’s the deal: there are some waits that are gonna...

Done Started Something If you talk to anyone who bills by the hour for SQL Server, one of the first things they’ll ask you is what your wait stats are. It’s...

We've talked about dynamic titles in Power BI befo...

In last week’s post I described the new Power Query M functions for working with Well Known Text objects, and in a post a few weeks ago I showed...

Want to explore or test Power BI administration se...

Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify...

Recently I was working with a customer and they asked if they could somehow package up their schema without the data and send this to a colleague. Absolutely, and... The...

In December 2019, Jeff Barr published this post announcing the launch of a new Local Zone in Los Angeles, California. A Local Zone extends existing AWS regions closer to...

Integration Services Extension v3.9 is now available for Visual Studio 2019. I tested the skip-package-validation feature and I like it! Interesting (to me) is skipping deployment to Azure-SSIS for...

Como integrar modelos hierárquicos de séries tem...

Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index.

[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us onFacebook & YouTube.] Refer our Complete Guide To “SQL Server Security & Architecture and Internals”... The...

Hacking isn’t all 1s and 0s—more often than yo...

Recursively Querying Related Rows Recursive querie...

Recently I noticed that my client has been using t...

A very interesting puzzle, where you see the data ...

When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there...