SQL Server provides the sys.time_zone_info server-wide configuration view to return a list of supported time zones.
You can retrieve these with a simple SELECT statement.
Get the Current Time Zone of the Server in SQL Server (T-SQL)
Microsoft introduced the CURRENT_TIMEZONE() function in SQL Server 2019 for returning the time zone of the server.
More specifically, this function “returns the name of the time zone observed by a server or an instance”.
Continue reading4 Ways to Update a Document in MongoDB
MongoDB provides various ways to update a document. The method you use will depend on exactly how you want to perform the update.
This article presents 4 ways to update a document in MongoDB.
Continue readingMongoDB $push vs $addToSet: What’s the Difference?
MongoDB has a $push operator and an $addToSet operator, both of which do a very similar thing.
Both operators append values to an existing array. The main difference is in how they deal with arrays that already contain the value you’re trying to append, and also in the modifiers that can be used.
Continue readingHow to Delete a SQL Server Agent Job in Azure Data Studio
If you’ve installed the SQL Server Agent extension in Azure Data Studio, you will be able to see a list of SQL Server Agent jobs, as well as create, edit, view history, etc.
But you may be wondering how to delete a job.
If so, read on.
Continue reading4 Ways to Find Out What Columns will be Returned by a Stored Procedure in SQL Server
If you ever find yourself in the situation where you’re about to execute a stored procedure, but you suddenly catch yourself. You wonder “How many columns does this thing return? Which tables? Does it query a remote server?”
The good news is there are several ways to get this information before you run the query. Let’s look at them.
Continue readingFix “index name must be a string” when Dropping Multiple Indexes in MongoDB
If you encounter the “index name must be a string” error when dropping multiple indexes in MongoDB, it’s probably because you’re passing the specifications document instead of the name.
When you use the dropIndexes() method or the dropIndexes command to drop multiple indexes, you need to pass the index names (not the specifications documents) in an array.
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator (SQL Server)
If you’re running a query in SQL Server, and you get the following error…
Msg 104, Level 16, State 1, Line 8
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.…you should check your SQL statement – you’ve probably omitted a column from your SELECT list.
As the error message implies, you’ll probably only see this error if you’re running a query that contains a UNION, INTERSECT or EXCEPT operator.
Simply adding the column to your SELECT list should fix the problem.
7 Ways to Check your MongoDB Version
If you’re wondering what version of MongoDB you’re running, here are 7 ways you can use to check.
Actually, some of these check your MongoDB server version, and some check your mongo shell version. In any case, let’s take a look.
Continue readingRename a Primary Key in SQL Server (T-SQL)
In SQL Server, you can use the sp_rename stored procedure to rename a user created object in the current database, including a primary key.
This can be handy if you’ve got a primary key that had its name automatically assigned, and you now want to give it a more readable name.
When you create a primary key without explicitly providing a name for it, SQL Server automatically delegates a name for it. Such names typically include a long numeric suffix, which makes it harder to remember. If you need to refer to that primary key (e.g. in your code, documentation, etc), such names can make your life more difficult. Fortunately, sp_rename provides a quick and easy way to change this name.