slabad

DECLARE @name varchar(max)
DECLARE @sql nvarchar(max)

DECLARE name CURSOR FOR
	select dp.name from sys.database_principals dp
	join sys.syslogins l on l.name = dp.name 
OPEN name

FETCH NEXT FROM name INTO @name

slabad

select 
	SPID
    ,Status
    ,loginame
    ,HostName
    ,blocked
    ,open_tran
    ,waittype
    ,cmd
    ,Last_Batch

slabad

--generate grant statements 
declare @sql varchar(8000)
declare loop1 cursor 
for 

SELECT prin.[name] [User],object_name(major_id) objName, sec.state_desc + ' ' + sec.permission_name [Permission] 
--into #tmp
FROM [sys].[database_permissions] sec 
  JOIN [sys].[database_principals] prin 
    ON sec.[grantee_principal_id] = prin.[principal_id] 

slabad

SELECT 
    d.PERCENT_COMPLETE AS [%Complete],
    d.TOTAL_ELAPSED_TIME/60000 AS ElapsedTimeMin,
    d.ESTIMATED_COMPLETION_TIME/60000   AS TimeRemainingMin,
    d.TOTAL_ELAPSED_TIME*0.00000024 AS ElapsedTimeHours,
    d.ESTIMATED_COMPLETION_TIME*0.00000024  AS TimeRemainingHours,
    s.text AS Command
FROM    sys.dm_exec_requests d
CROSS APPLY sys.dm_exec_sql_text(d.sql_handle)as s
WHERE  d.COMMAND LIKE 'backup DATABASE%'

slabad

USE Master; 
GO  
SET NOCOUNT ON 

-- 1 - Variable declaration 
DECLARE @dbName sysname 
DECLARE @backupPath NVARCHAR(500) 
DECLARE @cmd NVARCHAR(500) 
DECLARE @fileList TABLE (backupFile NVARCHAR(255)) 
DECLARE @lastFullBackup NVARCHAR(500) 

slabad

curl -s https://gist.githubusercontent.com/mattmc3/b15e30a6715b82f8b76bfd4232583df3/raw/a80da215ac1698184b60a7f96bce719703954aa3/1-slack-dark-mode.js | sudo tee -a /Applications/Slack.app/Contents/Resources/app.asar.unpacked/src/static/ssb-interop.js > /dev/null

slabad

Download the pre-patched powerline symbols font file.

$ wget -c https://github.com/Lokaltog/powerline/raw/develop/font/PowerlineSymbols.otf

• Open “Font Book” (Hit Cmd + Space to open spotlight and type Font Book).
• Go to “File > Add Fonts” and open the PowerlineSymbols.otf file.
• After the font is added, right click on “PowerlineSymbols” font and select “Validate Font”.
• Now the font should be installed and ready to use.
• If you are using iTerm, change the non-ascii font to PowerSymbols to start using the powerline fonts.

slabad

sudo tccutil reset Accessibility

slabad

SELECT 
	schemaname
    ,relname AS TableName
	,n_live_tup AS LiveTuples
	,n_dead_tup AS DeadTuples
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC
;

slabad

WITH constants AS (
    -- define some constants for sizes of things
    -- for reference down the query and easy maintenance
    SELECT current_setting('block_size')::numeric AS bs, 23 AS hdr, 8 AS ma
),
no_stats AS (
    -- screen out table who have attributes
    -- which dont have stats, such as JSON
    SELECT table_schema, table_name,