Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.
Losing your instance might result in the need to get information from what you have. Steve Jones looks at a way to get the proper version and patch, and database list, from what limited resources you might have.
IBM is breaking up and Steve thinks back about the evolution of the company and where they might go from here.
In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.
SQL Server shares some data with Microsoft, but the use is documented. Steve sees this as a model for how companies might share information.
Moving resources from one location to another in Azure has been possible but not easy to do. In this article, Dennes Torres introduces an exiting new Azure feature: Azure Resource Mover.
With the launch of SQL Monitor 11, you can now monitor your SQL Servers hosted on Amazon RDS alongside your on-premises and other cloud-based servers, instances, and databases. Join our webinar on October 28 to discover the benefits of monitoring your entire estate; including on-premises and cloud-hosted databases, from a single pane of glass.
The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]
I usually write about SQL Server, but I thought I'd share my experience of using SQL Server from MuleESB. If you haven't used Mule before, it's an open-source ESB (enterprise service bus), which also has a paid-for Enterprise version. I've been using it since 2015 and have been impressed with how quickly we can create […]
-WhatIf you could see what would happen if you ran a command?
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers