Skip to content

Instantly share code, notes, and snippets.

View kasuken's full-sized avatar
:octocat:
Authoring courses

Emanuele Bartolesi kasuken

:octocat:
Authoring courses
View GitHub Profile
@kasuken
kasuken / RestartSP.cmd
Created November 15, 2019 09:21
A simple command file to restart all SharePoint 2016 services on the server
@echo off
@echo Stopping Sharepoint services...
@echo Restarting The SharePoint Timer Service...
net stop SPTimerV4
net start SPTimerV4
@echo Restarting The SharePoint Administration Service...
@kasuken
kasuken / powershellsnippetvscode.json
Created September 25, 2019 06:46
PowerShell snippet for VS Code
{
"Condition statement": {
"prefix": "cond",
"body": [
"${_} { ${0}; break }"
],
"description": "Switch condition statement"
},
"Condition single quoted string statement": {
@kasuken
kasuken / profiles.json
Created June 23, 2019 12:22
Windows Terminal settings and files
{
"globals" :
{
"alwaysShowTabs" : true,
"defaultProfile" : "{61c54bbd-c2c6-5271-96e7-009a87ff44bf}",
"initialCols" : 120,
"initialRows" : 30,
"keybindings" :
[
{
@kasuken
kasuken / EmptySiteCollectionsRecycleBin.ps1
Last active June 19, 2019 09:49
Powershell script to remove an SPOsite (from the recycle bin, as well)
$username = ""
$password = ""
$Password = ConvertTo-SecureString -String $password -AsPlainText -Force;
$Credentials = new-object -typename System.Management.Automation.PSCredential -argumentlist $username, $password
Connect-SPOService -Url "https://[tenant]-admin.sharepoint.com" -Credential $Credentials
Get-SPODeletedSite | Remove-SPODeletedSite
@kasuken
kasuken / devmachine.ps1
Last active January 27, 2022 10:40
Boxstarter script for a dev machine
#####################
# PREREQUISITES
#####################
Set-ExplorerOptions -showHiddenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
Set-TaskbarSmall
# Console
cinst PowerShell
cinst poshgit
@kasuken
kasuken / RestartSharePoint.cmd
Created June 11, 2019 04:58
A CMD script to restart all SharePoint services and IIS (it works on SP2010, SP2013, SP2016, SP2019)
@echo off
@echo Stopping Sharepoint services...
@echo Restarting The SharePoint Timer Service...
net stop SPTimerV4
net start SPTimerV4
@echo Restarting The SharePoint Administration Service...
@kasuken
kasuken / AllItem.aspx
Created January 3, 2019 10:09
SharePoint 2013/2016 TreeView
<asp:Content ContentPlaceHolderId="PlaceHolderMain" runat="server">
<table style="width: 100%">
<tr valign="top">
<td width="20%">
<SharePoint:SPHierarchyDataSourceControl ID="docLibDataSource" runat="server" RootContextObject="List" ShowFolderChildren="True" EnableViewState="false"></SharePoint:SPHierarchyDataSourceControl>
<SharePoint:SPTreeView ID="doclibtreeview" runat="server" DataSourceID="docLibDataSource" EnableViewState="false" ExpandDepth="2" SelectedNodeStyle-CssClass="ms-tvselected"></SharePoint:SPTreeView>
</td>
@kasuken
kasuken / GravatarHelper.cs
Last active May 20, 2018 16:14
Create a Gravatar Link with C#
public class GravatarHelper
{
private string CalculateHash(string email)
{
MD5 md5Hasher = MD5.Create();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(email));
StringBuilder sBuilder = new StringBuilder();
@kasuken
kasuken / FileController.cs
Created January 25, 2018 07:24
Download and Upload files via Web API
[Route("api/[controller]")]
public class FilesController : ControllerBase
{
[HttpGet]
public async Task<IActionResult> Download(string filename)
{
if (filename == null)
return Content("filename not present");
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "download", filename);
@kasuken
kasuken / SqlCommandStatistics.cs
Created October 27, 2017 11:55
Retrieve the SQL Server Statistics for a SQL Command
public Dictionary<string,string> Run(string connectionString, string query)
{
using (var sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.StatisticsEnabled = true;
sqlConnection.Open();
using (var cmd = new SqlCommand(query, sqlConnection))
{