SQL Server Tips, Articles and Training

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 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 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.

Popular Right Now

1 - Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 3

2 - Set Select All as Default for Multi-Value Report Parameters in SQL Server Reporting Services

3 - Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

Calculating Costs for Microsoft SQL Server

Learn Power BI Today

Get Free SQL Tips

DevOps

How to use GitHub Actions to Deploy Database Changes After a Commit

In this article, we look at how to use GitHub Actions to deploy database changes after a commit to the Main branch in a GitHub repository.

Stored Procedures

SQL Server Temporary Stored Procedures

Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.

Microsoft Fabric

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.

Availability Groups

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.

Azure Synapse Analytics

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.

SQL Server Agent

SQL Server Agent Jobs, Automation and Email Notification

Learn how to set up, create jobs, and send email notifications using SQL Server Agent.

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.

Dates

Understanding Time Zones in SQL Server

In this article we look at the datetimeoffset data type in SQL Server and how this can be used to determine dates for different time zones.

SQL Server Management Studio Configuration

SQL Server Management Studio Dark Mode

Learn how to configure SQL Server Management Studio to use dark mode in this step by step article.

Install and Uninstall

How to install SQL Server 2022 step by step

In this article, we cover how to install SQL Server 2022.

Tutorial

Insert inital seed data into the table in SSDT

Learn how to insert an initial set of data in a table that is part of the SSDT SQL Project.

Tutorial

SQL Server Spatial Indexes

In this section we look at another type of SQL Server index, spatial indexes.

Tutorial

Creating SSIS Packages with SQL Server Management Studio (SSMS)

Learn about the different options to create an SSIS package.

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

DBA Best Practices - How to be a Smarter DBA

There are smarter practices for managing database servers. Come to this session to see how one DBA learned from years of mistakes to become a more eff

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.