SQL Server Tips, Articles and Training

Automated PDF Document Summarization with Azure OpenAI

Use Azure OpenAI API and a custom Python class to create a summarization pipeline to take a PDF file and produce a summary of the contents.

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

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

Popular Right Now

1 - SQL Server Attach and Detach Database Examples

2 - GitHub Copilot Examples to Create SQL Server Indexes and Tune Queries

3 - Create Calendar Table Using Power Query M Language

Learn Power BI Today

SQL Server Performance Tuning Checklist

SQL Server Tutorials

Integration Services Development

SSIS Most Overlooked Features - Fuzzy Lookup, Fuzzy Grouping, Data Profiling and DQS Cleansing

Learn about features to enhance your SSIS projects such as Fuzzy Lookup and Fuzzy Grouping, Data Profiling Task, and DQS Cleansing Transformation.

Python

Polymorphism 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_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 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 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 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 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 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 Database

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

Indexing

Unraveling the Tuple Mover for SQL Server Columnstore Indexes

Learn about the tuple mover in SQL Server, what it is, and how it works to maintain SQL Server columnstore indexes in the background.

SQL Server Management Studio

Export Data from SSMS to Excel

Learn various ways to quickly export data from a SQL Server Management Studio query window into an Excel file.

Database Design

Append Columns to SQL Server Table and Add Data to the Table

In this article, learn how to append columns to an existing SQL Server table as well as how to append data to a SQL Server table.

Tutorial

Return stored procedure parameter values to a calling stored procedure

This topic covers how to pass output from a stored procedure to other processes.

Tutorial

SQL Server Integration Services SSIS Versions and Tools

This is a history of SSIS and the different things that have been added to SSIS with the various releases of SQL Server.

Tutorial

SQL UNICODE Function Use and Examples

Learn how to use the SQL Server UNICODE function to return the unicode value for a particular character.

Whitepaper

Why Clustering for SQL Server High Availability

This white paper covers the basics of high availability for SQL Server- what it is, what it is not and how to leverage clustering to achieve your requ

Webcast

SQL Server Resilience for Hybrid Cloud

This presentation guides you through the outline of how to ensure data is available wherever and whenever needed.

Webcast

SQL Server Performance Benchmarking and Optimization on AWS

Learn about SQL Server Performance Benchmarking and Optimization on AWS for a successful migration to the cloud.