Viewing 15 posts - 1 through 15 (of 889 total)
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
I've never had my own dedicated lab environment until recently, when I decided that I really need to start learning Powershell. A book that I bought contains the instructions for...
August 9, 2019 at 7:44 am
Disinformation is an old weapon of choice, these days it can travel faster and further.
Many years ago I can recall the chairman of a company I worked at telling us...
August 7, 2019 at 7:59 am
No problem, I'm pleased it was so simple.
If we start comparing stupid mistakes, I might have quite a head start on you.
August 6, 2019 at 2:37 pm
Are you amending the schedule, which is associated with more than one job? If so, then any job that uses that schedule will be affected.
Or are you creating a new...
August 6, 2019 at 7:47 am
No, the documentation is quite clear about that.
"You cannot back up or restore database snapshots."
July 30, 2019 at 3:02 pm
Yes, I've had to re-do the images and it doesn't appear to refresh immediately - there appears to be a review process before changes to an article get through.
July 11, 2019 at 6:25 pm
Some years ago I was one of the group of 50 or so people that Paul Randal offered to mentor.
At the start of the exercise he sent an extensive list...
July 3, 2019 at 10:36 am
It's nice to know that I'm not the only one who has to struggle for a year to get Redgate tools purchased.
June 25, 2019 at 4:59 pm
Thanks for the reply. The important thing (to myself) is that I didn't do anything obviously stupid - so I'm happy with that for the time being.
Thanks for your time.
June 18, 2019 at 9:48 am
MS have added database diagrams back into SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
June 12, 2019 at 9:19 am
April 26, 2019 at 10:50 am