The case for SQL Server Agent 2.0
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.
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.
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.
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.
Redgate has done something this month to try and create culture for its employees during the pandemic.
Learn how you can load Extended Events with PowerShell, nice and fast.
This article will show how to use Windows authentication for AWS RDS SQL Server by setting up an AWS Managed Active Directory and integrate it with an AWS RDS SQL Server instance.
High performing teams must implement a common approach to database migrations so that the database can be included in Continuous Delivery. This ‘kernel’ of Database DevOps leads to better alignment between developers and Ops teams, and increases the throughput of high quality releases. The key for many is Flyway, and this whitepaper explores how this highly configurable migrations tool enables a bespoke migrations-based deployment strategy that is easy to adopt and scale across teams
There are plenty of opportunities to grow your career by sharing knowledge. Steve points out a few today.
Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers