Awesome, Tim! Keep up with SSMS intermediate to advanced videos! 😁

Been using SSMS for years... but learned a few things. Yet another awesome video.

I realize this was a year ago but your reference to highlighting code to run and being careful with delete statements. I feel much better that you pointed that out ; as that was one of my worst memories starting out 15+ years ago. I had a Delete statement with a where stated. But a sensitive mouse and on my way to the Execute button I accidently RE-highlighted the script WITHOUT the Where and continued on to the Execute button, all in one motion. My team never heard a mouth like that or since, lol.

I agree with the comment about entity framework. Regardless of the data access tool - ie Entity Framework - you need to know the execution plans it will use or your performance will take a hit, especially on larger databases.

Please make a video on Indexes and more specifically Query Performance Fine Tuning Tim

Wow coming right on time as usually, looking forward for the next video about t-sql. When you write a stored procedure what should you write and why in every stored procedure things like on error rollback = true or something like that so it would run smoothly and safely on the production without timeouts. Now because I am doing everything locally everything works great but already thinking few steps ahead of how to set up stored procedures for the production. Hoping that this question can be answered in one of the next videos.

Just FYI, I'm a C# developer and at least 25% or more of my time is in SSMS.

Thanks great introduction!

I use this application daily so it is good that you are covering this important topic.

Do you have a course on ms sql or ssms, yours is by far the most helpful sql intro that I have watched!

I would highly recommend as a free add-on for SSMS, red gate's SQL Search. Very useful

Thanks Corey! Please make a follow up video intermediate to advanced :)

Just to say you are awesome. Greetings from Serbia.

Thank you, this is exactly what I need right now

Great Video

Will you please make a video on How to manage memory management in .NET Core?

Awsome Tim! Thanks :)

Hey there, god bless your efforts. i have a simple enquiry as a newbie. Does a cursor keep track only of the records in the result set or can it return to the original table? Thanks a lot.

Do you use Azure Data Studio for any of your dev work? I was wondering because Azure Data Studio is automatically installed alongside SSMS.

Is attaching a database (via SSMS) to an existing visual studio proj (e.g. .NET Core Web API) a reliable way to have your table data transfer to other environments?

Isn’t that localdb thing just a logical endpoint, your actual database was in the appdata folder of the logged in user?

Great! Will you do one for azure data studio?

It's trying to remove the GUI unless you use Azure

love ya tim

Can MSSQL be used without Azure? Is MSSQL cloud based?

I have a question. you said a business would use a paid version of sql server. I've been in businesses where they were able to use sql server express and it worked fine. Which was great because there was one job where if the express version was not available, then i would have been out of luck because i only got paid 40 to 50 dollars a month and could not afford to pay out of pocket and the business would not be able to afford it either. I would think in most cases, sql server express is the best. i do know if the database size was too large, then they would be forced to pay a lot more for a paid version. the sql server developer version seems useless because of the restrictions.

Have to admit, not watched the video (yet) as I use SSMS v18 daily, the one thing I hate is they removed the run in debug and breakpoints from SSMS. WHY! Have they brought it back for v19, doubt it? Tim, maybe a video about doing SQL stuff and debugging in Visual Studio (unless you have one already). Edit, NVM -- found you already have one -- kzfaq.info/get/bejne/n9B0lqt43d_VdWg.html

How can I sent u a direct private message

What is Sequel? :) Please say: S Q L

You should have at least mentioned that "sa" is system admin, "dbo" is database object, it's schema not owner. Maybe you should have mentioned the schema existence at least - access rights can be configured etc. The second part of the video sounds improvised and boring because it shows almost nothing. You used to have very informative videos with every unknown detail explained but this one isn't one of them.