HOIT ASIA -Sever Free Download

Sitemap
Disclaimer
Privacy

Home
HoIT
- MacOS
- Android
- Game
- Ebook
About
Contact
More...
- Try RTL Mode
MacOS

Search Suggest

ADF

SQL

SSIS

BIML

SSMS

Data

AAS

ARA

SSDT

XML

IOT

Maps

TSQL

BUG

MARK

JSON

SLOWLY CHANGING DIMENSION

SORT

TFS

API

CRM

TASK

TDE

TIPS

UPDATE

ZIP

continuous integration

CTE

GIS

GUID

GitHub

IMAGES

KUDU

Last page insert contention

MAIL

QGIS

SSRS

UDF

WMI EVENT WATCHER TASK

ADLS

Approx_Count_Distinct

Azure App Service

Azure App Service FTP Troubleshooting

Azure Data Lake Store

Azure FTP

Azure app service FTP

Azure web app remote debugging

BACKUP CERTIFICATE

BDD

BTREE_INSERT_FLOW_DISPATCHER

Batch Mode on RowStore

CAST

CREATE DATABASE ENCRYPTION KEY

CSV

Component error code: 0x851A0018

ESRI

FTP

Flatten

GIT

GPIO

HUB

JOB

LOCK

OPTIMIZE FOR SEQUENTIAL KEY

Publisher failed to allocate a new set of identity ranges for the subscription

Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers

SAS

SCM

SSAS

TDS

Table Variables deferred compilation

XSD

cardinality estimation

"Cannot failover availability group 'XXXXX' to this instance of SQL Server" "Cannot failover availability group 'XXXXX' to this instance of SQL Server"

"Information\ResumeKeyFilter.store" failed. The file permission settings were supposed to be 35363445448-169532831-1350696550)'

"SQL Server Database Services feature state"

#70-535

#troubleshooting log shipping issues.

'Cluster Disk X'

'New Distributed Transaction Coordinator (1)'.

'msdb110_upgrade.sql' encountered error 200

.net version

/AUXSOURCE= flag

0x000000AB

0x010100000000000512000000

200

202

208

3015693

35217

3D Map

404 not found:An error has occured

409 Conflict: Cannot delete directory. It is either not empty or access is not allowed.

409 Conflict: Could not write to local resources:\home\site\wwwroot

409 conflict

409 conflict: could not write to local resource

5057

A;CI;KR;;;[SQLServer2005SQLBrowserUser$XXXXDB1

AAD

ACID

ACID properties of transactions

ADO

AFTER trigger

AGGREGATE

ALTER DATABASE [DelayedDurabilityTest] SET DELAYED_DURABILITY = ALLOWED

ALWAYS ON

ANSI_WARNINGS

APS

ARM Template

ARM Template Deployment with Powershell and JSON.

AUTHENTICATION = CERTIFICATE

Accelerated Database Recovery

Account SAS

Adaptive Join

Adaptive Query Processing

Add Database in AlwaysOn Availability Group

Add additional IP addresses to a load balancer for more than one availability group

AdventureWorks2014

Alerts

Alter availability group

Alter database

Always Encrypted Technology

An OS call failed: (8009030c)

Application Gateway and its different components.

ApplicationIntent=Readonly

Ascending Key Problem

Authentication mode

Automatic tuning in Azure SQL Database

Availability replica is in disconnected state and AlwaysOn secondaries are in disconnected state.

Awesome facts about Azure Cloud

Azure .net version

Azure 1.32.0-insider

Azure App Configuration

Azure App Service Add/Modify/Update application settings using PowerShell

Azure App Service Powershell

Azure App Service keyboard shortcuts

Azure Databricks

Azure Disk Encryption for IaaS VMs

Azure Function App Graceful Shutdown

Azure Functions No Access

Azure Functions Runtime is unreachable

Azure Functions timeout

Azure Monitor

Azure Region is close to your premise

Azure Resources Created Date

Azure Restore deleted app service

Azure SQL Database automatic tuning

Azure SQL Intelligent Insights

Azure Service Bus

Azure app Service Created Date

Azure app Service create/reset FTP user level credential through PowerShell

Azure app Service zip deployment

Azure app service FTP PowerShell

Azure app service remote debugging

Azure deployment

Azure deployment credential

Azure function Blank screen

Azure function app No Access

Azure function app overview

Azure function error; Azure Functions Runtime is unreachable. Click here for details on storage configuration

Azure function is not running after some changes

Azure function is not triggering after deployment

Azure functions FTP

Azure functions deploy single function

Azure functions internal server error

Azure functions storage queue

Azure keyboard shortcuts

Azure outage

Azure policy real time example

Azure portal keyboard shortcuts

Azure resource manager

Azure web app

Azure web app FTP

Azure web app Multiple FTP Users

Azure web app created date

Azure webjobs type

BACKUP DATABASE TO URL

Blob

Blob Storage Container

CDS

COLUMN ENCRYPTION KEY

CORS

CParser;GetChar;SqlLang.dll

CREATE ENDPOINT

CREDENTIAL

CRUD

CTAS

Cambiare impostazioni relative alla lingua

CancellationToken

Cannot connect to WMI provider

Cannot find server certificate with thumbprint '0xDEABEBD2A72BB96EDA2521AB16011FD4E1F661DF'.

Cannot open server 'sqlsouthasia' requested by the login. Client with IP address not allowd to access the server.

Cannot truncate table 'XXXXX' because it is being referenced by a FOREIGN KEY constraint.

Cardinality

Change Azure functions hosting plan

Change Consumption Plan to Premium Plan

Change Function app hosting plan

Change SQL Servers Authentication Mode with PowerShell using SMO

Change webjobs from Continuous to Triggered

Change webjobs from Triggered to Continuous

Changr SQL Server name

Check Azure App Service dotnet version

Choose consumption plan name

Clustered key value

Commit limit. Page file

Common Data Services

Common Table Expression (CTE)

Composite index

Condition

Configure Azure Key Vault Integration for SQL Server on Azure Virtual Machines

Connect on Premise Network to Azure - Site to Site VPN Configuration using PowerShell

Consumption plan timeout

Consumption plan timeout Everything about function app timeout

Contained Always on availability group

Could not allocate a new page for database \\'tempdb\\' because of insufficient disk space

Could not find the Database Engine startup handle

Create a AKS Cluster and execute the image which is stored in ACR using AKS cluster public IP.

Create consumption plan with your desire name

Create the Azure Container Registry

DAC

DATA_FLUCH_INTERVAL_SECONDS

DCOM

Database mirroring connection error 2 'DNS lookup failed with error: '11004

Datascience

Decimal Data type

Dedicated Administrator Connection

Default Value

Delayed Durability

Delete Activity

Deploy one function in an Azure function app

Detect how much checkpoint happened on the DB Server.

Dictionary Encoding

Different gsutil commands

Disabling A Single Function In Azure Functions Deployed From Visual Studio

Either a networking or firewall issue exists

Everything about Azure app service FTP

Extended Event

Extract the row values of which another field has maximum value

FIX

Failed to bring availability group '' online

Failed to join local availability replica to availability group

Failed to open file C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp Error Code: 1603

Failed to unlink socket file /tmp/mongodb-27017.sock errno:1 Operation not permitted

File Management

File is not visible in KUDU

File; xp_DirTree

Files are not visible in KUDU

Filetables

Filled Map

Find files that have percent growth-Key database properties for all databases on instance-Changing selected database properties

FireWall

Float data type

Flow map

Folders are not visible in KUDU

Function App configuration

Function host is not running

GCP App Engine Questions

GCP Questions

GCP Stackdriver objective questions for revision

GUI

Grouped Aggregate Pushdown;columnstore index

HDFS

HDINSIGHT

HEADER

HTML

HTTP

Handle function app abort;function app shutdown

Hash Match Algorithm

Heatmap

How

How can I generate PDF In azure app service application?

How many zip files azure app service keep in zip deployment

How to Find who/ when restarted your Windows Server.

How to Migrate from Consumption Plan to App Service Plan

How to Retrieve MSSQLSERVER or SQL Server engine running on a set of Servers.

How to add a Secondary NIC on a VM in Azure

How to create a DSC file for Azure Data Studio.

How to delete the SPN

How to disable functions in Azure Functions

How to enable TDE Encryption on a database in an Availability Group

How to enable TLS 1.2 on DB Server

How to find schema change history for specific day in SQL Server using server side trace

How to i change

How to move Azure SQl database to different elastic pool

How to restore a deleted Azure Web App

How to run Glenn Berry Scripts from Powershell and store output to the Excel

How to set different ipaddresses in each server for configure multi subnet server using RRAS for home lab

How to write SQL Server Audit Events to the Security Log

How to write Query

I am not able to connect to azure app service through FTP

IMEX

Important link for Azure Certification No #70-535

In SQL Server

Indici Univoci filtrati

Ingestion

Install SQL Server 2019

Install windows 11

Integer autoincrement ID columns with a clustered index defined on it

Integration

Intelligent Insights

Internal Server error

Invalid Length for a Base-64 char array or string;function app Invalid Length for a Base-64 char array or string

Invalid access to memory location

Invalid class [0x80041010]

Invalid object name 'master.dbo.spt_values

IronPDF in Azure App Service

Is it possible to deploy just one function in an Azure function app

IsMemoryGrantFeedBackAdjusted

JASPER

JDBC Driver 9.4

JOBS

JOIN

Javascript

KB2919355 Check Failed. If you have installed KB2919355

Kill

La tabella suspect_pages

Latch Coupling

Level 17

Levenshtein

Line 102 [Batch Start Line 23]

List of Database on Specific Availability group

Load

LocalAggBelowJoin

Lock resources to prevent unexpected changes

MIM

MOF

MSSQL_REPL20011

Macro

Managed Backup

Management and Security Essentials

MaxDop

Memory-Optimized TempDB Metadata

Metrics

Microsoft Dynamics 365

Microsoft SQL Server

Microsoft-Windows-FailoverClustering 1135 Node Mgr Cluster node 'XXXXXXXXSQL01' was removed from the active failover cluster membership.

Microsoft.Data.SQLClient package

Mirroring disconnected with error No 10054 and 11004

Mirroring from SQl server 2008 to SQl server 2014 with minimum downtime

Monitor

Monitoring Azure SQL Database using dynamic management views

NSG

NetftRemoteUnreachable

Network

New way to handle app configuration

New-AzureRmSqlDatabase

New-AzureRmSqlElasticPool

New-AzureRmSqlServer

New-AzureRmSqlServerFirewallRule

OBJECT_NAME

ODBC Driver 17.8

ODBC Driver in Azure app service

ODBC Error: [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)

OMS

Operating system error = 2310

OverView of AlwaysOnReadOnlyURL

PASS

PackageManagement' and 'Provider' tags. Please check if the specified

Parameter Sniffing

Parameter-sensitive plan optimization (PSP)

Parent Child Nodes

Partial aggregate

Partition

Partition elimination

PerfCountersUpload.dtsx

Performance recommendation in the Azure portal

Performance recommendations in the Azure portal

Plan Guides

Please

Please ensure the key vault has been configured with soft-delete.

PowerShell script samples that create and manage Windows virtual machines (VMs).

Powershell.exe -ImportSystemModules -ExecutionPolicy Unrestricted -command Get-ClusterLog -Destination 'C:\xfer' -Node 'WIN2K12-2' -TimeSpan X -Uselocaltime

Predicate

Predictive Analytics

Primary Secondary axis

Procedure managed_backup.sp_add_task_command

Process to fine tune Select / Update or Delete statements in SQL Server

PublicKeyToken=b03f5f7f11d50a3a'

Pulse Chart

Push a container to the Registry

QUERYTRACEON 3604

QUERYTRACEON 8675

QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n

Query Performance Insight

Query Performance Insights

RDCB

RLE

RML

RML utilities

ROW_MODE_MEMORY_GRANT_FEEDBACK

RPO

RPO & RTO Difference

RRAS

RTO.

Range_scan

ReadOnlyRoutingConfiguration

Remove Additional files at destination

Remove Additional files at destination kudu

Request to a downlevel service failed;

ResUtilsStartResourceService failed (status 435)

Residual predicates

Resource Manager

Restore TDE Enabled database in AlwaysOn

Restore deleted web app

Reverse index technique

Ricerche case sensitive

Round Robin

Route table

Row count Spool

Rule "Microsoft Cluster Service (MSCS) cluster verification errors" failed.Refer to KB953748 or SQL Server Books Online for more information.

Run the image from Azure Web App Services

Run the image locally to verify operation

SCM_MAX_ZIP_PACKAGE_COUNT

SMSS

SQL Server 2022 preview CTP 2.0

SQL Server 2022 public preview for LINUX

SQL Server Managed Backup to Microsoft Azure

SQL Server Management Studio 19.0 Preview 2

SQL Server Optimizer

SQL Server Query Tuning and Optimization

SQL Server Toolkit 5-1 for MSSQL

SQL Server Version

SQL Server cannot become the primary replica because the WSFC cluster was started in Force Quorum mode. Consider performing a forced manual failover (with possible data loss).

SQL Server network configuration

SQL Sevrer 2019 for linux

SQL2019

SQLBrowserConfigAction_install_ConfigNonRC_CPU32

Script to find out how many seconds is a secondary replica behind the primary replica

Securing a Virtual Network with Azure Firewall

Seek

Send Message

Server Managed Backup aka Smart Backup and Restore from Azure storage

Server-level firewall rule

Service SAS

Service SAS URI & Account SAS URI example

Service is dead

Service pack installation failed.

Set-AzureRmSqlDatabase

Set-AzureRmSqlDatabaseElasticPool

Set-AzureRmSqlElasticPool

Severity: 21

Shadow

Shared access signatures (SAS)

Stackdriver objective questions

Start/Stop/Restart web app; automate Start/Stop/Restart web app

State 6

State: 3

Status Code

Stellar Repair for MS

String or binary data would be truncated

Sub Queries

Subquery

Subscribe to Azure App Services Announcements

Support for Visual Studio 2015 remote debugging

Switch Activity

System Variables

System.NotSupportedException: Unable to determine the provider name for provider factory of type 'System.Data.SqlClient.SqlClientFactory'. Make sure that the ADO.NET provider is installed

Tag

The

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

The Consumption pricing tier is not allowed in this resource group;Azure functions;Dynamic pricing tier is not allowed in this resource group;Function app;Azure functions;

The certificate chain was issued by an authority that is not trusted

The cost based optimization process

The description for Event ID ( 17052 ) in Source ( MSSQL$XXXD1 ) cannot be found

The function runtime is unable to start

The function runtime is unable to start. Microsoft.Azure.WebJobs.Script.WebHost: Repository has more than 10 non-decryptable secrets backups

The insert failed. It conflicted with an identity range check constraint in database '<DatabaseName>'

The memo

The network connection between your computer and the VPN server could not be established because the remote server is not responding. This could be because one of the network devices

The operation timed out. Verify that the local Windows Server Failover Clustering (WSFC) node is online.

The pricing tier PremiumV2 is not available for this resource group. Please redeploy or clone your app into a new app service plan in a new resource group

The term 'Login-AzureRmaccount' is not recognized as the name of a cmdlet

The thread pool for AlwaysOn Availability Groups was unable to start a new worker thread because there are not enough available worker threads

There is already a master key in the database.

This Azure function app is down for maintenance

Time

Time Slider

Timeout occurred while installing Workload Backup extension on the virtual machine.\r\nRetry the operation. If the issue persists

Timeout value of 00:05:00 exceeded by function

Try 'Get-PackageProvider -ListAvailable' to see if the provider exists on the system.

Types of shared access signatures

UNPIVOT

UPDATE()

UPSERT

Unable to add function in Function App

Unable to connect to the Microsoft Visual Studio Remote Debugger (MSVSMON.EXE);MSVSMON.EXE;0x89710023

Unable to edit/delete files through KUDU site

Unable to find a volume with enough disk space for file extraction

Unable to retrieve Functions Keys

Unable to show XML. The following error happened: Unexpected end of file has occurred. Line 24137

Uneven data distribution

Unique Index

Unique-NonClustered Index is also a HEAP Table.

Update SQL Server Collation for SQL Server failover cluster Instance.

Update application settings for azure app service using PowerShell

Update or change webjobs types

Use PDF in Azure App Service

Use of Azure Function

User defined functions

VIEW DATABASE STATE

VLF

Value Encoding

Verify container registry images

Version

Version=9.0.0.0

VertiPaq

View Node Weight Configure and Adjust Cluster Quorum Node Weight Settings.

Virtual Machine

VirtualMachineMustHaveOneNetworkInterfaceAsPrimary

Vollgar

WAIT

WINDOWS SERVICE

WSFC

Wait States

We are not able to retrieve the keys for function

Web

WebJob cannot be added from portal if deployment from source control is configured

Webjobs are missing after deployment

What we can do with Azure functions

Windows successfully diagnosed a low virtual memory condition.Commit Charge

Windows-Resource-Exhaustion-Detector_2004

am_page_range_cache_invalidation

app service created date

appstore

arm-template-parameters-definition.json

audit

automate stop web app

availability for the distribution database

azure created date

azure resource created date

azurespeed

before performing this operation

benchmark

bit-packing

bitmap operator

blank page. azure. azure app service

cardinality estimator

central repository for configuration

certificate

checklist

click once

clustered index scan operator

code

code change;web app code change;app service code change;who changed web app code;

column '<ColumnName>'.

columstore index

concurrency

configure AlwaysOn using certificates

confitional access

consumption to app service plan

database replica is not in the PRIMARY or SECONDARY role

database-level firewall rule

define your consumption plan name

deleted data

description for Event ID ( 17052)

detect

disable azure function

disable read only function

disk

dm_exec_query_transformation_stats

dms

dotnet version in azure app service

dynamic data masking feature

enable TPM on WMplayer 16.2

enlarge

ericom

evenly distribuited data

excel in azure app service

excel in azure web app

exponential backoff algorithm

extended events

failed because statistics cannot be updated on a columnstore

file

find()remove()

findOne()

fn_backup_db_config

fn_hadr_is_primary_replica

function app. Azure functions

get the auto notification for any changes/update in Azure App Service

ghost record

host is offline

how to Migrate SQL 2008 database to Azure SQL database using Azure Database Migration

iam_page_range_cache_population

in the database

index fragmentation

index. UPDATE STATISTICS is valid only when used with the STATS_STREAM option.

inline scalar function

input tree

insert()

install SQL Server command line tools

installed date of sql server

interleaved execution

invalidated execution plan

ios

last page insert contention issue

latch_acquired

latch_released

ledger

life as a database expert

like wildcard basic

long running process

lvcreate

managed_backup.fn_available_backups

managed_backup.sp_backup_config_schedule

mfa

msdb.managed_backup.sp_backup_config_basic

msddsp

multi-statement table valued function (MSTVF)

multivalues insert

new-object : Cannot find type [Microsoft.SqlServer.Management.Smo.Server]: verify that the assembly containing this type is loaded.

office365

online (Error code 5942)

openxml sdk

optimizer

or open the master key in the session

or operable program.

or the endpoint address provided for the replica is not the database mirroring endpoint of the host server instance.

os_language_version

partition scheme

please contact Microsoft support

please make sure you have restarted your machine. For more information

query_store_plan_forcing_user_change

querytraceon 8608

querytraceon 8615

random clustered key value (GUID)

read only resource

read-only non clustered Columnstore Index

recovery model

relational databases

replicated table 'dbo.<TableName>'

residual predicate

returned

roadmap

root of the path G:\MSSQL14.XXXX\MSSQL\data does not exist.

round function

save transaction

secondary replica behind primary replica.

severity 25PerfCountersCollect.dtsx

shared memory

shrink

sid

slowdowns

smart_admin.sp_backup_on_demand

smart_backup_files

sniffing problem

sp_add_log_shipping_secondary_database

sp_add_log_shipping_secondary_primary

sp_adddistributiondb

sp_execute_external_script

stop/start web app through code

storage queue trigger function;base64

stored access policy

sync azure function

sys.database_principals

sys.database_role_members

sys.dm_db_partition_stats

sys.dm_db_resource_stats

sys.dm_db_stats_properties

sys.dm_exec_connections

sys.dm_exec_query_stats

sys.dm_exec_sql_text

sys.dm_os_performance_counters

sys.dm_os_tasks

sys.dm_os_threads

sys.dm_os_volume_stats

sys.dm_os_waiting_tasks

sys.dm_os_windows_info

sys.dm_server_registry

sys.dm_server_services

sys.fn_get_audit_file

sys.fn_xe_file_target_read_file

tech

this return status indicates that the value provided as the current password

troubleshoot the database firewall in Azure SQL Databases

trying to update a password

unsupported features of SQL server on Linux. Differences in SQL Server on Linux

updating permission setting for file

use

was unable to communicate

web app created date

web jobs missing

webinar

webjobs deleted after deployment

windows server 2016 technical preview 3

windows_release

windows_service_pack_level

windows_sku

wmware

writeable Clustered Columnstore Index

wrong cardinality estimate

you can visit https://support.microsoft.com/kb/2919355/

your SAS credential is invalid.

new-object : Cannot find type [Microsoft.SqlServer.Management.Smo.Server]: verify that the assembly containing this type is loaded.

Issue : when you connect to SQl Server using SMO in Powershell you get below error.. ------- new-object : Cannot find type [Microsoft.SqlServer.Mana…

HOIT ASIA

Company

About
Blog

Product & Service

Home
Software
Android
MacOS
Games

Support

Contact
Documentation