TSQL2SDAY
T-SQL Tuesday #122 – Imposter Syndrome wrap up
I want to thank everyone who participated in this month’s #TSQL2SDAY! There are new folks starting their journey towards a new career every day and I believe that these stories can honestly help many individuals. Thank you, Steve Jones – (b|t) for letting me host this month and thank you Adam Machanic for starting this blog party back in 2009.
Overall, we had 27 individuals post or share their Imposter Syndrome stories and thoughts. I had a lot of great reading to do this week and weekend.
T-SQL Tuesday #122 – Imposter Syndrome
As we enter the new year, I’m sure many of us are setting goals, resolutions, or perhaps beginning new challenges. Change can often be terrifying, but that’s how we grow. With this in mind, the topic I’d like us to write about this month is “Imposter Syndrome”.
Imposter syndrome isn’t a topic I’ve seen addressed before via T-SQL Tuesday and this is an issue I’ve commonly seen in the IT industry.
T-SQL Tuesday #120 What were you thinking?
Thank you Wayne for hosting this month’s T-SQL Tuesday! Wayne shared last year a story where he had to reverse engineer a complex hierarchy pattern within a table. The developers appeared to do this to obfuscate how the software operated. This left him asking, “What were you thinking?” So this month, we are discussing stories that left you asking that same question.
During my introduction to a new company, we were running through the processes, duties, systems, and everything else you would expect when starting a new job. Overall, it was a basic induction into a new company.
T-SQL Tuesday #119 Changing my mind
Thank you Alex Yates for this month’s topic!
Something I’ve changed my mind on recently is working on contracting projects instead of performing work directly for a company. Very recently I had a (good) problem of choosing between a few different job roles and companies. The choice was not easy and two years ago I told myself I’d never do contract work again. I’m not talking about starting an S-Corp or an LLC but working for a company that contracts your work out to another company. I have also in the past changed my mind about how I update rows in critical systems and whether you can ROLLBACK a TRUNCATE statement (in SQL Server).
T-SQL Tuesday #118 My fantasy SQL features
T-SQL Tuesday #118Thank you Kevin for hosting this month’s T-SQL Tuesday! It’s an interesting topic to reflect on features we wish we saw in SQL Server. I’m excited to read some of the other ideas and maybe we’ll see one or two get pushed out in the future!
I have three features I’d love to see from SQL Server. Two of these mostly exist already, but they are not easy to utilize. I wish so badly that SQL Server could generate smart Entity Relation Diagrams (ERD) and documentation. Really, I wish it could create the artifacts the way Redgate does. If I had a third feature to wish for while knowing it would be unrealistic, but I’d love if they had a feature to change the culture of a workplace.
T-SQL Tuesday #114 Puzzle Party
This months T-SQL Tuesday comes from Matthew McGiffen who has given us the topic of “Puzzles”, thank you for a great topic!
Puzzles can be fun or frustrating, but I like them because it can be a great way to showcase who you are and how you work. For example, I was given a puzzle from a company that was interested in me but wanted to know how I approached specific problems. They gave me a simple SQL query and three word problems to go along with it. My reply back illustrated how I approach problems, document findings, performance test, and also work to obtain business requirements.
T-SQL Tuesday #112 Dipping into my Cookie Jar
This month Shane asks us to reach into our “cookie jar” and pull out some life lessons. Thank you for an interesting topic to think and write about!
Shane also describes for us what this term means in our context:
Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance from them. You dip back into that cookie jar and use whatever energy that provides to keep going.
T-SQL Tuesday #110 Automate your Toggl dataset with SSIS
Something I’ve automated* recently was my import of Toggl data! So T-SQL Tuesday #110 seems like a great time to post this solution. Thank you Garry Bargsley for the great idea and being this months host!
I put an asterisks next to automated, as obtaining the file from Toggl and placing its location is not automatic. They provide a premium feature to allow this or you could work on creating your own web scraper. (Which is probably against their rules of use on their site, since they are offering the file drop as a premium feature.)
T-SQL Tuesday #108 Learning non SQL Server technologies
This month’s T-SQL Tuesday is hosted by Malathi Mahadevan. Our topic comes during the PASS Summit, a SQL event filled with learning, networking, and the #SQL Family! So it is only fitting that our topic is regarding learning and education. Thank you Malathi for hosting this month and for the great topic!
The topic is to pick one thing that is not SQL Server that we want to or already know. How do we or did we learn this skill and how do we add it to our resume?
T-SQL Tuesday #106 Trigger headaches or happiness?
Triggers are both a useful tool with a specific niche… and the devil. Thank you Steve Jones for hosting this week’s topic on triggers!
On the left we have triggers and on the right we have constraints.When used appropriately, it’s a great skill to have in your repertoire. When used inappropriately, you will probably ruin someone’s day.