- 301
- 852 719
Tech and Art
India
เข้าร่วมเมื่อ 23 มิ.ย. 2020
Hello Mate,
This channel is for moreover related to Database technology. The motive of creating this channel to provide a good content to my starters and beginners, who normally facing issues in his starting industries experience. Also this channel is covering all type of latest technology related stuff and as well as DIY.
Please connect with this channel and do subscribe, likes and share for motivation and also press the bell icon for your future videos notifications.
contact us for any Business query like promotion, paid promotion and sponsorship durgeshthakur131989@gmail.com
Big Thanks to all of you !!!!!!!! :)
This channel is for moreover related to Database technology. The motive of creating this channel to provide a good content to my starters and beginners, who normally facing issues in his starting industries experience. Also this channel is covering all type of latest technology related stuff and as well as DIY.
Please connect with this channel and do subscribe, likes and share for motivation and also press the bell icon for your future videos notifications.
contact us for any Business query like promotion, paid promotion and sponsorship durgeshthakur131989@gmail.com
Big Thanks to all of you !!!!!!!! :)
How to detect and prevent unexpected growth of the TempDB SQL Server TempDB configuration settings
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link
Hi Mate,
Welcome to my channel Tech & Art.
**STAY HEALTHY AND KEEP LEARNING***
***ALWAYS HAPPY AND CONNECTED ***
N/B:-- Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion.
In this session we are going to discuss about How to detect and prevent unexpected growth of the TempDB SQL Server TempDB configuration settings
Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏
***********************************************************
SQL ARCHITECTURE:-
th-cam.com/video/jskazgQ9_VI/w-d-xo.html
SQL SELECT STATEMENT:-
th-cam.com/video/pnCHhOoqrRA/w-d-xo.html
SQL DML STATEMENTS PROCESSING:-
th-cam.com/video/nGd4jvWO4as/w-d-xo.html
SQL AAG
th-cam.com/video/luMWeT_lzww/w-d-xo.html
Linked server
th-cam.com/video/VFxl2KnFNs0/w-d-xo.html
SQL MIRRORING
th-cam.com/video/fHZhE0gKzTQ/w-d-xo.html
SQL REPLICATION
th-cam.com/video/FLsAn38ITvw/w-d-xo.html
SQL LOGSHIPING
th-cam.com/video/BJK06vmy_Kg/w-d-xo.html
th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
th-cam.com/video/b9ryo5lxroc/w-d-xo.html
th-cam.com/video/6IPIM7VTRsY/w-d-xo.html
ORACLE INSTANCE AND DATABASE:-
th-cam.com/video/1UESpY_5R2U/w-d-xo.html
ORACLE INSTANCE STARTUP SEQUENCE
th-cam.com/video/5UqaVVQIEU8/w-d-xo.html
ORACLE INSTANCE SHUTDOWN SEQUENCE:-
th-cam.com/video/M-YEbYHYTr8/w-d-xo.html
SQL SERVER BACKUP/RESTORE:-
th-cam.com/video/Ig7b0va5G-4/w-d-xo.html
th-cam.com/video/fjWzMtyNABY/w-d-xo.html
SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED,
#sqlserver #sqlserverdba #techandart
Hi Mate,
Welcome to my channel Tech & Art.
**STAY HEALTHY AND KEEP LEARNING***
***ALWAYS HAPPY AND CONNECTED ***
N/B:-- Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion.
In this session we are going to discuss about How to detect and prevent unexpected growth of the TempDB SQL Server TempDB configuration settings
Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏
***********************************************************
SQL ARCHITECTURE:-
th-cam.com/video/jskazgQ9_VI/w-d-xo.html
SQL SELECT STATEMENT:-
th-cam.com/video/pnCHhOoqrRA/w-d-xo.html
SQL DML STATEMENTS PROCESSING:-
th-cam.com/video/nGd4jvWO4as/w-d-xo.html
SQL AAG
th-cam.com/video/luMWeT_lzww/w-d-xo.html
Linked server
th-cam.com/video/VFxl2KnFNs0/w-d-xo.html
SQL MIRRORING
th-cam.com/video/fHZhE0gKzTQ/w-d-xo.html
SQL REPLICATION
th-cam.com/video/FLsAn38ITvw/w-d-xo.html
SQL LOGSHIPING
th-cam.com/video/BJK06vmy_Kg/w-d-xo.html
th-cam.com/video/2MhpdyzOS-U/w-d-xo.html
th-cam.com/video/b9ryo5lxroc/w-d-xo.html
th-cam.com/video/6IPIM7VTRsY/w-d-xo.html
ORACLE INSTANCE AND DATABASE:-
th-cam.com/video/1UESpY_5R2U/w-d-xo.html
ORACLE INSTANCE STARTUP SEQUENCE
th-cam.com/video/5UqaVVQIEU8/w-d-xo.html
ORACLE INSTANCE SHUTDOWN SEQUENCE:-
th-cam.com/video/M-YEbYHYTr8/w-d-xo.html
SQL SERVER BACKUP/RESTORE:-
th-cam.com/video/Ig7b0va5G-4/w-d-xo.html
th-cam.com/video/fjWzMtyNABY/w-d-xo.html
SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED,
#sqlserver #sqlserverdba #techandart
มุมมอง: 497
วีดีโอ
Create EC2 Instance and Deployed Jenkins || How to Connect EC2 Instance ||EC2 Instance Creation
มุมมอง 78หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about Create EC2 Instance and Deployed Jenkins || How to Connect EC2 Instanc...
AWS IAM || AWS Identity and Access Management || How to Create User Policies Group and Roles
มุมมอง 432 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about AWS IAM || AWS Identity and Access Management || How to Create User Po...
AWS Account Creation || How to Create AWS Account || How to use AWS portal free of Cost
มุมมอง 742 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about AWS Account Creation || How to Create AWS Account || How to use AWS po...
SQL Server Database Engine cannot obtain a LOCK resource at this time || SQL Server Lock Memory
มุมมอง 3382 หลายเดือนก่อน
ALL RELATED QUERY AND DOCUMENT PLACED HERE:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link DOC NAme Diagnosing The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time.docx Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more li...
SQL Server Trace flag 902 || SQL Server not star5ting post upgrade || Upgrade Issues
มุมมอง 4693 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss aboutSQL Server Trace flag 902 || SQL Server not star5ting post upgrade || U...
SQL Server Always ON Connection Timeout error || SQL Server Always ON issues.
มุมมอง 5113 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about SQL Server Always ON Connection Timeout error || SQL Server Always ON ...
SQL Server Capacity Planing || SQL Server Capacity planing why so important
มุมมอง 4403 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about SQL Server Capacity Planing || SQL Server Capacity planing why so impo...
SQL Server Tempdb Performance || What are the settings needed for SQL Tempdb
มุมมอง 7314 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about SQL Server Tempdb Performance || What are the setting needed for SQL T...
SQL Server High Disk IO || SQL SERVER Database File Latency || SQL DBA
มุมมอง 4304 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link QUERY:- HIGH DISK IO SELECT DB_NAME(mf.database_id) AS [Database Name], mf.physical_name [Physical Name], num_of_reads, num_of_bytes_read, io_stall_read_ms, num_of_writes, num_of_bytes_written, io_stall_write_ms, io_stall, size_on_disk_bytes FROM sys.dm_io_virtual_file_stats(null,null) AS vfs INNER JOIN...
Ad hoc backup SQL Server || Hoe to take || Backup SQL Server
มุมมอง 5265 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about how to fix the sql database connection issues threshold. Stay tuned by...
Key DBA features in SQL Server 2022 , SQL Server 2022 New Features
มุมมอง 8587 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about how to fix the sql database connection issues threshold. Stay tuned by...
Long running Query in SQL Server || SQL Server Database long running query || Performance
มุมมอง 1.5K8 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about how to fix the sql database connection issues threshold. Stay tuned by...
Tempdb files limitation || SQL Server Tempdb Files configuration || SQL Server Tempdb
มุมมอง 8049 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about Tempdb files limitation || SQL Server Tempdb Files configuration || SQ...
How does Max Degree of Parallelism work in SQL Server || SQL Server interview Question || SQL DBA
มุมมอง 1.1K10 หลายเดือนก่อน
QUERY LINK:- drive.google.com/drive/folders/1tBZSoBeKOMR5b4uMSKipE8ops0AjxzTN?usp=share_link Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING ALWAYS HAPPY AND CONNECTED N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. In this session we are going to discuss about How does Max Degree of Parallelism work in SQL Server || SQL Server in...
SQL Server Database Recovery process || SQL Server Database unexpected Shutdown || Recovery Process
มุมมอง 1.4K11 หลายเดือนก่อน
SQL Server Database Recovery process || SQL Server Database unexpected Shutdown || Recovery Process
SQL Server ADR || SQL Server Accelerated Database Recovery || SQL Server New Feature ADR ||
มุมมอง 1.2K11 หลายเดือนก่อน
SQL Server ADR || SQL Server Accelerated Database Recovery || SQL Server New Feature ADR ||
SQL Server 2022 New Features || SQL Server 2022 || SQL Server New Features || SQL Server Performance
มุมมอง 1.8Kปีที่แล้ว
SQL Server 2022 New Features || SQL Server 2022 || SQL Server New Features || SQL Server Performance
MultiSubnetFailover=True SQL Server Always on multisubnetfailover SQl Server Listener
มุมมอง 691ปีที่แล้ว
MultiSubnetFailover=True SQL Server Always on multisubnetfailover SQl Server Listener
Duplicate Index || SQL Server Duplicate Index Causing the Issues || SQL Server Performance Issues ||
มุมมอง 993ปีที่แล้ว
Duplicate Index || SQL Server Duplicate Index Causing the Issues || SQL Server Performance Issues ||
SQL Server Performance tuning Point || How to Start SQL Server Performance tuning || SQL Performance
มุมมอง 1.2Kปีที่แล้ว
SQL Server Performance tuning Point || How to Start SQL Server Performance tuning || SQL Performance
SQL Server Extended Event || How to monitor Extended Event || how to create Extended Event Creation
มุมมอง 853ปีที่แล้ว
SQL Server Extended Event || How to monitor Extended Event || how to create Extended Event Creation
How to use Query Store || SQL Server Query Store || What is Regressed Query || SQL Server
มุมมอง 1.1Kปีที่แล้ว
How to use Query Store || SQL Server Query Store || What is Regressed Query || SQL Server
Trace Flag T1800 || Slow synchronization | when disks have different sector sizes in SQL Server AG
มุมมอง 653ปีที่แล้ว
Trace Flag T1800 || Slow synchronization | when disks have different sector sizes in SQL Server AG
SQL Server Disk high IO Latency Issues | SQL Server Disk Performance Issues | SQL server Performance
มุมมอง 1.6Kปีที่แล้ว
SQL Server Disk high IO Latency Issues | SQL Server Disk Performance Issues | SQL server Performance
Backups Trace Flag T3226 || What is Trace Flag T3226 and why it's useful || || SQL Server Backup
มุมมอง 954ปีที่แล้ว
Backups Trace Flag T3226 || What is Trace Flag T3226 and why it's useful || || SQL Server Backup
Always ON Automatic seeding or Direct Seeding || Always ON Automatic Seeding new Features |
มุมมอง 1.5Kปีที่แล้ว
Always ON Automatic seeding or Direct Seeding || Always ON Automatic Seeding new Features |
SSMS installation Loading Packages Issues || How to Resolved SSMS Installation Issues || SSMS 2023
มุมมอง 2.1Kปีที่แล้ว
SSMS installation Loading Packages Issues || How to Resolved SSMS Installation Issues || SSMS 2023
SQL Server Replication Issues| SQL Server Replication ANSI_PADDING issues | How to fix ANSI_PADDING
มุมมอง 1.2Kปีที่แล้ว
SQL Server Replication Issues| SQL Server Replication ANSI_PADDING issues | How to fix ANSI_PADDING
SQL Server Virtual Log Files VLF || SQL Server VLF || SQL Server VLF Count
มุมมอง 1.1Kปีที่แล้ว
SQL Server Virtual Log Files VLF || SQL Server VLF || SQL Server VLF Count
Very informative. Thank you
server role script not available on google drive link posted by you sir. please upload it.
Nice explanation sir I got clarification on this
Good info...can you please share the script with us sir😊
Sir i have two offer letters from Accenture anf kyndryl (on-site) both are offering same ctc but Accenture is in bhubaneswar and kyndryl is in banglore.i am confused can you pls suggest which one is better?
very well explained. Thanks
Please share the script
Thank you for the information. I have a database of approximately 50 TB. If I keep ADR enabled continuously, what disadvantages might I face? Best regards
Excellent explanation, i need documents dor MSI patching
Thank you for the information sir. Please share the script.
Thank you for the information sir. Please share the script.
Excellent sir
cut the music pls
Even the backup gets skipped if this feature is enabled. Not sure through native, But through commVault its getting skipped. Another disadvantage (major).
Everything is created and installed perfectly. Good job 👏
Nice explanation 🎉
Great explanation, thank you.
Hi sir, Can I change the time zone settings on running db server through taking downtime
Thank you so much sir for telling us to analysis of queries with dev 🙏
Thanks for your efforts
Thank you! Very easy to follow
What if the this select command run by client side system and how to fetch this type of info 🤔
Can you Pls Share The Script Sir
Is there any way to monitor the process after initiating the patch?
This lesson was very 👍 nice sir
Very clear explanation
Very good explanation ❤
I have 350 million rows to return but would like to keep the last 13 months and archive about 6 years of data!
I am getting ssl security error when connecting odbc to SQL server.. Could you please help? Tls1.0 already enabled on sql server.
Please share the vbs script..thanks
Thankyou sir🙏
Thanks. Where is the script? I watched a couple of your videos and you said you will share the script but I cannot find it.
Can you please share me the scripts ?
Appreciate. Thanks.
Pls share the scripts or share the link where you save or share
Hi could you please share the document please
Hi Sir, It was very useful for me to Fix MSI but MSP Document I am unable to run the Js file. Could you please share the doc with me
Good video and explaination.
Nice learning thanks 👍
Thanks for your time watching your Video from Adelaide Australia as a MS SQL DBA
Please explain with practical example sir Theory we will get in google
I just want to say Thanks I am able to do it for one of the server
Is there any powershell module we need to install before running the script? Or normally we can execute as such ?
Can you explain the quey please
Thank you.
Thank you so much. This helped me understand better.
Thanks for the script.
nice explain and it got useful to us in one of the issue
Wow simplified explaination sir. Thanks for sharing your valuable kanowledge with us :)
Wow perfect explanation sir tysm :)
Can you please share that query in description