MongoDB doesn’t have a CREATE DATABASE statement like SQL does.
In MongoDB, you create a database simply by switching to a non-existent database, then inserting data.
Continue readingCategory: DBMS
Database Management Systems
Install MongoDB on Windows
MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.
MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.
You can use MongoDB as a cloud deployment, or as an on-premise installation.
In this tutorial, I install it as an on-premise installation using the MongoDB Community Edition on Windows.
Continue readingInstall MongoDB on a Mac
MongoDB is a general purpose, document-based, distributed data platform built for modern application developers and for the cloud.
MongoDB is classified as a NoSQL database. It uses JSON-like documents with optional schemas.
This tutorial shows you how to install MongoDB on a Mac via Homebrew.
Continue reading4 Ways to Get a List of Schedules in SQL Server Agent (T-SQL)
In this article, I present four options for using T-SQL to return the schedules that are attached to a SQL Server Agent job.
Continue readingCreate a SQL Server Agent Job in Azure Data Studio
In this article, I show you how to create a SQL Server Agent job in the Azure Data Studio GUI.
Here, I create a test job that includes one job step and an attached schedule.
Continue readingCreate a SQL Server Agent Schedule with T-SQL
When using T-SQL, you can use the sp_add_schedule stored procedure to add a SQL Server Agent schedule.
This procedure creates the schedule, but it doesn’t attach it to any jobs. To attach it to a job, you must use the sp_attach_schedule procedure.
You can also use sp_add_jobschedule to create the schedule and attach it all with the same procedure.
How to Locate SQL Server Agent Jobs in Azure Data Studio
I wrote this post, because it may not be immediately apparent how to find the SQL Server Agent jobs in Azure Data Studio once you’ve installed the SQL Server Agent Extension.
In SSMS, the SQL Server Agent can be hard to miss, but in Azure Data Studio, it can be hard to find!
Or perhaps you’re not even aware that you need the extension, and you may be searching for jobs that simply can’t be found.
Here’s how to locate the SQL Server Agent jobs in Azure Data Studio.
Continue reading3 Ways to Return a List of SQL Server Agent Jobs (T-SQL)
Often the quickest way to get a list of SQL Server Agent jobs is to simply expand the SQL Server Agent node in the SSMS Object Explorer.
But that’s not the only way. And depending on your environment, it might not even be an option. If you don’t have SSMS or a database tool that allows you to see the SQL Server Agent jobs, you may need to use T-SQL instead.
In this article, I present three options for returning a list of SQL Server Agent jobs when using T-SQL.
Continue reading4 Ways to Get SQL Server Job History
In this article, I present four options for returning SQL Server Agent job history data.
Continue readingFix “SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries'”
If you get error Msg 15281, Level 16 in SQL Server, chances are you’re trying to run an ad hoc distributed query, but you haven’t enabled ad hoc distributed queries.
This can be fixed easily by enabling ad hoc distributed queries.
Continue reading