Viewing 15 posts - 1 through 15 (of 900 total)
I had a look at this myself, a few weeks ago - because log backups can be taken from any of the AG servers, yet differential backups can't. This is...
February 10, 2020 at 2:47 pm
A little left-field, but a snapshot backup just before the log file ships and then running a data compare (such as redgate's SQL Data Compare) between the snapshot and the...
December 10, 2019 at 3:46 pm
I worked at a place where the slightest mistake was met with derision, shouting and a generally abusive atmosphere. On the last day of my probation period I pulled the...
December 6, 2019 at 9:59 am
The Update Failed message reminds me of when I was a database developer some time ago working with Oracle, and the DBA's there programmed some automated job that would...
October 31, 2019 at 9:22 am
I've found that as I get older I worry less about future employment opportunities, as my experience and confidence increases. Because, I still find the role of a DBA interesting...
October 14, 2019 at 11:21 am
Phil's solution is definitely the more elegant but (for completeness) there is also a TABLESAMPLE clause.
October 9, 2019 at 8:01 am
Writing a backup solution for HAG can be a messy business.
I'm in the process of replacing a series of Mintenance Plans (not an attractive solution) with ola...
October 9, 2019 at 7:49 am
SQL Saturday in Edinburgh - 1st Feb, anybody from here thinking about going?
October 4, 2019 at 9:18 am
Oh go on Steve - pick an easy solution!
Doesn't help for my 12 month task (the joys of a PCI audit), but I do wish I'd thought of that.
September 4, 2019 at 9:46 am
As you have created the stored procedure 'sp_area', go back and modify it - I suspect you'll be a bit surprised at what you see.
Then have a look at 'batch...
September 4, 2019 at 7:20 am
Erland is correct, there is no time-based setting for retaining the error logs.
However, I'm looking at exactly the same issue right now (but I need to keep mine for a...
September 3, 2019 at 8:02 am
The question was "What types of backup are there?" followed by a lot of muttering, hesitation and apologies for going blank. I've gone completely blank in interviews before, so it...
August 22, 2019 at 2:51 pm
Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a...
August 22, 2019 at 2:13 pm
I agree with Jeff on this. I have seen too many people at interviews that have amazing paper qualifications and yet can't answer my most basic practical questions.
Microsoft are very...
August 13, 2019 at 9:57 am
Have you taken a look at Redgate's Data Masker? You can download it for a free trial period and see if it is suitable.
We're looking at purchasing...
August 12, 2019 at 7:34 am