If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.  Read more...

Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.  Read more...

As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing  Read more...

Learn how you can get a SQL Server 2017 container working with Docker and Windocks.  Read more...

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.  Read more...

The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.  Read more...

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.  Read more...

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.  Read more...

SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces Graph Databases in the first article of this new series.  Read more...

Microsoft has released a version of SQL Server 2017 for Linux.  Read more...

Koen Verbeeck looks at how to hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.  Read more...

SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.  Read more...

Interleaved Execution allows SQL Server's query optimizer to get accurate cardinality estimates in places where it couldn't before.  Read more...

In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.  Read more...

Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators  Read more...

Microsoft has never documented how the database log works, such as its format, its logging mechanism/algorithm, etc. But SQL Server 2017 has introduced a few improvements in some DMVs that expose more details about the status of data and log changes, and we can use the new information to design a better backup strategy.  Read more...

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.  Read more...

This tutorial from Siddharth Mehta is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL.   Read more...

Python is a very popular language used for many purposes including machine learning. SQL Server 2017 supports Python with its Machine Learning Services component. Robert Sheldon explains how to get started using Python in SQL Server in the first article of this series.  Read more...

Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.  Read more...