• Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us
TecAdmin
Menu
  • Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us

Category: SQL Server

16 June 2019

How to Rename a Column Name in SQL Server Database

Written by Rahul
Rahul
The sp_rename stored procedure is used to rename a column name in a table in MSSQL server database. Syntax: Here is the syntax of the sp_rename stored procedure. [crayon-5df4fdb13597f480846277/] Caution: Changing any part of an object name could break scripts and stored procedures. Example: For example, I have a table named Accounts in the...
Read More about How to Rename a Column Name in SQL Server Database
SQL Server Leave a Comment
09 May 2017

How to Find Currently Running Query in SQL Server

Written by Rahul
Rahul
This can be an important query for your while debugging slowness of SQL server. This will help you find currently running SQL queries on SQL Server. You can find which queries are running from a long time and utilizing CPU. To run this query, start SQL Server Management Studio, Open New Query window and...
Read More about How to Find Currently Running Query in SQL Server
SQL Server 6 Comments
15 August 2016

FIXED MSSQL Error 3154 – The backup set holds a backup of a database other than the existing database

Written by Rahul
Rahul
Using SQL Query Window: Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and backup file location as per your setup. USE MASTER GO RESTORE DATABASE MyDB FROM DISK = 'C:\Backups\MyDB_15082016.bak' WITH REPLACE GO
Read More about FIXED MSSQL Error 3154 – The backup set holds a backup of a database other than the existing database
SQL Server Leave a Comment
03 December 2014

How To Create ASPState Database in SQL Server

Written by Rahul
Rahul
The ASPStage (ASP.NET Session State) provides you the option to store website session data to the SQL server database. This is a useful option with load balancing, where application deployment is on multiple servers. This tutorial will help you to create ASPState database in SQL server with the command line. Prerequsities You must have...
Read More about How To Create ASPState Database in SQL Server
SQL Server 2 Comments
03 February 2014

How to Migrate SQL Server Database to Amazon RDS Instanace

Written by Rahul
Rahul
Amazon SQL Server RDS Instance doesn’t support to restore data from .bak files. So using this article I am writing to how to migrate your SQL server database to Amazon RDS instanace with easy steps. If you looks on AWS migration steps its too complicated, But windows Azure migration wizard tools provide an easier...
Read More about How to Migrate SQL Server Database to Amazon RDS Instanace
Amazon Web Services, SQL Server 7 Comments
02 March 2013

How to Shrink SQL Server Transaction Log Files using DBCC SHRINKFILE

Written by Rahul
Rahul
Sometimes SQL Server logs files acquire a large space on the disk. In that case, we need to reduce the size of the log file to claim some space. But truncating or reducing database log file in SQL Server 2008 can be quite difficult. It also has its own issues. This article contains a...
Read More about How to Shrink SQL Server Transaction Log Files using DBCC SHRINKFILE
SQL Server 1 Comment

Popular Posts

  • How to Install Python 3.8 on Ubuntu, Debian and LinuxMint
  • How to Restart Network Service on CentOS 8 or RHEL 8
  • How to Check IP Address on CentOS 8
  • How to Install Java 11/8 on Amazon Linux
  • How to Configure Static IP on CentOS 8 (CLI)
Copyright © 2013-2019 TecAdmin.net. All Rights Reserved. This site uses cookies. By using this website you agree with our term and services
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo
Revoke cookies