Skip to content

Instantly share code, notes, and snippets.

View guyinacube's full-sized avatar

Adam Saxton guyinacube

View GitHub Profile
@guyinacube
guyinacube / basic.xml
Created January 1, 2020 15:52
Basic ISBoxer setup for troubleshooting
<?xml version="1.0" encoding="utf-8"?>
<ISBoxerToolkitProfile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="42" VersionMinor="0" BuildDate="1/1/2020 9:50:19 AM">
<CharacterSet>
<ExecuteOnLoad />
<Name>Druid</Name>
<Description>Generated by ISBoxer 42 Quick Setup Wizard - 1/1/2020</Description>
<DisableFPSIndicator>true</DisableFPSIndicator>
<EnforceSingleWindowControlTested>true</EnforceSingleWindowControlTested>
<GUIToggleCombo>
<Combo>Ctrl+`</Combo>
<?xml version="1.0" encoding="utf-8"?>
<ISBoxerToolkitProfile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="42" VersionMinor="0" BuildDate="12/28/2019 8:57:42 AM">
<CharacterSet>
<ExecuteOnLoad>
<KeyMapString>Initialization</KeyMapString>
<MappedKeyString>___Startup Sequence</MappedKeyString>
</ExecuteOnLoad>
<Name>Druids - Alliance</Name>
<Description>Generated by ISBoxer 42 Quick Setup Wizard - 12/18/2019</Description>
<DisableFPSIndicator>true</DisableFPSIndicator>
@guyinacube
guyinacube / Clear Cache.xmla
Created September 16, 2019 02:28
Clear the model cache XMLA
<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID> ENTER YOUR DATABASE NAME!!! </DatabaseID>
</Object>
</ClearCache>
@guyinacube
guyinacube / Get-PowerBI-DiagPort.ps1
Created September 16, 2019 02:26
Get the Power BI Diagnostic port using PowerShell
#PLEASE OPEN YOUR POWER BI DESKTOP FILE BEFORE RUNNING THIS SCRIPT!!!!!
#Gets a list of teh ProcessIDs for all Open Power BI Desktop files
$processids = Get-Process msmdsrv | Select-Object -ExpandProperty id
#Loops through each ProcessIDs, gets the diagnostic port for each file, and finally generates the connection that can be use when connecting to the Vertipaq model.
if($processids)
{
foreach($processid in $processids)
{
@guyinacube
guyinacube / AssignPowerBIFree.ps1
Created March 28, 2018 20:05
Assign a Power BI (Free license to any user that doesn't have one.
## This sample script assigns a Power BI (Free) license to any user
## that does not have it already. This requires that Power BI (Free)
## license block exists within your tenant. This shows up when at least
## one user signs up for Power BI.
##
## This is reflected as the POWER_BI_STANDARD SKU.
## NOTE: You must sign in with an account that has admin rights to assign licenses
## within your tenant.
@guyinacube
guyinacube / JDBCKerberosTest.java
Last active December 9, 2021 10:29
SQL JDBC Driver connectivity test for Kerberos
import java.sql.*;
import java.util.logging.*;
import java.io.IOException;
public class JDBCKerberosTest{
public static void main(String[] args) {
//Logger logger = Logger.getLogger("com.microsoft.sqlserver.jdbc");
@guyinacube
guyinacube / JDBCConnectionTest.java
Created November 27, 2017 11:53
SQL JDBC Driver connectivity test
import java.sql.*;
import java.util.logging.*;
import java.io.IOException;
public class JDBCConnectionTest{
public static void main(String[] args) {
//Logger logger = Logger.getLogger("com.microsoft.sqlserver.jdbc");
@guyinacube
guyinacube / group copy.ps1
Last active April 26, 2022 18:12
Create mail enabled security group based on O365 Unified group
## Option 1 - This can be used to be prompted for credentials
$UserCredential = Get-Credential
## Option 2 - If you really want to automate the script, you will
## want to hard code the credentials to log into Azure AD.
# $User = "<ADMIN USER>"
# $PWord = ConvertTo-SecureString -String "<PASSWORD>" -AsPlainText -Force
# $UserCredential = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $User, $PWord
## Create the session to Exchange Online
@guyinacube
guyinacube / boxstarter.txt
Last active October 14, 2017 13:52
My boxstarter script for new installs
Set-ExplorerOptions -showHidenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
Enable-RemoteDesktop
cinst Microsoft-Hyper-V-All -source windowsFeatures
cinst 7zip
cinst 7zip.install
cinst AdobeAIR
cinst adobe-creative-cloud
cinst azure-cli
cinst beyondcompare
@guyinacube
guyinacube / Power BI License Automation.ps1
Created January 10, 2017 20:50
Power BI License Automation from Audit Log - PowerShell
# Option 1 - This can be used to be prompted for credentials
$UserCredential = Get-Credential
Connect-MsolService -credential $UserCredential
# Option 2 - If you really want to automate the script, you will
# want to hard code the credentials to log into Azure AD.
$User = "<ADMIN USER>"
$PWord = ConvertTo-SecureString -String "<PASSWORD>" -AsPlainText -Force
$UserCredential = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $User, $PWord