Add on Find Your Tab

This article offers a sample of basic Markdown syntax that can be used in Hugo content files, also it shows whether basic HTML elements are decorated with CSS in a Hugo theme.

SQL Script to export table data in xml files, or export schema data to xsd files This use OLE Automation Stored Procedures (Transact-SQL), and maybe, you need to change the global configuration settings of SQL Server. It can be an issue in production environment, and this case. The SQL Script have three stored...

This PowerShell script generates an html report listing all accounts used as logon account by services on servers in an Active Directory domain. The script has filters to ignore accounts : NT Service, NT AUTHORITY and LocalSystem https://github.com/sozezzo/Powershell/blob/master/Report/report-service-server.ps1 Apply...

This query returns list of tables and their columns with details. 1 2SELECT @@Servername AS ServerName 3 , DB_NAME() AS DatabaseName 4 , DB_ID() AS DatabaseId 5 , sc.name AS SchemaName 6 , tab.schema_id AS SchemaId 7 , tab.NAME AS TableName 8 , tab.object_id AS TableId 9 , col.NAME AS ColumnName 10 , col.column_id 11 ,...

Disable all triggers on a table, you do what you have to do, after enable only the triggers that have been disabled. Step 1 : Disable all triggers 1 2--#region Disable triggers 3 4DECLARE @triggers TABLE (SqlEnableTrigger NVARCHAR(MAX)); 5DECLARE @SchemaName VARCHAR(128) = 'mySchema'; – ** TO DO ** 6DECLARE @TableName...