Seven tips in seven minutes for the SQL Developer | Data Exposed: MVP Edition

Come learn seven quick tips that will make you a better SQL developer in this episode of Data Exposed: MVP Edition with Anna Hoffman and Ike Ellis. Whether you use SSMS or Azure Data Studio, you will find value in this session. In seven minutes, you'll learn tips to be a more productive developer.

0:00 Introduction
1:47 Tip 1
2:32 Tip 2
2:59 Tip 3
4:51 Tip 4
5:42 Tip 5
6:23 Tip 6
8:33 Tip 7

About Ike Ellis:

About MVPs:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#MVPTuesday #AzureSQL #MVPBuzz #DataPlatformMVP

[Bourn]

this is cool, now here's a some Tips for Microsoft,
1. Make dark theme available for SSMS
2. Make Azure data studio a fully fledged SQL IDE with the features of SSMS

[chidiumezinne]

Didn't know about the dragging of columns to the query window. Thanks. The last tip has been very useful to me. You could also scroll the Mouse while holding the ALT key to achieve the same thing.

[steveheyden]

Thanks! I really super appreciate the chapters and transcripts for this. Sometimes you just listen but for ones like this I want to go back to what I need. Thanks again

[MikeCarey]

Brillante tips! Hoping for a "sequel" video with more of these

[bhavyaparikh]

Alt + Shift tip was really helpful. Thank you.

[fgl]

Wow! That's was amazing!!! I expend lots of hours writing T-SQL so this tips are extremely useful.

[lovablepersona]

Pro tip for Microsoft. Make SSMS a full fledged code editor.

[NewtonMbazima]

great tips on the shortcuts and status bar. thanks very much

[starmole]

Anna FTW!

P.S. even after tip 1 I'm like "Oh yeh, that's what that's for"!

One tip on the tip: for each one provide a quick ex plainer on how to actually do it or even have a link in the video for each tip with instructions there.

It's not a biggy.

I take it back, I'll just not be lazy :D

[brevanpharaoh]

Holy crap. That last tip is solid gold. I use joins all the time . 300% less freustration for me.,

[g.yeswanthreddy]

ohh this is super man thanks a lot I am gonna use and share it with my colleagues tooo

[rajjoshilove]

Oly color concept i was missing i added that in my small mind. Nice one

[robinhalabicki]

holy crap, tip 7 just changed my world

[marcosoliveira]

I love the bar tip! Thank you!
Is there a way to connect git from SSMS em submit my t-sql code for versioning?

[TristanFlorian]

What is the point of dragging the columns and then using a third-party tool (that needs to be set up not to mess up the column names) to format the code when there is possible to select the top 1000 rows and have it formatted by default?

[teunkruijer]

I like how he gives a tip about switching databases with a shortcut instead of manually and then proceeds to manually switch the database in the last tip.

[SOSSTSE]

I want to create a AI for my smart security products.
Any ideas?

[blackmagic]

Custom colors is very buggy and does not persist. If you want that feature, use ADS

[starmole]

OMG I know double comment but GOOD LORD I can't believe these gems existed.

[NONO-hzvo]

Add in a history feature like DBeaver or others do. I know there are SSMS plugins but they are generally bloated.