Just got Nextcloud running on a Rasberry Pi I had laying around. Pretty cool. Just need to configure the home network now to pass traffic to it and will be all set. Already using the iPhone app on the internal network. Nextcloud – a safe home for all your data
Read moreMonthly Archives: March 2017
SSRS Logs
Need to know the stats of what is going on in SSRS. Query ExecutionLog, ExecutionLog2, or ExecutionLog3 and get the time for data retrieval, processing, and time rendering.
Read moreSSRS – Report Data Window – Shortcut
sure why I lose this window sometime, but here is how to get it back: With a report file selected: View -> Report Data. It is a shortcut of Ctrl+Alt+D
Read moreSSRS – Alternate Row Colors
Set Background property of the detail to: = IIf(RowNumber(Nothing) Mod 2 = 0, “#EEEEEE”, “Transparent”)
Read moreSQL Server – Find all tables that have a column with a specific name
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name =’FindColumnName’ ORDER BY schema_name, table_name;
Read moreStored Procedures Modified in last 7 Days
SELECT name, create_date, modify_date FROM sys.objects WHERE type = ‘P’ and modify_date>=DateAdd(Day,-7,GetDate())
Read more