MongoDB: Loop through a collection and update the match
// Get a array with values for name field var botArray = db.bots.find({},{name:1}).toArray(); // loop through another collection
Schedule SQL Server Back ups in SQL Server Express edition manually
This approach is ideal when your SQL server doesn't support SQL Server Integration services for any sort of SQL maintenance. Create a a stored proc in Master Database **sp_BackupDatabases** CREATE PROCEDURE [dbo].[sp_BackupDatabases]
SQL Server function to convert a string to Pascal Case
IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[udf_PascalCase]') AND type IN ( N'FN', N'IF', N'TF', N'FS', N'FT' ) ) DROP FUNCTION [dbo].[udf_PascalCase];
GUID (128 bits) into an int (32 bits)
To achieve Random number generator with GUID internal static int GetIntegerGUID() {
