tab Resources

Share

Related resources for tab

Fabric Data Factory: On-Prems Folder to Fabric SQL Database1/20/2025 9:45:15 AM. In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for
Entity Framework (5-1), With .Net Core MVC, Database-First --- Scaffold-DbContext1/18/2025 7:33:03 PM. This article is to discuss the reverse engineering command Scaffold-DbContext by AI.
Entity Framework (5), With .Net Core MVC, Database-First1/18/2025 6:49:50 PM. This article will describe Entity Framework with .Net Core MVC, Database-First approach,
Configuring Route Table in AWS1/18/2025 6:54:27 AM. Learn how to configure AWS VPC route tables to manage network traffic between subnets and gateways. This guide covers adding routes, selecting gateways, and verifying configurations to connect AWS and
Let's Play with ServiceNow Table API Using Postman1/15/2025 3:39:16 AM. Learn how to create and test a POST Table API in ServiceNow using Postman. Step-by-step guide covers API setup, JSON payload, authentication, headers, and testing, ensuring secure and efficient data h
SQL Server – Query Performance – Database Maintenance can Help1/15/2025 3:19:58 AM. To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual
How to Configure Security Groups in AWS VPC1/14/2025 8:43:39 AM. A Security Group in AWS is a virtual firewall controlling inbound/outbound traffic for resources like EC2 and RDS. It defines rules for IPs, ports, and protocols, ensuring secure access within your Vi
Local and Global Temporary Tables in SQL Server1/13/2025 6:55:28 AM. Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
Transaction in SQL Server1/13/2025 5:32:43 AM. This article covers the basics of SQL transactions, including BEGIN, COMMIT, and ROLLBACK commands, ACID properties, isolation levels, and error-handling techniques for effective database management.
Database Dictionary (2) --- Extended Properties1/11/2025 2:47:23 PM. This article will discuss Data Dictionary, Extended Property
Database Dictionary (1-2) --- Create a System Data Dictionary Database1/11/2025 2:47:05 PM. This article will create a System Data Dictionary Database
Database Dictionary (1-1) --- Server, Database, Schema, Table and Column1/11/2025 2:46:44 PM. This article is to discuss the major schemata in SQL server.
Database Dictionary (1) --- Schema1/11/2025 2:46:24 PM. This article will discuss the database schema.
Advanced C# 13 and .NET 9 Features for Expert .NET Engineers1/10/2025 10:20:34 AM. With this guide, you will learn about enhanced pattern matching, static abstract members, Native AOT, and much more in C# 13 and .NET 9. Written by Ziggy Rafiq, this is the best resource for experienc
How to use Databricks AI Mask Function To Protect Sensitive Data1/8/2025 6:10:51 AM. In this video, I demo how to use the powerful Databricks AI_Mask Function to obfuscate sensitive data
Database Dictionary (3) --- Loop Databases and Servers by AI1/7/2025 3:34:49 PM. This article will discuss to loop databases and servers
Azure SQL Database - Configure Job using Elastic Agents1/7/2025 8:41:35 AM. This article covers setting up Elastic Job agents, creating jobs, and automating tasks across multiple databases. Streamline database management, schedule tasks efficiently, and enhance performance wi
Optimize Relationships Migrations Performance in ASP.NET Core MVC1/6/2025 10:00:24 AM. This article covers Entity Framework Core, query optimization, caching strategies, lazy and eager loading, and best practices to enhance your MVC application's efficiency.
Create Database-Scoped Users for Microsoft Entra Security Groups1/6/2025 7:24:39 AM. In modern cloud environments, managing access to databases at scale can be challenging. By integrating Azure SQL with Microsoft Entra (formerly Azure Active Directory) Security Groups, you can streaml
Database Dictionary (1-2-1) --- Using Dynamic SQL Script1/4/2025 1:53:53 PM. This article will discuss when to use dynamic SQL Script and the conditions.
How to Restore a Snapshot in Amazon RDS1/3/2025 5:59:11 AM. Learn how to restore a snapshot in Amazon RDS with this simple step-by-step guide. Amazon RDS allows you to back up and restore your database easily using snapshots.
How to Take Snapshots in Amazon RDS1/2/2025 10:57:31 AM. Learn how to take snapshots of your Amazon RDS database with this simple explanation. Snapshots act as backups, capturing your database at a specific point in time for easy restoration.
How to Set Up DynamoDB in AWS?1/2/2025 7:33:42 AM. Amazon DynamoDB is a fully managed, serverless NoSQL database service offering fast performance, scalability, and flexibility. It supports key-value and document data models, with global availability
AI_GEN Function in Databricks SQL12/31/2024 5:14:12 AM. This video walks you through how you can use the new ai_gen function in Databricks SQL which leverages on generative AI models to process and respond to to user-provided prompts
Azure Databricks Activity in Fabric Data Pipeline + Power BI12/28/2024 7:38:17 AM. In this video, I covered how to use Azure Databricks Activity in Fabric Data Pipeline to orchestrate ingestion of files from Databricks File System to Fabric Lakehouse as delta table.
How to Set Up and Use AWS RDS for Beginners12/27/2024 9:08:08 AM. Learn how to create an AWS RDS database with this beginner-friendly guide. AWS RDS simplifies database setup and management, supporting engines like MySQL, PostgreSQL, and MariaDB.
Automated Cross-Tenants Data Sharing in Microsoft Fabric12/18/2024 6:17:49 AM. In this new data engineering video, I covered how to architect automated cross-tenants data sharing in Microsoft Fabric focusing on Lakehouse. You will learn how to enable the share and receive extern
Unlocking Faster INSERT Operations in SQL Server with TABLOCK12/17/2024 6:48:30 AM. In this article learn how using the TABLOCK hint in SQL Server can significantly speed up INSERT operations by reducing logging overhead and enabling parallel insertions.
A Threadsafe C# LRUCache Implementation12/16/2024 5:27:17 AM. The LRUCache<TKey, TValue> class in C# provides a custom implementation of a Least Recently Used (LRU) cache. It optimizes memory usage by retaining a fixed number of items and evicting the leas
Bulk Insert Example with Two SQLite DB Files using .NET12/13/2024 5:06:10 AM. Learn how to merge two SQLite databases in C# using bulk insert/update. This method reads data from one DB and updates or inserts it into another, achieving efficient data merging.
Entity Framework (10), With .Net WebForms, Database-First12/12/2024 2:31:52 PM. This article will to discuss Entity Framework With .Net WebForms, Database-First approach.
Entity Framework (7), With .NET WPF, Database-First12/12/2024 2:31:04 PM. This article describe to develop a WPF app with entity framework, database first approach.
Understanding the AI_EXTRACT SQL Function in Databricks12/12/2024 7:17:56 AM. This article dives into the mechanics of AI_EXTRACT, its syntax, and various use cases with examples. AI_EXTRACT in Databricks extracts structured data, like names and dates, from unstructured text us
Entity Framework (2), With .Net MVC, Database-First12/11/2024 9:28:27 PM. This article will be Entity Framework with .Net MVC, Database-First approach,
Modern Featured Entity Framework With SQLite DB Example 12/11/2024 10:31:03 AM. Learn to build a .NET Core application using C# async/await and SQLite with Entity Framework. Implement CRUD operations, handle asynchronous tasks, and explore efficient database interaction using Vis
React v19 Now Stable: What Developers Need to Know12/11/2024 7:00:41 AM. React v19 has officially reached stable release, bringing enhanced features and performance for developers building dynamic user interfaces. Dive into the new version to streamline your projects and l
SQLite Database with .NET Example12/10/2024 9:51:01 AM. SQLite is a lightweight, file-based relational database ideal for small web, mobile, and .NET applications. This guide demonstrates SQLite integration, CRUD operations, and database handling using C#.
Create Multi-page AI/BI Dashboard in Databricks12/10/2024 8:50:41 AM. In this video, I covered how to create multi-page AI/BI dashboard in databricks leveraging unity catalog data.
Automating Table Creation using SSIS12/10/2024 8:44:47 AM. In this article, we will see how to create a database table in SQL Server using the SSIS package. Learn how to create a database table in SQL Server using an SSIS package. Follow step-by-step instruct
Understanding Triggers in SQL Server12/9/2024 7:29:47 AM. SQL Server triggers are automated procedures executed on DML/DDL events. This guide explores trigger types, real-world examples, and implementations for logging, validation, and restriction in SQL Ser
Unit Test (2) --- TSQLT12/7/2024 2:51:50 AM. This article will discuss TSQLT Unit Test.
What is a CTE, and How Do You Write a CTE in SQL Server?11/29/2024 8:23:30 AM. A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into ma
Optimizing Performance in Azure Cosmos DB: Best Practices11/29/2024 5:20:56 AM. Azure Cosmos DB optimization enhances performance, scalability, and cost-efficiency. Key practices include selecting the right partition key, customizing indexing, optimizing queries, tuning consisten
Implement Databricks Lakehouse Federation (BigQuery)11/29/2024 4:42:00 AM. In this new video, I covered how to implement and run federated queries federated queries on Google BigQuery.
.NET with MONGO Database Code Example11/28/2024 8:22:04 AM. Learn MongoDB integration with .NET, from setup to CRUD operations. Discover its advantages, like cross-platform flexibility, high-speed data handling, and robust security, with code examples for seam
Explaining CTE in SQL Server11/27/2024 8:21:27 AM. Common Table Expressions (CTEs) in SQL simplify complex queries by creating temporary result sets. They can be used in SELECT, INSERT, UPDATE, and DELETE statements, supporting scenarios like hierarch
Renaming a Database in SQL Server11/27/2024 5:11:47 AM. Renaming a database in SQL Server is vital for tasks like aligning naming conventions, testing, or version control. It involves setting the database to single-user mode, ensuring no active connections
Exploring SQL Databases in Microsoft Fabric11/22/2024 11:29:28 AM. Microsoft Fabric now integrates SQL databases, bridging transactional and analytical workloads in a unified platform. It enables cloud-native data storage in OneLake, supporting Parquet and Delta form
CI/CD of MSFT Fabric Database via Azure DevOps11/22/2024 8:20:13 AM. Learn how to set up a CI/CD pipeline for Microsoft Fabric Database using Azure DevOps. This guide covers automated deployment, integration, and management of databases in a seamless DevOps workflow.
Comparison Between SQL and MongoDB Database11/22/2024 5:23:46 AM. SQL and NoSQL(MONGO) DB Comparison. This article compares MS SQL Server and MongoDB, highlighting their development, data models, schemas, performance, and query mechanisms, aiding in understanding th
User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single valu
Events: Love Triangle in Integration Testing11/20/2024 6:30:48 AM. This video will delve into the main problems of not creating integration tests that check whether the application works fine, showing different alternatives with their pros and cons.
Temporary Tables vs Table Variables in SQL Server Explained11/19/2024 10:49:20 AM. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Delta Tables in Microsoft Fabric🔼11/18/2024 7:51:14 AM. Delta tables in Microsoft Fabric offer a powerful way to manage large-scale data efficiently. Built on open-source Delta Lake, they enable ACID transactions, versioning, and real-time data streaming.
SSRS (4) --- SQL Server Database Project in Visual Studio11/11/2024 8:37:33 PM. This article is to discuss: SQL Server Database Project in Visual Studio
Read Multiple CSV Files from GitHub Repository to Databricks Notebook11/11/2024 5:52:15 AM. In this Data engineering episode, I covered how to read multiple CSV files from GitHub Repository to Databricks Notebook for analysis.
Mirror Azure Databricks Unity Catalog in Microsoft Fabric11/7/2024 4:43:27 AM. In this video, I covered how to mirror Azure Databricks Unity Catalog in Microsoft Fabric for downstream analysis in Power BI Service.
Understanding Distributed and Monolithic SQL Architectures11/5/2024 10:01:52 AM. In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance,
Creating Azure SQL Database with Tables11/4/2024 4:59:13 AM. In this video, I demo how to create Azure SQL database, create and insert records into the table, and query the data.
Implement a RAG Solution Using Azure SQL Database11/1/2024 11:03:43 PM. In this brief video I walk you through the components of retrieval augmented generation (RAG). I talk about embeddings and vectors and even show you how they are created. Finally, I'll show you
Create Premium Databricks Workspace on Azure in 5 mins10/31/2024 4:45:34 AM. This video shows how to create Databricks workspace on Azure.
How to Store Temporary Information in Table Like Format in C#?10/28/2024 8:56:49 AM. In this article, we will learn how to manipulate and manage in-memory data effectively, allowing for quick access and modifications while maintaining a structured format for your applications.
Create a Model with Database Table in .NET 8 using EF Core10/28/2024 7:16:12 AM. This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection str
Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
Manage Azure SQL Roles with Azure Data Studio10/26/2024 5:43:14 AM. Azure SQL Database is a managed cloud database service enabling secure, scalable applications. With Azure Data Studio, a free, cross-platform tool, database admins can view and manage user roles and p
SQL Data Analysis in Databricks Notebook10/25/2024 6:09:40 AM. This video dives into performing SQL Data Analysis in Databricks Notebook.
Redis: RedisString and RedisJSON10/23/2024 8:19:31 AM. RedisString has long been the basic and most common data type in Redis. Recently, RedisJSON has gained popularity as a module that allows you to store, query, and manipulate JSON data natively.
Compiling Multiple Files to Build an Application10/22/2024 10:46:04 AM. This article explains how to compile multiple C files into a single executable using the C compiler. It covers two approaches: compiling multiple files with the cc command or using the #include direct
Read/Write From Fabric Lakehouse to Databricks Notebook using ABFSS Protocol10/21/2024 8:15:07 AM. In this episode, I covered how to Read/Write From Fabric Lakehouse to Databricks Notebook using ABFSS Protocol.
Getting Started with Databrick Dataset10/19/2024 3:05:37 PM. This article dives into how to use databricks preloaded datasets. Databricks Datasets provide ready-to-use, real-world data built into the Databricks platform, enabling users to easily access, analyze
Databricks: Provision and Analyze Azure SQL Database Table10/16/2024 7:38:47 AM. In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.
Is PostgreSQL the Future of Databases?10/16/2024 5:00:45 AM. This article explores whether PostgreSQL is the future of databases, highlighting its advantages in scalability, performance, and innovation. Discover how it compares to other database systems in toda
Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
Write Data from Fabric Dataflow Gen2 to Azure SQL Database10/15/2024 5:16:17 AM. In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.
How To Delete Duplicate Rows From A Table In SQL Server10/12/2024 5:29:23 AM. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the o
Make Divs Editable For User With jQuery10/11/2024 12:28:33 PM. This article outlines a simple method to make a generic DOM element editable, enabling users to modify its internal HTML. By using jQuery, the tutorial demonstrates how to convert a div into a textare
Implementing Azure Databricks AutoLoader (Incremental Data Loading)10/11/2024 4:25:22 AM. In this end to end video, I walked you through how to implement Azure Databricks Autoloader which allows incremental loading of new files from Azure Data Lake Storage Gen2.
Exclude Exchange Databases from Auto-Provisioning in New DAG - Exchange 201910/10/2024 3:49:52 AM. In a multi-DAG Exchange environment, there are often scenarios where we want to ensure that primary mailboxes remain on a specific DAG, while a new DAG is reserved solely for archive mailboxes. This c
Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)10/8/2024 8:54:22 AM. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
Passing Connection String Dynamically While Using a Model First Approach10/8/2024 3:57:28 AM. We'll discuss the importance of dynamic configuration for database connections, demonstrate effective techniques for setting up runtime connection strings, and highlight best practices for managin
Read Multiple PARQUET Files from GCS to Azure SQL Database using Azure Data Factory10/7/2024 4:56:25 AM. In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.
Real-World Expression Trees: Dynamic Filtering in C# with Minimal API10/6/2024 7:51:48 AM. This article explores the practical use of expression trees in C# by building an ASP.NET Core web API with dynamic filtering functionality. It demonstrates how to construct flexible queries using expr
Generate or find Connection String from Visual Studio10/3/2024 11:44:59 AM. This guide covers various methods, including using the Connection String Builder, accessing app.config and web.config files, and integrating with SQL Server and Entity Framework. Mastering connection
iPhone Memory Leaks Tracking and Use of Instruments10/3/2024 11:41:57 AM. This article explores iPhone memory leaks, detailing how to track them using Instruments and NSZombie. It explains what memory leaks are, their causes, and the consequences of losing track of allocate
Creating Stored Procedures with Managed Code10/3/2024 11:41:01 AM. This article demonstrates how to create a stored procedure in Microsoft SQL Server 2005 using managed code in C#. It details the process of setting up a SQL Server project in Visual Studio, writing th
How to Use a Cursor in SQL?10/3/2024 11:08:13 AM. A cursor in SQL is a database object that allows row-by-row processing of query results. It enables you to iterate through a result set, perform operations on each row, and manage data more efficientl
How to Compare Two Objects in C#10/3/2024 7:08:40 AM. In this article, we’ll walk through how to create a generic method that can compare the objects of any class, even those with nested collections. We’ll break it down step by step so you can implement
Hidden Gems - Converting the Table Response Into String Variable10/3/2024 3:55:29 AM. Discover the hidden gems and best practices for effectively handling data within Microsoft Copilot. Enhance your AI-driven applications by learning essential techniques for data manipulation and integ
Database, Data Warehouse, and Data Lake: A Comparative Analysis10/2/2024 4:49:26 AM. Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
Types of Keys in SQL10/1/2024 6:09:16 AM. In SQL, keys play a crucial role in maintaining data integrity and defining relationships between tables. Common types include the Primary Key, which uniquely identifies records; the Foreign Key, link
How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
Check which process deleted the files on Window9/28/2024 5:13:19 AM. Enable event logging to identify the process causing deletion operations. Set up folder auditing by adjusting security properties, adding auditing entries, and running AuditPol commands.
How to Send Mail Using SQL Server: Part 39/27/2024 10:16:21 AM. In this third installment of our series, "How to Send Mail Using SQL Server," we delve into the configuration and implementation of Database Mail. Learn how to set up SMTP settings, create m
Inserting Form Data Into DataBase Using Stored Procedure In ASP.NET C#9/27/2024 10:10:24 AM. Learn how to insert form data into a database using stored procedures in ASP.NET with C#. This guide covers setting up a form, handling user input, creating a stored procedure, and securely inserting
Getting Started with Azure SQL Database – A Beginners Guide9/27/2024 7:19:23 AM. A quick introduction to Azure SQL Database that showcases some key offerings and highlights the flexibility and scalability that comes with it.
Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse9/26/2024 9:45:47 AM. In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabr
Create Custom Tab in Office Ribbon at Excel/ Word 20079/25/2024 9:48:35 AM. This article provides a step-by-step guide for customizing Office 2007 applications like Excel and Word using Visual Studio 2008. It demonstrates how to create a custom tab in the Ribbon without codin
Create Dynamic Pivot Table Using Store Procedure9/25/2024 6:58:27 AM. Learn how to create a dynamic pivot table using a stored procedure in SQL. This guide covers transforming rows into columns dynamically, automating pivot table creation, and efficiently querying large
How To Create A Sparklines In Power BI Tables And Matrix Visual?9/24/2024 12:01:28 PM. This article explores the new "Sparklines" feature in Power BI as of December 2021, which allows users to visualize trends within table and matrix visuals. Sparklines provide a compact way t
How To Add A Button To Existing Ribbon Tab In Office Applications9/24/2024 11:56:24 AM. Learn how to enhance your productivity by adding a custom button to an existing Ribbon tab in Microsoft Office applications. We’ll walk you through the steps to customize the Ribbon, whether you'r

Topics