SQL Server Tips, Articles and Training

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.

SQL Server Cursor Example

SQL cursor is T-SQL logic to loop over a predetermined number of rows one at a time to update data or perform DBA processes such as backups.

Popular Right Now

1 - What MAXDOP setting should be used for SQL Server

2 - Different Ways to Format Currency Output in SQL

3 - Getting Started with SQL Server Developer Edition

Get Free SQL Tips

Learn Power BI Today

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

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.

Reporting Services Development

SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports

Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.

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.

Power BI Charts

Power BI Dynamic X and Y Axis Using Groupings in Field Parameters

Learn how to dynamically select what should be on the X or Y axis of a Power BI chart in this step-by-step article.

Tutorial

SQL Server Reporting Services (SSRS) Tutorial

In this tutorial we will step through a number of topics that you need to understand to successfully build a report using SSRS.

Tutorial

Work with Sample Data in SQL Server Integration Services SSIS

In this tutorial we will setup test databases that can assist us with testing and learning more about SSIS.

Tutorial

Download, Install and Update SQL Server Management Studio

In this part we look at how to download, install and update SQL Server Management Studio.

Whitepaper

Understanding Disaster Recovery Options for SQL Server

This white paper provides some practical guidance to help system and database administrators tasked with creating business continuity and disaster rec

Webcast

Disaster: LIVE! - SQL Server from disaster to operational

This event will guide you through a few simulated disasters of SQL Server to see the steps to follow to go from disaster to operational.

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.