database weekly

SQLServerCentral Editorial

PASS Data Community Summit Pre-cons

  • Editorial

This year PASS Data Community Summit is a free virtual event, and I encourage you to register even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps. What I’m most excited about this […]

You rated this post out of 5. Change rating

2021-10-09

109 reads

SQLServerCentral Editorial

Malleable Source Control

  • Editorial

Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]

You rated this post out of 5. Change rating

2021-04-03

141 reads

SQLServerCentral Editorial

Automatic Install of Azure Data Studio

  • Editorial

Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]

You rated this post out of 5. Change rating

2020-11-07

1,052 reads

SQLServerCentral Editorial

What is Possible?

  • Editorial

There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]

You rated this post out of 5. Change rating

2020-10-31

93 reads

SQLServerCentral Editorial

What's Causing the Pushback with DevOps?

  • Editorial

The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]

You rated this post out of 5. Change rating

2020-10-24

157 reads

SQLServerCentral Editorial

Of Hedgehogs and Database Design

  • Editorial

One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]

5 (2)

You rated this post out of 5. Change rating

2020-08-22

359 reads

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

By

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

By

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

What is the best index strategy for a table that gets truncated?

By water490

Hi everyone My SSIS package does a bulk insert of csv files into a...

Blob Storage automated downloads

By Brandie Tarvin

Dipping my toes into the waters of Azure and of course before I get...

Announcing SQL Server 2025

By Press Release

Comments posted to this topic are about the item Announcing SQL Server 2025

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error?

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers