Search Suggest

SSIS 2012
SSIS 2008
AZURE
C#
JOOST
ADF
POWERSHELL
SSIS 2014
VB.NET
SSIS 2005
SSIS 2016
SCRIPT COMPONENT
Azure Data Factory
SCRIPT TASK
SQL
SSIS
RICARDO
Power BI
CUSTOM
VARIABLES
RUNBOOK
BIML
SSMS
T-SQL
Data
FOREACH LOOP
AAS
PERFORMANCE
POWER_BI
SQL_DW
azure remoteapp
ARA
DEVOPS
POWERAPPS
SQL Server 2019
SQL_DB
EXCEL
SSDT
XML
ERROR
SOURCE
DATA_LAKE
DATA_LAKE_STORE
ENVIRONMENTS
IOT
Maps
TSQL
BUG
CONFIGURATIONS
ENUMERATOR
LOGIC_APPS
MARK
SQL Server 2022
STATISTICS
Tempdb
Azure functions
Data Modeling
EXPRESSIONS
FUNCTION
Level 16
OTTIMIZZAZIONE
Open Data
Power Query
SARGABLE
SQLSERVER
SSIS 2016 CTP 2
Trigger
Visualization
ASYNCHRONOUS
Array
BEST PRACTICES
BLOB_STORAGE
COLLATE
DATA_LAKE_ANALYTICS
Data Factory
EVENTS
JSON
Mapping Data Flows
SLOWLY CHANGING DIMENSION
SORT
SQL Server
STREAM_ANALYTICS
TFS
U-SQL
API
AlwaysOn
Analytics
CRM
DEVELOPMENT
EXECUTION PLAN
Function App
KEY_VAULT
PYTHON
Parameter
REGEX
SCHEDULE
SQLSAT
TASK
TDE
TIPS
UPDATE
VM
ZIP
continuous integration
sql parser
ArcGIS
ArgGIS Map
Azure Function
Azure Logic App
CONNECTION MANAGER
CTE
DATABRICKS
DB Corrotti
DEADLOCK
DEBUG
DENALI CTP1
DENALI CTP3
DIMENSION
EXECUTE SQL TASK
Email Notification
FN_DBLOG
FOR LOOP
GIS
GUID
GitHub
IMAGES
KUDU
Last page insert contention
Latitude
Longitude
MAIL
MENNO
PARALLELISM
POLYBASE
POWER_AUTOMATE
Pipeline
QGIS
Query Optimizer
REFLECTION
SCALE OUT
SNIFFING
SQL SERVER AGENT
SSIS VNEXT
SSRS
Shape Map
TEMPLATE
TWITTER
Table Spool
Table variables
UDF
WMI EVENT WATCHER TASK
WRITE AHEAD LOGGING
continuous delivery
installation
webjobs
21197
ADLS
ASSEMBLY
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
Big Data
Bing Map
CAST
CHECKSUM
CI/CD
CREATE CERTIFICATE
CREATE DATABASE ENCRYPTION KEY
CSV
Component error code: 0x851A0018
Custom Shapefile
DECRYPT
DELETE
DTUTIL
Data Vault
Durable Function
ENCRYPT
ESRI
FTP
Flatten
GIT
GPIO
HUB
Halloween problem
Head Blocker
How to Enable TDE.
IMPORT COLUMN
INDICI
INDICI COLUMNSTORE
JOB
LAST MODIFIED
LATCH CONVOY
LATCH_SH
LOCK
LOOKUP
Line 3
Linked Server
MERGE
Machine Learning
Mapbox
Msg 41131
Notebook
ODATA
OPTIMIZE FOR SEQUENTIAL KEY
PAGELATCH_EX
PARAMETERS
PARAMETRIZZAZIONE
PIVOT
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
RIJNDAEL
Range Scan
RemoteApp
Rules
SAS
SCM
SQL Azure
SQL Azure Database
SSAS
Script
SqlCmd
State 0
State 1
State 3
TDS
TIME DIMENSION
TRANSACTIONS
Table Variables deferred compilation
Technical preview 3
VALIDATION
WALTER
WGS 84
Webhook
Windows Server 2016
Wrangling data flows
XSD
cardinality estimation
cloud
create
database
deployment
ghost cleanup task
html5
resource
singleton lookup
state 7
sys.dm_tran_locks
transaction
trick
"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
0x8009030c
0x80090331.
10028
17052
2
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
AR
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)
Animation
Apache Spark
App Configuration
Append Variable
Application Gateway and its different components.
ApplicationIntent=Readonly
Apply
Apply Operator
Architect
Architecture
Arduino
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
BATCH FILE
BTree Structure
BUFFER
BatchMode
Blob
Blob Storage Container
Breadboard
Build
CACHE
CDS
CODING CONVENTIONS
COLUMN ENCRYPTION KEY
COLUMN MASTER KEY
CONTINUOUSLY
CONVERT
CORS
CParser
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
Cross Apply
Culture=neutral
Custom Maps
Custom Solution
DAC
DATA CONVERSION
DATA TAP
DATA_FLUCH_INTERVAL_SECONDS
DBCC CHECKDB
DBCC CSINDEX
DBCC IND
DBCC PAGE
DBCC WRITEPAGES
DCOM
DELETED
DONE_IN_PROC
DOWNLOAD
Data Architecture
Data Classification
Data Lake
Data Token Stream
DataForACause
Database Design
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
Distance
Distinct
Dual axes
Durability
EPSG 4326
ER Studio
EVENTLOG
EXPORT COLUMN
Eager Spool
Either a networking or firewall issue exists
Error No:1135
Error number: 15517
Error: -2146893019
Error: 3417
Error:33111
Error:983
Everything about Azure app service FTP
Extended Event
Extract the row values of which another field has maximum value
FAST_FORWARD
FILE SYSTEM TASK
FIX
FOR trigger
FORCESEEK
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
GA
GCP App Engine Questions
GCP Questions
GCP Stackdriver objective questions for revision
GUI
Gallery Template
GenLGAgg
Geometry
Get-ClusterLog
Get_GenLex
Global Fishing
Globe Map
Group By
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
IF activity
IISCrypto.exe
IMEX
INDEXES
INSERTED
IO Related Dynamic Management Views and Functions
ISNULL function
ISNUMERIC
Icon Map
Identity
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
KUDU 299
Kerberos status:When
Kill
LATCH_EX
LGetToken
LOP_DELETE_ROWS
LOP_INSERT_ROWS
La tabella suspect_pages
Latch Coupling
Level 17
Levenshtein
Line 102 [Batch Start Line 23]
Line 2
Line 23
Line 70
Line 82
List of Database on Specific Availability group
Load
LocalAggBelowJoin
Lock resources to prevent unexpected changes
Log Analytics
Log Buffer
Log Reader Agent
M language
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
MrbMiner;security
Msg 15578
Msg 35337
Msg 41009
Msg 41044
Msg 41066
Msg 41158
Msg 45207
NO COUNT
NSG
Named pipe
Narrative Science
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)
ODBC drives
OLE Automation
OMS
Office 365 ProPlus
OpenXML
Openrowset
Operating system error = 2310
OverView of AlwaysOnReadOnlyURL
PAGELATCH_SH
PASS
PIVOT DATA
PROPERCASE
PROXY
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.
Policy
Polling
Polygon
Power Map
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
Queue
R Language
RASPBERRY PI
RDCB
RECOVERY
REST API
RESUMABLE=ON
RLE
RML
RML utilities
ROW_MODE_MEMORY_GRANT_FEEDBACK
RPO
RPO & RTO Difference
RRAS
RTO.
Range_scan
ReadOnlyRoutingConfiguration
Recompile
Reference Layer
Release
Remote App
Remote Control
RemoteApps
RemoteFX
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
SEQUENCE CONTAINER
SERVICES
SMSS
SNIPPET
SQL 2019
SQL Assessment API
SQL Express
SQL INJECTION
SQL Monitoring
SQL SERVER 2019 CU2
SQL Server 2019 CU12
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
SQLOS
SQLRALLY
SSIS 2016 CTP 3
STORED PROCEDURE
STRING_AGG
SYNAPSE
SYNCHRONOUS
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)
Simplification
Singleton_lookup
Solution Template
Source Control
Sp_Who
Sp_getapplock
Spark
Spatial Data
Spatial Functions
Spatial datatype
Sqllang.dll
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
TCP/IP
TLS 1.2
TLS 1.2 is enabled
TRAILER
TRANSAZIONI
TRUNCATE
Table Variables (@)
Tabular
Tag
Teched 2014
Temp Tables (#)
Template Gallery
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
TopoJSON
Transaction SID
Triggers
Trivial plan
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
XACT_ABORT
a
abort
aggregate Pushdown
already
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
by
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
control
created date
curah
curation
current instance
cursor
custom parameter
data normalization
database replica is not in the PRIMARY or SECONDARY role
database-level firewall rule
datatypes
datetime
datetime2
db_datareader
default values
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
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
is
is not correct
kb3015693
kudu 404 not found
last page contention
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
massive insert
master key
mfa
microsoft edge
mkfs.xfs
mongodb upgrade
mount –t
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
position 629.
prepared queries
prepared statements
preview
primary replica
privacy
private
pvcreate
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.
security
segment operator
semijoin reduction
setspn -D
setspn -L
severity 16
severity 25.
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
sp_releaseapplock
sp_send_dbmail
sp_set_firewall_rule
spool operators
sql server security
start menu
start screen
stats_date
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
sys.objects
sys.resource_stats
sysjobs
sysjobsteps
sysrscols
tabular data stream
tcp/ip 1433
tech
this return status indicates that the value provided as the current password
to
trace flag 2543
trace flag 8757
traceflag
traceflag 1165
traceflag 2371
traceflag 2543
traceflag 661
transaction log
troubleshoot the database firewall in Azure SQL Databases
trying to update a password
tuning
tutorial
u_tables.sql
ubuntu
unsupported features of SQL server on Linux. Differences in SQL Server on Linux
updating permission setting for file
use
uvicorn
video
virtual log file
vworkspace 8.5
was unable to communicate
web app created date
web jobs missing
webinar
webjobs deleted after deployment
what is TLS1
where is my webjob
window function
window spool
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.
SLOWLY CHANGING DIMENSION
TSQL Merge for Slowly Changing Dimension or Persistent Staging Area

TSQL Merge for Slowly Changing Dimension or Persistent Staging Area

Case What is a fast way to load a Slowly Changing Dimension or Persistent Staging Area in SSIS. When using a Data Flow Task for this, the process cou…
T-SQL Merge in SSIS as SCD alternative

T-SQL Merge in SSIS as SCD alternative

Case About two year ago I did a post about alternatives for the poorly performing SCD Transformation in SSIS. And even in SSIS 2012 it is still unus…
Lookup Slowly Changing Dimension type II

Lookup Slowly Changing Dimension type II

Case I have a slowly changing dimension type II (with a start and end date). How do I create a working lookup in my dataflow? Solution There are rou…
Slowly Changing Dimension Alternatives

Slowly Changing Dimension Alternatives

Case The Slowly Changing Dimension component works fine for small dimensions, but performance is very poor for slightly bigger dimensions. Is there a…

Microsoft SQL Server 2012 improvement suggestions

Recently CPT 1 of SQL 2012 (code-named 'Denali') was released. Although there were a lot of vey nice changes , there is still room for improv…