Shill Alert Manning did provide me a free copy of this book. This came with no pre-conditions, so all opinions are my own and I've provided none of this to anybody at Manning beforehand. These are my own opinions and my own distraction-laden rants. The Review I'm working my way through Peter Carter's 100 SQL…
New Teams and Black Screens
I ran into a problem with the new Microsoft Teams and figured I'd write a quick blog post about the solution. The Problem After updating to the new Microsoft Teams, I could see my camera in the preview screen, but when I was in a meeting, I'd only see a black rectangle as myself. Other…
Video: Transactional Replication in SQL Server on Linux
THE VIDEO https://youtu.be/0eW6XO0DDEo THE SYNOPSIS In this video, we will briefly cover the various forms of replication available in SQL Server, as well as what is in SQL Server on Linux. Then, we will create a simple publication and subscription using T-SQL. THE COMMANDS Following are the command line operations I used throughout the video.…
Video: Create an Availability Group in SQL Server on Linux
THE VIDEO https://youtu.be/hSKwz7OvmgQ THE SYNOPSIS In this video, we will build out two availability groups for SQL Server on Linux. THE COMMANDS Following are the command line operations I used throughout the video. Initial preparation This block runs on each server. sudo /opt/mssql/bin/mssql-conf set hadr.hadrenabled 1 sudo systemctl restart mssql-server sudo apt install -y openssh-server…
Video: SQL Server Failover Cluster Instances on Linux
THE VIDEO https://youtu.be/BqgbzsDQMXY THE SYNOPSIS In this video, we will talk about Failover Cluster Instances in SQL Server on Linux. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space. Configure failover cluster instance - SQL…
36 Chambers - The Legendary Journeys: Execution to the max! 