July 19, 2012 at 3:20 pm
SQLRNNR (7/19/2012)
Gianluca Sartori (7/19/2012)
On a totally different note, I recently started on a new job as DBA/DBD and I'm a bit surprised of some restrictions in this shop.Out of curiosity, does any of you administer instances without ANY rights on the windows machine?
And, please, anyone tell me how to administer a cluster without permissions on the cluster itself. How am I supposed to fail-over the instances if I can't reach the cluster admin snap-in?
I asked to be granted those permissions and I've been told that only sysadmins can have administrative rights on the servers.
Weird, I always thought a DBA was a sysadmin, or a least kind of. I suppose I've always been wrong.
I have been in that type of environment. Even to the point of having no access to SQL Server other than through SSMS. It makes it very difficult as the DBA to do everything you need.
Suppose that requires documentation detailing exactly what you know you need to do, why, and the risks of not giving you the ability of doing so. Then signoff by your boss(es). Should either get you what you need, or serve as a get-out-of-jail-free card.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
July 19, 2012 at 3:34 pm
jcrawf02 (7/19/2012)
SQLRNNR (7/19/2012)
Gianluca Sartori (7/19/2012)
On a totally different note, I recently started on a new job as DBA/DBD and I'm a bit surprised of some restrictions in this shop.Out of curiosity, does any of you administer instances without ANY rights on the windows machine?
And, please, anyone tell me how to administer a cluster without permissions on the cluster itself. How am I supposed to fail-over the instances if I can't reach the cluster admin snap-in?
I asked to be granted those permissions and I've been told that only sysadmins can have administrative rights on the servers.
Weird, I always thought a DBA was a sysadmin, or a least kind of. I suppose I've always been wrong.
I have been in that type of environment. Even to the point of having no access to SQL Server other than through SSMS. It makes it very difficult as the DBA to do everything you need.
Suppose that requires documentation detailing exactly what you know you need to do, why, and the risks of not giving you the ability of doing so. Then signoff by your boss(es). Should either get you what you need, or serve as a get-out-of-jail-free card.
That's a good idea! Thanks.
I'm working in an industry where data theft is very common and intellectual property is the most important assset. I understands the reasons behind this security paranoia, but I'm nevertheless annoyed.
What boggles the mind is the fact that DBAs are seen as developers by sysadmins and are considered sysadmins by the developers. Enemies all around me. :crying:
-- Gianluca Sartori
July 19, 2012 at 3:37 pm
Gianluca Sartori (7/19/2012)
That's a good idea! Thanks.I'm working in an industry where data theft is very common and intellectual property is the most important assset. I understands the reasons behind this security paranoia, but I'm nevertheless annoyed.
What boggles the mind is the fact that DBAs are seen as developers by sysadmins and are considered sysadmins by the developers. Enemies all around me. :crying:
Ah! So it's your first real DBA position!
Seriously though I'd just talk to your sysadmins and explain to them the restrictions they're applying and determine if it's generic policy or one they've adopted. They may have had a few lower proficiency DBAs come through (read: dumbasses with smoke on their resumes) who made a mess of things in the past.
But yeah, I agree. Document, get signoff, move on with life... it won't matter until 6 months from now when at 2 in the morning you CAN'T swap the cluster and the sysadmin on call is out drinking and the other one's on a honeymoon in Hawaii.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 19, 2012 at 5:24 pm
Gianluca Sartori (7/19/2012)
How am I supposed to fail-over the instances if I can't reach the cluster admin snap-in?
What permissions does the SQL Server service account have, and is xp_cmdshell enabled (and how heavily do they audit)?
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
July 20, 2012 at 1:20 am
rodjkidd (7/19/2012)
Enjoyed The Hobbit.Did get a little stuck with LOR, but worth it in the end.
Haven't read any other Tolkien books though.
Ran through the first three Dune books, took a while to get round to the other three. But really liked the whole series / arc.
Rodders...
The Hobbit is great fun. LOR is good too, in places it seems to get a bit verbose or even stuck but it's worth a read. The first 3 Dune books are OK, not great (the first one starts out like wathing grass grow) but for me numbers 4,5, and 6 are like watching paint dry with a raging toothache - definitely to be avoided!
I never went back to the first 3 Dunes after getting through them, and never finished any of the other three although I tried them all. LOR on the other hand I've read, all three volumes, several times.
Tom
July 20, 2012 at 1:42 am
Evil Kraig F (7/19/2012)
Gianluca Sartori (7/19/2012)
That's a good idea! Thanks.I'm working in an industry where data theft is very common and intellectual property is the most important assset. I understands the reasons behind this security paranoia, but I'm nevertheless annoyed.
What boggles the mind is the fact that DBAs are seen as developers by sysadmins and are considered sysadmins by the developers. Enemies all around me. :crying:
Ah! So it's your first real DBA position!
😀 I guess it is so...
Seriously though I'd just talk to your sysadmins and explain to them the restrictions they're applying and determine if it's generic policy or one they've adopted. They may have had a few lower proficiency DBAs come through (read: dumbasses with smoke on their resumes) who made a mess of things in the past.
But yeah, I agree. Document, get signoff, move on with life... it won't matter until 6 months from now when at 2 in the morning you CAN'T swap the cluster and the sysadmin on call is out drinking and the other one's on a honeymoon in Hawaii.
Quite true. I'm used to dealing with nonsense, I guess I can live with it, though I don't think it's a good sign. Am I getting old?
-- Gianluca Sartori
July 20, 2012 at 1:46 am
GilaMonster (7/19/2012)
Gianluca Sartori (7/19/2012)
How am I supposed to fail-over the instances if I can't reach the cluster admin snap-in?What permissions does the SQL Server service account have, and is xp_cmdshell enabled (and how heavily do they audit)?
Almost none. And very heavy auditing.
It's not a technical issue, it's just a matter of responsibility. If you insist doing my work, do it. I'm ok with it. Don't complain with me if you're not doing it right, though.
-- Gianluca Sartori
July 20, 2012 at 1:49 am
Gianluca Sartori (7/20/2012)
GilaMonster (7/19/2012)
Gianluca Sartori (7/19/2012)
How am I supposed to fail-over the instances if I can't reach the cluster admin snap-in?What permissions does the SQL Server service account have, and is xp_cmdshell enabled (and how heavily do they audit)?
Almost none. And very heavy auditing.
Ah, drat. So you can't even ask SQL to do things for you.
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
July 20, 2012 at 2:43 am
Crap! My session on SQL Server HA for a conference was just rejected because another speaker already submitted a session on the same topic. Grrrr!
I'm out of ideas and I have to submit a new abstract today.
So, you experienced speakers, which topics have you recently presented?
Suggestions are most welcome!
-- Gianluca Sartori
July 20, 2012 at 2:54 am
Database Corruption
Statistics
Indexing fundamentals
Execution plans
Performance tuning (demo-heavy)
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
July 20, 2012 at 2:54 am
Not sure it's your cup of tea:
* Introduction to DQS
* New features of SSIS
* Optimizing DWH with columnstore index, CDC adaptors in SSIS and star-join optimization.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 20, 2012 at 3:21 am
Query Tuning
Execution Plans
Backups
Monitoring
Development & Deployment processes
Deadlocks
Parameter sniffing
Rinse and repeat
"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
July 20, 2012 at 3:45 am
Grant Fritchey (7/20/2012)
Rinse and repeat
Can't wait for 'Spin and Drip Dry' 😛 😉
Far away is close at hand in the images of elsewhere.
Anon.
July 20, 2012 at 4:18 am
Gianluca Sartori (7/20/2012)
Crap! My session on SQL Server HA for a conference was just rejected because another speaker already submitted a session on the same topic. Grrrr!I'm out of ideas and I have to submit a new abstract today.
So, you experienced speakers, which topics have you recently presented?
Suggestions are most welcome!
Backups
Recovery
Intro to T-SQL (basic SELECT stuff)
Disaster Recovery & Business Continuity
Intro to T-SQL pt 2 (Filters, different ways of using JOINs to manipulate the record set)
How to get a DBA job
July 20, 2012 at 4:48 am
Thanks everyone for the suggestions.
I failed to mention that it must be something I know well enough, which excludes BI and many other things.
Now that I think about it, it excludes almost everything. 😛
-- Gianluca Sartori
Viewing 15 posts - 36,961 through 36,975 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply