Author

Database Table Definition with Extended Property

Extended properties can be all sorts of annotations added about an object. They can be added manually, or by a tool. The extended properties has no effect on queries accessing the object. For specifying extended properties, the objects in a SQL Server database are classified into three levels: 0, 1, and 2. Level 0 is... » read more

Query for all child objects

SELECT name, SCHEMA_NAME(schema_id) AS schema_name, type_desc , type FROM sys.objects WHERE parent_object_id = (OBJECT_ID(‘dbo.tblXXXX’)) AND type IN (‘C’,’F’,’PK’,’D’, ‘UQ’) order by name; GO

Database Partitioning

Partitioning is the database process where very large tables are divided into multiple smaller parts. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. The main of goal of partitioning is to aid in maintenance of... » read more

Allowing Additional Host/App to Send Email on G Mail Server

By default, Google mail server will deny sending email from their servers. To enable additional host/application to send email you must add additional host/application records to the routing email section. If you try to send an email from your application without setting this up, you will get the following error message: “5.7.1 Invalid credentials for... » read more

MyDomain setup for Azure Websites

Nameservers Setup Change the default from… ns1.mydomaincom-default.domainparkingserver.net ns2.mydomaincom-default.domainparkingserver.net to… ns1.mydomain.com ns2.mydomain.com Otherwise Azure Portal will not be able to confirm your domain name. DNS Records Add the following DNS Records… Record Name Content A * xx.xx.xx.xx A @ xx.xx.xx.xx A www xx.xx.xx.xx CNAME www xx.azurewebsites.net TXT A xx.azurewebsites.net

MongoDB

MongoDB is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemata. MongoDB is developed by MongoDB Inc., and is published under a combination of the Server Side Public License and the Apache License. Wikipedia https://www.mongodb.com/ MongoDB AtlasGlobal Cloud Database Deploy, operate, and scale a MongoDB... » read more

Deciding Among SQL Server Components

Use the Feature Selection page of the SQL Server Installation Wizard to select the components to include in an installation of SQL Server. By default, none of the features in the tree are selected. Use the information in the following tables to determine the set of features that best fits your needs. Server components Description... » read more

SQL Server Editions

The following table describes the editions of SQL Server. SQL Server Editions Features Enterprise The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence – enabling high service levels for mission-critical workloads and end user access to data insights. Standard SQL Server Standard edition... » read more