.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Every time SQL Server is started, the current error log is renamed to errorlog.1; errorlog.1 becomes errorlog.2, errorlog.2 becomes errorlog.3, and so on. sp_cycle_errorlog enables you to cycle the error log files without stopping and starting the server. Return Code Values 0 (success) or 1 (failure) Source: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-errorlog-transact-sql?view=sql-server-2017
Query to return info about replicas. Query to return a list of Primary Replicas databases. Query to return a list of Non-Primary Replicas databases.
Save template file as xxxxx.sqldoc Adding extended note to database table… Important: Remember to use “MS_Description” instead of “Description”.
Example 1 Example 2 Sources: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver15
Pages/sec is the rate at which pages are read from or written to disk to resolve hard page faults. Memory: Pages/sec A high rate for the Pages/sec counter could indicate excessive paging. Memory: Page Faults/sec Monitor the Memory: Page Faults/sec counter to make sure that the disk activity is not caused by paging. Page Faults/sec is the... » read more
Go to … C:\ProgramData\Cisco\Cisco AnyConnect Secure Mobility Client\Profile Create or edit xml file xxxxxx.xml Make sure to restart the AnyConnect application for the changes to go into effect.
Setup Monitor Data Collector Sets -> New Be sure to “Start” to start recording. Note: Data file will be updated and accessible once the job has been stopped.
Today’s landscape for data warehousing is a rapidly evolving space and most of that evolution is happening in the cloud. The cloud has long offered ways to scale analytic workloads for data warehousing with services like Azure SQL Data Warehouse. However, this only solves one part of the data warehousing workload and as the complexity... » read more