Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]
2020-09-01
10,380 reads
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
A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]
2020-08-31
7,685 reads
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
In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.
2020-08-28 (first published: 2018-12-11)
2,575 reads
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
In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQL Server on Ubuntu 16.04 Install Pacemaker agents and configure the cluster Create Always On Availability Groups Create […]
2020-08-25
3,648 reads
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Most apps that call an LLM send every request to the same model. That...
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers