Why table can have only one clustered index? No it is not what you think.

A really important and interesting post I wanted put out lately. A topic which I would say is a basic core concept but I was surprised how so many people (read DBAs) were wrong about it. Why can't we have more than one clustered index on a table. 

I got many interesting answers for it in many interviews i took recently and some of them I tried to debunked in this blog too and tried to clearly establish on, why we can't have more than one clustered index and what exactly physical sorting means. So read on and enjoy.

Happy Learning!

Why table can have only one clustered index? No it is not what you think.

Happy New Year 2021

 Wishing my dear viewers a very happy new year 2021

How to create job in SQL Server

Hi there. Hope you all are safe and sound. 

In my last post I've talked about an important component i.e. SQL Server Configuration Manager and in this video I've picked up another essential component i.e. SQL Server Agent.

SQL Server Agent itself has two major components i.e. SQL Server Jobs and Alerting mechanism and in this first part I've picked up and explained about SQL Server Jobs. How we can create jobs, what are the options we see and what they mean, how we can schedule them etc. 

SQL Server Jobs is vital part of SQL Server management and indispensable for DBA's where we use jobs to not only to perform database maintenance but also to monitor and collect several important information that can help in diagnosing a bottleneck or performance issue. So, go ahead and watch this video and learn all about SQL Server jobs.

Happy Learning!

As always, please do not forget to click the "like" button if you like the video and subscribe my channel and click that "bell" to stay updated. You can also follow me facebook.

Using SQL Server Configuration Manager

Hello everyone and welcome back. In this video I've talked about one of the important component of SQL Server that gets installed along with our SQL Server Instance i.e. SQL Server Configuration Manager.

SQL Server Configuration Manager is used to set properties related components and associated services. It also helps in managing protocols and connectivity related setting for your SQL Server Instance.

Go through this video to understand how you can access these properties and learn to set correct values for them.

Happy Learning!

As always, please do not forget to click the "like" button if you like the video and subscribe my channel and click that "bell" to stay updated. You can also follow me facebook.

Scripting objects using SSMS

Hello viewers, in this video I've shown how to script objects of your instance quickly and easily using various options available in SSMS.

SSMS provides options to script object out by right clicking on the as well as we have database task to "Generate Scripts" for your database or selected objects.

In this video I've shown both of these methods and have also covered how we can customize them using the various options available to us.

Happy Learning!

Don't forget to hit like if you like the video and subscribe my channel and click the bell icon to stay updated on all latest upcoming videos.

Using GUI of SSMS to create tables and edit data

Hello everyone, this video is in continuation to my last video about SSMS where in I showed how to get started with latest version of SSMS.

In this video I went ahead and have talked about how SSMS provide us with an intuitive GUI format to create tables as well as perform various DML operations like insert or update within GUI. How we can use GUI to get custom views of data as well modify them on the fly.

Please do not forget to hit that like button as well as subscribe my YouTube channel.

Quick fix for error "Windows cannot find SSMS"

Have you recently upgraded your SSMS and are unable to run it using windows "run" prompt. If your SSMS is working fine but you get "Windows cannot find SSMS" error while trying to access using Windows Run Command then watch this video to quickly fix them.

Please do not forget to hit that like button if my video helps you resolve your issue. And also click on that subscribe button and the bell icon to stay updated on my upcoming videos.