This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Custom Fields | |
SELECT C.Name, COUNT(CF.CID) AS [CustomFieldCount] FROM SnowLicenseManager.dbo.tblCustomField CF | |
INNER JOIN SnowLicenseManager.dbo.tblCID C ON CF.CID = C.CID | |
GROUP BY C.Name | |
-- Custom Compare Values | |
SELECT C.Name, COUNT(CCV.CID) AS [CCVCount] FROM SnowLicenseManager.dbo.tblCustomCompareValues CCV | |
INNER JOIN SnowLicenseManager.dbo.tblCID C ON CCV.CID = C.CID | |
GROUP BY C.Name |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# START : Get SQL Instance Version # | |
cls # prevents the script itself from echoing out into ISE | |
"---------------------------------------------------------------------" | |
$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances # Gets the installed SQL instances | |
$sqlInstanceCount = 0; # loop for the foreach | |
foreach ($i in $inst) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Author: Laim McKenzie | |
Date: 30-04-2021 | |
Updated: 07-05-2021 | |
https://laim.scot | |
*/ | |
/* Create temp table to populate with data */ | |
CREATE TABLE #sp_who2 | |
( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom"> | |
<channel> | |
<title>{{ site.name | xml_escape }}</title> | |
<description>{{ site.description | xml_escape }}</description> | |
<link>{{ site.url }}</link> | |
<atom:link href="{{ site.url }}/feed.xml" rel="self" type="application/rss+xml" /> | |
{% for post in site.posts limit:10 %} | |
<item> | |
<title>{{ post.title }}</title> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Take the database offline before restoring | |
ALTER DATABASE [DatabaseName] | |
SET OFFLINE WITH ROLLBACK IMMEDIATE | |
-- Restore the database | |
RESTORE DATABASE DatabaseName FROM DISK = '\\FileServer\directory\servername\database\database_backup.bak' | |
-- Bring it back online, this should be automatic but just incase. | |
ALTER DATABASE [DatabaseName] | |
SET ONLINE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
strName = "." 'Computer name, if local just use a period. | |
Set objWMI = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strName & "\root\cimv2") | |
For Each obj in objWMI.ExecQuery ("Select * from Win32_SystemEnclosure") | |
For Each strChassisType in obj.ChassisTypes | |
Wscript.Echo strChassisType | |
Next | |
Next |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$user = "laim"; | |
$key = ""; | |
$type = "history"; //history or watching | |
// You need to register an API app here https://trakt.tv/oauth/applications to get the API Key (ClientID) | |
function traktAPI($user, $key, $type) { | |
$ch = curl_init(); | |
curl_setopt($ch, CURLOPT_URL, "https://api.trakt.tv/users/$user/$type"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
body { | |
font-family: monospace; | |
background-color: #1d1f21; | |
color: #FFF; | |
} | |
a:link { | |
text-decoration:none; | |
color:#CC3300; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Imports YourApp.Registry | |
Public Class frmMain | |
Private Sub btnRegGet_Click(sender As Object, e As EventArgs) Handles btnRegGet.Click | |
Try | |
lbKeys.Items.Clear() | |
For Each i In getKeys("SOFTWARE\Google") | |
lbKeys.Items.Add(i.ToString) | |
Next |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script> | |
function SearchEnabled() { | |
if(document.getElementById("ext_search_txt").value==="") { | |
document.getElementById('ext_search').disabled = true; | |
} else { | |
document.getElementById('ext_search').disabled = false; | |
} | |
} | |
</script> |