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
You can enable dark mode in SSMS by editing the pkundef file. It mostly works but there are some visual challenges with some aspects. Can't help you with number 2.
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
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.
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.
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
Multiple cursors in general is a huge help. Another great shortcut is Shift + Alt + ; If you have a long list of comma separated values and want to add a new line after each, you can just put your cursor before a comma, press this shortcut, and then you have extra cursors on every single one. You can now just press comma, then enter, and it'll add a new line for each. Another useful scenario for this is when you select some data, and want to use a list of values from the grid to filter another query. Copy all the rows you want to use (ctrl + c) Open a new window (ctrl + n) Paste the list (ctrl + v) Go to the end of the second to last line (Up, End) Create the extra cursors like before (Shift + Alt + ;) Type apostrophe, comma, apostrophe. ( ' , ') your list now looks like this: one','two','three','four','five','six Just put the apostrophe and brackets at the start + end, and you've got a list ready to go for an IN statement: ('one','two','three','four','five','six') Across 5 values this might not change much, but it now takes the same amount of work to do it for 100 or 1000
There is intellisense, so if you declare you variable in the query, you can start to type it and the intellisense will show it. maybe it is an option though that needs to be turned on, but it's definitely in SQL SMSS 18+
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?
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
You can enable dark mode in SSMS by editing the pkundef file. It mostly works but there are some visual challenges with some aspects.
Can't help you with number 2.
AND ADD MORE COLOR! Like we had back in SSMS 2005! Arrrggg...
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
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.
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.
Brillante tips! Hoping for a "sequel" video with more of these
Wow! That's was amazing!!! I expend lots of hours writing T-SQL so this tips are extremely useful.
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
Alt + Shift tip was really helpful. Thank you.
Multiple cursors in general is a huge help. Another great shortcut is Shift + Alt + ; If you have a long list of comma separated values and want to add a new line after each, you can just put your cursor before a comma, press this shortcut, and then you have extra cursors on every single one. You can now just press comma, then enter, and it'll add a new line for each. Another useful scenario for this is when you select some data, and want to use a list of values from the grid to filter another query.
Copy all the rows you want to use (ctrl + c)
Open a new window (ctrl + n)
Paste the list (ctrl + v)
Go to the end of the second to last line (Up, End)
Create the extra cursors like before (Shift + Alt + ;)
Type apostrophe, comma, apostrophe. ( ' , ')
your list now looks like this: one','two','three','four','five','six
Just put the apostrophe and brackets at the start + end, and you've got a list ready to go for an IN statement: ('one','two','three','four','five','six')
Across 5 values this might not change much, but it now takes the same amount of work to do it for 100 or 1000
Pro tip for Microsoft. Make SSMS a full fledged code editor.
There is intellisense, so if you declare you variable in the query, you can start to type it and the intellisense will show it. maybe it is an option though that needs to be turned on, but it's definitely in SQL SMSS 18+
ohh this is super man thanks a lot I am gonna use and share it with my colleagues tooo
holy crap, tip 7 just changed my world
Oly color concept i was missing i added that in my small mind. Nice one
Holy crap. That last tip is solid gold. I use joins all the time . 300% less freustration for me.,
Always love your tips!! Thank you!
Great tips. Thank you.
great tips on the shortcuts and status bar. thanks very much
very helpful, thanks!
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?
OMG I know double comment but GOOD LORD I can't believe these gems existed.
Great.
Really Helpful😊😊😊
These tips are amazing... Thanks man
Fantastic tips!! Thanks 👍
Thank you for tips.
Custom colors is very buggy and does not persist. If you want that feature, use ADS
The last one was pretty based
I love the bar tip! Thank you!
Is there a way to connect git from SSMS em submit my t-sql code for versioning?
I want to create a AI for my smart security products.
Any ideas?
Add in a history feature like DBeaver or others do. I know there are SSMS plugins but they are generally bloated.
Recommending control+U to switch database and proceed to use the mouse to switch database on the last tip, how ironic
Ha you didn't even use your own useless ctrl-u tip.
I noticed that but it is not useless. Anything to avoid taking the hand away from the keyboard if not essential.
Yeah, the Ctrl+U tip is crap
I wish MSSMS has a built in "Beautifier" . Copying the code googling beautifier paste it there then bring it back takes a toll on productivity.
Thank You Guys. 😊
SOSSTSE