Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
The post SQL Server Graph Tables – Cross Database Surprises appeared first on SQLServerCentral.

Without someone on your team experienced at putting DevOps into practice, it can be difficult to know how to get started. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover his top tips on how to kick start DevOps in your organization.
The post Webinar | Kick start your DevOps Initiative appeared first on SQLServerCentral.

Explaining some of the 'gotchas' that can trip up the unwary Flyway user, and how to avoid them. One or two of these you'll encounter quickly, such as the case-sensitivity of parameters and arguments. Others, such as potential problems with undo scripts or running scripted callbacks, only when you are tackling more complex development processes.
The post Flyway Gotchas appeared first on SQLServerCentral.

Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines.
The post An Introduction to Flowlets in Azure Data Factory appeared first on SQLServerCentral.

There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.
The post Tips and tricks with DAX table functions in paginated reports appeared first on SQLServerCentral.

In this article we walk through things you should know to create new tables in SQL Server using the SQL Server Management Studio interface.
The post How to create a table using SQL Server Management Studio appeared first on SQLServerCentral.

In case you missed it! Before you get very far with database development you need to be clear about your strategy for handling data. In this article I'll explain some of these issues in general terms, and then demonstrate how you can navigate these problems easily with Flyway.
The post ICYMI: Dealing with Database Data and Metadata in Flyway Developments appeared first on SQLServerCentral.

This wizard migrates SSIS Catalog from one server to another in just a few clicks.
The post Migrate the SSIS Catalog in Just a Few Clicks appeared first on SQLServerCentral.