.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Create Database Master Key and Certificate Note: USE master database. You should backup the Certificate (With Master Key) as soon as you create the certificate. Note: You can not create a Master Key if a Master Key is already created. You can not drop a Master Key if there are existing Certificate created with the... » read more
Tasks Check Database Integrity Shrink Database Reorganize Index Rebuild Index Update Statistics Clean Up History Execute SQL Server Agent Job Back Up Database (Full) Back Up Database (Differential) Back Up Database (Transaction Log) Maintenance Cleanup Task
A synonym is a database object that serves the following purposes: Provides an alternative name for another database object, referred to as the base object, that can exist on a local or remote server. Provides a layer of abstraction that protects a client application from changes made to the name or location of the base... » read more
Note: sp_spaceused is the fastest way to get a list of table size of the database. sp_spaceused Note: This query is the most detailed. It breaks out the Used space to Data Space and Index Space. ReservedSpace = DataSpace + IndexSize + UnusedSpace Total Space Note: Total Space includes both Used Space (Data + Index)... » read more
Restoring database to original from full backup file. Note: After restore completed, need to re-map user permissions to that database. Time 100 GB = 1 hr
Problem: User can not connect to SQL Server from a remote computer via SSMS. Ping returns unreachable. When user remote desktop on to server and use SSMS from the server, the user is able to connect to SQL Server. Note: Make sure SQL Server Instance is running on the server. If multiple instances installed, make... » read more
View SQL Server Logs SSMS -> Server -> Management -> SQL Server Logs Error Logs View the error logs if SQL Server is unable to start. C:\Program Files\Microsoft SQL Server\MSSQLx.MSSQLSERVER\MSSQL\Log Sources: https://docs.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver15
Regression testing is re-running functional and non-functional tests to ensure that previously developed and tested software still performs after a change. REGRESSION TESTING is defined as a type of software testing to confirm that a recent program or code change has not adversely affected existing features. Regression Testing is nothing but a full or partial selection of already executed test cases which are re-executed to... » read more
Displaying the File Extension in Windows Vista and Windows 7 Click the Start menu. … Type “folder options” (without the quotes). … A dialog box with the title “Folder Options” will appear. … Click to uncheck the box for “Hide extensions for known file types”. Click the “OK” button at the bottom of the dialog box.
After you have installed SQL Server Reporting Services 2017, you will need to configure SSRS before you can use it. Go to Reporting Services Configuration Manger to configure SSRS. Reporting Services Configuration Manager Configure the Web Service URL tab and hit Apply to create directory in IIS. Configure the Web Portal URL tab and hit... » read more