Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.
2020-09-03
2020-09-02
Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.
2020-09-02
This article will demonstrate how to get started with Delta Lake using Azure Data Factory's new Delta Lake connector through examples of how to create, insert, update, and delete in a Delta Lake.
2020-09-01
Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.
2020-08-31
Starting out a new database development with source control is relatively easy. To introduce source control into an existing database application can be more challenging. Phil Factor explains some of the fundamental steps.
2020-08-28
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
2020-08-28
If you haven’t used a date table before, here are a couple of primers on how to create one and use it.
2020-08-27
In this article we look at some simple ways to test a SQL Server developers T-SQL skills with some query questions and answers.
2020-08-26
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
We are trying to update a sqlservice account from a user account to a...
Hi there! This should make some eyes roll for some of you DBA's out...
For myself this seems to work and for other users they receive this error:...
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
See possible answers