The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data. After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just […]
2021-09-29
4,602 reads
If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By using UiPath Studio, you can build an RPA program just like drawing a diagram. With the CData ODBC Driver for Oracle, users can embed Oracle data in the workflow. Let’s […]
2021-09-24
1,468 reads
The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolkit to build MongoDB-connected Python applications and scripts. This article details how to use SQLAlchemy to connect to MongoDB data to query, update, delete, and insert MongoDB data. Connecting to MongoDB Data Connecting to MongoDB data is similar to connecting to any other relational database. Create a […]
2021-09-22
4,195 reads
This article shows in detail how to use the Power BI Connector to create real-time visualizations of ServiceNow data in Microsoft Power BI Desktop.
2021-09-20
1,616 reads
Grant Fritchey discusses the relationship between microservices architecture and database deployment and how these two important pieces of the DevOps puzzle, can work together, or against each other in the future.
2021-07-28
During development you need a fast, automated way to build multiple copies of a database on any development or test server, with each database at the right version. This article provides a PowerShell automation script for Flyway that will do the job.
2021-04-02
If you have SQL Compare, then the SQL Snapper utility is very valuable 'extra' for certain team activities, because it can be freely distributed. It means that any developer can create a SQL Compare snapshot from databases that are on their local workstation and store them on the network.
2021-01-22
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,818 reads
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.
2020-11-05 (first published: 2020-10-10)
2,875 reads
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
2,908 reads
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Hello - I have attached a Word document here with details about my issue....
I am having trouble writing linking the MAX query that I created back to...
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers