There's usually a maintenance job of some sort that runs nightly.  For example, I have the History Cleanup job running daily at 4am.

I would just add a job step to...

• This reply was modified 3 months ago by  tung858.

Just set all grantor to SA.  Who really minds who granted what permission.  It's going to be a DBA with sysadmin access doing it.

update internal.project_permissions

set grantor_sid = 0x01

Just set all grantor to SA.

Who really minds who granted what permission?  It's going to be a DBA with sysadmin access doing it.

update internal.project_permissions

set grantor_sid = 0x01

Try beefing up your DR with more CPU and RAM so it can restore faster.  Some companies setup DR servers on lower resources from PRD in order to save costs. ...

A server upgrade would just be a once in a while event and not recurring with high frequency.  I'd recommend using SSDT and using the Business Intelligence > Integration Service...

DMK is only needed if you want to maintain sensitive values in your package as you restore the SSISDB database to another server instance.  If DMK is not restored, the...

Try not to specify the idPool column twice in the same Update statement and get rid of the Select statement.

The select statement where criteria is the same as the update...

select rp.name as database_role, mp.name as database_user
from sys.database_role_members drm
  join sys.database_principals rp on (drm.role_principal_id = rp.principal_id)
  join sys.database_principals mp on (drm.member_principal_id = mp.principal_id)
order by rp.name

--...

Try this for SQL Server 2008 R2 and above

The sizes will convert to mb, gb, or tb depending on how large the drive is.

The query only works with one server. ...

• This reply was modified 4 years, 4 months ago by  tung858.
• This reply was modified 4 years, 4 months ago by  tung858.
• This reply was modified 4 years, 4 months ago by  tung858.
• This reply was modified 4 years, 4 months ago by  tung858.

Those are very good points.  I too have taken safety precautions given the fact that my account has access to everything.  For the app, I use my windows credentials to...

the easiest method is to use...

"select...from sys.master_files mf cross apply sys.dm_os_volume_stats (mf.database_id, mf_file_id) vs"

then CREATE a read-only DUMMY DATABASE that has data files across all drives....

I had the same problem. I ran an index defrag process but the transaction log became full and the defrag process errored out. The transaction log remained large.

Yup deleting and adding again to the dimension usage tab solved my issue.  I'm now able to save and process everything.

So a little background.  I have a date...

I encountered the same issue with a report subscription where the developer created a separate dataset for each report parameter.  There were close to 2 dozen parameters.

Creating or...

I actually found an easy solution to this fix since I had the same issue.

I was trying to remove the filegroup [fg_LMeterDetail_13] but got the "cannot be removed because it...