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 moreCategory Archives: Uncategorized
SSRS – 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 moreFix User permissions on Restore Databases
When a the User at the database level has no login, but there is one in the database. exec sp_change_users_login “auto_fix”, “cw_reports”;
Read moreSSRS Scripts
Find reports that are not mapped to a data source: SELECT ItemPath = c.[Path], ItemName = c.Name, DatasourceRefrenceName=ds.Name FROM [Catalog] AS c INNER JOIN DataSource AS ds ON ds.ItemID = c.ItemID WHERE ds.Link IS NULL AND ds.Extension IS NULL order by ItemPath
Read moreSQL Server Backup and Maintenance Scripts
https://ola.hallengren.com/sql-server-backup.html
Read moreQuickBooks iif Import Files
Some very good information on how to format an iif file that can be used to import data into QuickBooks. Using this to move sales transaction information from a website into QuickBooks. Import lists into QuickBooks with IIF http://www.my-quickbooks-expert.com/import-quickbooks.html
Read moreSQL Management Studio – Windows Authentication – different domain
Sometimes you need to use windows authentication to SQL using SQL Management Studio, but the your domain and or username is different than who you are currently logged into you machine as. In that case run the following command from a Command Prompt. runas /netonly /user:domainusername “C:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe”
Read more