MS SQL SERVER DBA

SQL Server 2016 Windows Server 2016 Firewall Rule Step-By-Step. Opening Firewall in SQL Server 2016. Once the SQL Server is installed on the machine. We must enable the incoming traffic i.e., from the application to the SQL Server Database. For this purpose, we must create rule for SQL Server ports so that the application can connect to database & perform the CRUD operations on the tables. Now Let’s start Step-by-Step to enable it. 1.   Start System and Login (As Administrator); 2.   Open Control Panel. Click on Windows Firewall; 3. Now click on Advanced Settings; 4. Windows Firewall console open. If you click on Properties (right side) – you can disable firewall for all networks. We going to Inbound Rules (left side) for our rule creation; After Clicking on the Inbound rules. We will see the below screen.  Click on New

YouTube Video's Links of SQL Server. Monitoring of Database Objects for Space Issues https://youtu.be/ywfEeHnr8sw Please Like, Subscribe, share the videos of my channel...!!! Increase in the Growth of the Log File | SQL Server https://youtu.be/eWvfwqPB6to Please Like, Subscribe, share the videos of my channel...!!! To find the Active Running Transactions on SQL Server. https://youtu.be/6jPl1jKRfvU Please Like, Subscribe, share the videos of my channel...!!! Shrinking a Log File of a Database in Always on Availability. https://youtu.be/VKlbiz-HNbQ Please Like, Subscribe, share the videos of my channel...!!! Self Introduction and Responsibilities of DBA. https://youtu.be/Td-8nQ6cRe4 Please Like, Subscribe, share the videos of my channel...!!! Re-Indexing of Database. https://youtu.be/0Dd2ylJBjG8 Please Like, Subscribe, share the videos of my channel...!!! Shrinking of LDF and MDF Files on Drives https://youtu.be/LtbSaiHu6Ho Please Like, Subscribe, share t