In previous posts here and here we discussed AlwaysOn Availability Group replication latency and monitoring concepts, specifically the importance of monitoring the send_queue and redo_queue. In this post I’m going to...
2015-06-17
5 reads
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup...
2015-06-10
1,285 reads
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup situation is. One of the first things that I...
2015-06-10
1 reads
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training...
2015-05-16
616 reads
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity....
2015-05-16
1 reads
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups...
2015-05-06 (first published: 2015-04-28)
7,166 reads
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our...
2015-04-28
1 reads
Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...
2015-04-21
2 reads
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR...
2015-04-13
1,117 reads
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR technology of choice for many SQL Server environments. Crucial...
2015-04-13
1 reads
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;
GO See possible answers