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.

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

How to creates a cluster log file for all nodes, or a specific a node, in a failover cluster in user local time.

How to creates a log file for all nodes, or a specific a node, in a failover cluster. Here is the command which i use to get the ClusterLog in userl…

HOIT ASIA

Company

About
Blog

Product & Service

Home
Software
Android
MacOS
Games

Support

Contact
Documentation