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 - Understanding Time Zones in SQL Server

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

3 - Execute Dynamic SQL commands in SQL Server

SQL Server Performance Tuning Checklist

Get Free SQL Tips

SQL Server Tutorials

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.

TSQL

Many Uses of SQL CASE Expression in a JOIN Clause

In this article, we look at the many uses of the SQL CASE expression and whether you should ever use CASE in a JOIN.

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.

Application Development

SQL Server Connection String Examples with PowerShell

In this article we look at different parameters and options that can be used with connection strings to connect to a SQL Server instance and database.

Tutorial

SQL DATEPART Function Use and Examples

Learn how to use the SQL Server DATENAME function to return an integer value for a specific part of a date such as day, hour, month, etc.

Tutorial

SQL LTRIM Function Use and Examples

Learn how to use the SQL Server LTRIM function to removed leading spaces from a string.

Tutorial

How To Launch a SQL Server Profiler Session

In this section we look at how to lauch the SQL Server Profiler tool to begin capturing data.

Whitepaper

SQL Server Performance Tuning Checklist

This SQL Server checklist will serve as a starting point to help determine what steps might make sense as part of a performance improvement effort.

Webcast

Modern High-Performance Tools for SQL Server DBAs

dbWatch Control Center is the latest database monitoring and management solution from dbWatch and we will demonstrate how you can efficiently monitor

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.