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 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

Microsoft Windows Movie Maker

Windows Movie Maker was a video editing software by Microsoft. It was a part of Windows Essentials software suite and offered the ability to create and edit videos as well as to publish them on OneDrive, Facebook, Vimeo, YouTube, and Flickr.Wikipedia Initial release date:September 14, 2000Developed by:Microsoft CorporationPlatforms:x86-32 (32 bit Intel x86),x86-64 Windows Movie Maker,... » read more