This is one of my favorite script which I use most of the time in troubleshooting performance issues on production
Continue readingFind SQL Text of recently executed queries in SQL Server
Finding SQL Text of recently executed queries in SQL Server we can find out SQL Text of recently executed queries
Continue readingHow to know memory usage in SQL Server?
We can find out memory usage of SQL Server by using below scripts. select total_physical_memory_kb/1024 AS total_physical_memory_mb, available_physical_memory_kb/1024 AS available_physical_memory_mb,
Continue readingHow to Add data file or log file in SQL Server?
We can add data and log file in SQL Server through below script. Add data file(.mdf) in SQL Server ALTER
Continue readingHow To Convert Python String To Int
In Python programming, function int() is a standard inbuilt function that converts the string into integer value and function str()
Continue readingPython Program to convert bytes to Kilobytes, Megabytes, Gigabytes and Terabytes
Bytes:- A Byte is just 8 Bits and is the smallest unit of memory . One byte can store one
Continue readingSQL Server – Resolve Error 5030 to Rename Database
When we try to rename the database then getting error below Msg 5030, Level 16, State 2, Line 1 The
Continue readingHow to Install Yarn on CentOS And Fedora
YARN is a advanced package management software for Node.js applications and it is a package manager for the code that
Continue readingHow to Install Latest Node.js and NPM on Ubuntu with PPA
Node.js is an open-source, cross-platform for general-purpose programming and built on Chrome’s JavaScript run-time environment that easily executes JavaScript code
Continue readingHow To Install Latest Nodejs on CentOS/RHEL 8
Node.js is an open-source, cross-platform and built on Chrome’s JavaScript run-time environment that easily executes JavaScript code outside of a
Continue reading