If you want resources offline to learn about programming and web technologies MDN is for you! and I recommend to use MDN over w3school because w3school is outdated.
Download it offline (2.1gb) at https://mdn-downloads.s3-us-west-2.amazonaws.com/developer.mozilla.org.tar.gz
| SELECT | |
| sch.name AS table_schema | |
| ,tbl.name AS table_name | |
| ,trig.name AS trigger_name | |
| ,trig.is_disabled | |
| ,CASE WHEN is_disabled = 0 THEN 'Enabled' ELSE 'Disabled' END trigger_Status | |
| FROM sys.triggers AS trig | |
| LEFT JOIN sys.tables AS tbl ON tbl.object_id = trig.parent_id | |
| LEFT JOIN sys.schemas AS sch ON sch.schema_id = tbl.schema_id |
| SELECT | |
| ind.name | |
| ,sch.name | |
| ,obj.name | |
| ,sc.name | |
| ,sc.is_computed AS is_computed | |
| ,tbl_computed_columns.definition AS computation |
| To disable "This file comes from another computer" | |
| Disable blocking when files are downloaded, open the following registry key: | |
| HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Attachments\SaveZoneInformation | |
| Change SaveZoneInformation to 1. | |
| NOTE: | |
| 0 = Not Configured |
| SELECT | |
| ind.name | |
| ,'DROP INDEX ' + QUOTENAME | |
| ( | |
| CASE WHEN SUBSTRING(ind.name, 1, 2) = 'ix' THEN 'IX' + SUBSTRING(ind.name, 3, 10000) ELSE ind.name END | |
| ) + ' ON ' + QUOTENAME(sch.name) + '.' + QUOTENAME(obj.name) + '; ' AS DropIndexScript | |
| , ' CREATE ' |
Alle: =IIF(COUNTROWS("SEL_Standort").Equals(Parameters!in_standort.Count),"Alle","Nicht Alle")
| What | Color |
|---|---|
| Title Background | #4472C4 |
| Light Blue | #D9E1F2 |
| Line | #AABEE4 |
| Simply convert: | |
| ffmpeg -i input.avi output.mp4 | |
| Simply convert, but only the left half of the screen(s): | |
| ffmpeg -i input.avi -filter_complex "[0:v]crop=iw/2:ih:0:0,scale=iw:ih[out]" -map "[out]" output.mp4 | |
| Simply convert, but only the right half of the screen(s): | |
| ffmpeg -i input.avi -filter_complex "[0:v]crop=iw/2:ih:ow:0,scale=iw:ih[out]" -map "[out]" output.mp4 |
| USE master | |
| GO | |
| ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE | |
| GO | |
| ALTER DATABASE database_name SET MULTI_USER WITH ROLLBACK IMMEDIATE | |
| SELECT | |
| t.[text], qs.creation_time | |
| FROM sys.dm_exec_cached_plans AS p | |
| CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t | |
| JOIN sys.dm_exec_query_stats qs ON p.plan_handle = qs.plan_handle | |
| -- WHERE t.[text] LIKE N'%something unique about your query%'; | |
| WHERE t.[text] LIKE N'%CTE%' | |
| -- AND t.text LIKE '%APP-APERTUR%' | |
| ORDER BY qs.creation_time DESC |
This is how to fix this error:
An HTTPS binding already exists for the specified IP address and port combination!
netsh http show sslcert
if too long
netsh http show sslcert > sslcert.txt