SQL Server Tips, Articles and Training

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros - all for free. The content we serve is all human written and based on our authors' real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.


Today's Resources

Convert a String to JSON with SQL Server Queries

Convert a String to JSON with SQL Server Queries

In this article, we look at various ways to generate JSON formatted data for SQL Server queries using FOR JSON option.

Comparing SQL Server and Oracle Backup Types

Comparing SQL Server and Oracle Backup Types

Learn about the similarities and differences of backing up a database in SQL Server versus Oracle.

Write Logical Expressions using DAX with Power BI Operators and Functions

Write Logical Expressions using DAX with Power BI Operators and Functions

Learn how to write logical expressions using DAX when working with Power BI with logical operators, functions, and more.

Python

Polymorphism in Python Code Examples - Functions, Classes, Inheritance and Duck TypingPolymorphism in Python Code Examples - Functions, Classes, Inheritance and Duck Typing

Learn about polymorphism in Python with these code examples to learn about functions, classes, inheritance, and duck typing.

Locking and Blocking

Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOTReduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT

This article explores how enabling READ_COMMITTED_SNAPSHOT on your SQL Server database might ease excessive blocking.

Integration Services Development

SSIS in One Hour: Hands-On TutorialSSIS in One Hour: Hands-On Tutorial

This tutorial shows developers how to use SSIS in transforming and combining data through hands-on examples.

TSQL

Express a Number or Currency in Words with T-SQL CodeExpress a Number or Currency in Words with T-SQL Code

This SQL script allows you to take a number and convert the number to words, and convert a currency value into words.

Database Design

Normalization in SQL to Reduce Data RedundancyNormalization in SQL to Reduce Data Redundancy

Learn about the various levels of normalization in SQL for a data model with these explanations and examples.

Containers

Best Practices for Docker to run SQL Server on a MacBest Practices for Docker to run SQL Server on a Mac

Check out this consolidated list of things you can (or should) do when using Docker to run SQL Server on a Mac.

PostgreSQL

PostgreSQL JSON and JSONB Data Types for Non-Structured or Semi-Structured DataPostgreSQL JSON and JSONB Data Types for Non-Structured or Semi-Structured Data

Learn about the most important syntaxes, features, and possibilities of the PostgreSQL JSON and JSONB data types.

PostgreSQL

Migrate a SQL Server Database to a PostgreSQL DatabaseMigrate a SQL Server Database to a PostgreSQL Database

Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.

Application Development

Advanced Features of DAB (Data API Builder) to Build a REST APIAdvanced Features of DAB (Data API Builder) to Build a REST API

Get guidance on the advanced features of DAB (Data API Builder) and how to set up a production-ready environment.

Functions System

SQL Server PIVOT and UNPIVOT ExamplesSQL 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.

Triggers

An Introduction to SQL TriggersAn Introduction to SQL Triggers

Learn about SQL Server triggers and how to use them for inserts, updates, and deletes on a table, along with step-by-step examples.

TSQL

Query SQL Server Data Based on Various Date and Time FunctionsQuery SQL Server Data Based on Various Date and Time Functions

This simple reference guide shows you various ways to query SQL Server data based on various date and time clauses.

Tutorial

Work with Sample Data in SQL Server Integration Services SSIS 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

SQL Server Window Functions LEAD and LAGSQL Server Window Functions LEAD and LAG

In this section we look at how to use lag, lead, first_value and last_value.

Tutorial

Types of SQL Server BackupsTypes of SQL Server Backups

In this tutorial we look at the different types of backups that can be created for SQL Server.

Whitepaper

Calculating Costs for Microsoft SQL ServerCalculating Costs for Microsoft SQL Server

This white paper looks at how costs can be controlled with a sufficient understanding of the Microsoft SQL Server licensing process.

Webcast

Database Monitoring and Management - Manage more, better and for lessDatabase Monitoring and Management - Manage more, better and for less

dbWatch Control Center monitors and manages more database instances on various platforms with greater efficiency, saving time and reducing costs.

Webcast

Exploring the Benefits of Single Server Protection High Availability in Windows EnvironmentsExploring the Benefits of Single Server Protection High Availability in Windows Environments

Attend this webinar and learn about Single Server Protection High Availability (SSP-HA).