Windows services are installed as part of the SQL Server and its component installations. With the operating system, these services exchange information. In Administrative Tools
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
NULL in SQL Server
In Structured Query Language, the special identifier NULL is used to denote the absence of a data value from the database. A field with a
SQL Server DISTINCT Clause
If the column constraint is not set to primary or with uniqueness, a column in a table may contain numerous duplicate entries. In these situations,
SQL Server Editions
The SQL Server editions and their features must be known to the database administrators. Applications needing mission-critical in-memory performance, security, and high availability should use
SQL Server – Data Retrieval with Clauses and Operators
This post aims to give some examples to novices on how to obtain data from SQL Server using clauses and operators. The examples contain not
SQL Server System Databases
The databases that are loaded with SQL Server are known as system databases. These are used to store system-level data, metadata data, data about scheduled
Big Data & SQL 