SQL Server Tips, Articles and Training

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.

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.

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.

Popular Right Now

1 - Using SQL Server Profiler to Capture Stored Procedures Executions

2 - SQL Server Connection String Examples with PowerShell

3 - Using Power BI with JSON Data Sources and Files

SQL Server Performance Tuning Checklist

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

Calculating Costs for Microsoft SQL Server

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.

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.

Functions System

SQL Server PIVOT and UNPIVOT Examples

In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples.

Functions System

SQL Server PIVOT and UNPIVOT Examples

In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples.

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.

Tutorial

Using try catch in SQL Server stored procedures

Error handling is a key part of stored procedure development and this section covers how to build error handling logic.

Tutorial

Generate INSERT statement in Management Studio

Learn how to auto generate an INSERT statement by using the features in SQL Server Management Studio.

Tutorial

SQL Server Stored Procedure with Parameters

In this tutorial topic we will cover how to create SQL Server stored procedures that use input parameters.

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

Achieving Resilience in Building Management and Security Systems: Essential Strategies for SQL Server High Availability

Learn about real-world use cases and the benefits of embracing high-availability solutions for Building Management and Security Systems.

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.