Skip to content

Instantly share code, notes, and snippets.

View johndacosta's full-sized avatar

johndacosta

1 follower · 4 following
View GitHub Profile
@johndacosta
johndacosta / powershell_javascript_iso_date.ps1
Created November 18, 2015 18:03
basic stub to get out a basic date object in json from powershell
# "2015-11-18 18:02:55Z"
(get-date).ToUniversalTime().toString("u") | ConvertTo-Json
@johndacosta
johndacosta / install-npm-packages.bat
Last active August 29, 2015 14:22
install npm packages globally, this is personal preference only --- not a recommendation
REM by deploying one at a time, an incorrectly types package name does not bomb entire installation
for %x in (async aws-sdk backbone body-parser bower browserify chalk cheerio cli-color coffee-script colors commander connect cordova debug express forever fs-extra glob grunt grunt grunt-cli gulp handlebars jade jquery karma less lodash log4js mime minimist mkdirp moment mongodb morgan mustache oauth optimist passport pg phantomjs pm2 promise q react redis request rimraf semver socket.io statsd tedious through through2 uglify-js underscore uuid validator when winston wrench yo) do npm install -g %x
@johndacosta
johndacosta / rjdbc_query_sql_server_mac_osx.r
Last active June 29, 2019 07:17
Connecting to SQL Server with R using RJDBC and com.microsoft.sqlserver.jdbc.SQLServerDriver on Mac OS X
# http://dacosta9.wordpress.com/2014/02/26/connecting-to-sql-server-with-r-with-rjdbc/
# reference document on RJDBC
# http://cran.r-project.org/web/packages/RJDBC/RJDBC.pdf
# install.packages("RJDBC",dep=TRUE)
library(RJDBC)
drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver" , "/Users/johndacosta/Downloads/sqljdbc_4.0/enu/sqljdbc4.jar" ,identifier.quote="`")
conn <- dbConnect(drv, "jdbc:sqlserver://192.172.1.210:55158;databaseName=master", "sa", "password")
d <- dbGetQuery(conn, "select * from sys.databases where database_id <= 4 ")
summary(d)
@johndacosta
johndacosta / rjdbc_query_sql_server_ubuntu.r
Last active August 29, 2015 13:56
Connecting to SQL Server with R using RJDBC and com.microsoft.sqlserver.jdbc.SQLServerDriver on Ubuntu
# http://dacosta9.wordpress.com/2014/02/26/connecting-to-sql-server-with-r-with-rjdbc/
# reference document on RJDBC
# http://cran.r-project.org/web/packages/RJDBC/RJDBC.pdf
# install.packages("RJDBC",dep=TRUE)
library(RJDBC)
drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver" , "/home/johndacosta/C/jdbc/sqljdbc_3.0/enu/sqljdbc4.jar" ,identifier.quote="`")
conn <- dbConnect(drv, "jdbc:sqlserver://192.172.1.210:55158;databaseName=master", "sa", "password")
d <- dbGetQuery(conn, "select * from sys.databases where database_id <= 4 ")
summary(d)
@johndacosta
johndacosta / rjdbc_query_sql_server_windows.r
Last active August 29, 2015 13:56
Connecting to SQL Server with R using RJDBC and com.microsoft.sqlserver.jdbc.SQLServerDriver on Windows 7 64-bit
# http://dacosta9.wordpress.com/2014/02/26/connecting-to-sql-server-with-r-with-rjdbc/
# http://cran.r-project.org/web/packages/RJDBC/RJDBC.pdf
# install.packages("RJDBC",dep=TRUE)
library(RJDBC)
drv <- JDBC("com.microsoft.sqlserver.jdbc.SQLServerDriver" , "C:/jdbc/sqljdbc_4.0/enu/sqljdbc4.jar" ,identifier.quote="`")
conn <- dbConnect(drv, "sqlserver://192.172.1.210:55158;databaseName=master", "sa", "password")
d <- dbGetQuery(conn, "select * from sys.databases where database_id <= 4 ")
summary(d)
@johndacosta
johndacosta / database_file_sizes.sql
Created July 30, 2013 04:41
Get files sizes for sql server. intentionally using old table due to desire to support sql 2000
-- http://msdn.microsoft.com/en-us/library/ms181338.aspx
select
@@servername as ServerName, db_name(dbid) as DatabaseName,dbid,fileid,groupid, size, size * 8 sizeKB, maxsize, growth, status, name, filename
from master.dbo.sysaltfiles
@johndacosta
johndacosta / WMI_Memory.config
Created July 27, 2013 23:04
typeperf collection set for WMI_Memory Counters
\Memory\% Committed Bytes In Use
\Memory\Available Bytes
\Memory\Available KBytes
\Memory\Available MBytes
\Memory\Cache Bytes
\Memory\Cache Bytes Peak
\Memory\Cache Faults/sec
\Memory\Commit Limit
\Memory\Committed Bytes
\Memory\Demand Zero Faults/sec
@johndacosta
johndacosta / WMI_LogicalDisk.config
Created July 27, 2013 22:59
typeperf configuration file for collecting all logical disk counters.
\LogicalDisk(*)\% Disk Read Time
\LogicalDisk(*)\% Disk Time
\LogicalDisk(*)\% Disk Write Time
\LogicalDisk(*)\% Free Space
\LogicalDisk(*)\% Idle Time
\LogicalDisk(*)\Avg. Disk Bytes/Read
\LogicalDisk(*)\Avg. Disk Bytes/Transfer
\LogicalDisk(*)\Avg. Disk Bytes/Write
\LogicalDisk(*)\Avg. Disk Queue Length
\LogicalDisk(*)\Avg. Disk Read Queue Length
@johndacosta
johndacosta / Get-SQLServerDatabaseUsers.ps1
Created July 25, 2013 17:11
Gets List of Applications, Users and Host Names from SQL Server Default Trace and Exports to JSON Output Sample { "ServerName": "MYSERVERNAME\MYINSTANCENAME", "DatabaseName": "MYDATABASENAME", "DatabaseID": 5, "NTUserName": "MYNTUSERNAME", "NTDomainName": "MYNTDOMAIN", "HostName": "MYSERVERNAME", "ApplicationName": "LiteSpeed for SQL Server", "L…
## Invoke by Running .\Get-SQLServerDatabaseUsers.ps1 SQLSERVER\INSTANCENAME
## Gets List of Applications, Users and Host Names from SQL Server Default Trace
param(
[string] $ServerInstance = $(Throw "Provide a SQL Server Instance Name as first parameter")
)
[void][System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO');
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
$QueryApplications = "SELECT DISTINCT t.ServerName,t.DatabaseName, t.DatabaseID,t.NTUserName,t.NTDomainName,t.HostName,t.ApplicationName,t.LoginName,t.DBUserName,t.LinkedServerName,t.SessionLoginName
FROM sys.fn_trace_gettable(CONVERT(VARCHAR(150), ( SELECT TOP 1 f.[value] FROM sys.fn_trace_getinfo(NULL) f WHERE f.property = 2 )), DEFAULT) T"
$QueryApplicationsResults = Invoke-Sqlcmd -ServerInstance $ServerInstance -Query $QueryApplications
@johndacosta
johndacosta / get-diskspace.ps1
Created July 25, 2013 14:46
Get Disk Space Information via Powershell in JSON Format
Get-WmiObject win32_volume | Select-Object SystemName,Name, BlockSize, Capacity, FreeSpace, DriveLetter , @{Name="CapacityGB";Expression={[math]::round($_.Capacity/1GB,2)}}, @{Name="FreeSpaceGB";Expression={[math]::round($_.FreeSpace/1GB,2)}} , @{Name="FreeSpacePercent";Expression={[math]::round(($_.FreeSpace/($_.Capacity*1.00))*100.00,2)}} , @{Name="Date";Expression={$(Get-Date -f s)}}| Sort-Object Name | Convertto-JSON
# This format will allow you to filter on drive name and select a remote computer.
# Get-WmiObject win32_volume -ComputerName ServerName | Where-Object {$_.label -match "S\:.*"} | Select-Object SystemName,Name, BlockSize, Capacity, FreeSpace, DriveLetter , @{Name="CapacityGB";Expression={[math]::round($_.Capacity/1GB,2)}}, @{Name="FreeSpaceGB";Expression={[math]::round($_.FreeSpace/1GB,2)}} , @{Name="FreeSpacePercent";Expression={[math]::round(($_.FreeSpace/($_.Capacity*1.00))*100.00,2)}} , @{Name="Date";Expression={$(Get-Date -f s)}}| Sort-Object Name | Convertto-JSON