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,418 reads
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
2,418 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,300 reads
Learn how to restore sql server database using data management provider Rubrik REST API
2020-03-19
2,931 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,696 reads
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
2020-02-24
5,566 reads
Learn how to set up Polybase in containers to access an Oracle database.
2020-01-09
5,191 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
9,988 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers