SQL

Article

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

2021-06-07

The changing landscape of continuous database integration

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.

2021-06-04

Oracle Sequences: RAC

by Additional Articles

SimpleTalk

Oracle

Article

Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.

2021-05-31

SQL Server plan cache mining – Plan attributes

by Additional Articles

SimpleTalk

Performance

Article

Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues.

2021-05-21

How to choose between SQL and NoSQL databases

by Additional Articles

SimpleTalk

NoSQL

Article

Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL and NoSQL databases.

2021-05-19

Finding Dependencies in SQL Server Databases using SQL Dependency Tracker

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Before you alter a database object, you need to understand what other objects will be affected. This article shows how to generate a simple dependency diagram that reveals both those objects that reference the target object, and those referenced by it, and includes foreign key references, column references and all the other details you need.

2021-05-05

Implement Azure SQL Elastic Jobs with PowerShell

by Mikey Bronowski

SQLServerCentral

Article

In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level. Currently, the elastic jobs are […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

You rated this post out of 5. Change rating

2021-06-21 (first published: 2021-05-03)

1,902 reads

Discuss

SQL Server Memory Usage Query

by Additional Articles

MSSQLTips.com

Article

Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.

2021-05-03

How do you monitor your databases? Take the survey!

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Calling data professionals! We want to know how you are monitoring your servers, instances and databases. By taking the 2021 State of Database Monitoring survey, you’ll help us better understand how the community monitor and manage their estates, and the challenges they face. You’ll get exclusive early access to the 2021 State of Database Monitoring report, plus, one lucky winner will receive a $500 Amazon gift card in our prize draw.

2021-04-29

Building a SQL Server data dictionary

by Additional Articles

SimpleTalk

Database Administration

Article

In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.

2021-04-29

SQL

Redgate Streamed: Embracing technology trends for database success

The changing landscape of continuous database integration

Oracle Sequences: RAC

SQL Server plan cache mining – Plan attributes

How to choose between SQL and NoSQL databases

Finding Dependencies in SQL Server Databases using SQL Dependency Tracker

Implement Azure SQL Elastic Jobs with PowerShell

SQL Server Memory Usage Query

How do you monitor your databases? Take the survey!

Building a SQL Server data dictionary

Blogs

A New Word: Vicarous

SQL Server Cross Platform Availability Groups and Kubernetes

Using Managed Identities with Azure SQL DB

Forums

We Stink!

View works for me ...but doesn't return results for a user in SSMS but no errors

Dark mode, other color schemes

Question of the Day

Internal Checkpoints