#SQLServer2017 – DB Cloud TECH

When we are talking about Performance tuning and Monitoring on Azure SQL Server, we should consider some services provided on azure supporting us in this task

Query performance insight.
Azure SQL Performance Recommendation Services
Azure SQL Analytics
Azure SQL Automatic Tuning Services
Diagnostics settings
Learning Resources

**Azure SQL Database Monitoring Services**

Continue reading →

it Tutorial

How To Setup PasswordLess SSH Connectivity Using SshUserSetup.sh in Linux September 16, 2021

I will explain How To Setup PasswordLess SSH Connectivity Using SshUserSetup.sh in this post. How To Setup SSH Connectivity Using SshUserSetup.sh Normally, If you want to connect to any server from the other server, that server request the password of related user ( root, oracle,grid,weblogic or etc.. ). But sometimes you need … The post How To Setup P […]

Mehmet Salih Deveci

Mapping ile Tablo Aktarılması 2 – ODI Dersleri 6 September 10, 2021

Merhaba arkadaşlar, bu gün ki makalemizde mapping işlemlerine devam edeceğiz. Okumadıysanız öncelikle mappingin logical tanımlamalarını gerçekleştirdiğimiz makalemi okumanızı tavsiye ederim. Makaleye buradan erişebilirsiniz. Bu gün ki makalemizde Pyhsical sekmesinde yer alan ayarlamaları yapacağız. Physical sekmesini tıkladığımızda aşağıdaki gibi bir ekra […]

Kübra Hebeş

DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle September 8, 2021

I will explain DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle in this post. DBA_Hist_Active_Sess_History | Active Session History (ASH) in Oracle dba_hist_active_sess_history view is one of the most important Oracle views that displays history of the contents of the in-memory active session history of recent system activity. It conta […]

Mehmet Salih Deveci

DATA WAREHOUSE – OLTP/OLAP September 7, 2021

OLTP (On-line Transaction Processing) By the mid-1970s, online transaction processing (OLTP) made even faster access to data possible, opening whole new vistas for business and processing. Shortly after the advent of massive OLTP systems, an innocuous program for “extract” processing began to appear. Since OLTP data is on the operational side, it includes tr […]

Onur Cirkin

Random value for DATETIME column August 30, 2021

Today, I am going to describe how to generate random value for DATETIME field within a given range. This is very useful specially for generating test data. For this, we will use couple of built-in functions like: DATEDIFF DATEADD RAND ROUND Random DATETIME Value DECLARE @startDate DATETIME -- start date DECLARE @endDate DATETIME -- end … The post Random valu […]

M A A Mehedi Hasan

Tag: #SQLServer2017

Azure Services for Monitoring and tuning Azure SQL Database

Share this:

Like this: