Perform Data Filtering in Oracle Link to SQL Server
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
2,419 reads
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
2,419 reads
As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]
2020-04-02
1,305 reads
Learn how to restore sql server database using data management provider Rubrik REST API
2020-03-19
2,934 reads
Easily graph your storage needs based on msdb backup data recorded automatically, no matter what your backup solution is.
2020-03-17 (first published: 2020-03-10)
1,701 reads
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
2020-02-24
5,579 reads
Learn how to set up Polybase in containers to access an Oracle database.
2020-01-09
5,197 reads
Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any locks? What commands are being run, who is running them, from where? How […]
2019-12-17
10,035 reads
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers