| Pretty Links |
https://ajaydwivedi.com/go/links |
https://ajaydwivedi.com/pretty-links/ |
| Carry Over Sort TSQL Script - Erik Darlling |
https://ajaydwivedi.com/tsql/carry-over-sort |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/dev/Advanced%20Query%20Techniques/Carry-Over-Sort-vs-Batch-Mode-Window-Functions.sql |
| Delta Update Stats |
https://ajaydwivedi.com/query/deltastats |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/Maintenance/QRY-Delta-UpdateStats-IndexOptimize.sql |
| Postgres - Explain - Copy of https://explain.dalibo.com/ |
https://ajaydwivedi.com/pg/explain |
https://imajaydwivedi.github.io/pev2/ |
| Rent - Rewa - Flats |
https://ajaydwivedi.com/rent/rewa |
https://drive.google.com/drive/folders/1MhSgxwE9a0ejFZQwnLzlvpNeRGBdgONd?usp=sharing |
| Google Drive Shared Folder |
https://ajaydwivedi.com/share/gdrive |
https://drive.google.com/drive/folders/0B7PUbvl0QLSxcHQzS2s2RzI5T00?resourcekey=0-dizvebF3WzjI_7wu5e8MCw&usp=sharing |
| My Slack Profile |
https://ajaydwivedi.com/go/slack |
https://sqlcommunity.slack.com/team/UA12A4N56 |
| Slack Channel #sqlmonitor |
https://ajaydwivedi.com/sqlmonitor/slack |
https://sqlcommunity.slack.com/archives/C04BN1ZEET0 |
| Contact Me |
https://ajaydwivedi.com/contactme |
https://ajaydwivedi.com/contact-me |
| Reward & Premonitions |
https://ajaydwivedi.com/go/rewards |
https://github.com/imajaydwivedi/Images/tree/master/Recognitions |
| Contact Me |
https://ajaydwivedi.com/contact |
https://ajaydwivedi.com/contact-me |
| Micap Index |
https://ajaydwivedi.com/go/midcapindex |
https://groww.in/indices/nifty-midcap-select |
| Large Cap Index |
https://ajaydwivedi.com/go/largecapindex |
https://groww.in/indices/nifty-218500 |
| Travel Expenses Folder |
https://ajaydwivedi.com/go/travel |
https://drive.google.com/drive/folders/14-d_1HMqhaPZhpw-x4KonMb3j2y0Nxcg?usp=sharing |
| Nifty Midcap 50 Price to Earnings Ratio(PE) |
https://ajaydwivedi.com/go/midcap |
https://trendlyne.com/equity/PE/NIFTYMIDCAP50/1894/nifty-midcap-50-price-to-earning-ratios/ |
| Nifty Smallcap 250 Price to Earnings Ratio(PE) |
https://ajaydwivedi.com/go/smallcap |
https://trendlyne.com/equity/PE/SMALLCA250/910398/nifty-smallcap-250-price-to-earning-ratios/ |
| Nifty 50 Price to Earnings Ratio(PE) |
https://ajaydwivedi.com/go/largecap |
https://trendlyne.com/equity/PE/NIFTY/1887/nifty-50-price-to-earning-ratios/ |
| Permissions Poster |
https://ajaydwivedi.com/go/permissions-poster |
https://github.com/microsoft/sql-server-samples/tree/master/samples/features/security/permissions-posters |
| Scooty Details - Google Drive |
https://ajaydwivedi.com/go/scooty |
https://drive.google.com/drive/folders/18-lECCaUKxsK5H3nSj3mUWM09uexST5D?usp=sharing |
| Car Details on Google Drive |
https://ajaydwivedi.com/go/car |
https://drive.google.com/drive/folders/1jQZdLNowkovvbZ_zhz_muM141uI3snte?usp=sharing |
| LIVE SQLMonitor - Dashboard - All Server |
https://ajaydwivedi.com/demo/sqlmonitor/allserver |
https://ajaydwivedi.ddns.net:3000/d/distributed_live_dashboard_all_servers/monitoring-live-all-servers?orgId=1&refresh=1m |
| LIVE SQLMonitor - Dashboard - Perfmon |
https://ajaydwivedi.com/demo/sqlmonitor/perfmon |
https://ajaydwivedi.ddns.net:3000/d/distributed_perfmon/monitoring-perfmon-counters-quest-softwares-distributed?orgId=1&refresh=5m |
| Live SQLMonitor |
https://ajaydwivedi.com/demo/sqlmonitor |
https://sqlmonitor.ajaydwivedi.com/dashboards?tag=sqlmonitor |
| Join - SqlCommunity.Slack.com |
https://ajaydwivedi.com/join/slack |
https://dbatools.io/slack |
| Airtel Router Config |
https://ajaydwivedi.com/go/router |
https://drive.google.com/drive/folders/1mCyuWkMOGuR2_z4KDfZShhBTz08aKE3K?usp=sharing |
| SQLMonitor - Portal - Credentials |
https://ajaydwivedi.com/go/sqlmonitor |
https://github.com/imajaydwivedi/SQLMonitor#portal-credentials |
| Vaishali - Education - Sponsorship - Slips |
https://ajaydwivedi.com/go/vaishali |
https://drive.google.com/drive/folders/1F2BwLM7e8ipG39WDmgIxVxSutzJ7OGLm?usp=share_link |
| SQLMonitor - Common Errors/Fixes |
https://ajaydwivedi.com/sqlmonitor/common-errors |
https://github.com/imajaydwivedi/SQLMonitor/discussions/170 |
| Recognitions or Awards |
https://ajaydwivedi.com/github/recognitions |
https://github.com/imajaydwivedi/Images/tree/master/Recognitions |
| GitHub - Images Repo |
https://ajaydwivedi.com/github/images |
https://github.com/imajaydwivedi/Images |
| ajaydwivedi.slack.com Workspace URL |
https://ajaydwivedi.com/join/myslack |
https://join.slack.com/t/ajaydwivedi/shared_invite/zt-1gs7v35w3-ZrM~XtJ37EMjMAWjZtU84g |
| Brent Ozar Oct 2022 Fundamentals Training |
https://ajaydwivedi.com/go/brent-training |
https://www.brentozar.com/archive/2022/09/buckle-up-october-is-free-fundamentals-month/ |
| Google Form for Registration |
https://ajaydwivedi.com/go/register |
https://forms.gle/8BqbwcpVwe9k6bYr6 |
| Blog Ideas |
https://ajaydwivedi.com/go/blogideas |
https://docs.google.com/spreadsheets/d/1K4Fs8GcBbeqACA0hHapcbOfONkewOTG9OV0r2E81_A4/edit?usp=sharing |
| Query Softwares - SQL Server Perfmon Counters of Interest - PDF |
https://ajaydwivedi.com/go/perfmonposter |
https://drive.google.com/file/d/1LB7Joo6055T1FfPcholXByazOX55e5b8/view |
| Query Resource Consumption Infra - Top Queries |
https://ajaydwivedi.com/query/resourceconsumptioninfra |
https://github.com/imajaydwivedi/SQLMonitor/blob/master/Sql-Queries/QRY-ResourceConsumption-Infra.sql |
| Query WhoIsActive Infra for Long Running Queries |
https://ajaydwivedi.com/query/whoisactiveinfra |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/QRY-WhoIsActive-Infra.sql |
| NOLOCK Demo Query |
https://ajaydwivedi.com/demo/nolock |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/Demo/QRY-Demo-NOLOCK-StackOverflow.sql |
| NOLOCK Demo Query |
https://ajaydwivedi.com/query/nolock |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/Demo/QRY-Demo-NOLOCK-StackOverflow.sql |
| StackOverflow Sample - Helps |
https://ajaydwivedi.com/go/stackoverflowhelp |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/StackOverflow/Help.sql |
| Query - Remove Single User |
https://ajaydwivedi.com/query/singleuser |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/Misscellaneous%20Queries/QRY-Remove-SingleUser-Database-Mode.sql |
| SQLMonitor Videos |
https://ajaydwivedi.com/youtube/sqlmonitor |
https://www.youtube.com/playlist?list=PLFUGPe1byxeuExQ9Yy4GXFOxhZ3DB6BrW |
| TempDb Saver |
https://ajaydwivedi.com/go/tempdbsaver |
https://ajaydwivedi.com/tsql/whats-consuming-space-in-tempdb |
| TempDb Saver Query |
https://ajaydwivedi.com/sch/tempdbsaver |
https://ajaydwivedi.com/tsql/whats-consuming-space-in-tempdb |
| Index Progress |
https://ajaydwivedi.com/query/indexprogress |
https://dba.stackexchange.com/a/274930/98923 |
| IO Latency TSql Query |
https://ajaydwivedi.com/query/iolatency |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/Other%20queries.sql#:~:text=%2D%2D%09How%20to%20examine%20IO%20subsystem%20latencies%20from%20within%20SQL%20Server%20(Disk%20Latency) |
| SSMS Solution - Github |
https://ajaydwivedi.com/github/solution |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution |
| West Metro Apartments, Chanda Nagar - Google |
https://ajaydwivedi.com/go/westmetro |
https://www.google.com/maps/place/W+Metro+Apartments+Rd,+Chanda+Nagar,+Hyderabad,+Telangana+500133/@17.5005246,78.3258969,17z/data=!3m1!4b1!4m5!3m4!1s0x3bcb929a8ed7e27d:0x20ca0f4ebecc7351!8m2!3d17.5005246!4d78.3258969 |
| Queries - Credential Manager |
https://ajaydwivedi.com/query/credentialmanager |
https://github.com/imajaydwivedi/SQLMonitor/blob/master/Credential-Manager/QRY-Usages-CredentialManager.sql |
| Github - Credential Manager |
https://ajaydwivedi.com/github/credentialmanager |
https://github.com/imajaydwivedi/SQLMonitor/tree/master/Credential-Manager |
| SQLMonitor - Github Project |
https://ajaydwivedi.com/github/sqlmonitor |
https://github.com/imajaydwivedi/SQLMonitor?swcfpc=1#why-sqlmonitor |
| WP Admin |
https://ajaydwivedi.com/wpadmin |
https://ajaydwivedi.com/wp-admin |
| Huawei Dongle |
https://ajaydwivedi.com/go/dongle |
https://docs.google.com/document/d/1Lz4tC6p60YGuNolk8i27rwVYT4aR5g-kuy8KZx5qDxI/edit?usp=sharing |
| IndexOptimize Delta Query |
https://ajaydwivedi.com/query/indexoptimize |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/Maintenance/QRY-Delta-UpdateStats-IndexOptimize.sql |
| Search ERRORLOG |
https://ajaydwivedi.com/query/errorlog |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/ErrorLogs/QRY-Search-ErrorLog.sql |
| WhatIsRunning - Query |
https://ajaydwivedi.com/query/whatisrunning |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/WhatIsRunning.sql |
| WhoIsActive - Usage - Queries |
https://ajaydwivedi.com/query/whoisactive |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/QRY-sp_WhoIsActive-Usages.sql |
| WhoIsActive Modified Definition |
https://ajaydwivedi.com/sch/whoisactive |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/SCH-sp_WhoIsActive_v12_00(Modified).sql |
| Github Query RingBuffer Server Health |
https://ajaydwivedi.com/query/health |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/RingBuffer-PerfMon-CPU-Memory.sql |
| GitHub - SQLDBATools |
https://ajaydwivedi.com/github/sqldbatools |
https://github.com/imajaydwivedi/SQLDBATools |
| Saanvi-School - Google Sheets |
https://ajaydwivedi.com/school/saanvi |
https://docs.google.com/spreadsheets/d/1Ze87eh_z8_iuDf25vWovKxBWOg5i4N4Tt0iuAF25-G4/edit?usp=sharing |
| SMB Share |
https://ajaydwivedi.com/linux/smbshare |
https://www.how2shout.com/linux/install-samba-on-linux-mint-to-share-files-with-windows/ |
| GitHub - Baseline |
https://ajaydwivedi.com/github/baseline |
https://github.com/imajaydwivedi/SQLMonitor#live-dashboard---basic-metrics |
| Smart Goals Sheet |
https://ajaydwivedi.com/go/smartgoals |
https://docs.google.com/spreadsheets/d/1GJG3BUf6nVo7IgMSd3plDxGXQTt6tSmTkkiMwiObWuc/edit?usp=sharing |
| TSQL - Health Check |
https://ajaydwivedi.com/mssql/healthcheck |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution/blob/master/BlitzQueries/RingBuffer-PerfMon-CPU-Memory.sql |
| Medicine Records |
https://ajaydwivedi.com/go/meds |
https://docs.google.com/spreadsheets/d/1HmQnvVnzT-qW6og087HKkX1JUR2BSQ-mbs_6ZUG-mdg/edit?usp=sharing |
| PowerShell - Multithreading |
https://ajaydwivedi.com/ref/multithreading |
https://dbatools.io/multithread/ |
| Anant Pics |
https://ajaydwivedi.com/pics/anant |
https://drive.google.com/drive/folders/1J6AEBari8SCUS1pKlwkP3ng5_im3NmpZ?usp=sharing |
| Saanvi Pics |
https://ajaydwivedi.com/pics/saanvi |
https://drive.google.com/drive/folders/1lYHAlbhxqlrpC7G4zzfeNJEkEZ0lvhGD?usp=sharing |
| Expenses Excel |
https://ajaydwivedi.com/go/expenses |
https://docs.google.com/spreadsheets/d/1J84A63Wy7IBwVDtEGEIg2g-uKt6UlOOBUlpaXnkmq1Q/edit?usp=sharing |
| ITR - Income Tax Returns |
https://ajaydwivedi.com/go/itr |
https://drive.google.com/drive/folders/1DuOoU3hKsHlNBiDgbcyExv6SFB512qGG?usp=sharing |
| PowerShell by Don Jones |
https://ajaydwivedi.com/go/learn-powershell |
https://drive.google.com/drive/folders/1YzQ0pBGlyAv4ZaV7Bn_h2ra2n-sNdPnF?usp=sharing |
| CBT Nuggest - Administration - Videos |
https://ajaydwivedi.com/go/learn-dba |
https://drive.google.com/drive/folders/1_Nx2SsAKrTTOGhTDHoUleB0tWTmUWqoD?usp=sharing |
| Separation |
https://ajaydwivedi.com/go/separation |
https://drive.google.com/drive/folders/1yroLw7HvFphKxoLzTLztx0IKOxBnQsQL?usp=sharing |
| Rent Slip |
https://ajaydwivedi.com/go/rent-slip |
https://docs.google.com/document/d/0B7PUbvl0QLSxM0tsSVVCel9vU1U/edit?usp=sharing&ouid=109881027674622174545&resourcekey=0-4nzRrBfBocE9wXPKwRvxCg&rtpof=true&sd=true |
| OKRs |
https://ajaydwivedi.com/go/goals |
https://github.com/imajaydwivedi/Goals |
| Sql Formatter |
https://ajaydwivedi.com/go/format |
https://poorsql.com/ |
| Desktop - Custom PC |
https://ajaydwivedi.com/go/pc |
https://ajaydwivedi.com/linux/desktop-build-for-sql-server-lab/ |
| Desktop - Custom PC |
https://ajaydwivedi.com/go/desktop |
https://github.com/imajaydwivedi/Training/blob/main/README.md#custom-pc-build---high-end-system-for-virtualization |
| Index Progress |
https://ajaydwivedi.com/go/indexprogress |
https://dba.stackexchange.com/a/274930/98923 |
| sp_WhoIsActive Blocking Tree |
https://ajaydwivedi.com/mssql/blockingtree |
https://ajaydwivedi.com/tsql/sql-server-blocking-tree-identifying-blocking-chain-using-sp_whoisactive/ |
| NuGet Error/Fix |
https://ajaydwivedi.com/go/nuget |
https://ajaydwivedi.com/powershell/error-fix-packagemanagementinstall-packageprovider-no-match-was-found-for-the-specified-search-criteria-for-the-provider-nuget |
| github/SQLDBA-SSMS-Solution |
https://ajaydwivedi.com/go/ssmssolution |
https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution |
| YouTube |
https://ajaydwivedi.com/go/youtube |
https://www.youtube.com/@imajaydwivedi |
| LinkedIn |
https://ajaydwivedi.com/go/linkedin |
https://www.linkedin.com/in/imajaydwivedi |
| github/SQLDBATools |
https://ajaydwivedi.com/go/sqldbatools |
https://github.com/imajaydwivedi/SQLDBATools |
| github/imajaydwivedi |
https://ajaydwivedi.com/go/github |
https://github.com/imajaydwivedi/ |
| Resume Writing & Interviewing Tips |
https://ajaydwivedi.com/go/interview |
https://ajaydwivedi.com/interviewing/resume-writing-interviewing-tips/?swcfpc=1 |
| My Github Resume |
https://ajaydwivedi.com/go/resume |
https://imajaydwivedi.github.io/Ajay_Kumar_Dwivedi.pdf |
| TempDb Saver |
https://ajaydwivedi.com/query/tempdbsaver |
https://ajaydwivedi.com/tsql/whats-consuming-space-in-tempdb |
| Auto-Clearing Blocking Alert |
https://ajaydwivedi.com/go/blockingalert |
https://ajaydwivedi.com/blocking-alert/setup-blocking-mail-alert-on-sql-server/?swcfpc=1 |