Results for "microsoft"
12 / 184 posts
SQL Server Configuration Manager
Introduction Jab hum Microsoft SQL Server install karte hain , tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool…
Databricks, Apache Spark, Data Engineering and Science etc.
Azure Databricks is a platform on Microsoft Azure that helps with big data analysis and machine learning. It lets you work with large datasets easily and c…
What is Power BI
Power BI is a suite of business analytics tools developed by Microsoft that allows you to visualize and share insights from your data. Power BI consists of…
SYS and INFORMATION_SCHEMA
sys In Microsoft SQL Server, the sys schema is a special schema that contains system views and stored procedures that provide metadata about the SQL Server…
What is Managed and External table in Spark
In Apache Spark, both Managed and External tables are used to store the data. However, there are significant differences in how Spark manages the data for …
Split full name into first name and last name in SQL
Split full name into first name and last name : SELECT EmployeeName, CASE WHEN CHARINDEX(' ', EmployeeName) > 0 -- Check if there is a space (indicating…
What is Data Lake
A data lake is a centralized repository that allows you to store all your structured and unstructured data at any scale. You can store your data as-is, wit…
What difference between between MySQL and MSSQL
Feature MySQL MSSQL Ownership Oracle Corporation Microsoft Licensing Open-source (GPL) and commercial versions Commercial with free Express Edition Operati…
The ALTER TABLE statement in Microsoft SQL Server (MSSQL) and PostgreSQL
The ALTER TABLE statement in Microsoft SQL Server (MSSQL) and PostgreSQL is used to modify the structure of an existing table. It allows you to: Add, drop,…
Comparison of WHERE Clause Operators in MSSQL vs PostgreSQL
Here's a comparison of how operators in the WHERE clause are used in Microsoft SQL Server (MSSQL) vs PostgreSQL : Operator Purpose Used in MSSQL Used in Po…
SQL Server Deadlock & Performance Monitoring Made Easy
Learn how to detect SQL Server deadlocks and monitor performance with ready-to-use stored procedures for faster troubleshooting and optimization.
SQL Server Administration – Management Tools Overview
Is section me hum mainly SQL Server ke management tools aur system databases ko samjhenge. SQL Server Management Tools Jab aap Microsoft SQL Server install…