How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique should be applicable to any RDBMS.
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
Learn how you can share your Power BI report with others in the public. Steve shows how his data in Google Sheets is added to Power BI and then made public in a report.
Today Steve encourages everyone to feel welcome in the data professional community.
In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.
How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.
However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them.
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers