Question about Microsoft Computers & Internet

1 Answer

Sql server good morning sir, i am working as data base administrator. recently i was joined. i want know about DBA. what my work would be. and what i want to learn to get real expert in DBA.please give suggetion to me. thank you sir ranjit routhu from hyderabad, india

Posted by on

  • ranjitrou Oct 27, 2008

    thank you sir. but i am working in sqlserver2000.now i am writing stored procedures and .giving reports.so i want to know about sql2000.plz reply me sir

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 35 Answers

A good point to begin is to start preparing for the Microsoft Certified IT Professional Developer (MCITP) Certifications for Microsoft SQL Server 2008. For more information about this certification please visit:
http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx

As an Administrator you should start with this certification:
MCTS: SQL Server 2008, Implementation and Maintenance

I recommend buying the self-paced training books recommended for this exam which can be found here:
http://www.microsoft.com/learning/en/us/exams/70-432.mspx

Even if you do not want to apply for the exam. These resources are the perfect place to start.

Good luck

Posted on Oct 27, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

Tip

SQL 2008 SA Password Reset


How to reset sa password in SQL Server 2008 when forgot the sa password?

Many time, This problem comes, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login sa password by which they can connect to server. In SQL Server 2005, SQL used to fixed group sysadmin with the server role BUILTINAdministrators, that is to say, all local NT administrator automatically add a SQL Server system administrator. But since 2008 Windows BUILTINAdministrators group is not included by default in the sysadmin server role in SQL Server.

So, follow the steps mentioned to reset SQL 2008 password for SA account if no BUILTINAdministrators.

Step 1. Download and install MS SQL Server Password Unlocker.

Step 2. Run MS SQL Server Password Unlocker, click Open, import the master.mdf file. All the user names of your SQL Server will be displayed.

Step 3. Select an SQL account, such as 'SA', click Change Password button.

Step 4. Type a new password, and then click OK.

The new password has been set for your SA account, now you can login
SQL Server with the new password.

Currently SQL Server 2008 still supports two types validation and authentication for access link to resources database, Windows authentication mode and SQL Server and Windows authentication mode which also known as mixed mode. Both of these authentication methods provide access to SQL Server 2008 and its resources.

The Mixed Mode - SQL Server and Windows Authentication Mode

SQL Server and Windows Authentication Mode uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server. SQL Server 2005 introduces a new way, the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. SQL Server 2008 also to do so. The policy of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode.

on Oct 26, 2010 | Computers & Internet

5 Answers

Some requirement for SQL server repair


Read this blog at the following link: http://recoverymaster.livejournal.com and know helpful details about MS SQL server database recovery wizard. You can download this software: http://www.sqlrecovery.org

Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...

5 Answers

What the presager of SQL repair by any tool


Latest tool is here if you want try please use SQL repair tool to repair and recover MDF file with loss of any data. Visit here:-

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | Computers & Internet

2 Answers

Sql procedure


Dear friend you can get all your answers about stored procedure in sql server through this link:
http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx

good luck

Feb 25, 2009 | Microsoft SQL Server 2005 Enterprise...

4 Answers

How get sql data backup


there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

Data storage form


I dont know about your career, it is MCSE with Exchange or MCSE with SQL.. or Linux admin?

but i have some tips for you. if you like to go as a system administrator, u have no problem. you dont worry about the SQL.

if you like to work or learn as a system admin without SQL.... some options are here:

System Admin Jobs
- Desk support, Server Support, Exchange server support, DNS, DHCP support, Active directory support.

These are the above options are going without SQL server. so, it doesnt matter for you.

Keep going with Active directory, DNS, DHCP will be the best.

thank you.




Jul 20, 2008 | Microsoft Windows Server Standard 2003 for...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

202 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...