I agree with Grant regarding ExtendedEvents , however while default trace is available and running, it still has lots of usefull information for a DBA. Imho, it's a valueable source...

hi Duncan

I would do the following:

edit reports using Notepad (manually) or powershell script (automatic) and change section <Language>en-US</Language> to the needed value.

https://mcpmag.com/articles/2018/08/08/replace-text-with-powershell.aspx

hi

compare the target objects you're running the query against - they can have different structure, amount of data, type, etc

also, (sql?) settings can be the same, but resources are different...

hi

Answers:

1.A

this query will show all events default trace captures

SELECT c.name [Category]
, e.name [Event]
,tc.name [Column]
,tc.type_name [DataType]
,tc.max_size [MaxSize]
FROM fn_trace_geteventinfo(1) evi 
JOIN sys.trace_events e ON evi.eventid = e.trace_event_id 
join sys.trace_categories...

another option is to add calculated field to the appropriate dataset

however, it's not clear what are YTLP , TSA and YT items? how do they get values?

hi Chris

there's "fx" button next to the dropdown - you can try to specify your formula there

hi

never seen/had such issue before

i develop reports in ssdt & visual studio for several years already

to protect yourself against such rare scary issue, perhaps, isn't it worth to have the...

my 5 cents :

select 
isnull(object_schema_name(major_id,db_id()) +'.'+ object_name(major_id),
case when dp.class_desc='SCHEMA' then 'db schema '+quotename(schema_name(dp.major_id)) else dp.class_desc end ) [object]
,permission_name [permission]
, user_name(dp.grantee_principal_id) [GrantedTo]
, user_name(dp.grantor_principal_id) [GrantedBy]
, o.is_ms_shipped
, o.type_desc
,dp.state_desc
from sys.database_permissions dp
left...

• This reply was modified 5 years, 7 months ago by  Andrey. Reason: comments are removed from the code

Example of the report output against my local Express instance

try this one:

https://github.com/ASamykin/PerformanceReports/blob/master/Report%20Project1/QuickOverview.rdl

this is SSRS report which connects to a SQL instance under current user (should have sysadmin rights to get  all info)

to avoid KERBEROS issue it's better...

played a bit with a file name variable - see below

declare @file varchar(50) = 'ABC1234_CO_201905060352.bak'

-- my version
select 
datediff(hh
,CONVERT(DATE,GETDATE(),120)  /*why from the beginning of the day?*/
,convert(datetime
/*date below*/
,left(
replace(stuff(@file,1,len(@file)-charindex('_',reverse(@file))+1,''),'.bak','')
,8)
+'...

imho, there are other options to consider rather analysing file names:

1. get list of 4 last backups from appropriate server (msdb) - they are needed, the rest is not
2. exec...

google knows a lot

https://www.youtube.com/watch?v=IZViEKeGAwE

declare @dt1 date  = '20190501';
declare @dt2 date  = '20190522';

with dates as
(
select @dt1 [d], datename(dw,@dt1) [n]
union all
select dateadd(dd,1,d),datename(dw,dateadd(dd,1,d)) 
from dates 
where d<=@dt2
)
select 
count(1) [Mondays]
from dates 
where...