Um auf eine SQL Instanz per Remote (von außen) zugreifen zu können, muss man in der Firewall folgende Ports aufmachen:
InBound (Eingehende): TCP 1433 (für z.B. SSMS), UDP 1434 (für ODBC Verbindungen)
OutBound (Ausgehende): TCP 1433
Auserdem muss der TCP/IP Client Protokoll in SQL Configuration eingeschaltet werden:
außerdem muss der SQL Browser Service laufen:
Wie funktionier await?
Ein Thread ist wie eine Pipeline, die einen bestimmten Code in die CPU gibt.
Mal angenommen Thread 1 (Ui Thread) will etwas downloaden und dann auf der UI darstellen. Während des Http Requests ist die Ui gesperrt. Weil der Thread 1 darauf wartet, bis der Server geantwortet hat.
Mit await wird ein freier Thread genommen und der macht den Request. Thread 1 wird nun freigegeben. Der Benutzer kann z.B. weiter die Ui wie gewohnt nutzen.
Wenn Thread 2 fertig ist, sagt er, ich bin fertig und möchte zu dem Thread zurück kehren, der ihn erzeugt hat: Thread 1.
Thread 1 übernimmt und der Codeblock wird weiter ausgeführt.
Wenn es nun egal ist, welcher Thread den Codeblock weiter ausführen soll, kann man
|
1 |
await myAsyncMethod().ConfigureAwait(false) |
nutzen.
.Result sollte nicht genutzt werden, da im Exceptio Stacktrace Fehlermeldungen wie “MoveNext()” erscheinen. Diese kommen aus der kompilierten Statemachine. Besser ist es
|
1 |
.GetAwaiter().GetResult() |
zu nutzen, da dann unser Typ und unsere Exception zurück gegeben werden.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
Handlebars.registerHelper('select', function (value, options) { // Create a select element var select = document.createElement('select'); // Populate it with the option HTML select.innerHTML = options.fn(this); // Set the value select.value = value; // Find the selected node, if it exists, add the selected attribute to it if (select.children[select.selectedIndex]) select.children[select.selectedIndex].setAttribute('selected', 'selected'); return select.innerHTML; }); Handlebars.render = Handlebars.render || function(tpl, data) { data = data || {}; var compiled = Handlebars.render.cache[tpl]; if (!compiled) { // Uncached template compiled = Handlebars.compile(tpl); Handlebars.render.cache[tpl] = compiled; } return compiled(data); }; Handlebars.render.cache = {}; |
Surface 2019-05-19
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 |
! 3.5.2019 https://de.malwarebytes.com de.malwarebytes.com##.ce-banner ! 3.5.2019 https://www.kaspersky.de www.kaspersky.de##.bottom.dark.transparent.notification-bar ! 3.5.2019 https://help.kaspersky.com help.kaspersky.com##.js_cookie_policy.cookie-policy ! 4.5.2019 https://notepad-plus-plus.org notepad-plus-plus.org##.cc_container--open.cc_container.cc_banner ! 4.5.2019 https://slyxi.com slyxi.com###yandex_rtb_R-A-388882-3 > .adb-def ! 6.5.2019 https://www.mydealz.de www.mydealz.de##.vAlign--all-b.tGrid-cell ! 9.5.2019 https://www.fcbarcelona.com www.fcbarcelona.com##.cookie-notice--show.js-cookie-notice.cookie-notice--hidden.cookie-notice ! 9.5.2019 https://www.kenwoodworld.com www.kenwoodworld.com##.bannerpadding ! 9.5.2019 https://www.internetworld.de www.internetworld.de##.cc-color-override--227966932.cc-top.cc-theme-block.cc-type-info.cc-banner.cc-window ! 9.5.2019 https://www.ebay.de www.ebay.de###gdpr-banner ! 12.5.2019 https://selbermachen.de selbermachen.de###sliding-popup > div selbermachen.de###zs_next_article ! 12.5.2019 https://www.obi.de www.obi.de##.cookiepolicy__container ! 12.5.2019 https://www.sport.de www.sport.de##.cc-color-override-896100485.cc-bottom.cc-theme-edgeless.cc-type-info.cc-banner.cc-window ! 12.5.2019 https://www.youtube.com ||i.ytimg.com/vi/fMnq5v8yZp4/hqdefault.jpg?sqp=-oaymwEZCNACELwBSFXyq4qpAwsIARUAAIhCGAFwAQ==&rs=AOn4CLCjYTrHeYEdlRyirmTM-tqQfhTokA$image ! 13.5.2019 https://www.beitsarshalom.org www.beitsarshalom.org##.cookie-notice-container ! 14.5.2019 https://www.ikea.com www.ikea.com##.cookie-info__panel--show.js-cookie-info__panel.cookie-info__panel ! 14.5.2019 https://www.sitepoint.com www.sitepoint.com##.qc-cmp-ui-content www.sitepoint.com###qcCmpUi www.sitepoint.com##.qc-cmp-showing.qc-cmp-ui-container ! 18.5.2019 https://www.dasheimwerkerforum.de www.dasheimwerkerforum.de##.noticeContent.baseHtml ! 19.5.2019 https://www.wohntec.de www.wohntec.de##.page-wrap--cookie-permission www.wohntec.de###BadgeContent_db8d3657bdbe440c985ae127463eaad4 www.wohntec.de##.etrusted-tb-footer__content www.wohntec.de###BottomSlantBadge_db8d3657bdbe440c985ae127463eaad4 > svg www.wohntec.de###BadgeFooter_db8d3657bdbe440c985ae127463eaad4 |
|
1 2 3 4 5 |
1.ToString("#,0.00") // 1,00 1000.ToString("#,0.00") // 1.000,00 1000.12 // 1.000,12 1000.126.ToString("#,0.00") // 1.000,13 0.12.ToString("#,0.00") // 0,12 |
DECLARE @ObjectID UNIQUEIDENTIFIER = '18AAF1E3-FBFC-4BB1-957A-60AD7EFC0276'
WITH RowsToDelete AS (
SELECT [ID]
FROM [Security].[PermissionLevel]
WHERE [ID] = @ObjectID
UNION ALL
SELECT [Child].[ID]
FROM [Security].[PermissionLevel] Child
INNER JOIN RowsToDelete Parent ON Parent.[ID] = [Child].[ParentID]
)
DELETE FROM [Security].[PermissionLevel]
FROM [Security].[PermissionLevel] h
INNER JOIN RowsToDelete d on h.ID = d.ID
go
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
DECLARE @Page INT = 1 , @PageSize INT = 50 , @LanguageID INT = 46 , @ObjectID UNIQUEIDENTIFIER = '27461EA1-6EAC-47C5-8500-50A411C440D6' , @Sort_Key BIT = NULL , @Sort_Default BIT = NULL , @Sort_Translation BIT = NULL , @Filter_Key NVARCHAR(50) = NULL , @Filter_Default NVARCHAR(255) = NULL , @Filter_Translation NVARCHAR(MAX) = NULL SELECT [KeyStore].[ID] AS [KeyStore_ID] , [KeyStore].[Key] AS [KeyStore_Key] , [KeyStore].[Default] AS [KeyStore_Default] , [KeyStore].[ApplicationID] AS [KeyStore_ApplicationID] , [Value].[ID] AS [Value_ID] , [Value].[Value] AS [Trans] , [Value].[LanguageID] AS [Value_LanguageID] , [Language].[EnglishName] AS [Language_EnglishName] , TotalRows = COUNT(*) OVER() -- Return Total Rows. Without Offset FROM [Translation].[KeyStore] LEFT JOIN [Translation].[Value] [Value] ON [Value].[KeyStoreID] = [KeyStore].[ID] INNER JOIN [Translation].[Language] [Language] ON [Language].[ID] = @LanguageID WHERE ([ApplicationID] = @ObjectID AND ([Value].LanguageID IS NULL OR [Value].LanguageID = @LanguageID)) -- Filter: Key AND ( (@Filter_Key IS NULL OR @Filter_Key = '') OR ([KeyStore].[Key] LIKE REPLACE(@Filter_Key, '*', '%') OR (DIFFERENCE([KeyStore].[Key], @Filter_Key) > 3) ) ) -- Filter: Default AND ( (@Filter_Default IS NULL OR @Filter_Default = '') OR ([KeyStore].[Default] LIKE REPLACE(@Filter_Default, '*', '%') OR (DIFFERENCE([KeyStore].[Default], @Filter_Default) > 3) ) ) -- Filter: Translation AND ( (@Filter_Translation IS NULL OR @Filter_Translation = '') OR ([Value].[Value] LIKE REPLACE(@Filter_Translation, '*', '%') OR (DIFFERENCE([Value].[Value], @Filter_Translation) > 3) ) ) ORDER BY -- Sort: Key CASE @Sort_Key WHEN 0 THEN [KeyStore].[Key] END DESC, CASE @Sort_Key WHEN 1 THEN [KeyStore].[Key] END ASC -- Sort: Default , CASE @Sort_Default WHEN 0 THEN [KeyStore].[Default] END DESC, CASE @Sort_Default WHEN 1 THEN [KeyStore].[Default] END ASC -- Sort: Value , CASE @Sort_Translation WHEN 0 THEN [Value].[Value] END DESC, CASE @Sort_Translation WHEN 1 THEN [Value].[Value] END ASC -- Default Sort , CASE WHEN @Sort_Key IS NULL AND @Sort_Default IS NULL AND @Sort_Translation IS NOT NULL THEN [KeyStore].[Key] END ASC -- Offset paging OFFSET ((@Page - 1) * @PageSize) ROWS FETCH NEXT @PageSize ROWS ONLY |
Der Profiler ist schon eine tolle Sache. Wenn man im SQL Management Studio eine Prozedur ausklappt, dann macht das Management Studio folgende Abfrage um die Informationen auszulesen:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
SELECT param.name AS [Name], 'Server[@Name=' + quotename(CAST( serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/StoredProcedure[@Name=' + quotename(sp.name,'''') + ' and @Schema=' + quotename(SCHEMA_NAME(sp.schema_id),'''') + ']' + '/Param[@Name=' + quotename(param.name,'''') + ']' AS [Urn], usrt.name AS [DataType], ISNULL(baset.name, N'') AS [SystemType], CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND param.max_length <> -1 THEN param.max_length/2 ELSE param.max_length END AS int) AS [Length], CAST(param.precision AS int) AS [NumericPrecision], CAST(param.scale AS int) AS [NumericScale], param.default_value AS [DefaultValue], param.is_output AS [IsOutputParameter], param.is_cursor_ref AS [IsCursorParameter], sp.object_id AS [IDText], db_name() AS [DatabaseName], param.name AS [ParamName], CAST( case when sp.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = sp.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit) AS [ParentSysObj], 1 AS [Number] FROM sys.all_objects AS sp INNER JOIN sys.all_parameters AS param ON param.object_id=sp.object_id LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = param.user_type_id LEFT OUTER JOIN sys.types AS baset ON (baset.user_type_id = param.system_type_id and baset.user_type_id = baset.system_type_id) or ((baset.system_type_id = param.system_type_id) and (baset.user_type_id = param.user_type_id) and (baset.is_user_defined = 0) and (baset.is_assembly_type = 1)) |
// Letzte Trades
http://www.ptdtrading.com/latestTrades.php?whichProfile=1
JQuery hinzufügen dynamisch
|
1 2 3 4 5 |
var jq = document.createElement('script'); jq.src = "https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"; document.getElementsByTagName('head')[0].appendChild(jq); // ... give time for script to load, then type (or see below for non wait option) jQuery.noConflict(); |
Blendet alle Regulären Pokemon aus
|
1 |
$('.block:not(.shiny):not(.shadow)').remove() |
Blendet Pidgeot aus
|
1 |
$('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/18_1.png"]').closest('.pokemon_compact').remove() |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
// Chrome Extension: ScriptRunner //folgendes kopieren: $('.block:not(.shiny):not(.shadow)').remove() //Pidgeot $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/18_1.png"]').closest('.pokemon_compact').remove() //Pidgey $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/16_1.png"]').closest('.pokemon_compact').remove() //Tentacool $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/72_1.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/72_0.png"]').closest('.pokemon_compact').remove() //Staryu $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/120_1.png"]').closest('.pokemon_compact').remove() //Onix $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/95_0.png"]').closest('.pokemon_compact').remove() //Geodude $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/74_1.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/75_0.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/63_1.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/121_1.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/75_1.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('img[src="http://www.ptdtrading.com/games/ptd/small/95_1.png"]').closest('.pokemon_compact').remove() $('.block.pokemon_compact').find('b:contains((Hacked Version)').closest('.pokemon_compact').remove() |
Login