If you encounter error Msg 15123, Level 16, reading “The configuration option ‘Agent XPs’ does not exist“, you were probably trying to execute EXEC SP_CONFIGURE 'Agent XPs' while advanced options are hidden.
This error is easily fixed.
how to
2 Ways to Delete a Database in MongoDB
If you no longer need a database in MongoDB you can delete it.
Technically speaking, the term normally used for deleting a database is drop. To drop a database is to delete it.
In any case, below are two ways you can drop/delete a database in the mongo shell.
How to Prettify Exported MongoDB Documents in mongoexport
When you use mongoexport to export documents in MongoDB, you have the option of “prettifying” them.
By this I mean, instead of the document being presented on one long line, it instead includes line breaks, indents, etc to make it easier to read.
To do this in mongoexport, use the --pretty parameter.
5 Ways to Check the Size of a Collection in MongoDB
In this article I present 5 ways that you can use to check the size of a MongoDB collection when using the mongo shell.
How to Fix “Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.” Error in SQL Server
It’s quite easy to encounter error Msg 214, Level 16 when executing stored procedures such as sp_executesql or sp_describe_first_result_set.
Fortunately it’s easy to fix too!
The most common reason for getting this error is that you forgot to prefix your string with N.
Therefore, to fix this issue, try prefixing your string with N.
3 Ways to Extract the Month from a Date in SQL Server (T-SQL)
Here are three T-SQL functions that you can use to extract the month from a date in SQL Server.
5 Ways to Insert Documents in MongoDB
MongoDB provides many ways to insert documents into a collection.
Here are 5 ways to insert documents into a collection when using the mongo shell.