Articles by Bilal Shahid

MongoDB Howtos

1. How to Connect MongoDB With PowerShell
2. Difference Between ObjectId and $Oid in MongoDB
3. How to Check if MongoDB Is Installed on Windows
4. How to Use an ORM in MongoDB
5. Locking in MongoDB
6. How to Build a MongoDB REST API
7. How to Convert a String to Date in MongoDB
8. How to Import CSV Files in MongoDB
9. How to Shutdown/Stop MongoDB

VBA Howtos

1. How to Convert Text to Number in Microsoft Excel VBA
2. How to Unsort Sorted Data in Microsoft Excel VBA
3. How to Parse XML in Microsoft Excel VBA
4. How to Use for Each on an Array Using VBA
5. How to Check if a Cell Is Empty in Microsoft Excel VBA
6. How to Convert Integer to String Data Type in Microsoft Excel VBA
7. How to Create a Progress Bar in Excel VBA
8. How to Import CSV Into Access using VBA
9. How to Loop Through Files in a Folder Using VBA
10. How to Save as in Microsoft Excel VBA
11. How to Use Regular Expressions in Excel VBA
12. MsgBox in Microsoft Excel VBA
13. On Error Statement in Microsoft Excel VBA
14. Project Password in Microsoft Excel VBA
15. How to Clear the Immediate Window Using VBA
16. How to Parse JSON With VBA
17. How to Read a Text File Line by Line in VBA
18. How to Reference Another Sheet in VLookup Using VBA
19. How to Convert a Column Number to Letter in Excel Using VBA
20. How to Copy and Paste Values in VBA
21. How to Create an Array From a Specific Range in Excel Using VBA
22. How to Open a Workbook by Specifying Its Path in Microsoft Excel Using VBA
23. Introduction to Comparison Operators in VBA

SQLite Howtos

1. How to Declare and Use Variables in SQLite
2. How to INSERT a New Record or UPDATE One if It Already Exists in SQLite
3. How to Open a Database File From SQLite
4. SQLite Data Types
5. SQLite Describe a Table
6. Encryption and Password Protection in SQLite
7. How to Use JSON Data in SQLite
8. How to Use SQLite Electron Module
9. Regex Operator in SQLite
10. How to Create and Use Temporary Tables in SQLite
11. How to Prevent Duplication in SQLite

PostgreSQL Howtos

1. PostgreSQL Default Port
2. Best Postgres Clients Available for Windows Users
3. How to Create a Read Only User in PostgreSQL
4. How to Drop Not Null Constraint in PostgreSQL
5. How to Install and Start PostgreSQL Server on Mac
6. How to Install and Troubleshoot the ODBC Driver for PostgreSQL
7. How to Log All PostgreSQL Queries
8. How to PostgreSQL - Check Date and Time Relative to Today
9. How to PostgreSQL Database Encryption
10. Introduction to Views in PostgreSQL
11. How to Add PostgreSQL Database as a Maven Dependency
12. How to Convert From Unix Epoch to the Date in PostgreSQL
13. How to Insert Current Timestamp in PostgreSQL
14. PostgreSQL Port 5432
15. How to Convert Timezone in PostgreSQL Server
16. How to Run PostgreSQL in Memory Only
17. How to Select From Dual in PostgreSQL
18. How to Transpose Columns to Rows in PostgreSQL
19. Alternatives to DATEADD() in PostgreSQL
20. How to Grant Privileges to the User in PostgreSQL
21. How to Install PSQL Without Installing Full PostgreSQL
22. How to Unnest in PostgreSQL
23. How to Upgrade the PostgreSQL Server Version Without Losing Any Data
24. The DISTINCT Clause in PostgreSQL
25. The initdb Command in PostgreSQL
26. Varchar vs Text in PostgreSQL
27. How to Check if PostgreSQL Is Installed on Linux
28. Database Cluster in PostgreSQL
29. How to Delete All Table Rows in PostgreSQL
30. How to Find and Delete Duplicate Records in a Database in PostgreSQL
31. How to Get Array Length in PostgreSQL
32. How to Limit Rows in PostgreSQL
33. How to Order by Clause in PostgreSQL
34. How to Use UTC Current Time as Default in PostgreSQL
35. How to Start PostgreSQL Server on Windows
36. How to Write Case-Insensitive Queries in PostgreSQL
37. How to Configure PostgreSQL in Linux
38. How to Create Role or User if It Does Not Exist in PostgreSQL
39. How to Comment Characters in PostgreSQL
40. How to Select Random Rows in PostgreSQL
41. NEXTVAL Function in PostgreSQL
42. How to Create a Pivot Table in PostgreSQL
43. How to Rename a Table Inside a Schema in PostgreSQL
44. How to Run PostgreSQL Queries in PSQL
45. How to Save PL/pgSQL Output From PostgreSQL to CSV
46. How to Terminate a PostgreSQL Connection
47. How to Exit From the Command Line Utility in PostgreSQL
48. How to Round an Average to 2 Decimal Places in PostgreSQL
49. How to Compare Dates in Datetime Fields in PostgreSQL
50. How to Drop Database Through PSQL in PostgreSQL
51. How to Subtract a Day From a Timestamp Date in PostgreSQL
52. How to Use NOT IN With Subquery in PostgreSQL
53. Differences Between the IN and ANY Operators in PostgreSQL
54. Foreign Key ON DELETE CASCADE in PostgreSQL
55. How to Insert on Duplicate Update in PostgreSQL
56. How to List All Tables in PostgreSQL INFORMATION_SCHEMA Table
57. How to Remotely Connect to Another Instance Using PSQL
58. Default Username/Password for PostgreSQL Server in Rails 4
59. How to Add a Unique Constraint After Creating a Table in PostgreSQL
60. How to Extract Day of Week From Date Field in PostgreSQL
61. How to Kill a Process ID in PostgreSQL
62. How to SELECT if String Contains a Substring Match in PostgreSQL
63. How to Concatenate Columns in PostgreSQL Using Select
64. How to Upsert (Insert on Duplicate Update, Merge) in PostgreSQL With EXCLUDE Values
65. How to Upsert (Merge, Insert on Duplicate Update) in PostgreSQL
66. Auto Increment Values in PostgreSQL
67. Foreign Key Syntax in PostgreSQL
68. How to Single Query to Rename and Change Column Type in PostgreSQL
69. How to Create Table if It Does Not Exist in PostgreSQL

C# Howtos

1. URL Encoding in C#
2. Interface vs Abstract Classes in C#
3. How to Obtain a Distinct List Based on One or More Properties in C#
4. Callback in C#
5. How to Draw Circles in C#
6. How to Post JSON to a Server in C#
7. How to Check for the Existence of a Dictionary Key in C#
8. How to Implement a Read-Only Property in C#
9. How to Toggle a Boolean Variable in C#
10. How to Swap Variable Values Without the Use of Temporary Variable in C#
11. How to Convert a Dictionary to JSON String in C#
12. How to Implement a Property in an Interface in C#
13. Method Group in C#
14. How to Convert String to Double in C#