A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?

How SQL Prompt Improves SQL Server Database Development

by Additional Articles

Redgate

Vendors/3rd-party Products

While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality.

Running Container Workloads in Microsoft Azure

by Additional Articles

SimpleTalk

Azure

Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.

A Getting Started PostgreSQL Tutorial

by Shivayan Mukherjee

SQLServerCentral

PostgreSQL

Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various platforms such as Linux, macOS, Solaris, and Windows. PostgreSQL databases provide enterprise-class database solutions and are used by […]

Do You Know What the Settings Should Be?

by Steve Jones

SQLServerCentral

Estate management keeps getting more complex, especially with the move to the cloud, or to multiple clouds. Today Steve talks about the need to ensure you know what the settings are in your environments.

3 Ways to Run DBCC CHECKDB Faster

by Additional Articles

Brent Ozar Blog

DBCC CHECKDB

In my last post, I talked about how you can get 43%-67% faster backups. This time, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage.

Solving the Provisioning Problem in Database Development using Clones

by Additional Articles

Redgate

SQL Clone

When database development is described, the details often get vague when the data gets beyond spreadsheet-size. There is 'hand-waving' talk of providing databases for each developer, but little detail of how you would provision all the databases that would be needed, at the correct version and with the correct development data, and then keep them all in sync with the source code, as developers commit changes. This article explains the requirements, and how SQL Clone can meet them.

New Stuff Can Be Scary

by Grant Fritchey

SQLServerCentral

I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's […]