Posts

dbatools toolkit

 I know most of the people in SQL database space aware of the useful dba tools toolkit. But when I spoke to an experienced DBA, I accidently talked about dbatools and realized it's the first time he is hearing about this.  So what's dbatools? In a simple note, it's a repository of powershell commands useful for any DBA in their day-to-day duties. Also, it's handy for automating many of the database processes. In general, it a collection of powerful powershell commands which will ease the DBA life. dbatools docs Explore the link above.. Happy DBA'ing.
Post a Comment
Read more

Permission for non-sysadmins to create and manage SSIS packages and run it from SQL Agent

Image
There are different ways to manage permissions in SQL server environment. As a DBA, I came across different environments, where everyone got sysadmin access. Trust me, I'm not exaggerating here.  I recently worked for a client where they are using an AD group for all the developers and that AD group got sysadmin access in all the environments. As you know, it's a RISK for the environment and of course, for the DBA. When someone hired you as their DBA, then it's your responsibility to protect the environment as long as you are their DBA! Normally when a DBA asks reason for sysadmin privilege, normal answers are like yeah I need to develop SSIS packages, then create jobs and run those jobs etc. So how to grand access for a developer to do all the required jobs like add a SSIS catalog, modify, create a SQL Agent job, run and modify without waiting for the DBA time?  Just a side note, always try to give permissions through groups instead of adding individual users in the server...
Post a Comment
Read more