As far as I am aware, they are the same. The command runs the same between Windows and Linux and I haven't found any command options in DBCC CHECKDB that work on Windows but not Linux.
I've never written anything on replication other than this video. The notes for the video (including code) are at 36chambers.wordpress.com/2024/02/20/video-transactional-replication-in-sql-server-on-linux/ but that's about it.
I have a link in the show notes containing this information: 36chambers.wordpress.com/2024/02/20/video-transactional-replication-in-sql-server-on-linux/ I just updated it to include a copy of the BLS database.
Not as such, no. I do have a couple playlists that are potentially relevant, though: - SQL Server installation and configuration: ruclips.net/p/PLeWL8zChJ2us9eZJJl0RJd1i0kwFg9Mjs - Writing queries in SQL Server: ruclips.net/p/PLeWL8zChJ2usuvVEHGl2BykCQ6SaiZgrW I do have some ideas on my backlog for future videos, but if there are any particular topics of interest, let me know and I'll see what I can do.
I basically wanna go through MSSQL server on windows covering full tutorial from installation to the end. The current playlist of linux (though short but pretty clear) is excellent. Following this playlist, I have setup the availability group which works perfect. What's missing is availability group using pacemaker, which would have been great had you added that. Anyways excellent work you are doing and I am looking forward for a complete DBA training using MSSQL on windows.
@@FaizanFastian23 That's fair enough. I can certainly add it to the backlog. It'd be a longer-term project, so no hard dates on anything, but would be something in the channel's wheelhouse.
Hey Kevine, great vide, i'm trying to rid of windows so i'm using SQL for linux i'm running SQL on docker using ubuntu , is there any way to implement merge replication, i'm using SSMS 18 , i'm already implement it on windows and it is working
Merge replication is not supported on Linux, no. Merge replication tends to be something of a laggard for most features. You'll see transactional and snapshot replication support in a variety of features but merge and peer to peer are much less likely to be supported when new things come out, including SQL Server on Linux. learn.microsoft.com/en-us/sql/linux/sql-server-linux-replication?view=sql-server-ver16#supported-features
@@KevinFeasel so can i set Bidirectional Transactional Replication on Linux , I want the subscriber pull the data from the publisher and in some times subscriber can make some changes , i want to move out of windows to use linux and docker container
@@HusseinSaeed-ex7pm This is where the documentation gets a little tricky. There's nothing saying you *cannot* use bidirectional transactional replication, but there's also nothing explicitly saying you *can*. I haven't tried the scenario, to be honest, so I don't know whether that's possible. I'd recommend trying it out to see. If you made me give my prior probability on success, I'd say about 30% chance of success, as it's a more complicated replication scenario than normal transactional replication and unless there were Microsoft customers clamoring for support of that particular feature, it'd probably be low on their implementation list. But there is a chance bidirectional replication came "for free" with the normal transactional replication code--the only way to know for sure is to try it and see if it works.
Can you please confirm me whether DBCC CHECKDB command to repair database is same in Windows and Linux Server?
As far as I am aware, they are the same. The command runs the same between Windows and Linux and I haven't found any command options in DBCC CHECKDB that work on Windows but not Linux.
@@KevinFeasel Thnks
Hey do you have documentation for the replication (ur documentation not from Microsoft) .. that will be helpful thank you 🙏
I've never written anything on replication other than this video. The notes for the video (including code) are at 36chambers.wordpress.com/2024/02/20/video-transactional-replication-in-sql-server-on-linux/ but that's about it.
How can i download the script and demo database ?, Thanks
I have a link in the show notes containing this information: 36chambers.wordpress.com/2024/02/20/video-transactional-replication-in-sql-server-on-linux/
I just updated it to include a copy of the BLS database.
Hi Kevin. Do you have a complete training series on SQL server for Windows?
Not as such, no. I do have a couple playlists that are potentially relevant, though:
- SQL Server installation and configuration: ruclips.net/p/PLeWL8zChJ2us9eZJJl0RJd1i0kwFg9Mjs
- Writing queries in SQL Server: ruclips.net/p/PLeWL8zChJ2usuvVEHGl2BykCQ6SaiZgrW
I do have some ideas on my backlog for future videos, but if there are any particular topics of interest, let me know and I'll see what I can do.
I basically wanna go through MSSQL server on windows covering full tutorial from installation to the end. The current playlist of linux (though short but pretty clear) is excellent. Following this playlist, I have setup the availability group which works perfect. What's missing is availability group using pacemaker, which would have been great had you added that. Anyways excellent work you are doing and I am looking forward for a complete DBA training using MSSQL on windows.
@@FaizanFastian23 That's fair enough. I can certainly add it to the backlog. It'd be a longer-term project, so no hard dates on anything, but would be something in the channel's wheelhouse.
Hey Kevine, great vide, i'm trying to rid of windows so i'm using SQL for linux i'm running SQL on docker using ubuntu , is there any way to implement merge replication, i'm using SSMS 18 , i'm already implement it on windows and it is working
Merge replication is not supported on Linux, no. Merge replication tends to be something of a laggard for most features. You'll see transactional and snapshot replication support in a variety of features but merge and peer to peer are much less likely to be supported when new things come out, including SQL Server on Linux.
learn.microsoft.com/en-us/sql/linux/sql-server-linux-replication?view=sql-server-ver16#supported-features
@@KevinFeasel so can i set Bidirectional Transactional Replication on Linux , I want the subscriber pull the data from the publisher and in some times subscriber can make some changes , i want to move out of windows to use linux and docker container
@@HusseinSaeed-ex7pm This is where the documentation gets a little tricky. There's nothing saying you *cannot* use bidirectional transactional replication, but there's also nothing explicitly saying you *can*. I haven't tried the scenario, to be honest, so I don't know whether that's possible. I'd recommend trying it out to see. If you made me give my prior probability on success, I'd say about 30% chance of success, as it's a more complicated replication scenario than normal transactional replication and unless there were Microsoft customers clamoring for support of that particular feature, it'd probably be low on their implementation list. But there is a chance bidirectional replication came "for free" with the normal transactional replication code--the only way to know for sure is to try it and see if it works.