What are ACID properties and types of files in SQL Server

Howdy there. Welcome back to Sidd's Technolog. Hope you all are doing fine and keeping safe. I started out putting videos regarding SQL Server as you all know and now coming to end of first series where we become acquainted with SQL Server.

In this beginner's course I covered various vital topics where we learned how to setup SQL Server on our system and also become aware about tools we need and how we can use them.

Of Couse this beginner's course is incomplete without talking about an important RDBMS concept i.e. ACID properties. ACID properties is something that all RDBMS systems has to conform with in order to provide consistency of your data and transactions. And in this video I have talked about these properties in detail.

Not only this, I've also tried to cover the hierarchical structure of database's physical storage format in SQL Server as well as what are basic type of files available in it. All this information will form a much required base for our next series or course. So what are you for, jump in and learn this essential concept.

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 on facebook.

Thanks in advance for watching.

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.