Tips and Tricks for Using SQL Server Management Studio Effectively
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features. Join Greg to see his favourite tips and tricks for working with SSMS.
Greg Low is a long-term Data Platform MVP and member of the Microsoft Regional Director program. He regularly speaks at conferences and tier-1 eventsworld-wide, and is a consultant for some of the world's more complex SQL Server environments. Greg is the author of a free SQL Server toolset called SDU Tools (sqldownunder.com/sdu-tools) and of a number of books and whitepapers. You can find more info on Greg here:greglow.me
Links to PASS and our Site:
PASS: Pass.org
DBAFundamentals: fundamentals.pass.org/default...
Why to Go: • Why Go to PASS Summit?
Use our discount code VGDISM843 to save $150.00 off the full price of PASS
Registration can be completed here: www.pass.org/summit/2019/Regi... - วิทยาศาสตร์และเทคโนโลยี
Brilliant! I’ve been working SQL Server since 7.0 and the various interfaces. I’ve been working with SSMS for so long that I thought, ‘eh, pretty certain I know my way around it I’ll check it out.’ I’m open to learning something to make me more efficient.
‘F7’ was quite interesting. Didn’t know that before this. I didn’t know you could drag “Columns” to the editor or hover over * to see the columns in the SELECT list.
The clipboard ring was a new thing for me.
I spend a lot of time tuning queries and in the execution plan. I’ve known about that little + for a while. Good to show others.
Still tripping out over the ‘F7’ details.
I typically write scripts to write scripts for me. Script out the dropping or creation of constraints, or any object, for that matter, generation of c# code for a stored procedure/function. It’s a lot faster to write a T-SQL statement to do the repetitive work for me. I give it an object name and milliseconds later, I can copy and paste.
Thanks Sir for making such informative video, You are Very Helpful !
You really saved me from lot of worries. Thanks
Thank you very much for sharing your knowledge, Sir!! Great exposition!
I see a few tricks I know and use, and a few I'm going to make a point of getting into regular use. Thanks for the content.
Amazing! Thank you Greg!
I was searching many thing which you have taught here. I didn't find most of the things in the web which I found here. This video is like finding a treasure box out of nowhere.
Than You so much Sir.
You're very welcome!
Thank you for sharing your Brilient knowledge with us .
I'm a new DBA for a tiny cloud database. Extremely helpful!!!
Great tricks! Thanks a lot!
Thank you very much, this helped me a lot. 🤩
Great video. Thanks. Even though this is a year old, I have a question. I have a folder on one drive where I wrote code, but I can't find it using explorer. How can I search for code in *.qry files? Thank you!
Wow, very clear and useful. Thanks!!!
Wow ,this is really helpful .
Impressive!
Thank you, I'll subscribe to SDU immediately.
Thank you. Good one
Thanks SDU. I learned a couple of useful tips from this though I've been using SSMS for several years. Do you have tips for Data Studio?
Great!!
👏great tips
my problem in sql is when i upload data with decimals, SQL automatically round up/down decimals. And when i divide, it automatically round up. i'm a newbie here.
Thanks alot..This is great video....Thumbnail not justifying greatness of information provided in video
How do i version control using ssms ?
Great video 👍
nice
good
Well, it would be great to follow the instructions and everything being said there but without an existing/accessible data base the commands will remain theoretical.
it's really used
"heeyah"? did I spell that right? what does it mean?