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.

Build a Secure SQL Server REST API in Minutes

Build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise.

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.

Popular Right Now

1 - How to setup SQL Server alerts and email operator notifications

2 - Register a SPN for SQL Server Authentication with Kerberos

3 - Understanding SQL Server Linked Servers

Get Free SQL Tips

SQL Server Performance Tuning Checklist

SQL Server Tutorials

Temp Tables

Mastering SQL Server Local and Global Temporary Tables

In this article, we walk through the syntax for SQL Server local and global temporary tables and also use cases for when and how to use them.

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.

Install and Uninstall

How to install SQL Server 2022 step by step

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

Power BI

DAX CASE Statement Functionality with IF, SWITCH and SWITCH True

DAX does not have a CASE statement, so we look at other options that have similar functionality such as IF(), SWITCH(), and SWITCH(TRUE()).

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.

Tutorial

Query Execution Plans

Query plans help you get insight as to what SQL Server does with a query and how you can determine issues to improve query performance.

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.

Tutorial

SQL Server Master Data Services Overview

This tutorial covers Master Data Services and how this is beneficial to keeping a set of data consistent throughout your databases.

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

How to Optimize and Speed Up Your SQL

Join us for this webinar where we will cover various aspects of how to optimize SQL Server code.

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.