SQL Server Tips, Articles and Training

Microsoft Fabric Lakehouse Table Maintenance Options for High Performance - Part 1

In this tip, we'll discuss the various maintenance options for ensuring performance doesn't degrade for lakehouse tables when using Microsoft Fabric.

Troubleshoot SQL Server Always On Availability Groups with SQL LogScout

Learn about SQL LogScout which is a log analysis tool to help troubleshoot SQL Server errors by using the available log files on the system.

Read Data Stored in a Lake Database using Azure Synapse Analytics

In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.

Popular Right Now

1 - Connect to SQL Servers in another domain using Windows Authentication

2 - Recursive Queries using Common Table Expressions (CTE) in SQL Server

3 - Truncate all tables in a SQL Server database

Get Free SQL Tips

Learn Power BI Today

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

Microsoft Excel Integration

How to Visualize Time Series Data using Microsoft Excel

In this article, we look at how to visualize time-series data using Excel with a walkthrough of how this is done with a sample dataset.

Cloud Strategy

Serverless Microservice Computing Concepts and Architecture

Learn about the concept of serverless microservices and how this architecture could be used to support your applications.

Python

Time Series Forecasting using Python Prophet

Learn how to use the Python library Prophet for time series forecasting to predict a target variable over a period.

Replication

SQL Replication Error - the row was not found at the Subscriber when applying the replicated UPDATE command

Learn how to fix replication error the row was not found at the Subscriber when applying the replicated UPDATE command for Table with Primary Key(s).

TSQL

SQL Quick Reference Guide

This guide outlines aspects of working with SQL along with several links to resources to help you better understand how to use the SQL language.

Power BI

Rank and Sort Data Based on Multiple Columns in Power BI with DAX

This article describes two approaches to allow you to rank and sort data based on multiple columns in Power BI.

Power BI

Power BI Calculations without Complex DAX using Power Query Editor

Learn how to use the standard calculation options in the Power Query Editor of Power BI without having to write complex DAX calculations.

TSQL

SQL FROM Query Examples and Syntax

Learn about the SQL FROM clause to create tables, alter tables, views, aliases, join tables, subqueries, and DELETE FROM in queries.

Artificial Intelligence

Google Gemini - Generative AI Tool for SQL Professionals

This article looks at using Google's artificial intelligence tool Gemini to build and explain T-SQL code.

Database Configurations

SQL Server Connection Strings using SqlClient, OLDEDB and ODBC

In this article we look at different ways to define a connection string to connect to SQL Server using SqlClient, OLDEDB and ODBC connections.

TSQL

Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF

Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.

SQL Server 2019

SQL Server 2019 Express Step by Step Download, Install and Configure

Learn how to download, install and configure SQL Server 2019 Express Edition in this step-by-step article.

Tutorial

SQL UNICODE Function Use and Examples

Learn how to use the SQL Server UNICODE function to return the unicode value for a particular character.

Tutorial

Use SQL Server Management Studio to Connect to Database

In this section we look at how to use SSMS to connect to a SQL Server database engine.

Tutorial

Schedule Data Collection with Windows Performance Monitor

In this section we look at how to schedule automatic data collection of perfmon counters.

Whitepaper

How to Build a SANless SQL Server Failover Cluster Instance in Google Cloud Platform

Learn how to build a SQL Server Failover Cluster Instance (FCI) on the Google Cloud Platform (GCP).

Webcast

Writing efficient code for SQL Server Based Applications

In this webinar we will take a look at things you should be aware of when writing SQL code for your database applications. We will cover various topic

Webcast

Microsoft Fabric: What it is and why you would use it

Learn about Microsoft Fabric and whether this platform is the right choice for your data environment.