- Видео 301
- Просмотров 859 155
Tech and Art
Индия
Добавлен 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:-
ruclips.net/video/jskazgQ9_VI/видео.html
SQL SELECT STATEMENT:-
ruclips.net/video/p...
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:-
ruclips.net/video/jskazgQ9_VI/видео.html
SQL SELECT STATEMENT:-
ruclips.net/video/p...
Просмотров: 609
Видео
Create EC2 Instance and Deployed Jenkins || How to Connect EC2 Instance ||EC2 Instance Creation
Просмотров 802 месяца назад
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
Просмотров 462 месяца назад
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
Просмотров 3662 месяца назад
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
Просмотров 4873 месяца назад
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.
Просмотров 5434 месяца назад
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
Просмотров 4594 месяца назад
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
Просмотров 7564 месяца назад
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
Просмотров 4445 месяцев назад
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
Просмотров 5336 месяцев назад
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
Просмотров 8717 месяцев назад
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,5 тыс.8 месяцев назад
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
Просмотров 8219 месяцев назад
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,1 тыс.11 месяцев назад
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,4 тыс.11 месяцев назад
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,3 тыс.Год назад
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,8 тыс.Год назад
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
Просмотров 711Год назад
MultiSubnetFailover=True SQL Server Always on multisubnetfailover SQl Server Listener
Duplicate Index || SQL Server Duplicate Index Causing the Issues || SQL Server Performance Issues ||
Просмотров 1 тыс.Год назад
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,2 тыс.Год назад
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
Просмотров 867Год назад
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,2 тыс.Год назад
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
Просмотров 663Год назад
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,7 тыс.Год назад
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
Просмотров 955Год назад
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,5 тыс.Год назад
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,1 тыс.Год назад
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,2 тыс.Год назад
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,1 тыс.Год назад
SQL Server Virtual Log Files VLF || SQL Server VLF || SQL Server VLF Count
Thank you Sir. Still relevant
Pleas don't mislead people if you do not intent to share the script!
Hey many times I said ... Go to my recent video description and there you will find google link ..all scripts are there ..
excellent explanation sir. please can you share those script files. thanks
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