Louis Davidson explains how he manages and shares several different sources of SQL Prompt code snippets, in a single Snippet library, using Dropbox and source control.

Datetime3

by Steve Jones

SQLServerCentral

humor

Today Steve proposes a new datatype for SQL Server.

Scheduling SQL Scripts Using Jenkins

by Vishnu Gupthan

SQLServerCentral

Learn how a Jenkins server can be used to schedule SQL scripts to execute against SQL Server.

How To Install SSAS 2019

by Additional Articles

MSSQLTips.com

In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.

Giving of Yourself

by Steve Jones

SQLServerCentral

Misc

Today Steve looks at the act of volunteering.

The case for SQL Server Agent 2.0

by Steve Rezhener

SQLServerCentral

SQL Server Agent is heavily used by many organizations, but it hasn't changed much in years. This article speculates on some new features that might improve the scheduler.

Are your Oracle archived log files much too small?

by Additional Articles

SimpleTalk

Oracle

Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis explains how Oracle uses online redo logs and why there might be a discrepancy in the archived log size.

Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates

by Additional Articles

Redgate

Vendors/3rd-party Products

As more organizations are managing at least some part of their data in the cloud, estate monitoring can become more complex with a mix of on-prem and cloud-based instances. Grant Fritchey discusses why businesses might move to the cloud, why they might stay on-prem, and when a hybrid approach might be best.