Monday, January 18, 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: 2min 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

Impact of COVID-19 on Startups Funding
Tech news

Post-Pandemic Investment Management: Why turn to AI

January 17, 2021
Get Maximum Benefit from your LinkedIn App using Piwaa
Tech news

Get Maximum Benefit from your LinkedIn App using Piwaa

January 16, 2021
chatbot customer service
Tech news

25 Virtual Assistant Services You Can Offer Your Clients

January 14, 2021
Learn how to set up automated security testing
Tech news

Majority of DDoS Attacks in 2020 – StormWall Report

January 14, 2021
Broadband – Types & Their Benefits to Cloud Computing
Tech news

Broadband Connection – Types & Their Benefits Explained

January 14, 2021
5 Ways to Optimize Your Home for Cloud Gaming
Tech news

5 Ways to Optimize Your Home for Cloud Gaming

January 13, 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

Impact of COVID-19 on Startups Funding
Tech news

Post-Pandemic Investment Management: Why turn to AI

by Daglar Cizmeci
January 17, 2021
Get Maximum Benefit from your LinkedIn App using Piwaa
Tech news

Get Maximum Benefit from your LinkedIn App using Piwaa

by Sony T
January 16, 2021
chatbot customer service
Tech news

25 Virtual Assistant Services You Can Offer Your Clients

by Sony T
January 14, 2021
Learn how to set up automated security testing
Tech news

Majority of DDoS Attacks in 2020 – StormWall Report

by Srikanth
January 14, 2021
Broadband – Types & Their Benefits to Cloud Computing
Tech news

Broadband Connection – Types & Their Benefits Explained

by Sony T
January 14, 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.