SQL Server Tips, Articles and Training

Apache Kafka for Streaming Real-Time Data

Learn about Apache Kafka, including setting up Apache Kafka and Zookeeper in a Docker container and covering various Kafka concepts.

Limit Cost Threshold for Parallelism for Small SQL Queries

This article looks at the performance benefits of bumping up the SQL Server Cost Threshold for Parallelism to see the impact of this change.

Change Advisory Boards (CAB) for Change Management

Learn about the purpose of Change Advisory Boards (CAB) to support a Change Management team by advising on requested IT changes.

Popular Right Now

1 - SQL Server READ_COMMITTED_SNAPSHOT Database Option and READ COMMITTED Transaction Isolation Level

2 - Install SQL Server Integration Services in Visual Studio 2019

3 - SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports

SQL Server Tutorials

Learn Power BI Today

SQL Server Performance Tuning Checklist

Microsoft Fabric

Relationships with Microsoft Fabric GraphQL API

Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.

Performance Tuning

The Future of SQL Server Database Tuning and Monitoring

When doing SQL Server performance tuning work, how many times have you said there's got to be a better way, well read this article to find out how.

Data Cleansing for Validation

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.

Microsoft Fabric

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.

Python

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.

Common Table Expressions

Troubleshoot Chained SQL Server CTE

This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.

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.

Power BI Formatting

How to Increase the Vertical Orientation of Power BI Report Page

In this article we take a look at how to make the size of a Power BI canvas larger so you can have more space to add visuals to the report.

TSQL

Many Uses of SQL CASE Expression in a JOIN Clause

In this article, we look at the many uses of the SQL CASE expression and whether you should ever use CASE in a JOIN.

Python

Introduction to Creating Interactive Data Visualizations with Python matplotlib in VS Code

In this tip, we present a step-by-step guide on how to present your data interactively using matplotlib and Python in VS Code.

Tutorial

Built in Performance Reports in SSMS

SQL Server Management Studio has several built-in reports you can use for monitoring performance.

Tutorial

Getting started with R in SQL Server

R is an open source programming language and environment and most used for statistical computing, statistical graphics and data science. In this tutor

Tutorial

Tracing a SQL Server Deadlock

Deadlocks are something you want to avoid in your database applications. We will cover what they are and what you can do.

Whitepaper

Calculating 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

Monitoring SQL Server - What, When, and How?

SQL Server DBAs have a lot of things to worry about - backups, performance, storage, etc. Learn how to collect, gather and visualize the trends.

Webcast

Ensuring High Availability in a Multi-Cloud Environment: Lessons from the CrowdStrike Outage

In this webinar, we will explore best practices for implementing multi-cloud High Availability (HA) solutions.