Database Documentation with RedGate SQL Doc
Save template file as xxxxx.sqldoc Adding extended note to database table… Important: Remember to use “MS_Description” instead of “Description”.
TSQL Error Handling
Example 1 Example 2 Sources: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver15
Memory Pages Per Second
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
AnyConnect: Saving VPN Entries
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.
Windows Performance Monitor
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.
Azure Data Factory: SSIS in the Cloud
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
SQL Server: Enable Send Mail
Error when using msdb.dbo.sp_send_dbmail: SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for... » read more
WinSCP Error: Error setting the permission and/or timestamp.
Error: Upload of file ‘test.txt’ was successful, but error occurred while setting the permissions and/or timestamp. Resolution: Turn off preserve timestamp setting. Sources: https://winscp.net/eng/docs/message_preserve_time_perm
Error Character ‘%’, hexadecimal value 0x25 is illegal in an XML name
Error: XML configuration file contains illegal characters in xml. Resolution: Escapes or unescapes an XML file removing traces of offending characters that could be wrongfully interpreted as markup. The following characters are reserved in XML and must be replaced with their corresponding XML entities: ‘ is replaced with ' “ is replaced with " & is replaced with & < is replaced... » read more