SQL Server Performance & Troubleshooting – Where Milliseconds Matter 🚀

Hello friends,  Welcome back to this new post.   I was thinking. The same job is now done in a different way. I can wear more casual attire, but surely not seeing students' faces live during classes makes it less easy to teach them. If, on the other hand, I have to concentrate, I prefer to be alone in my studio and carve out moments in which to share work with my team. Rember, it is important to communicate. It's important to team up! This is the summary of concept of smartworking as I understand it. But it does not matter, because everything advances and often there is no choice. As usually enjoy the reading!      Impress your boss with a professional report  Let me tell you, Scripts done with the SQL Server Management Studio are old! I am sure you have thousands SQL Server Scripts and it is not easy to keep in order all that materials. For these reason today we talk about the notebook feature of which we already talked about here How to upgrade the SQL ...

Hi Guys, Welcome back! I hope you and your family are fine. Today, after some posts about spatial data type and Machine learning, we will have a light post in which we will talk about the SQL server management studio. But not only...   Introduction What is the SQL server management studio or briefly SMSS? Well the SSMS is simply a graphical interface to access to the SQL Server database Engine. For example with the SSMS you can execute every T-SQL command or set options. But remember:   Everything you can do with the SSMS you can do sending command directly to the database engine . Remember also the is always recommended to use the last SSMS . This is because at each version bugs are fixed and new functionality are inserted. This month Microsoft released the version 18.5 so what better opportunity to show you how to install this new version? Are you Ready? How to install the last SSMS version This is easy. First download the last SMSS version fr...