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
639 reads
If you ever need to perform a DR install of SQL to a new path and then restore the system...
2012-11-12
639 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
791 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,402 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,271 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,115 reads
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
871 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
879 reads
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
I have a PowerShell script that I use to automate the backup of Analysis...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers