Results for "ALl"
47 / 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…
SQL Server System Databases
Introduction SQL Server me jab hum kaam karte hain, to generally hum tables, queries aur user databases par focus karte hain. Lekin ek hidden backbone hota…
How to use Magic (virtual) table INSERTED and DELETED in SQL server
Magic Tables are virtual tables that are automatically created and maintained by SQL Server for each data modification operation performed on a table. They…
UNION, UNION All, INTERSECT, EXCEPT used in SQL Server
UNION : The UNION operator is used to combine the result sets of two or more SELECT statements into a single result set. It removes duplicate rows from the…
Window Functions in PySpark
Window functions in PySpark allow you to perform operations across a set of rows that are somehow related to the current row. They are useful for tasks lik…
Triggers in SQL server
A trigger in SQL is a special type of stored procedure that runs automatically when certain actions happen in a table or view . A trigger cannot be explici…
ANY and ALL operators used in SQL
The ANY operator: returns a boolean value as a result returns TRUE if any of the sub-query values meet the condition Any means that the condition will be t…
How to get first date From month and Finyear
If we have Finyear and month then we create a date for examples: DECLARE @finyear CHAR(5) = '202425'; DECLARE @month smallint = 5; --Get Year DECLARE @year…
All Date Components in SQL
We get First Date , Last date ,month number, month Name,Year, Financial Year(Finyear), and Month Year from Date (Date Range of each single date). SET DATEF…
Markdown Cheat Sheet
Basic Syntax These are the elements outlined in John Gruber’s original design document. All Markdown applications support these elements. Element Markdown …
Azure Databricks command
Here are some common commands used in Databricks: %fs : Allows you to interact with the filesystem. For example, %fs ls lists the files in the current dire…
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…
What is RLS (Row-Level Security) in Power BI
RLS stands for Row-Level Security, which is a feature in Power BI (and also in SQL Server Analysis Services) that allows you to restrict data access at the…
Databricks widgets
Input widgets allow you to add parameters to your notebooks and dashboards. You can add a widget from the Databricks UI or using the widget API. If y…
Schema and Handling Corrupt data in PySpark
A schema in PySpark (and generally in data processing) defines the structure of a DataFrame, including the names and data types of each column. It serves a…
What is catalog in Spark
In Apache Spark, the catalog refers to the internal management system that keeps track of all the metadata related to tables, databases, functions, and oth…
List,Tuple,Set and Dictionary in Python
🔹 List (सूची) 📌 Definition : List ek aisi collection hai jo ordered (क्रमबद्ध) aur mutable (बदलने योग्य) होती है. Ismein duplicate values allowed hain. m…
Advance functions in Power BI
ALL Filter: The ALL filter returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied. This function …
USERELATIONSHIP function In Power
USERELATIONSHIP: This is particularly useful when you have multiple relationships between the same tables but only one can be active at a time. By default,…
ALLSELECTED Function in Power BI
ALLSELECTED : The ALLSELECTED function in DAX is used to return all the rows in a table, or all the values in a column . This is particularly useful in sce…
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…
Database trigger to audit (Transaction logs) all of the DDL changes made to the Database
Create table DatabaseLog: CREATE TABLE [dbo].[DatabaseLog]( [DatabaseLogID] [int] IDENTITY(1,1) NOT NULL, [PostTime] [datetim…
What is Functions and Difference between Functions and Stored Procedures in SQL Server
What is a Function in sql : A function is a set of SQL Statements that perform a specific task. Basically, it is a set of SQL statements that accept only i…
Basic in NumPy
NumPy is a Python library. NumPy is used for working with arrays. NumPy is short for "Numerical Python". The array object in NumPy is called ndarray, it pr…
Vectors
Definition A vector is a quantity that has both magnitude and direction . Vectors can be represented in different ways, such as geometrically (with arrows)…
Matplotlib Pyplot for Visualisation
Pyplot Most of the Matplotlib utilities lies under the pyplot submodule, and are usually imported under the plt alias: import matpl…
Making API Calls in Python
APIs (Application Programming Interfaces) are the bridges that allow different software systems to communicate with each other. pip install requests import…
EasyDict dictionaries
EasyDict is a subclass of Python's built-in dictionary that allows accessing dictionary keys as attributes like JavaScript object. pip install easydict fro…
Log Shipping (Ship Log) in SQL Server
Log Shipping in SQL Server is a high-availability feature that allows you to automatically send transaction log backups from a primary database on one serv…
Data archive in SQL Server
A data archive refers to the process of moving inactive or less frequently used data from an operational system to a storage system , typically in a separa…
DBA
Setting up a lab environment for the course. Option 1 (Limited Resources) : Use a computer, laptop, or workstation with Windows 10 installed. Install SQL S…
SQL Logical Operators with Examples
SQL logical operators are used to filter data by combining multiple conditions in SQL queries. These operators help in refining queries to fetch specific r…
select() Function in PySpark
In PySpark, select() function is used to select single, multiple, column by index, all columns from the list and the nested columns from a DataFrame, PySpa…
Collect() in PySpark
PySpark collect() Function – The collect() function in PySpark is used to retrieve all the rows of a DataFrame (or RDD) from the distributed cluster back t…
Applying Functions in PySpark
PySpark, the Python API for Apache Spark, provides multiple ways to apply functions to DataFrame columns. This flexibility allows data engineers and analys…
Joins in PySpark
They allow us to combine two or more DataFrames based on a common column, enabling efficient data processing and analysis. 1. PySpark Join Types Below are …
union(), unionAll(), and unionByName() in PySpark
Here's the corrected explanation of union() , unionAll() , and unionByName() in PySpark along with appropriate examples. 1. union() The union() method is u…
PySpark Pivot and Unpivot DataFrame
✅ What is Pivot and Unpivot? Pivot = Convert rows into columns Unpivot = Convert columns into rows 🌀 Sample DataFrame Let’s start with a small DataFrame t…
File Handling(create, read, write, and delete files etc.)
File Handling in Python allows us to create, read, write, and delete files . It's an essential feature when working with data that needs to be stored perma…
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,…
Understanding Data Types and Variables in MSSQL vs PostgreSQL
📊 Data Types Comparison Table 🚩 Category 🟦 MSSQL 🟨 PostgreSQL Integer Types INT , BIGINT , SMALLINT INTEGER , BIGINT , SMALLINT , SERIAL Decimal Types …
Advance Python Concept
The @property decorator in Python is used to make a method behave like an attribute . It allows you to define getters, setters, and deleters in an elegant …
Dynamic CREATE TABLE Script in SQL Server
DECLARE @TableName NVARCHAR(100) = 'Employee'; DECLARE @SQL NVARCHAR(MAX) = ''; DECLARE @PKCols NVARCHAR(MAX) = ''; -- Get Primary Key Column(s) SELECT @PK…
Row-Based vs Column-Based (Columnar) Storage
Database me table hume: Rows aur columns ke form me dikhti hai. Lekin internally data store hone ka tareeka alag hota hai. Do main storage types hote hain:…
What is MPP (Massively Parallel Processing)
Aaj ke time me: ✔ Data bahut fast grow ho raha hai ✔ Users bahut zyada queries run kar rahe hain ✔ Reports real-time chahiye Traditional database model is …
SQL Server Agent Jobs & Schedules – Complete Practical Guide (Step-by-Step)
Agar aap SQL Server me automation samajh chuke ho, to next logical step hai SQL Server Agent Jobs aur Schedules ko practically use karna . Is blog me hum d…
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…