AlwaysOn, one of the most used MSSQL high availability solutions, will not be created on the other side when a user is created on one …
Read More »MSSQL
Differences Between Azure SQL Server And On-Prem SQL Server?
In today’s article, we will explain what the differences are between Azure SQL Server and On-Prem SQL Server. Azure SQL Server is a Paas product …
Read More »How To Send Telegram Messages From SQL Server
In today’s article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram. First of all, of course, …
Read More »SQL Server Monitoring With Influxdb And Grafana
In our article today, we will be discussing how we can monitor SQL Server using open source systems (Influxdb and Grafana). First of all, let’s …
Read More »Install Powershell Module
Today, we will discuss dbatools, which is one of the features of SQL Server that allows us to perform SQL Server management processes through open …
Read More »How To Restore SQL Server Database Using PowerShell
In our previous article, we learned how to take a database backup using Powershell’s dbatools module, and in today’s article, I will explain how to …
Read More »Database Administrator Job Description
Database Administrator (DBA) is the person or persons responsible for the control, maintenance, coordination and operation of the database management system. It is primarily responsible …
Read More »SQL Server Security
In this article, I will explain how to use and perform SQL Server security testing. Data is very important to everyone, but how safe is …
Read More »Parameter Sensitive Plan Optimization
In this article, I will explain what the PSP (Parameter Sensitive Plan Optimization) feature is. I would like to point out that this feature will …
Read More »SQL Server Contained Database
Contained Databases is a database isolated from other databases and the instance of SQL Server hosting the database. SQL Server helps the user isolate the …
Read More »