Results for "azure"
17 / 184 posts
How to find table column information by using SQL query
Comprehensive Guide to Fetching Table and Column Metadata with SQL Server Stored Procedures When working with databases, understanding the structure of tab…
What are Constraints in SQL?
SQL में constraints डेटाबेस टेबल में डेटा को सुरक्षित और सही बनाए रखने के लिए उपयोग किए जाते हैं। ये टेबल में डेटा की वैधता (validity) और अखंडता (integrity…
XML Data – Complete Conceptual Guide (SQL Server Perspective)
How insert data on table from XML in SQL server, example: There are two method for insert data in table from XML. DECLARE @XMLInput VARCHAR(MAX); SET @XMLI…
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…
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 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…
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 …
Spark Transformations, Actions and Lazy Evaluation and DAG.
Apache Spark RDD supports two types of Operations: Transformations Actions A Transformation is a function that produces new RDD from the existing RDDs but …
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…
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…
Store Error Logs In SQL
Create Table for Error log: CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY(1,1) NOT NULL, [ErrorTime] [datetime] …
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…
Database Permissions in SQL Server
In SQL Server, database permissions control what actions users can perform on specific database objects (like tables, views, and stored procedures). Permis…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
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…
Understanding Stored Procedures in MSSQL
What is a Stored Procedure? A stored procedure is a group of SQL statements that are compiled and saved in the database. Instead of writing the same SQL qu…
Azure Data Factory (ADF)
Azure Data Factory (ADF) Kya Hai? Soch le tu ek delivery company chalata hai – jaise Swiggy/Zomato. Restaurant se khana uthaya → pack kiya → raste me check…