About Bilal Shahid
GitHubHello, I am Bilal, a research enthusiast who tends to break and make code from scratch. I dwell deep into the latest issues faced by the developer community and provide answers and different solutions. Apart from that, I am just another normal developer with a laptop, a mug of coffee, some biscuits and a thick spectacle!
Articles by Bilal Shahid
MongoDB Howtos
- How to Connect MongoDB With PowerShell
- Difference Between ObjectId and $Oid in MongoDB
- How to Check if MongoDB Is Installed on Windows
- How to Use an ORM in MongoDB
- Locking in MongoDB
- How to Build a MongoDB REST API
- How to Convert a String to Date in MongoDB
- How to Import CSV Files in MongoDB
- How to Shutdown/Stop MongoDB
VBA Howtos
- How to Convert Text to Number in Microsoft Excel VBA
- How to Unsort Sorted Data in Microsoft Excel VBA
- How to Parse XML in Microsoft Excel VBA
- How to Use for Each on an Array Using VBA
- How to Check if a Cell Is Empty in Microsoft Excel VBA
- How to Convert Integer to String Data Type in Microsoft Excel VBA
- How to Create a Progress Bar in Excel VBA
- How to Import CSV Into Access using VBA
- How to Loop Through Files in a Folder Using VBA
- How to Save as in Microsoft Excel VBA
- How to Use Regular Expressions in Excel VBA
- MsgBox in Microsoft Excel VBA
- On Error Statement in Microsoft Excel VBA
- Project Password in Microsoft Excel VBA
- How to Clear the Immediate Window Using VBA
- How to Parse JSON With VBA
- How to Read a Text File Line by Line in VBA
- How to Reference Another Sheet in VLookup Using VBA
- How to Convert a Column Number to Letter in Excel Using VBA
- How to Copy and Paste Values in VBA
- How to Create an Array From a Specific Range in Excel Using VBA
- How to Open a Workbook by Specifying Its Path in Microsoft Excel Using VBA
- Introduction to Comparison Operators in VBA
SQLite Howtos
- How to Declare and Use Variables in SQLite
- How to INSERT a New Record or UPDATE One if It Already Exists in SQLite
- How to Open a Database File From SQLite
- SQLite Data Types
- SQLite Describe a Table
- Encryption and Password Protection in SQLite
- How to Use JSON Data in SQLite
- How to Use SQLite Electron Module
- Regex Operator in SQLite
- How to Create and Use Temporary Tables in SQLite
- How to Prevent Duplication in SQLite
PostgreSQL Howtos
- PostgreSQL Default Port
- Best Postgres Clients Available for Windows Users
- How to Create a Read Only User in PostgreSQL
- How to Drop Not Null Constraint in PostgreSQL
- How to Install and Start PostgreSQL Server on Mac
- How to Install and Troubleshoot the ODBC Driver for PostgreSQL
- How to Log All PostgreSQL Queries
- How to PostgreSQL - Check Date and Time Relative to Today
- How to PostgreSQL Database Encryption
- Introduction to Views in PostgreSQL
- How to Add PostgreSQL Database as a Maven Dependency
- How to Convert From Unix Epoch to the Date in PostgreSQL
- How to Insert Current Timestamp in PostgreSQL
- PostgreSQL Port 5432
- How to Convert Timezone in PostgreSQL Server
- How to Run PostgreSQL in Memory Only
- How to Select From Dual in PostgreSQL
- How to Transpose Columns to Rows in PostgreSQL
- Alternatives to DATEADD() in PostgreSQL
- How to Grant Privileges to the User in PostgreSQL
- How to Install PSQL Without Installing Full PostgreSQL
- How to Unnest in PostgreSQL
- How to Upgrade the PostgreSQL Server Version Without Losing Any Data
- The DISTINCT Clause in PostgreSQL
- The initdb Command in PostgreSQL
- Varchar vs Text in PostgreSQL
- How to Check if PostgreSQL Is Installed on Linux
- Database Cluster in PostgreSQL
- How to Delete All Table Rows in PostgreSQL
- How to Find and Delete Duplicate Records in a Database in PostgreSQL
- How to Get Array Length in PostgreSQL
- How to Limit Rows in PostgreSQL
- How to Order by Clause in PostgreSQL
- How to Use UTC Current Time as Default in PostgreSQL
- How to Start PostgreSQL Server on Windows
- How to Write Case-Insensitive Queries in PostgreSQL
- How to Configure PostgreSQL in Linux
- How to Create Role or User if It Does Not Exist in PostgreSQL
- How to Comment Characters in PostgreSQL
- How to Select Random Rows in PostgreSQL
- NEXTVAL Function in PostgreSQL
- How to Create a Pivot Table in PostgreSQL
- How to Rename a Table Inside a Schema in PostgreSQL
- How to Run PostgreSQL Queries in PSQL
- How to Save PL/pgSQL Output From PostgreSQL to CSV
- How to Terminate a PostgreSQL Connection
- How to Exit From the Command Line Utility in PostgreSQL
- How to Round an Average to 2 Decimal Places in PostgreSQL
- How to Compare Dates in Datetime Fields in PostgreSQL
- How to Drop Database Through PSQL in PostgreSQL
- How to Subtract a Day From a Timestamp Date in PostgreSQL
- How to Use NOT IN With Subquery in PostgreSQL
- Differences Between the IN and ANY Operators in PostgreSQL
- Foreign Key ON DELETE CASCADE in PostgreSQL
- How to Insert on Duplicate Update in PostgreSQL
- How to List All Tables in PostgreSQL INFORMATION_SCHEMA Table
- How to Remotely Connect to Another Instance Using PSQL
- Default Username/Password for PostgreSQL Server in Rails 4
- How to Add a Unique Constraint After Creating a Table in PostgreSQL
- How to Extract Day of Week From Date Field in PostgreSQL
- How to Kill a Process ID in PostgreSQL
- How to SELECT if String Contains a Substring Match in PostgreSQL
- How to Concatenate Columns in PostgreSQL Using Select
- How to Upsert (Insert on Duplicate Update, Merge) in PostgreSQL With EXCLUDE Values
- How to Upsert (Merge, Insert on Duplicate Update) in PostgreSQL
- Auto Increment Values in PostgreSQL
- Foreign Key Syntax in PostgreSQL
- How to Single Query to Rename and Change Column Type in PostgreSQL
- How to Create Table if It Does Not Exist in PostgreSQL
C# Howtos
- URL Encoding in C#
- Interface vs Abstract Classes in C#
- How to Obtain a Distinct List Based on One or More Properties in C#
- Callback in C#
- How to Draw Circles in C#
- How to Post JSON to a Server in C#
- How to Check for the Existence of a Dictionary Key in C#
- How to Implement a Read-Only Property in C#
- How to Toggle a Boolean Variable in C#
- How to Swap Variable Values Without the Use of Temporary Variable in C#
- How to Convert a Dictionary to JSON String in C#
- How to Implement a Property in an Interface in C#
- Method Group in C#
- How to Convert String to Double in C#