Technology has changed a lot in the past years, especially with cloud/globalization/automation. What an impact has this had on your job? Do you feel endangered? Or do you have more exciting features/toys to work with? Do you embrace the change and learn new skills? Or do you hide in your cubicle and fear the robot uprising?
Now my knowledge of these subjects are somewhat limited; I have yet to research the cloud beyond a rudimentary “poking it with a stick” so I leave that topic to people like Arun Sirpal ( blog | twitter ) and others.
Globalization is another new topic for me. I consider it to be along the lines of being able to fill in positions with people all around the globe (but I’m probably wrong with this). There is a veritable plethora of people online that are excelling at this, so I leave it up to you to seek them out.
Automation…well I have some dealings of this, so I was considering this to be my topic. Then I realised that I could write about something along the same lines. Out-sourcing, but not in the conventional sense. More like…
There’s never enough hours in the day for everything I need to do!
How many times have we heard a complaint similar to that? Especially now-a-days when DBAs are tasked to look after more and more servers and instances. I cannot remember the last time I heard of a DBA taking care of servers in the single digits.
The work of the DBA keeps increasing but the amount of time that we have remains the same. How do we combat this? How do we make it so we are not sprinting just to keep up?
The only answer I have to this problem is this.
Don’t try to re-invent the wheel…let someone else do it.
The SQL community has been hard at work creating awesome content for everyone to use.
A short list of the top of my head include:
This doesn’t include the tools available from companies like
And have you seen some of the scripts created by individual members of the SQL community?
- Similar Tables? No problem for Jana Sattainathan ( blog | twitter )!
- Check FreeSpace, Mike Fal ( blog | twitter ) has you covered!
- Heck, even the MS SQL Tiger Team ( blog | twitter ) has tools out for you now!
Hmm, maybe this won’t be as short a list as I thought…
- Brent Ozar Unlimited ( blog | twitter ) has got the First Responders kit,
- Glenn Berry ( blog | twitter ) has his DMV Queries (with video), and
- Paul Randal ( blog | twitter ) has his Wait Library, in conjunction to his Wait Script!
You know what this blog post needs? More links!
- Andy Yun ( blog | twitter ) has got sp_helpExpandView.
- Kimberly Tripp ( blog | twitter ) has got sp_helpIndex, and
- Adam Machanic ( blog | twitter ) has got sp_WhoIsActive!
Can I stop now? NO!!! MOAR LINKS!!!
- Kenneth Fisher ( blog | twitter ) has got SrvPermissions & DBPermissions.
- Raul Gonzalez ( blog | twitter ) has got sqlg_securityAuditServerLogins, and
- Ola Hallengren ( blog | twitter ) has got, what the community calls, the “Ola Hallengren scripts“!
And with Microsoft’s advancements with SQL Server and PowerShell, porting it to work with Linux and with Azure, it is like Microsoft are actively trying to get you to automate; actively trying to make your life easier!
So yes, technology has changed but we, as a SQL community, have worked so that you can use these tools, automate away the drudgery, and embrace these changes.
As long as you embrace this “inline out-sourcing” that we have.
Now I could wax lyrical about all the different aspects of the community and how, with these resources, you shouldn’t need to re-invent the wheel but I’m not going to.
These people have poured hours of effort into these scripts all for you to use. They have poured their heart, souls, and RAM into these scripts just so that they can help out the community.
I would ask a favour of people reading this post though. For all the time, effort, and sacrifice that these people have put in…
It means more than you know.