Posted in SQL Server, T-SQL Tuesday

T-SQL Tuesday #94 – PoSH Goes Dynamic

TSQL2SDAY-150x150It’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”

Posted in SQL Server, T-SQL Tuesday

T-SQL Tuesday #93 – Auditioning for the Job

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”

Posted in SQL Server

My First SQL Presentation

I’d like to blame Andy Yun’s (b|tT-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”

Posted in SQL Server

SELECT-ing About Your Database

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”

Posted in SQL Server

A Closer Look at SELECTs – Part 3

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”

Posted in SQL Server

A Closer Look at SELECTs

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”