Viewing 15 posts - 9,406 through 9,420 (of 22,214 total)
If you look at Policy Based Management, it has backup monitoring built in. But there are examples online. Here's one from MSSQLTips[/url]. As far as reports goes, I'd suggest taking...
October 24, 2013 at 4:45 am
A) It's difficult to get a job without experience, despite any training you have. So that's going to be a hurdle. I wouldn't mess around with SSIS because that is...
October 23, 2013 at 12:10 pm
According to the documentation, you have to use a table variable. That means defining the columns.
October 23, 2013 at 12:06 pm
If you have a mechanism to test the backup, meaning restore it, then you could do a physical only check on the live database which is much faster. Then, you...
October 23, 2013 at 10:33 am
Koen Verbeeck (10/23/2013)
Beatrix Kiddo (10/23/2013)
Grant Fritchey (10/23/2013)
October 23, 2013 at 7:15 am
Beatrix Kiddo (10/23/2013)
Grant Fritchey (10/23/2013)
October 23, 2013 at 7:14 am
100% Accidental.
I mainly took the job because it paid more. Flat out. When I was offered the job, I said no... until I was told the raise that went with...
October 23, 2013 at 6:27 am
tabinsc (10/22/2013)
Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the most difficult.
Nah,...
October 22, 2013 at 8:18 am
Sean Pearce (10/22/2013)
Grant Fritchey (10/22/2013)
You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes.
Indexed views do...
October 22, 2013 at 8:16 am
Michael L John (10/22/2013)
Look at RDX also.
I was trying to think of that company. I did meet one of their DBAs last week. He seemed like a competent guy. That...
October 22, 2013 at 8:12 am
As far as I know you can only do something like through ad hoc mechanisms or programming (PowerShell to the rescue).
October 22, 2013 at 6:48 am
Using just SSMS and SSMS only, you can't run them at the same time. You can run them from two different windows, but there will be lag while you click...
October 22, 2013 at 6:47 am
Only because instead of managing a single file now you're managing many. Sometimes it's the only way to get the job done, but it does add a wrinkle that makes...
October 22, 2013 at 6:44 am
100% agreement. I usually tell people to write a post on backups. Yes, they've been done before. I think I must have 6-8 blog posts and at least that many...
October 22, 2013 at 5:47 am
Viewing 15 posts - 9,406 through 9,420 (of 22,214 total)