SQL Server

There are two ways you can limit the size of your transaction log files. 1. Using SSMS (SQL Server Management Studio) 2. By writing a manual script. Below are the steps to limit transaction log files. Open your Microsoft SQL

There are situations where sometimes a database is stuck in recovery mode. 1. During the Restore process without running this command – RESTORE DATABASE mydatabase WITH RECOVERY 2. when the drive space is not sufficient and the transaction log size

Please run the below query to get specific details about a table. SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH FROM [DATABASE_NAME].INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N’TABLE_NAME’ Other Database Objects that can be used: – CONSTRAINT_COLUMN_USAGE – CONSTRAINT_TABLE_USAGE – DOMAIN_CONSTRAINTS – DOMAINS –

In order to set up SQL Server 2012 SP3 – I downloaded the files using Microsoft Subscription. Please follow below steps to run the installation. Please make sure to install .Net Framework versions 2.0 and 3.5 from Server Manager. Download

After configuring email server on Windows 2012 R2. There is a possibility that emails might not be sent to addresses outside your domain. When I was using Pickup Directory option to send emails outside our network, I was constantly getting

Recently, I ran into an issue where we have to upgrade our servers to accommodate better hardware. As a part of this migration, one of the task was to upload SSRS reports (rdl) files to the new server. I found

For one of my web project, we were asked to implement a functionality for Document upload and let the users upload and store the documents via the site. One of the requirement was to store the document in BLOB format.

Hi there, in this post I’ll try to explain you how you can restore a database using SQL script. Before I dig deep, I want to share my experience about why use SQL script when you can do it from