Friday, April 23, 2021
Techiexpert.com
No Result
View All Result
  • Login
  • Register
  • Home
  • Tech news
  • Startups
  • AI
  • IOT
  • Big Data
  • Cloud
  • Data Analytics
  • ML
  • Blogging
Techiexpert.com
No Result
View All Result

5 Tips for SQL server production

Sony T by Sony T
June 16, 2018
in Tech news
Reading Time: 2 mins read
A A
0
5 Tips for SQL server production
9
SHARES
127
VIEWS
Share on FacebookShare on Twitter

So here  we are talking about SQL Server and SQL databases, there are many different types of method and strategy for administrators to so there efficiency in better way. Many Database Administrators are not knowing the prefect tips to increase the production or how to verify production data.. In this part we are discussing about the tips that imperative to know by any Database Administrators.

1) Use forfiles to get rigid of old data

Forfiles (forfile.exe) usefulness are already pre- installed in Window server 2003. It empowers the administrators to achieve batch file processing. By utilising this service and SQL server Agent,  to which Database Administrators can delete the old heavy data backups, which will eventually eliminate the dependency on SQL server production.

2) Using of ‘ALTER USER’  to restore the unknown logins

The ‘ALTER USER’ command of T- SQL’s have a WITH LOGIN condition too, from SQL server 2005 SP2. By choosing this as option will repair the unknown logins by revising the user’s Sid for security identifier of server login. It will not enhance only SQL server but also the window server. When a database is used by any unknown server it is recognised as Orphaned user or unknown user, and that particular login is totally independent.

3) Use the ‘sp_addsrvrolemember’ to take up sysadmin  role

Sysadmin role is not present in Window administrators by any automated way, from SQL server 2008. To recover this and get benefit of sysadmin role you can start using SQL server as single- user mode or maintenance mode after that you ready to run ‘sp_addsrvrolemember’  in Sqlcmd  utility to register your login as sysadmin role.

ADVERTISEMENT

4) Using PortQryUI for troubleshooting for connecting issues

By using the Microsoft PortQryUI to vanish the problems related to TCP/ IP connectivity issue said RemoteDBA.com. Perviously PortQry was there to solve this issue but after the alternative to PortQryUI present but it also has GUI as pre- defined services. One of the pre defined services are for SQL server, composed of TCP port 1433 UDP port 1434. If you want to check the port you can simply enter the IP address or the FQDN (Fully Qualified Domain Name) or target SQL. It’s  easy to get PortQryUI utility at ‘PortQryUI’.

5) Use a different planning while running the DBCC CHECKDB against large database

Databases are becoming larger by every passing day,  for the maintenance such as checking integrity with DBCC CHECKDB command of T- SQL’s may take long time. One fastest solution is to access backup to get back database on different server and after that run the DBCC CHECKDB against the existing server.

Tags: SQL
Share4Tweet2Share1Pin1
Sony T

Sony T

Sony is a passionate bloggers writes on Futuristic technologies ...

Related Posts

Sharmin Ali, CEO Instoried
Tech news

Improve ROI of you content with AI Technology – Instoried

by Srikanth
April 22, 2021
BluSmart introduces environment friendly initiatives on Earth Day
Tech news

BluSmart introduces environment friendly initiatives on Earth Day

by Srikanth
April 22, 2021
Modern CTO
Tech news

Building a New Startup Is Always a Challenge but an Experienced CTO Can Help

by Anastasia Stefanuk
April 21, 2021
Action Games to Improve Decision making Skills
Tech news

Growth of online prediction games due to technological advancement

by Sony T
April 20, 2021
Teach For India welcomes 403 Alumni to join a movement of leaders working towards education equity
Tech news

Teach For India welcomes 403 Alumni to join a movement of leaders working towards education equity

by Srikanth
April 20, 2021

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

I agree to the Terms & Conditions and Privacy Policy.

Latest Stories

Five Mistakes Even Seasoned Investors Make and How to Avoid Them 1
Startup news

Five Mistakes Even Seasoned Investors Make and How to Avoid Them

by Sony T
April 23, 2021
Sharmin Ali, CEO Instoried
Tech news

Improve ROI of you content with AI Technology – Instoried

by Srikanth
April 22, 2021
BluSmart introduces environment friendly initiatives on Earth Day
Tech news

BluSmart introduces environment friendly initiatives on Earth Day

by Srikanth
April 22, 2021
ORAI raises INR 3.6 Cr Pre-Series A from IP Ventues
Startup news

ORAI raises INR 3.6 Cr Pre-Series A from IP Ventues

by Srikanth
April 22, 2021
Load More
Techiexpert.com

© 2020 All Rights Reserved

  • Terms of use
  • Privacy Policy
  • About Us
  • Contact us
  • Write For Us
  • Cookie Policy

  • Login
  • Sign Up
No Result
View All Result
  • Home
  • Tech news
  • Startups
  • AI
  • IOT
  • Big Data
  • Cloud
  • Data Analytics
  • ML
  • Blogging

© 2020 All Rights Reserved

Welcome Back!

Login to your account below

Forgotten Password? Sign Up

Create New Account!

Fill the forms below to register

*By registering into our website, you agree to the Terms & Conditions and Privacy Policy.
All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.
Newsletter ?

What is Expected ?

  • Newsletter
  • eBooks
  • Tech Reports
  • Infographic
  • Webinar
  • Event Tickets