SQL Server Tips, Articles and Training

Power BI Treemap Chart Step-by-Step Tutorial

Learn how to use and format the treemap visual in Power BI in this step-by-step tutorial.

How to Sort String Date Values on a Power BI Slicer Visual

In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.

Large Language Models with Azure AI Search and Python for OpenAI RAG

Infuse Azure SQL data with retrieval augment generation (RAG) for large language models (LLMs) such as GPT to provide answers to complex questions.

Popular Right Now

1 - How to Grant Permissions to run SQL Server Profiler for a non System Admin User

2 - Simple way to Import XML Data into SQL Server with T-SQL

3 - Several Methods to collect SQL Server Stored Procedure Execution History

Learn Power BI Today

Disaster Recovery in the Cloud: Understanding Challenges and Strategies for SQL Server

SQL Server Performance Tuning Checklist

Microsoft Fabric

Microsoft Fabric Monitoring with Metrics App and Data Activator

Learn about Metrics App and Data Activator for monitoring and taking necessary administrative action to control Microsoft Fabric capacity.

Import and Export

SQL Bulk Insert Command Examples

Learn about the SQL Server BULK INSERT command and how to use it to import text data in a SQL Server database table.

TSQL

SELECT TOP 10 SQL Examples

In this article, we look at various ways to use SQL SELECT TOP to return a certain number or percentage of rows when selecting data.

Python

Data Quality Management Issues in Time Series Analysis Resolved with Python

In this tutorial, we delve into critical aspects of data quality management when working with time-series data and we will use Python to demonstrate.

Temp Tables

Mastering SQL Server Local and Global Temporary Tables

In this article, we walk through the syntax for SQL Server local and global temporary tables and also use cases for when and how to use them.

Azure Synapse Analytics

Azure Synapse Analytics and Power BI Integration

In this article, learn how to integrate Power BI reports with data from Azure Synapse Analytics in this step-by-step tutorial.

Microsoft Fabric

Microsoft Fabric Lakehouse OPTIMIZE and VACUUM to Cleanup Parquet Files

In this article, we will explain how the OPTIMIZE and VACUUM commands can assist in maintaining the tables in the Microsoft Fabric Lakehouse.

Python

Python String Function Examples - Concatenate, Split, Replace, Upper, Lower

Learn how to manipulate strings in Python with these string functions: concatenate, split, replace, upper, lower, and more.

Professional Development Certifications

AZ 104 Exam Preparation for Microsoft Azure Administrators

Get ready for and pass the Microsoft Azure Administrators AZ-104 Exam with this study guide with lots of useful resources.

Functions System

Learn how to convert data with SQL CAST and SQL CONVERT

Learn how to convert SQL Server data to different data types such as string, date, integer and numeric using the CAST and CONVERT functions.

Python

Running a Python Application as a Windows Service

In this article, we look at how to build a Python application that runs as a Windows Service to handle ongoing routine tasks.

Power BI

Dynamically Compute Different Time Duration in Power BI Using DAX

Learn how to display the difference of two different time periods in days, hours, minutes and seconds for Power BI reports using DAX.

Tutorial

SQL Server Window Aggregate Functions SUM, MIN, MAX and AVG

In this part of the tutorial we’ll look at aggregate functions – sum, min, max, avg, etc. – and their relation with window functions.

Tutorial

SQL Server Analysis Services Backup and Restore

In this chapter we are going to discuss how to complete SQL Server Analysis Services database backups and restores.

Tutorial

Snowflake Tutorial Overview

In this tutorial we will go over the basics of Snowflake, introducing the product and features which makes it stand out against its competitors.

Whitepaper

Secrets to Fast, Easy High Availability for SQL Server in Amazon Web Services

Learn how to quickly build a two-node HA cluster for SQL Server in the AWS cloud.

Webcast

Azure SQL Database performance

Attend this webinar to learn how to monitor performance for Azure SQL Database.

Webcast

Accurate Data for Decision Making - How to Improve Business Insights

Learn how to improve your SQL Server data, analytics and decision making with curated and gold-standard reference data directly accessible in SQL Serv