Skip to content

Instantly share code, notes, and snippets.

View Laim's full-sized avatar
🧸
jeff

Laim

🧸
jeff
View GitHub Profile
/*
Modified version of https://blog.sqlauthority.com/2017/03/12/get-status-running-backup-restore-sql-server-interview-question-week-113/
Author: Laim McKenzie
Available from https://gist.github.com/laim
Copyright (c) 2021 laim.scot
*/
SELECT r.session_id AS [Session_Id]
,r.command AS [command]
@Laim
Laim / sp_who2_filter.sql
Last active May 7, 2021 15:48
sp_who2 filtering
/*
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
(
@Laim
Laim / feed.xml
Last active February 8, 2021 11:20
Jekyll working RSS feed.xml
<?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>
@Laim
Laim / RestoreSQLServerDatabase.sql
Last active May 27, 2020 12:29
Restore SQL Server Database
-- 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
@Laim
Laim / MT.vbs
Created April 22, 2020 12:39
machinetype
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
<?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");
@Laim
Laim / style.css
Created December 29, 2019 14:22
Dark Mode based on System
body {
font-family: monospace;
background-color: #1d1f21;
color: #FFF;
}
a:link {
text-decoration:none;
color:#CC3300;
}
@Laim
Laim / form.vb
Last active October 24, 2019 18:58
Get Subkeys in registry
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
@Laim
Laim / #4.html
Created February 21, 2019 17:25
<script>
function SearchEnabled() {
if(document.getElementById("ext_search_txt").value==="") {
document.getElementById('ext_search').disabled = true;
} else {
document.getElementById('ext_search').disabled = false;
}
}
</script>
@Laim
Laim / mod.php
Created February 1, 2019 19:09
MyHomeBoardPHP - mod page
<?php
require("../include/configuration.php");
require("../include/helper.php");
require("../include/db/conn.php");
require("../include/db/func.php");
$home = new MyHomeBoardPHP($pdo);
if(isset($_GET['action']) && isset($_GET['id']) && isset($_GET['type'])){
$type = htmlentities($_GET['type']);