SQL Performance

AUGUST 14, 2019

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. Previously I covered determinism , subqueries and joins. DROP TABLE IF EXISTS dbo. Transactions ; CREATE TABLE dbo.

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. There is an XEvents Profiler built into modern versions of SSMS, with an equivalent extension for Azure Data Studio.

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Server According to Bob

JULY 13, 2016

Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this.

Servers 40

Servers Media Engineering Virtualization 40

Smashing Magazine

JULY 6, 2021

As the Technical Director at Luminary, I have been helping our clients choose the best CMS, DXP (Digital Experience Platform) or headless CMS to suit their needs. All functionality and integrations would also have a tight dependency which in turn results in a large, cumbersome monolithic code base. Microservices architecture.

Cache 143

Cache Website Mobile Google 143