RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me that, where I work, we are a RedGate shop. Needless to say, even if I was not at my current employer I would still want this type of utility in my arsenal.
A lot of data professionals are always looking for ways to “save time” or “get ahead” in their day-to-day activities and this is one utility that will help provide some lift in those areas.
Why would I want to use this utility you may ask? Below are some of the highlights that this product offers that have helped me streamline some of my day-to-day activities:
- Tab History – being able to save or preview work that was done in SSMS allowing me to jump right back into where I left off is a huge benefit.
- Actions List – this new feature that allows you to select your code and provide hot keys so-to-speak if phenomenal
- SQL Formatting – enough said on this one. That’s right; I don’t have to go into detail; ever find that nasty code and you wonder who anyone can read it. Quick and easy option to format the code base you are working with.
- Auto Complete – if you’ve ever used something similar to this you’ll learn quick that this auto complete feature of joins etc. are pretty awesome. I always hear colleagues, co-workers, other community members that when this portion becomes unavailable they quickly realize how good they had it.
- Snippets – sharing snippets with other team members is huge.
I’m proud to say that I’ve worked with this utility greatly and would recommend it as a viable option to improve efficiency. Don’t take my word for it though; as with anything try it out.
Go check out the product here you won’t be disappointed.
One of the things I enjoy about the SQL community is the many people that you come into contact with. Whether it is speaking, interacting, listening, or collaborating one can meet many data professionals from all walks of life. With that you get to know, invest, and follow individuals. Two people that I’ve come to know this past year via the SQL community is Argenis Fernandez (b|t) and Kirsten Benzel (b|t).
An initiative that they started last year at PASS Summit was Argenis Without Borders. When I first heard about this I was enamored and intrigued; both individuals are stellar data professionals and pillars in our SQL community so I decided to check this out and see what it was all about.
This year they are back at it with a new initiative and new goals. I encourage you to check out what this new initiative is all about, and if you decide to get involved – fantastic. If not pass the information along so we can continue to spread the word.
“People making a difference one day at a time”
It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me some valuable lessons especially in my every day work life.
We live in a fast paced society. Work will never cease that’s a given; when is the last time you truly stopped, looked around, and appreciated where you are at in this point in time?
I used to struggle a lot with not blogging enough, not giving back to the community enough, not submitting to speak enough, arguments with other data professionals on what is the right way to do things versus the wrong way to do things, and the list could go on and on.
I look at SQL Family and what does it truly mean to me? I take great pride in my work, the people I am involved with daily, the many issues that come up that provide new solutions waiting to be found, but SQL Family is much more than that. It is shown daily by the likes of you and me. You see it in the generosity when one of our own passes away, you see it in others who rally around a good cause, you see it when a seasoned community member takes a newbie under his/her wing to guide them, and yes you see it shown when you receive heart breaking news that we all endure through the journey we call life.
There are intervals in life when you stop and asses priorities; nothing wrong with that. You start to look at if the he said she said argument was even worth it, you blast a newbie because he made a dumb mistake due to the fact that they just didn’t know, or you get on some ego trip because you believe you are entitled to something.
There will be things you can control and there will be things you can’t control; as a data professional and proud DBA I will continue to do the best I can day in and day out. I come from the school that you work hard regardless of the situation. You won’t find perfection, you won’t find a guy who knows it all; what you will find is a guy who has a passion for the SQL Community and a passion for learning and honing is craft.
To the new community member the days will not always be perfect; heck the days you will sometimes wonder what the heck you got yourself into; enjoy the ride. Don’t beat yourself up for things you think you could have done better; learn from them and move on. Realize that SQL Family IS the people, the interaction – it is what makes it thrive.
For the ones who have been around for a long time, with as much respect as I can muster, I just implore you to realize that when life does happen outside of our SQL walls; don’t let that time go by wasted. You need to cherish every minute of it; we (me included) rush around getting to the next event, next speaking engagement, next post and if we aren’t careful we will let those outside moments pass us by.
Some will take this post as me saying not to worry about the security breach that was caused by a pointless mistake, and some will read too much into it and be wondering if I’m speaking at anyone in particular. I get how it all works, these are just intended thoughts of mine that if I can take to heart myself, then it might help me in the future to become a better data professional and DBA.
Work hard, cherish the moments, and realize that taking one day at a time is okay.