SQL Server Tips, Articles and Training

Enabling Critical Decision-Making with Valuable Data Insights from Melissa Marketplace

Learn about the Melissa Marketplace, a rich data catalog comprised of exceptionally accurate data products for industry and business needs.

European Fabric Community Conference 2024 Announcements

Here are some announcements and new features for Microsoft Fabric from the European Fabric Community Conference 2024 in Stockholm, Sweden.

Web Scraping with Python Scrapy Framework

Learn how to build a web scraping tool using the Python Scrapy Framework and a step-by-step walkthrough of how to do this.

Popular Right Now

1 - How to Get Current Date in SQL Server

2 - When to use SET vs SELECT when assigning values to variables in SQL Server

3 - Different ways to determine free space for SQL Server databases and database files

Calculating Costs for Microsoft SQL Server

Get Free SQL Tips

SQL Server Tutorials

Python

Explore Pandas in Python to Analyze and Manipulate Tabular Data

Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.

Comparison Data and Objects

Capture SQL Server Database Object Changes

Learn how to capture SQL Server database object changes and an easy way to compare the before and after of these database object changes.

PostgreSQL

PostgreSQL VACUUM, AUTOVACUUM, and ANALYZE Processes for Deleted Data

PostgreSQL has a unique way of dealing with deletes and in this article, we look at the concepts of VACUUM, AUTOVACUUM, and ANALYZE.

Security

Audit SQL Server Extended Stored Procedures Usage

In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.

Application Development

Getting Started with Kiota for Building API Clients

Learn how to build an API using Microsoft Kiota and how popular programming languages like Python can be used to write the API.

Application Development

Implement Microservices with Ocelot API-Gateway in .NET

Learn how to build a microservice using the Ocelot API-Gateway in .NET in this step-by-step article.

Artificial Intelligence

Machine Learning Introduction: KNN Model

This tip will introduce and implement the K-Nearest Neighbors model in Python to give you a better understanding of how machine learning works.

TSQL

Optimize SQL LIKE Wildcard Searches

Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.

SQL Server Agent

SQL Server Agent Job History Retention Settings

This article looks at how to change SQL Server Agent history retention using SQL Server Management Studio GUI and T-SQL scripts.

Power BI Charts

How to Create a Box and Whisker Plot in Power BI Desktop

In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.

Python

Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String

Learn how to connect to SQL Server using Python with an ODBC connection and a connection string along with some sample Python c

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

SQL Server 2017 and Python Basics

In this tutorial overview, we look at how Python can be used within SQL Server and the items that will be covered.

Tutorial

SQL Server BACKUP DATABASE command

Learn about different options that can be used when creating a full database backup with several examples.

Tutorial

SQL Server Triggers DELETED Table

In this section we learn about the pseudo table DELETED that can be used with triggers when an UPDATE or DELETE occurs so you can see the prior values

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

Accelerate Migration from Microsoft SQL Server to Amazon Aurora for PostgreSQL with Babelfish

Did you know you can migrate SQL Server to an open-source compatible database? Learn how Babelfish for Amazon Aurora PostgreSQL reduces the time, risk

Webcast

SQL Server Disaster Recovery Strategies

Being able to recover our data in the event of an outage is a critical aspect of managing SQL Server. But how do we plan for the worst? What technolog