There shouldn't be an issue with that big of a leap in faith.

The only things to watch out for are the upgraded encryption defaults. If apps accessing the database are...

Hi Brandie, will writing a subquery work for this issue?  Such as the below example?

select sum(count)
from
     ( select servername, count = count(*)
 ...

Hi Stan,

I don't believe the .dll references in your script and GAC entries will be deployed along with your package deployment.  That's something you'll have to set up on the...

Hi Adri

I went through the same domain migration and had to clone existing windows logins/groups to the new domain which looks like you're attempting to do.  Here are 2 steps...

• This reply was modified 2 weeks, 5 days ago by SQL BrainBox.

Personally, I'd separate the user database data and log files into separate volumes.

As for the tempdb database, AWS EC2 uses solid state drives (SSD) so there's no need to create...

• This reply was modified 2 weeks, 6 days ago by SQL BrainBox.

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 1 years, 6 months ago by SQL BrainBox.

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 5 years, 7 months ago by SQL BrainBox.
• This reply was modified 5 years, 7 months ago by SQL BrainBox.
• This reply was modified 5 years, 7 months ago by SQL BrainBox.
• This reply was modified 5 years, 7 months ago by SQL BrainBox.

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...