Bilal Shahid

2. Author
3. Bilal Shahid

MongoDB Howtos

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

VBA Howtos

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

SQLite Howtos

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

PostgreSQL Howtos

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

C# Howtos

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