Sample Azure SQL Price

Plan DTUs ($1.50/DTU) Data Max Size Price Basic 5 2 GB $4.99/month Standard 10 250 GB $15.00/month Standard 20 250 GB $30.00/month Can adjust plan anytime. Service tiers in the DTU-based purchase model are differentiated by a range of compute sizes with a fixed amount of included storage, fixed retention period for backups, and fixed... » read more

0
Read
echiang
DBCC CHECKTABLE Fix Database Table

Examples A. Checking a specific table The following example checks the data page integrity of the HumanResources.Employee table in the AdventureWorks2012 database.SQLCopy B. Performing a low-overhead check of the table The following example performs a low overhead check of the Employee table in the AdventureWorks2012 database.SQLCopy C. Checking a specific index The following example checks a specific index, obtained... » read more

0
Read
echiang
An inconsistency was detected

Error: Running a query and got this error… An inconsistency was detected during an internal operation. Please contact technical support. Fix: DBCC CHECKDB (‘DMS’) WITH NO_INFOMSGS, ALL_ERRORMSGS DBCC CHECKDB(‘DMS’, REPAIR_REBUILD) dbcc CHECKDB(‘DMS’, REPAIR_ALLOW_DATA_LOSS) Sources: https://dba.stackexchange.com/questions/11235/an-inconsistency-was-detected

0
Read
echiang
Allow SQL Server Access for Azure VM

From portal.azure.com … Go to “Networking” section of VM. Add Inbound port rule … Port: 1433 Protocol: Any Check List: SQL Server Properties -> Connections -> “Allow remote connections to this server” is checked SQL Server Network Configuration -> TCP/IP is enabled and set to port 1433 Windows Defender Firewall with Advanced Security -> Inbound... » read more

0
Read
echiang
Enable email notification for SQL Jobs

Note: Make sure email profile and account are setup on the SQL Server first. To enable SQL Server Agent job email notification go to … SQL Server Agent -> Properties -> Alert System -> Mail session -> Enable mail profile

0
Read
echiang