A Beginners Guide to MySQL Replication Part 1
MySQL Replication is a process where data from one MySQL database known as the source (formerly called “master”) is copied over to one or more other databases called replicas (formerly called “slaves”). Think of this like having …
[Video] Office Hours: Ask Me Anything About SQL Server in Costa Rica
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:30 gotqn: In SQL Database we have “sp_invoke_external_rest_endpoint”, but in SQL Server …
Piping, Filtering and Using Flyway Output in PowerShell
The post Piping, Filtering and Using Flyway Output in PowerShell appeared first on SQLServerCentral.
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, you know that a good player is always thinking multiple moves ahead, working every combination of moves their opponents may possibly make, and getting a plan f …
Is SQL Server 2019 More CPU-Intensive Than SQL Server 2016?
I’m running into something that I’m having a hard time believing. A client was hitting CPU issues during load testing, and they swore all things were equal between their SQL Server 2016 and 2019 environments. The 2019 box was having CPU pre …
The Curious Case of…. alcoholism
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker – with no nasty behavior, abuse, day-drinking, DUIs, or things like that – just drinking too much in the evening a …
Using Virtual Network Data Gateways to Secure Access to Azure SQL in Power BI
Power BI and Azure are two related services, but with a considerable independence between them. Power BI share the Azure Tenant for security management, but in relation to networking, they are in completely different environments. Frequently Power BI n …
This is the Last Week of Free PowerShell Training.
You’ve been working hard all month to get through our newest class, Fundamentals of PowerShell for DBAs. This week, it all starts to come together as you put together PowerShell plus SQL Server to automate tasks on a regular basis: March 27, Mon: …
How to use the SQL WHERE Clause with Examples
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.
Passing parameters to query without TVFs
Problem Statement You have a need to extract data from a table or view with 1 or more parameters. The challenge is that the parameter changes based on various factors. The solution often is to write this, not as a view, but as a Stored Procedure or a …
Database Monitoring: The ROI of Build vs. Buy
The post Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Connect SQL Server and Create C# Objects for Data Management
If you’re a developer or a database administrator, you undoubtedly know that SQL Server and other relational database management systems are among the most popular tools for data management. Isn’t it time to enhance your knowledge of the subject? The B …
Thought Leadership resource page
The post Thought Leadership resource page appeared first on SQLServerCentral.
SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II
The post SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II appeared first on SQLServerCentral.
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y’all post questions at https://pollgab.com/room/brento and they don’t get a lot of upvotes, and reading through ’em, I bet it’s because other people don’t quite understand what you’re asking. I think ther …