A Day In The Work Of An SQL Admin.
Nov 14, 2007
Hello. I'm 15 years old only, but really interested in math and I'm curious what do You do in work (excepting having fun and chillin' ;))? I know a bit about MySQL and I'm now trying to write some simple queries in SQL Server Management Studio Express (I'm using MS SQL Server 2005), but I'm sure in Your work You use other programs? What should I look for and start with? I know this topic sucks and many/most of You use stuff that is worth xxxxxxx USD on specialized computers/servers but I had to ask, because I was trying soo hard with programming, and then I've found database management, and I'm excited, because it's very interesting. I have no idea why, but it's not even boring to me (yet), and maybe I will work in this business in future (I really, really hope that).
Thank You for any help/support.
View 1 Replies
ADVERTISEMENT
Apr 15, 2015
Say I have 2014 AlwaysOn setup and working:
SQLNode1 ->Instance01
SQLNode2 ->Instance02
When I setup my listener: ListenerA...Do I need to use the instance name in it?
ListenerAInstance01 or ListenerAInstance02 depending on which SQLNode is the "active" availability group?
Am I better off to use the same instance name for both nodes, since my goal is to have all databases on both instances in the same availability group and sync'd? When SQLNode1 migrates over to SQLNode2 I will need to update the instance name in my connection string on the listener from ListenerAInstance01 to Instance02? When I connect with SSMS do I just use: ListenerAInstance01 (or 02)?
View 3 Replies
View Related
Aug 27, 2015
I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.
I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.
I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).
So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.
View 0 Replies
View Related
Sep 6, 2007
We are using Win2k3 R2 with SQL 2000 in a domain environment.
Is it possible to create a domain group to grant admin level and user level access to SQL2000/2005 without giving users server admin or domain admin access?
It has always been my impression that to have admin access to SQL that you had to at least had admin level access on the server.
Any clarification would be greatly appreciated.
Thanks!
View 1 Replies
View Related
Jun 25, 2006
Does anyone know of a web based front end to Microsoft SQL Server 2005 Express edition? I tried using the SQL Server 2000 server web admin tool from microsoft, but it will not allow me to install it because it says it need the 1.1... framework installed. I have 1.0,1.1,and 2.0 installed, is there anyway to circumvent this? Or has anyone else figured another way to get the webadmin tool to work with 2005 express edition.
Thanks!
View 6 Replies
View Related
Mar 4, 2004
Hi,
I've been having trouble getting this tool to work with my server/database. I'm using XP Pro, MSDE, .NET 1.1.4322 and IIS 5.1. IIS has been installed and tested with the help of others. .asp pages are being served locally and to another PC on the network. No obvious problem here. When I installed MSDE I used the SAPWD='strongpassword" command to create a password. I also built a new database. I had positive feedback on both of these actions.
Now to the tool - when I activate the administrator it pops with the little window saying Web Server Configuration. It lists the following options:
Desired Port:
IIS
Cassini Personal Web Server
Restore Faults
and Start and Stop buttons.
If I leave the setting on IIS and click Start it opens a webpage entitled Web Data Administrator. Moving further down I have a welcome message and then the line -
Please enter a SQL Server name:
Username: [Desktopob shadowed entry]
Password
Server (local)
Authentication Method:
Windows Intergrated
SQl Login
and then a Login button
If I select SQL Login and enter "sa" as the username and then my password leaving (local) as the server I get the following error:
Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.
I have tried all combination of \desktopsa, sa, you name it. The password I selected is correct because I made a point of writing it down so I wouldn't forget it. I have also tried all the combos using Cassini as well.
This is where I'm stuck at this point. All suggestions are appreciated.
Thanks,
Bob
View 3 Replies
View Related
Dec 1, 2005
Is there a web based admin to administer MS SQL? If there is a free one, that would be better.
View 2 Replies
View Related
Apr 28, 2001
I am new to MS Cluster server. Could anyone tell me the correct procedure to shutdown and restart MS SQL Server 2000 in a Clustered environment? Thanks
View 1 Replies
View Related
Nov 2, 2001
Are there any tools for administering SQL2000 remotely over the TCP/IP? And if this is possible what are the main hurdles on setting it up. Emulation is an option.
View 2 Replies
View Related
May 3, 2000
Anybody know if you can manage the Cluster Administrator tool from a remote workstation? I've found nothing(except PcAnywhere and the like) documented on this..
Thanks
Pete
View 2 Replies
View Related
May 4, 2000
Hi,
I am fairly new to SQL server admin.
What sort of wages are paid for this type of work.
Is there a shortage skilled administators in this area?
Does the MSCE DBA increase your wages?
Thanks
View 1 Replies
View Related
Jul 5, 2000
Hi Guys
I have just been trying to install the Admin tools from the SQL 6.5 setup CD on a Win NT Workstation 4 SP6 system. Everything seems to go fine until the icons are addded into the program group, these come up as system default icons and don't link to any programs. If I go into the installed directory and execute the programs then I get the following message:
The SQLOLE OLE object could not be registered. Class not registered (80040154)
After clicking OK the program terminates. I have tried diferent install directories, even diferent partitions. I have also deleted the directory and removed the Registry entries manual - this is because it cannot be uninstalled.
Still no luck.
Any ideas?
Many thanks
Stuza
View 2 Replies
View Related
Jan 4, 2000
Does anyone know of a good book that will prepare you for this exam. I know that in some early discussions that Mike Hoetch warned against some of the new books on the market.
Thanks
Ricky Kelley
View 1 Replies
View Related
Dec 13, 1999
A couple of newbie questions:
1) Do Domain Admins have SA rights by default in SQL7? If so, is there a way to keep domain admins out of particular databases.
2) Is it possible to create a database or table that even SA can't get into?
Thanks
JD
View 1 Replies
View Related
May 19, 1999
Has anyone who has taken and passed the SQL 7.0 test for SQL Admin
have any recommendations on the best sources to help pass?
View 2 Replies
View Related
Jun 5, 1999
Any recommendations on a good SQL 7.0 Systems Admin book for future DBAs? Too many books at the store, so i'm wondering how i can narrow it down. I'm looking more for the Admin side rather than developer side type book. Thanks.
View 2 Replies
View Related
Jan 11, 2000
Hi there,
Could anyone please help me, I have been given the responsibility of planning and implementing the admnistration of 25 existing SQL Servers (6.5 and 7.0) countrywide and I am unsure as to where I should start. I am relatively new to SQL Server and if someone could just point me in the right direction or possibly recommend any good publications which I could refer to, I would be extremely grateful.
View 3 Replies
View Related
Mar 1, 2001
Hi
Here is a mcdba admin question
Consider the following time line:
8:00 You accomplish the full database backup.
8:10 User1 enters the order 53 for customer 10, whose name in the database is
XXXXX (I
can't remember, but not Bill Smith)
8:12 User2 at remote server changes the name XXXXX to YYYYY
8:13 User3 changes the name YYYYY to ZZZZZ
8:14 User3 commit the transaction.
8:20 Media fails for database.
8:30 You restore the database from 8:00 backup. What is the status of the order
53 in the
database?
a) The order 53 is not in the database.
b) The order 53 is in the database and name is XXXXX.
c) The order 53 is in the database and name is YYYYY.
d) The order 53 is in the database and name is ZZZZZ.
Ans: B The name was already there.
The answer is B but I think th answer is A
becouse He or Her restroe the database from 8:00
I think the 53 order maked after 8:00 so
there is not order 53 in the backup database
How about you think and why !!!
Thanks kjs
View 2 Replies
View Related
Dec 30, 1999
long, bad story here is the brief:
sql: 6.0 w/ fixes
platform: intel NT 4 sp3+
our "dba", i use that term loosly as the person who filled that position had little expertiese in managing sql, found a new job and has left; i worked with him on periphery matters so i'm less effective than he. unfortunatly ..."he with the most experience..." becomes "the man" so now i'm working to become a good dba and require some assistance.
we had a contractor come in and work out a method for archiving data using bcp, some batch files, and sql scripts; prior to this he assisted us in porting from one platform to another, digital alpha running NT to intel platform running NT.
in brief the procedure is as follows:
using options of EM create scripts to create all objects except indexes, again use EM to create sql scripts to create all objectes including indexes.
obtain sizing information and create a device and database, including log etc.
use the create objects script to create objects in the newly created database
use a custom script to create a batch file to bcp data from the primary database into flat files.
use a custom script/batch file to create a batch file to bcp data into the newly created database.
use the create indexes sql script to re-create indexes. we have to modify the sql create all objects including indexes script. i've worked up a batch file using for /f and if == to do this.
do some row counts and spot checks of tables stored procedures to verify conversion.
so now my questions:
using the information supplied causes problems, the tables end up being created but are owned by the wrong user. is there a way to change table, stored procedure, or object ownership? i create the database and objects as sa, then populate with bcp and re-create the indexes as the desired owner. my understanding is that sa has the special permissions needed to create objectes and the create objects script should make the appropriate users, logins, and changes to the db objects... where am i going wrong?
View 5 Replies
View Related
Apr 7, 2004
Can anyone tell me whether there is any way to automatically genereate SQL script for all SQL jobs on a server?
I need to create the script for about 30 jobs and dont want to spend hours getting RSI clicking on each one and exporting the script if i can avoid it!!!!
TIA
View 3 Replies
View Related
Feb 23, 2006
has anyone tried the cd/learning from sql usa
http://www.sqlusa.com/order2005/.
Interested in any input
View 1 Replies
View Related
Mar 29, 1999
Hello,
I will soon be managing a sqlserver/iis4.0/nt box located remotely in another state. It has a permanen connection to the net. I have a dialup connection.
I have a remote control package, but it is slow. Is there a way to add that boxes sql server to my enterprise manager on my local nt server so that I can
adminsiter it from my machine? I am not over familair with sql server, but quickly learning!
Will I need to set up a vpn to do that?
I searched microsoft knowledge base, but could not find anything.
Thanks for your support.
Johanna
View 2 Replies
View Related
Aug 29, 2001
I am trying to find some resources for SQL 2000 admin. I have a book and will be taking a class, but am still looking for a forum and a bit of Technical expertise to discuss issues with.
Thanks
View 1 Replies
View Related
Jan 9, 2006
Hi
Does any one know what the email contact is the dbforums admin? I can't seem to locate it, neither an online mailer?
Thanks
View 9 Replies
View Related
Mar 12, 2007
Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.
I need to change the number of characters permitted in a certain field.
I have to present this tomorrow morning so any help would be greatly appreciated.
My friend flew to Italy last night and I cant contact him hence the question."
View 13 Replies
View Related
Mar 14, 2007
What is the best book for SQL Server 2005 administration? For sql programming I assume the best book is professional sql server 2005 by Rob Viera.
I was not able to find a similar book for Administration. Any suggestions?
------------------------
I think, therefore I am - Rene Descartes
View 20 Replies
View Related
Mar 19, 2007
Countydown writes "Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.
I need to change the number of characters permitted in a certain field.
I have to present this tomorrow morning so any help would be greatly appreciated.
My friend flew to Italy last night and I cant contact him hence the question."
View 1 Replies
View Related
Mar 21, 2007
I have a SQL 2005 server and I am trying to run the SQL Agent service under a minimal permission account. Currently the service will run fine and perform all functions if it's account is a member of the administrators group on the local machine. As soon as I remove it from the local administrators group it fails to start and the only message recorded in the log for the agent is:
[241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
[098] SQLServerAgent terminated (normally)
And given the service works fine as an administrator I doubt there is anything wrong with the eventlog service. I have also checked and the eventlog service is indeed running, recording, and operating properly. I am at a loss as to what to do next, i've followed the directions available on MSDN for doing this but it still doesn't work.
View 3 Replies
View Related
Mar 10, 2008
Hi,
I went to services in sql server 2000 and stoped that and i right clicked my mssql server and clicked on logon button and enter the username and password.So knw i want to access my database through that admin name and password .How to do that.
Kindly reply for this mail.
Thanks & Regards,
Swar.
View 1 Replies
View Related
Apr 17, 2008
Hi There,
I need a report from reporting services that includes which reports(name of report not id) are run by who and when(with the ability to plug in the start and end date). The 2 database names are RSExecutionLog and ReportServer. I had a look at the admin type reports that come with the package but neither are appropriate.
Thank you for your help,
Rhonda
View 4 Replies
View Related
Apr 28, 2006
Does anyone now the minimum permissions to debug SQLCLR. I have a friend trying to develop as a non-admin and he finds that it doesn't work even if he launches Visual Studio to run as an admin account.
Is it possible? Are there certain rights required?
View 1 Replies
View Related
Mar 22, 2007
I have one other question. How do you define roles? What role(s) are required to fully administer SQL Server? What role(s) are required to fully administer a single database in SQL Server?
thanks,
View 1 Replies
View Related
Feb 8, 2007
Can I give a developer the ability to execute DTS pkgs without this server wide permission?
View 1 Replies
View Related
