How can we setup alerts in Azure SQL MI to notify us when there are issues?

The Yutes

by Grant Fritchey

SQLServerCentral

Uncategorized

I recently had the opportunity to talk a little PostgreSQL with the Salt Lake City PostgreSQL Meetup group (thank you for having me by the way). Great bunch of people who were really engaged and asked a lot of questions. On the way out of the event, I was chatting with one person (who had […]

Revisiting SQL Server Window Functions- A Practical Walkthrough

by Chandan Shukla

SQLServerCentral

A look at window functions in SQL and how they can be used to query data without the restrictions of a GROUP BY.

The Security of Old Tech

by Steve Jones

SQLServerCentral

Security

Older technology can introduce security issues, along with performance ones. Keeping your systems somewhat up to date is important for security.

How to Increase SQL Server Column Width Without IO (Input/Output) Overhead

by Additional Articles

SimpleTalk

T-SQL

This article dives into a fun (and interesting!) strategy for widening fixed-width columns in SQL Server, to reduce downtime, risk, and runtime at the time when a column’s data type needs to be changed.

Password Guidance

by Steve Jones

SQLServerCentral

Security

Passwords are essential and also a problem in many organizations. Guidance has changed over the years and Steve has a few thoughts on what's recommended today.

Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

by Tony Davis

SQLServerCentral.com

Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.

A Rolling Filtered Index in SQL Server

by Additional Articles

MSSQLTips.com

Filtered Index

I recently resolved an issue where a query pulling data from the last 30 days would time out due to the table’s size and the lack of a supporting index. Creating a supporting index is possible, but not ideal; it will be very large and may not be useful for most queries and use cases. I wonder how I could implement a filtered index that follows time and is always limited to the last n days.