DR: SQL installed on new path, master restored, and SQL can't find resource database or start jobs!?!
If you ever need to perform a DR install of SQL to a new path and then restore the system...
2012-11-12
646 reads
If you ever need to perform a DR install of SQL to a new path and then restore the system...
2012-11-12
646 reads
Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long...
2012-10-29
1,093 reads
Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...
2012-10-26
793 reads
SQL Server will not start.
You open up the ERRORLOG (...which I would only do with a text editor like gVim...
2012-10-25
1,409 reads
This is one of my most closely held DBA secrets.
Do you use PAL? You should.
Clint Huffman is a golden god...
2012-10-24
1,274 reads
Through most of my career, I believed that at some point I would be able to learn enough and master...
2012-10-23
682 reads
Log shipping is great.
It's basically the act of beginning a restore with no recovery, and then restoring logs (with no...
2012-10-22
2,127 reads
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
872 reads
Hi everyone,
So the other day on twitter in #sqlhelp and privately with some friends at Microsoft and elsewhere I had...
2012-10-18
881 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; GOSee possible answers