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
Examples of User Defined Data Type in SQL Server
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
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
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
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
SQL Server Mail Account Setup Server name: smtp.gmail.com Port number: 587 This server requires a secure connection (SSL): Checked Basic Authentication: enter your username and password Google Email Make sure “Allow less secure apps” is set to ON Note: for Google Admin users go to Gmail -> Security -> Less Secure Apps Run the following... » read more
Error: OLE DB provider “SQLNCLI11” for linked server “xxxxx” returned message “Unspecified error”. Msg 40515, Level 16, State 2, Line 1 Reference to database and/or server name in ‘xxxxx.sys.sp_tables_info_90_rowset_64’ is not supported in this version of SQL Server. Fix: Create linked server to SQL Azure Database using script. Sources: http://yasqlsb.blogspot.com/2014/07/sql-azure-linked-servers.html