This article covers how to use the different date and time functions when working with Spark SQL.

Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)

by Erin Dempster

SQLServerCentral

The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]

The Stagnant Career

by Steve Jones

SQLServerCentral

Career Growth

A stagnant career can be stifling, and it can make you unhappy at work, where you spend a lot of time. Steve has a few thoughts on how to avoid that.

Cardinality Estimation Feedback in SQL Server 2022

by Additional Articles

MSDN Communities

Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.

Plansplaining, part 20. SQL Graph (part 1)

by Additional Articles

SQLServerFast

Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph.

GitHub Copilot - Our Best Ally for T-SQL

by Daniel Calbimonte

SQLServerCentral

This article examines how GitHub Copilot might be used when working with T-SQL Code.

Be Careful with Missing Index Requests

by Steve Jones

SQLServerCentral

Steve reminds people today that the recommendations from execution plans aren't always what you want to use when tuning your database.

Championing DevOps: A Panel Webinar

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

If you aspire to drive Database DevOps at your company, regardless of the sector you work in, this webinar provides a unique opportunity to learn from experts in the finance sector who have successfully paved the way. Join us December 6th.