1.1. SQL Administration
- AdventureWorks Sample Database in SQL Server locally or in Azure
- Bulk Copy Program (BCP) Utility – Fast Bulk Import and Export in SQL Server
- Data Masking in SQL Server – How to Hide Data in a Specific Column
- Data Warehouse – Cost? Project Documentation and How to Manage a Project
- Installation of MS SQL Server – Planning, Hardware, and Software Requirements
- Installing SQL Server from the command line (cmd)
- Mac M1/Apple Silicon – SQL Server Developer – Installation Guide
- Resource Governor – Configuration, Resource Pools, Workload Groups
- SQL | SEQUENCE (ID Generation) and CACHE settings
- SQL | Triggers in SQL Server – Definition, Types, Syntax and Examples
- SQL Alerts and Notifications on SQL Server – Database Mail (Part 4.)
- SQL Automatic Index fragmentation fix in SQL Server + Script
- SQL Collation – How to Change Collation of Table Column
- SQL Emails in Reporting Services via Subscription – Database Mail (Part 3)
- SQL Error: Login Failed for User – What to do?
- SQL Error: Saving Changes is Not Permitted – Solution with Example
- SQL Index Fragmentation – Example + SQL Scripts
- SQL Indexes – Indexing Theory Simply, Balanced Tree, Heaps
- SQL List of Tables Without a Primary Key – Script
- SQL Server Agent for SQL Express + How to Guide, Task scheduler
- SQL Server Backup – Backup Types (Simple, Full, Diff) and Choosing a Strategy
- SQL Server Change data capture (CDC) – Tracking Changes in a Table
- SQL Server Creating Email Notification using T-SQL – Database Mail (Part 2.)
- SQL Server DBCC (Database console commands) – Overview
- SQL Server Email Configuration from Gmail – Example – Database Mail (Part 1)
- SQL Server Error Messages and Severity – sys.messages + Description
- SQL Server Express 2014 Installation Step by Step
- SQL Server Login – Definition of Server-Level Permissions
- SQL Server Table and Index Compression (Data Compression), Pros/Cons
- SQL Simple Recovery Model – Functions and Backup
- SQL User – Definition of user permissions at the database level
- SQLCMD (Server command line) – Run SQL query via cmd
- xp_cmdshell – How to Enable cmdshell in SQL Server?
1.2. SSRS – Reporting Services
- SQL Emails in Reporting Services via Subscription – Database Mail (Part 3)
- SQL Server – Reporting services 2016 News
- SSRS – Handling multiple value parameter/filters in reporting services
- SSRS | How to Create an Amortization Calculator in SQL Server – Including a Report with Parameters
- SSRS Tutorial Part 1 – Creating SSRS Project and Report in Reporting Services
- SSRS Tutorial Part 2 – Data Source Configuration in SSRS – Reporting services
- SSRS Tutorial Part 3 – How to Configure Dataset in SSRS – Reporting Services
- SSRS Tutorial Part 4 – Creating Report in SSRS – Reporting Services
- SSRS Tutorial Part 5 – Configuring Parameter/Filter in SSRS – Reporting Services
- SSRS Tutorial Part 6 – How To Deploy Report in SSRS – Reporting Services
1.3. SSIS – Integration Services
- KingswaySoft | Automation ETL SSIS data integration – data warehouse
- SQL Error – Microsoft.ace.oledb provider is not registered on the local machine
- SSIS | Control Flow – Tasks, Containers and Data Flow – Integration Services (Beginners)
- SSIS | Data Flow Task for Beginners – ETL Data Pump Component with Example
- SSIS | Integration Services for Beginners – Introduction, BIDS, Project, Package, SSIS Toolbox
- SSIS | SQL Server Parallelism, parallel data processing – more procedures at the same time
- SSIS Connection Manager + Example of a Simple ETL Data Pump
- SSIS Google analytics Data Import into SQL Server Database (using KingswaySoft)
- SSIS Toolbox – List of All Components and Tasks
2. SQL Tutorials
2.1. SQL Basics
- Basic SQL Queries – Overview For Beginners With Examples
- SQL Basics – The Most Commonly Used Statements for Beginners
- SQL Duplicates in a Table with an Example – How to Retrieve a List of Duplicate Values?
- SQL Error – Conversion failed when converting the varchar value to data type int
- SQL Export Table from SQL Server to Excel via SSMS
- SQL FULL JOIN – Joining Tables in SQL With Explanation in Excel
- SQL GROUP BY – Aggregating Data in Table
- SQL HAVING vs WHERE – What’s the difference?
- SQL INNER JOIN – Joining Tables in SQL With Explanation in Excel + Examples
- SQL LEFT OUTER JOIN – Joining tables in SQL With Explanation in Excel
- SQL ORDER BY – Sorting Data in SQL Table in Descending or Ascending Order
- SQL RIGHT OUTER JOIN – Joining Tables in SQL With Explanation in Excel + Example
- SQL SELECT – Selection of Columns From the Table – Basic Clause
- SQL WHERE Clause – Adding a condition using SQL
2.2. Handling SQL Tables
- SQL ALTER TABLE – Syntax, Add, Change Data Type, Delete Column
- SQL CREATE TABLE- How to Create a Database Table (SQL Server)
- SQL DELETE TABLE Statement, Difference DELETE and TRUNCATE, Deleting Large Amounts Of Data
- SQL INSERT – Inserting Rows into Database Table (3 methods) + Common mistakes
- SQL MERGE Statement – INSERT, UPDATE, DELETE at once
- SQL TRUNCATE TABLE Command vs DELETE
- SQL UPDATE Statement – Syntax and Example of Updating Records
2.3. Clauses
- Basic SQL Queries – Overview For Beginners With Examples
- SQL HAVING vs WHERE – What’s the difference?
- SQL ORDER BY – Sorting Data in SQL Table in Descending or Ascending Order
- SQL SELECT – Selection of Columns From the Table – Basic Clause
- SQL SELECT DISTINCT – Removing Duplicates from Table = Unique values
- SQL WHERE Clause – Adding a condition using SQL
2.4. Operators
- SQL BETWEEN Operator – Defining Range in a Condition with Examples
- SQL EXISTS Operator With Exampes – Existence Test
- SQL IN Operator – Multiple Values In Condition
- SQL LIKE Operator with Examples – Using Wildcards
- SQL UNION Operator – Unification of Sets with Example
2.5. Functions
- SQL COUNT Function – How to Count Rows In a Table with Examples
- SQL Error – Conversion failed when converting the varchar value to data type int
- SQL ISNULL vs COALESCE Functions – What Are The Differences And Usage
- SQL OFFSET (Window) Functions – LAG, LEAD, FIRST_VALUE, LAST_VALUE
- SQL REPLACE Function – Replace Text String
- SQL Server Aggregate Functions – SUM, COUNT, MAX, MIN, AVG
- SQL Server Ranking Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
- SQL String Functions – Overview of Text Functions in T-SQL
- SQL SUBSTRING Function – Get Part of String With Example
2.6. Commands
- SQL # Temp Table – Difference between # and ## Temp Tables
- SQL CTE (Common Table Expressions) With Examples – More Organized Queries and Procedures
- SQL IDENTITY (Auto increment) – Automatic value increase, description
- SQL IF THEN ELSE Command – Do Not Mix Up With CASE
- SQL INSERT – Inserting Rows into Database Table (3 methods) + Common mistakes
- SQL Loop – Do you Know How to Use WHILE or Recursive CTE?
- SQL OVER() with PARTITION BY – Definition, Example wint ROWS BETWEEN
- SQL Query Logical Processing Order
- SQL RAISERROR – How to Call an Error and Abort the Script
- SQL Server ROLLUP, CUBE, GROUPING SETS – Totals and Subtotals
- SQL Server TRY CATCH and Error Handling with Examples
- SQL THROW Exception – Alternative to RAISERROR and Differences
- SQL UNION ALL – Merge of Queries with Example
2.7. Useful scripts
- Basic SQL Queries – Overview For Beginners With Examples
- Bulk Copy Program (BCP) Utility – Fast Bulk Import and Export in SQL Server
- SQL Automatic Index fragmentation fix in SQL Server + Script
- SQL Duplicates in a Table with an Example – How to Retrieve a List of Duplicate Values?
- SQL IDENTITY (Auto increment) – Automatic value increase, description
- SQL List of Tables Without a Primary Key – Script
- SQL OFFSET (Window) Functions – LAG, LEAD, FIRST_VALUE, LAST_VALUE
- SQL Row Count and Table Size Check in a Database + Script
- SQL Server | Performance optimizing of SQL Queries – 10 Tips with Examples
- SQL Server Agent for SQL Express + How to Guide, Task scheduler
- SQL Server Create Database CREATE DATABASE + Script
- SQL Server Creating Email Notification using T-SQL – Database Mail (Part 2.)
- SQL Server DBCC (Database console commands) – Overview
- SQLCMD (Server command line) – Run SQL query via cmd
- SSRS | How to Create an Amortization Calculator in SQL Server – Including a Report with Parameters
- xp_cmdshell – How to Enable cmdshell in SQL Server?
2.8. XML for SQL Server
3. Power BI
3.1. DAX for Power BI
- Aggregation in DAX – How Aggregations Work? + Function Overview
- DAX | SUM and SUMX – How to Perform Aggregation in DAX Language for Power BI
- DAX Difference Between Measure and Column + Example on Report
- DAX language – Introduction into DAX for Power BI and Powerpivot
- DAX RELATED Function for Power BI – Lookup Into Table
- FILTER Functions for Power BI in DAX – Overview
- Function DAX CALCULATE – Aggregation With a Condition in Power BI
- Parameters in DAX – Introduction into DAX Expressions
3.2. Power BI Desktop
- Power BI Custom Visuals – Additional Visualizations to Power BI Desktop
- Power BI Desktop – Powerful Report Tool Introduction
- Sales Report in Power BI and Direct Query into SQL Database
3.3. Power Pivot
- Getting Started with Power Pivot – Data Modeling in Excel
- How to Enable Power Pivot in Excel
- Power Query, Power Pivot and Power BI – What’s the Difference?
3.4. Power Query
- Connecting to SQL Server | Power Query
- Power BI Refresh Does Not Work – Reason?
- Power BI Report (Dashboard) Tutorial Step By Step
- Power Query – Powerful Tool For Self Service BI – Introduction
- Power Query, Power Pivot and Power BI – What’s the Difference?
3.5. Sample reports in Power BI
- Financial Report in Power BI – Balance sheet and Income Statement
- How to Get Started With Power BI + BI Tools for Excel
- Microsoft Power BI – 10 Reasons to Use It
- MS BI Developer Skill Set – List of Knowledge and Abilities
- Power BI Report (Dashboard) Tutorial Step By Step
- Sales Report in Power BI and Direct Query into SQL Database
4. Excel
4.1. Excel Functions
- AND, OR Logical Functions in Excel
- Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
- Excel | Mean (Average) Overview – Types, Formulas, Example
- Excel | Subtotal – 11 Functions in One
- Excel | Text Functions – Top Functions Overview + Examples
- Excel | VLOOKUP vs HLOOKUP – What’s the Difference + Example
- WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?
- Weighted Arithmetic Mean in Excel – SUMPRODUCT
4.2. Excel Tutorials
- Excel Fuzzy Lookup Guide – Comparing 2 Lists with Example
- Excel Import to SQL Server Database via SSMS
- Getting Started with Power Pivot – Data Modeling in Excel
- How to Enable Power Pivot in Excel
- How to Execute SQL Query in Excel – Tutorial with Examples
- How to Execute SQL Server Procedure in Excel with Parameters