SQL Server Graph Tables – Cross Database Surprises
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
2022-04-18
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
2022-04-18
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,460 reads
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
2022-02-18
6,863 reads
Today Steve wonders how many of you really need 256GB of RAM in Standard Edition.
2022-01-21
317 reads
Video games would not be much fun without animation. In this article, Lance Talbert demonstrates Unity state machine behaviours to define code running during specific animation states.
2021-12-22
In this article we look at how to create a basic Power App that allows saving data to a database table.
2021-11-24
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.
2021-06-07
2021-06-04
213 reads
You’ve submitted thousands of bug reports and feature requests at feedback.azure.com. Brent Ozar goes through what you’ve voted as the top 10 requests right now.
2021-05-14
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
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; GOSee possible answers