It’s another T-SQL Tuesday, folks! Rob Sewell (b|t) is hosting this month’s challenge. (Thanks for hosting, Rob!) The topic is to talk about PowerShell, or PoSH for those in the know. Check out Rob’s post for details about the challenge and T-SQL Tuesday in general.
I am by no means a PowerShell expert. I first started working with PowerShell a couple of years ago when co-workers introduced it as a way to create “installers” to deploy ETL packages to our clients. My understanding was that it was like the command prompt on steroids. You could execute basic commands like you did in a command prompt, but it had the bonus where you could extend its functionality with your own functions or modules.
Continue reading “T-SQL Tuesday #94 – PoSH Goes Dynamic”
It’s been a while since I’ve done a T-SQL Tuesday. This month, it’s hosted by Kendra Little (b|t). Her challenge for us to talk about Interviewing Patterns and Anti-Patterns. You can read the full details here.
To be honest, I’ve been involved in a lot more auditions than I have in job interviews. But job interviews and auditions aren’t that different. Interviews are just auditions for the job, right?
Continue reading “T-SQL Tuesday #93 – Auditioning for the Job”
I’d like to blame Andy Yun’s (b|t) T-SQL Tuesday topic. His challenge was a call for growing new speakers in the community. I can’t blame him though because I chose to participate in that challenge, knowing that I was essentially commit myself to doing this. (It’s just how I work.) And for that, I have to thank Andy for choosing this as his topic.
And now for the story of my first SQL Presentation, in two parts.
Continue reading “My First SQL Presentation”
I may be switching up the title, but this is really a Part 4 of my closer look at SELECTs.
(Miss my previous posts about SELECTs? Check out Part 1, Part 2 and Part 3!)
Up to now, I’ve talked about SELECTs for your database tables and objects and they can start to help you understand how you use your data. But now let’s build on the other things you can SELECT from to learn about your database.
Continue reading “SELECT-ing About Your Database”
Yep – there’s a Part 3 to this Closer Look at SELECTs series. Who knew there was this much to say about the SELECT statement?
(If you missed Part 1 and Part 2, check them out!)
By looking at SELECT statement, you can tell a lot about your database design before looking at a data model or checking system tables or executing any of the sp_help* stored procs. You’ll want to consult any and all of those to help you along the way but the SELECT statements can help give clues about what you will find or what you should find.
Continue reading “A Closer Look at SELECTs – Part 3”
In my previous post, I talked about the SELECT statement being the key to writing INSERT, UPDATE, and DELETE statements. Now let’s build on that.
Continue reading “A Closer Look at SELECTs – Part 2”
I am putting together an Intro to SQL presentation for a local meetup. The goal is to go over the basics of the CRUD operation SQL statements (Create\ Insert, Read\Select, Update, Delete), especially for those who are new to SQL.
As I am putting this presentation together, I seem to have acquired a deeper appreciation of the SELECT statement. With the proper SELECT statements, I realized that you can accomplish 75% of what you need to do working with databases. OK, I’m totally making up that percentage but you can do a whole lot with a good SELECT statement.
I think there’s a lot to look at with this so I’ll talk about those in future posts. But for now, let’s start with this idea:
If you can write a SELECT statement, you can write an INSERT, UPDATE or DELETE statement.
Continue reading “A Closer Look at SELECTs”