Efficiently Polling Remote Data Sources
In this article, Edward Pollack describes some of the issues when querying against remote data sources. He covers remote SQL Servers and also connecting to a PostgreSQL database.
2020-10-30
Additional Articles
Format your own SQL code using this free online formatter
Redgate have launched their very own Online SQL Formatter powered by SQL Prompt. Visit the page here to try formatting your SQL code with a few pre-defined styles, or find out how to create and share your own styles with SQL Prompt.
2020-10-30
Adding Custom Stored Procedure Templates to SQL Server Management Studio and Visual Studio 2019
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
2020-10-29
Create a Feedback Loop between Devs and DBA Teams with Monitoring
With remote working still encouraged around the world, there is a need to ensure that operations teams have full visibility of your estate, not just your production servers. If your engineering teams have access to secure development and testing servers, deployment issues are caught before they reach production. Find out how to keep communication flowing between DBA and development teams in this free whitepaper. Read the whitepaper here.
2020-10-29
Why choose Oracle?
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.
2020-10-28
Execute SSIS Package from PowerShell - Part 1
In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.
2020-10-27
Let’s move: Azure Resource Mover
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.
2020-10-26
Monitoring Amazon RDS with Redgate SQL Monitor
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.
2020-10-26
Azure Data Factory Pipelines: Filling in the gaps
Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In this article, Rodney Landrum recalls a Data Factory project where he had to depend on another service, Azure Logic Apps, to fill in for some lacking functionality.
2020-10-23
Monitoring Amazon RDS with Redgate SQL Monitor
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 this 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.
2020-10-23
Blogs
Daily Coping 30 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
ASF 034: Alex Yates interview (part 1)
By Kamil
Introduction Alex is a Data Platform MVP who loves DevOps. He’s has been helping...
Blog .NET for Apache Spark UDFs Missing Shared State
By Ed Elliott
The Problem When you use a UDF in .NET for Apache Spark, something like...
Forums
Any way to use ReportServer in HA AND have two separate SSRS servers?
This is a little awkward to explain, but we have 2 SQL Server instances...
How to improve the performance of insert?delete?update sql statement
as it was said in the title, which we should pay attention to when...
TDE Drama
My workplace uses a 3rd party key management system as an encryption provider for...
Ask SSC