
When you are surrounded by some of the smartest and brightest people in the Microsoft data platform community, it’s like drinking from a fire hose. But the overwhelming feeling that you get from learning a lot in a very short span of time suddenly sinks in when you realize this very important message: your job as a data professional matters more today than it did ever since.
The benefits of being surrounded by the best and the brightest through the PASS Data Community Summit and the Microsoft MVP Summit cannot be understated. Catching up with friends from all around the globe – Australia, India, the UK, Europe, Philippines, the US, etc. – has now been my main reason for attending and speaking at events. More than the technical sessions and hands-on experiences with different data technologies, it’s the hallway conversations that make me all the more realize the importance of my earlier statement.
While having a conversation with one of the technical experts, he told a story about his involvement in a project deploying one of the very first SQL Server instances in the Philippines almost three decades ago – a two-node SQL Server 7.0 failover cluster. Because SQL Server was a relatively new product back then, not a lot of people had access to documentation and even formal training.
After the deployment, they had to implement a maintenance script for rebuilding the indexes when they became fragmented. The Operations team simply ran a job that calls the script if they feel that the system is starting to slow down.
That worked well for some time. Until the unexpected happened.
Somebody from the Operations team wanted to “do the maintenance on the production server” without really understanding what the script was doing. There were two sections in the script – one for dropping a staging table for an ETL process and one for maintaining the indexes. If the script was called from the SQL Server Agent job, everything would have worked as it always had because of the logic built into the script. Unfortunately, the script was manually copied and executed within Query Analyzer. I will leave it up to you to figure out what happened next.
Every once in a while, we make “dangerous production mistakes” like dropping a table, a database, or reformatting an entire server (trust me, I’ve done this myself by “accidentally” deploying a Windows XP OS image on a SQL Server machine thru System Center Configuration Manager.)
If you have not experienced any of these incidents before, you can’t call yourself a senior IT professional. These are the battle scars of the veterans in the industry.
We might just brush it off and look at it as unexpected incidents. That is until you start to see what’s beyond those systems.
That database might be used by a healthcare facility that needs to deliver timely data to save a patient’s life.
It could be used by a country’s immigration system to identify potential threats to national security.
Or it could be a job portal database to assist the unemployed find a new job to feed his family.
What about all those security breaches that we have been reading on the news recently?
When we start to see the people impacted by the database systems that we manage, this statement becomes even more relevant: your job as a data professional matters more today than it did ever since.
Sharpening The Saw
Unlike decades ago where your only source of information were outdated books in the library, there are now a ton of available resources to help you learn – blog posts, video tutorials, hands-on labs, tech events like SQLSaturday, online courses, and now with all the AI platforms.
I’ve been hearing the same old song for the last 30 years that I’ve been in the IT industry: “it’s hard to keep up.” There’s always something new to learn while making sure that we don’t ignore the fundamentals and basics.
If we only look at the technology advancements and the amount of learning that we need to do just to get our jobs done, it would be overwhelming.
But when you look at the people beyond those database systems, you’ll find learning new things and applying what you’ve learned in your job meaningful. I call it finding a deeper purpose in your work.
You can learn a new trick to optimize and automate a repetitive task so you can work on more meaningful ones.
You can learn how to apply best practices configuration for your specific environment to make it more stable.
You can use AI tools to source ideas on how to make your work more valuable (just don’t give it proprietary data that is only meant for internal use).
All the things you learn to help you improve your work do not go to waste. Just remember that there is an individual on the other end of the system that is reaping the benefits of that stored procedure you just optimized.
In a data-driven economy, our lives are all impacted by the amount of data being collected, maintained and analyzed.
Who knows, you might already be on the receiving end of another data professional doing a great job.
Please note: I reserve the right to delete comments that are offensive or off-topic.