May 15, 2015 at 4:22 am
GilaMonster (5/14/2015)
Question for the people here...Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started it that was a condition my boss required (no link whatsoever to the bank I worked for then) and partially because I hate sites of the form 'here's a scrap of info, pay me for the rest'.
I'm considering changing that, adding a bit to the side bar advertising my services, mostly database tuning, and maybe books I've written/contributed to and probably more later on.
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
A.
The books, of course. Advertising your services, of course (although, you can go overboard on this one, but you'd have to try hard). Advertising your precons, absolutely. Yes, this is part of why the blog is there in the first place. You're not putting it behind a pay wall and you're not going to let the ads take over and you're not going with google ads so all I see is non-applicable information.
Just do it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 5:37 am
Thanks all.
Next step, chat with management so that there are no unpleasant surprises, then start making some changes. And some plans. And some <redacted> :hehe:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 8:57 am
GilaMonster (5/14/2015)
Question for the people here...Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started it that was a condition my boss required (no link whatsoever to the bank I worked for then) and partially because I hate sites of the form 'here's a scrap of info, pay me for the rest'.
I'm considering changing that, adding a bit to the side bar advertising my services, mostly database tuning, and maybe books I've written/contributed to and probably more later on.
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
A.
I might go to the point of making a page that has that info, rather than inside of just a sidebar widget.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 15, 2015 at 9:03 am
SQLRNNR (5/15/2015)
GilaMonster (5/14/2015)
Question for the people here...Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started it that was a condition my boss required (no link whatsoever to the bank I worked for then) and partially because I hate sites of the form 'here's a scrap of info, pay me for the rest'.
I'm considering changing that, adding a bit to the side bar advertising my services, mostly database tuning, and maybe books I've written/contributed to and probably more later on.
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
A.
I might go to the point of making a page that has that info, rather than inside of just a sidebar widget.
Or the sidebar widget that links to the page where you can say a lot more.
May 15, 2015 at 9:13 am
Ed Wagner (5/15/2015)
SQLRNNR (5/15/2015)
GilaMonster (5/14/2015)
Question for the people here...Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started it that was a condition my boss required (no link whatsoever to the bank I worked for then) and partially because I hate sites of the form 'here's a scrap of info, pay me for the rest'.
I'm considering changing that, adding a bit to the side bar advertising my services, mostly database tuning, and maybe books I've written/contributed to and probably more later on.
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
A.
I might go to the point of making a page that has that info, rather than inside of just a sidebar widget.
Or the sidebar widget that links to the page where you can say a lot more.
That as well.
Just finished with the rest of the responses - and I agree with them.
This is the stuff you do for community and for your consulting. Let people know - tactfully.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 15, 2015 at 11:03 am
Ed Wagner (5/15/2015)
SQLRNNR (5/15/2015)
GilaMonster (5/14/2015)
Question for the people here...Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started it that was a condition my boss required (no link whatsoever to the bank I worked for then) and partially because I hate sites of the form 'here's a scrap of info, pay me for the rest'.
I'm considering changing that, adding a bit to the side bar advertising my services, mostly database tuning, and maybe books I've written/contributed to and probably more later on.
What are your feelings?
A) Why didn't you do that years ago?
B) Meh, ok, if you must.
C) I will never read your blog again!!1!!!11!!!
A.
I might go to the point of making a page that has that info, rather than inside of just a sidebar widget.
Or the sidebar widget that links to the page where you can say a lot more.
Yup, that's the current plan
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2015 at 2:12 pm
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What, me patient? Good thing you can't see behind the curtain! 😉
More thinking of shooting between the heartbeats:-D
😎
May 18, 2015 at 2:30 pm
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What, me patient? Good thing you can't see behind the curtain! 😉
More thinking of shooting between the heartbeats:-D
😎
I still have issues when I cut and paste your code. Never mind that we acknowledged that we made some typos. Some how those are supposed to just fix themselves automagically.
May 18, 2015 at 2:53 pm
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
Eirikur Eiriksson (5/18/2015)
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.Must admire your patience Lynn!
😎
What, me patient? Good thing you can't see behind the curtain! 😉
More thinking of shooting between the heartbeats:-D
😎
I still have issues when I cut and paste your code. Never mind that we acknowledged that we made some typos. Some how those are supposed to just fix themselves automagically.
And the Angels are singing!!!!!
May 18, 2015 at 3:25 pm
Good job, Lynn. I felt bad for the guy filling in for the DBA. That's a tough spot.
May 18, 2015 at 5:44 pm
Lynn Pettis (5/18/2015)
At some point, you have to work with the people in the best position to help.
Wow - they should hire a consulting firm or rdba service.
In addition, how does the sysadmin not know what a local drive is?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2015 at 5:59 pm
So, thinking about that thread that Lynn finally helped resolve, I think some pain could have been saved.
Looking at an earlier post by the OP, enough info was provided to be able to create the restore command (from the 8th post in the thread).
briancampbellmcad (5/15/2015)
I tried changing it to 'BCCrestored' but it didn't create that DB and multiple errors popped up:RESTORE DATABASE BCCrestored FROM DISK = '\\Belmont\c$\BCC_DB_backup_201505030017.bak'
GO
Msg 1834, Level 16, State 1, Line 1
The file 'D:\Databases\Data\BCC.mdf' cannot be overwritten. It is being used by database 'BCC_DB'.
Msg 3156, Level 16, State 4, Line 1
File 'BCC' cannot be restored to 'D:\Databases\Data\BCC.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Line 1
The file 'D:\Databases\Data\BCC_log.ldf' cannot be overwritten. It is being used by database 'BCC_DB'.
Msg 3156, Level 16, State 4, Line 1
File 'BCC_log' cannot be restored to 'D:\Databases\Data\BCC_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
From this, one could quickly come up with the following command...
RESTORE DATABASE BCCrestored FROM DISK = '\\Belmont\c$\BCC_DB_backup_201505030017.bak'
/* belmont was apparently the workstation name */
WITH MOVE 'BCC' TO 'D:\Databases\Data\BCCrestored.mdf'
/* provided by the error message and just updated to rename the in-use file */
,MOVE 'BCC_Log' TO 'D:\Databases\Data\BCCrestored_log.ldf'
/* provided by the error message and just updated to rename the in-use file */
,REPLACE --unnecessary since BCCrestored did not exist unlike BCCRestore, but harmless here
,BUFFERCOUNT = 75
,STATS = 5 --stats unnecessary unless op is trying to predict finish
GO
So maybe, if we slow down a bit sometimes, we can save the OP and ourselves some hair tugging.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 48,451 through 48,465 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply