Show Progress of Database Backup/Restore
Run the following scripts to show the progress of current database backup/restore.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Installing Older Versions of Visual Studio
Go to https://my.visualstudio.com and join Visual Studio Dev Essentials. After joining, you can download the specific versions of Visual Studio.
Estimating the Size of Backup Files
How to estimate the next backup size? When we want to estimate the next backup size we can use the following stored procedure which gives some information about the backup size. The reserved column value approximately gives information about size of uncompressed backup size. Reserved column defines the database size which consists of data and... » read more
.BAK File Size vs Actual Database File Size
The space was allocated to the database files, but not used. You can create a new database, make it 10GB in size, and see the files allocate that amount of space on disk. However, until you put data in the database, the file is essentially empty, and your backup file size will be minimal. For... » read more
Check and Reset Table Identity
Checks the current identity value for the specified table and, if it’s needed, changes the identity value. You can also use DBCC CHECKIDENT to manually set a new current identity value for the identity column. Examples A. Resetting the current identity value, if it’s needed The following example resets the current identity value, if it’s... » read more
Troubleshooting SQL Server Send Email
Sending Email Sources:
Installing SQL Server 2017 Reporting Services
With SQL Server 2017, Reporting Services is a separate install. Download install from Microsoft site. https://www.microsoft.com/en-us/download/confirmation.aspx?id=55252 After you have installed it, you will need to configure it via Report Server Configuration Manager. Once configured, you will be able to access SSRS via link http://server01/ReportServer.
SQL Server Named Pipes
After SQL Server install, need to enable Named Pipes in order to be accessible from SQL Server Management Studio. Go to SQL Server Configuration Manager to enable Named Pipes and TCP/IP. Also need to restart services.
SVN – Checkout Process
Check out a working copy from a repository. Select folder and checkout. Map repository folder to a local folder on your computer. All files folders will be copied over to your local folder. The folder will be marked with a green checkout icon. You can now edit files and commit changes back to repository.
XCOPY
The xcopy command is a Command Prompt command used to copy one or more files and/or folders from one location to another location. The xcopy command, with its many options and ability to copy entire directories, is similar to, but much more powerful than, the traditional copy command. The robocopy command is also similar to the xcopy command but has even more... » read more